diff options
author | kevg <claprix@yandex.ru> | 2017-05-19 23:27:40 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2017-05-24 18:46:56 +0300 |
commit | 45f6acd2964a89c933077b9c6cf66009bcc91de7 (patch) | |
tree | 17bdb65caf707d6a775e73f84e2192c1d0eba649 /mysql-test/r/information_schema.result | |
parent | abba11e6c4bd992c6c380ad73dfde1f7f4d438d7 (diff) | |
download | mariadb-git-45f6acd2964a89c933077b9c6cf66009bcc91de7.tar.gz |
Scripts: VTMD table [closes #122]
Diffstat (limited to 'mysql-test/r/information_schema.result')
-rw-r--r-- | mysql-test/r/information_schema.result | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result index dad6d5d8c8a..6a6b5e0616a 100644 --- a/mysql-test/r/information_schema.result +++ b/mysql-test/r/information_schema.result @@ -123,6 +123,7 @@ time_zone_transition time_zone_transition_type user v1 +vtmd_template select c,table_name from v1 inner join information_schema.TABLES v2 on (v1.c=v2.table_name) where v1.c like "t%"; @@ -1334,12 +1335,12 @@ DROP PROCEDURE p1; DROP USER mysql_bug20230@localhost; SELECT MAX(table_name) FROM information_schema.tables WHERE table_schema IN ('mysql', 'INFORMATION_SCHEMA', 'test') and table_name not like 'xtradb%'; MAX(table_name) -VIEWS +vtmd_template SELECT table_name from information_schema.tables WHERE table_name=(SELECT MAX(table_name) FROM information_schema.tables WHERE table_schema IN ('mysql', 'INFORMATION_SCHEMA', 'test') and table_name not like 'xtradb%'); table_name -VIEWS +vtmd_template DROP TABLE IF EXISTS bug23037; DROP FUNCTION IF EXISTS get_value; SELECT COLUMN_NAME, MD5(COLUMN_DEFAULT), LENGTH(COLUMN_DEFAULT) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='bug23037'; |