diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-07-25 22:15:05 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-07-28 15:43:01 +0200 |
| commit | 7034bbc3f87e0c93e394e08417148758dca168bc (patch) | |
| tree | 281f84eaff348b5e6e6b1a983a37dd3fb4bf1f82 /mysql-test | |
| parent | 2b0e66fe970cda02dd1461e6d4a9417ff081955c (diff) | |
| download | mariadb-git-bb-10.2-default.tar.gz | |
Feature_check_constraint status variablebb-10.2-default
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"; |