sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

CHECK constraints

Open stevenwdv opened this issue 6 years ago • 0 comments

The parser currently shows warnings for CHECK constraints, which are supported in MariaDB 10.2.1+

ALTER TABLE t_a ADD CONSTRAINT CHECK(col = 42);

CREATE TABLE t_b (
    col INT CHECK(col = 37)
);

CREATE TABLE t_c (
    col INT,
    CHECK(col != 0xDEAD)
)

stevenwdv avatar Sep 02 '17 17:09 stevenwdv