github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/check_constraint (about) 1 exec 2 CREATE TABLE checks (a INTEGER PRIMARY KEY, b INTEGER, c varchar(20)) 3 ---- 4 5 exec 6 ALTER TABLE checks ADD CONSTRAINT chk1 CHECK (B > 0) 7 ---- 8 9 exec 10 ALTER TABLE checks ADD CONSTRAINT chk2 CHECK (b > 0) NOT ENFORCED 11 ---- 12 13 exec 14 ALTER TABLE checks ADD CONSTRAINT chk3 CHECK (B > 1) 15 ---- 16 17 exec 18 ALTER TABLE checks ADD CONSTRAINT chk4 CHECK (upper(C) = c) 19 ----