summaryrefslogtreecommitdiff
path: root/mysql-test/r/information_schema.result
diff options
context:
space:
mode:
authorkevg <claprix@yandex.ru>2017-05-19 23:27:40 +0300
committerAleksey Midenkov <midenok@gmail.com>2017-05-24 18:46:56 +0300
commit45f6acd2964a89c933077b9c6cf66009bcc91de7 (patch)
tree17bdb65caf707d6a775e73f84e2192c1d0eba649 /mysql-test/r/information_schema.result
parentabba11e6c4bd992c6c380ad73dfde1f7f4d438d7 (diff)
downloadmariadb-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.result5
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';