summaryrefslogtreecommitdiff
path: root/mysql-test/main/information_schema.result
diff options
context:
space:
mode:
authorAnel Husakovic <anel@mariadb.org>2018-04-03 12:41:13 +0000
committerVicențiu Ciorbaru <vicentiu@mariadb.org>2018-08-25 17:03:20 +0300
commitd526679efd108478cc2af07578a15434fb46ed85 (patch)
tree0551593e16f022706d78d480cc5c0a099959c2ac /mysql-test/main/information_schema.result
parent7f73f5e4e5bdae80561ff2596f5142965397a1b1 (diff)
downloadmariadb-git-d526679efd108478cc2af07578a15434fb46ed85.tar.gz
MDEV-14474 information_schema.check_constraints
Implement according to standard SQL specification 2008. The check_constraints table is used for fetching metadata about the constraints defined for tables in all databases.
Diffstat (limited to 'mysql-test/main/information_schema.result')
-rw-r--r--mysql-test/main/information_schema.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/information_schema.result b/mysql-test/main/information_schema.result
index 0e6b4168ea5..83f987b78db 100644
--- a/mysql-test/main/information_schema.result
+++ b/mysql-test/main/information_schema.result
@@ -51,6 +51,7 @@ c
ALL_PLUGINS
APPLICABLE_ROLES
CHARACTER_SETS
+CHECK_CONSTRAINTS
CLIENT_STATISTICS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
@@ -938,6 +939,7 @@ connection user10261;
SELECT TABLE_NAME, COLUMN_NAME, PRIVILEGES FROM INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME='TABLE_NAME' and table_name not like 'innodb%';
TABLE_NAME COLUMN_NAME PRIVILEGES
+CHECK_CONSTRAINTS TABLE_NAME select
COLUMNS TABLE_NAME select
COLUMN_PRIVILEGES TABLE_NAME select
FILES TABLE_NAME select