Mysql check not enforce语法无法正常识别

环境：mysql 8.0.22 ， druid 1.2.3

SQL :

建表语句：

CREATE TABLE t12 ( CHECK (c1 <> c2), c1 INT CHECK (c1 > 10), c2 INT CONSTRAINT c12_positive CHECK (c2 > 0), c3 INT CHECK (c3 < 100), CONSTRAINT c21_nonzero CHECK (c1 <> 0), CHECK (c1 > c3) );

alter table t12 ALTER CHECK c12_positive NOT ENFORCED;

通过MYSQL的show CREATE table t1 得到的建表语句

CREATE TABLE t12 ( c1 int DEFAULT NULL, c2 int DEFAULT NULL, c3 int DEFAULT NULL, CONSTRAINT c12_positive CHECK ((c2 > 0)) /*!80016 NOT ENFORCED */, CONSTRAINT c21_nonzero CHECK ((c1 <> 0)), CONSTRAINT t12_chk_1 CHECK ((c1 <> c2)), CONSTRAINT t12_chk_2 CHECK ((c1 > 10)), CONSTRAINT t12_chk_3 CHECK ((c3 < 100)), CONSTRAINT t12_chk_4 CHECK ((c1 > c3)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

其中测试代码如下：

public static void main(String[] args) { String sql ="CREATE TABLE t12 (\n" + " c1 int DEFAULT NULL,\n" + " c2 int DEFAULT NULL,\n" + " c3 int DEFAULT NULL,\n" + " CONSTRAINT c12_positive CHECK ((c2 > 0)) /*!80016 NOT ENFORCED */,\n" + " CONSTRAINT c21_nonzero CHECK ((c1 <> 0)),\n" + " CONSTRAINT t12_chk_1 CHECK ((c1 <> c2)),\n" + " CONSTRAINT t12_chk_2 CHECK ((c1 > 10)),\n" + " CONSTRAINT t12_chk_3 CHECK ((c3 < 100)),\n" + " CONSTRAINT t12_chk_4 CHECK ((c1 > c3))\n" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci"; MySqlStatementParser parser = new MySqlStatementParser(sql); SQLStatement createTableStatement = parser.parseStatement(); System.out.println(createTableStatement); }

解释报错：

Exception in thread "main" com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'((c2 > 0)) /*!80016 NOT ENFORCED */, CO', expect ), actual null, pos 167, line 5, column 49, token HINT at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:558) at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:566) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:362) at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:301) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:249) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:4465)

原提问者GitHub用户WillsonYip