[MDEV-25077] Documented COLUMN_FORMAT option causes syntax error Created: 2021-03-07  Updated: 2021-03-09  Resolved: 2021-03-09

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 5.5, 10.1, 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: Elena Stepanova Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: 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.
Generated at Thu Feb 08 09:34:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.