Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
Windows, docker container (mariadb:latest)
Description
this is not possible, Error message
Error Code: 1064. 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 'not possible', id bigint not null, primary key (id) ...' at line 3
{{create table test (
value1 integer not null comment 'value 1',
value2 integer not null check (value2<=2) comment 'not possible',
id bigint not null,
primary key (id)
) engine=InnoDB}}
Remove comment after check, syntax is ok and work
{{create table test (
value1 integer not null comment 'value 1',
value2 integer not null check (value2<=2),
id bigint not null,
primary key (id)
) engine=InnoDB}}