Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.3.35
-
None
-
Linux
Description
If the table has a CHECK and a COMMENT and mysqldump is used with this table, then the output will be like:
...
`fieldname2` int(10) unsigned NOT NULL DEFAULT 0 ,
`fieldname` int(10) unsigned NOT NULL DEFAULT 0 CHECK (`fieldname` <> 0 or `fieldname2` <> 0) COMMENT 'lala',
...
But when trying to import that, this error is shown:
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 'COMMENT 'lala',
If the order is changed manually, this is, COMMENT first and then CHECK, it works.
Attachments
Issue Links
- duplicates
-
MDEV-17654 Incorrect syntax returned for column with CHECK constraint in the "SHOW CREATE TABLE ..." result
- Closed