diff options
author | Anel Husakovic <anel@mariadb.org> | 2018-10-07 04:51:46 -0700 |
---|---|---|
committer | Vicențiu-Marian Ciorbaru <vicentiu@mariadb.org> | 2019-01-16 13:34:54 +0200 |
commit | 802e8d6b89b4e1de1714cad56f53c643d58597c2 (patch) | |
tree | e095900fab5acc4ddde43e9e67da6ea59d278bcc /mysql-test/r/information_schema.result | |
parent | 2153aaf66eeff70b2191806e187c2b845b91f3a2 (diff) | |
download | mariadb-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.result | 2 |
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 |