summaryrefslogtreecommitdiff
path: root/mysql-test/r/information_schema.result
diff options
context:
space:
mode:
authorAnel Husakovic <anel@mariadb.org>2018-10-07 04:51:46 -0700
committerVicențiu-Marian Ciorbaru <vicentiu@mariadb.org>2019-01-16 13:34:54 +0200
commit802e8d6b89b4e1de1714cad56f53c643d58597c2 (patch)
treee095900fab5acc4ddde43e9e67da6ea59d278bcc /mysql-test/r/information_schema.result
parent2153aaf66eeff70b2191806e187c2b845b91f3a2 (diff)
downloadmariadb-git-802e8d6b89b4e1de1714cad56f53c643d58597c2.tar.gz
Backport 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. There were some result files which failed after running mtr. These files are updated with newly create record with mtr --record.
Diffstat (limited to 'mysql-test/r/information_schema.result')
-rw-r--r--mysql-test/r/information_schema.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result
index 5d2d960ad6f..ca76cc8100a 100644
--- a/mysql-test/r/information_schema.result
+++ b/mysql-test/r/information_schema.result
@@ -51,6 +51,7 @@ c
ALL_PLUGINS
APPLICABLE_ROLES
CHARACTER_SETS
+CHECK_CONSTRAINTS
CLIENT_STATISTICS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
@@ -922,6 +923,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