diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/features.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/features.test | 8 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/features.result b/mysql-test/r/features.result index 52650d118b3..615ab2368d9 100644 --- a/mysql-test/r/features.result +++ b/mysql-test/r/features.result @@ -3,6 +3,7 @@ set sql_mode=""; flush status; show status like "feature%"; Variable_name Value +Feature_check_constraint 0 Feature_delay_key_write 0 Feature_dynamic_columns 0 Feature_fulltext 0 @@ -158,3 +159,9 @@ drop table t1; show status like "feature_delay_key_write"; Variable_name Value Feature_delay_key_write 2 +create table t1 (a int check (a > 5)); +create table t2 (b int, constraint foo check (b < 10)); +drop table t1, t2; +show status like "feature_check_constraint"; +Variable_name Value +Feature_check_constraint 2 diff --git a/mysql-test/t/features.test b/mysql-test/t/features.test index 225ab40b361..63e923a772b 100644 --- a/mysql-test/t/features.test +++ b/mysql-test/t/features.test @@ -130,3 +130,11 @@ insert into t1 values(2); drop table t1; show status like "feature_delay_key_write"; + +# +# Feature CHECK CONSTRAINT +# +create table t1 (a int check (a > 5)); +create table t2 (b int, constraint foo check (b < 10)); +drop table t1, t2; +show status like "feature_check_constraint"; |