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}}