[keycloak-user] KC4.3.0.Final- mariadb db errors on fresh install

[java_os]

Struggled with this fresh install.
You get this error on startup:
You have an error in your SQL syntax; check the manual      that
corresponds to your MariaDB server version for the right syntax to use
near 'INT DEFAULT 30 NULL, ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1'  
NULL' at line 1 [Failed SQL: ALTER TABLE keycloak.CREDENTIAL ADD COUNTER
INT DEFAULT 0 NULL, ADD DIGITS INT DEFAULT 6 NULL, ADD PERIOD INT DEFAULT 
  30 NULL, ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1' NULL]^M

======

I ran it in manual mode db upgrade to get the generated .sql, changed the
alter on credentials as follows (injecting COLUMN into the sql - weird?)
ALTER TABLE keycloak.CREDENTIAL ADD COLUMN COUNTER INT DEFAULT 0 NULL, ADD
COLUMN DIGITS INT DEFAULT 6 NULL, ADD COLUMN PERIOD INT DEFAULT 30 NULL,
ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1' NULL;

especially before PERIOD when it bailed out.

Re-run the sql update - works, able to bring kc up.

Really? why ? Anyone gone through this?