Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
5.5, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6
-
None
Description
The KB says:
column_definition:
|
data_type
|
[NOT NULL | NULL] [DEFAULT default_value | (expression)]
|
[ON UPDATE [NOW | CURRENT_TIMESTAMP] [(precision)]]
|
[AUTO_INCREMENT] [ZEROFILL] [UNIQUE [KEY] | [PRIMARY] KEY]
|
[INVISIBLE] [{WITH|WITHOUT} SYSTEM VERSIONING]
|
[COMMENT 'string'] [REF_SYSTEM_ID = value]
|
[COLUMN_FORMAT {FIXED|DYNAMIC|DEFAULT}]
|
[reference_definition]
|
...
COLUMN_FORMAT¶
COLUMN_FORMAT is only used by MySQL Cluster, and is silently ignored in MariaDB.
In fact it is not ignored, it causes a syntax error:
10.6 03ff588d1 |
MariaDB [test]> CREATE TABLE t (a INT COLUMN_FORMAT FIXED); |
ERROR 1064 (42000): 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 'FIXED)' at line 1 |
MariaDB [test]> select @@version; |
+----------------------+ |
| @@version |
|
+----------------------+ |
| 10.6.0-MariaDB-debug |
|
+----------------------+ |
1 row in set (0.000 sec) |
It looks like it is so in all versions since at least 5.5.