summaryrefslogtreecommitdiff
path: root/mysql-test/t/view.test
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2018-02-10 14:42:59 +0200
committerMonty <monty@mariadb.org>2018-02-12 17:17:26 +0200
commit54db0be3be5952de88074883b0aaaa749910566d (patch)
treed4f6496405071d40491d57d2f3f15097a218f6bd /mysql-test/t/view.test
parent19dd14e648c56adb7dc7d14a4ea03d2b8ef147a5 (diff)
downloadmariadb-git-54db0be3be5952de88074883b0aaaa749910566d.tar.gz
Added Max_index_length and Temporary to SHOW TABLE STATUS
- Max_index_length is supported by MyISAM and Aria tables. - Temporary is a placeholder to signal that a table is a temporary table. For the moment this is always "N", except "Y" for generated information_schema tables and NULL for views. Full temporary table support will be done in another task. (No reason to have to update a lot of result files twice in a row)
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r--mysql-test/t/view.test6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index a8d0ac836ae..2d8f98f4d5f 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -87,7 +87,7 @@ explain extended select c from v6;
# show table/table status test
show tables;
show full tables;
---replace_column 8 # 12 # 13 # 14 #
+--replace_column 8 # 12 # 13 # 14 # 19 #
show table status;
drop view v1,v2,v3,v4,v5,v6;
@@ -738,7 +738,7 @@ create view v1 as select x1() from t1;
drop function x1;
-- error ER_VIEW_INVALID
select * from v1;
---replace_column 8 # 12 # 13 #
+--replace_column 8 # 12 # 13 # 19 #
show table status;
drop view v1;
drop table t1;
@@ -751,7 +751,7 @@ create view v1 as select a from t1;
alter table t1 change a aa int;
--error ER_VIEW_INVALID
select * from v1;
---replace_column 8 # 12 # 13 #
+--replace_column 8 # 12 # 13 # 19 #
show table status;
show create view v1;
drop view v1;