diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-10-10 13:15:14 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-10-10 13:15:14 +0300 |
| commit | 8b026230fff314a3a36132024611138cc2b605ae (patch) | |
| tree | 19e2e611cc802c0d0aa54a516190cdc981185b69 /mysql-test/r/view.result | |
| parent | 917a3474dee81e898092ff769f4030e9d4acf7c5 (diff) | |
| download | mariadb-git-8b026230fff314a3a36132024611138cc2b605ae.tar.gz | |
showing table type now is controled by new parameter 'FULL' of SHOW TABLES command (SHOW FULL TABLES) (as it was decided on last dev conf)
mysql-test/r/connect.result:
returned SHOW TABLES default behaviour
mysql-test/r/ctype_recoding.result:
returned SHOW TABLES default behaviour
mysql-test/r/drop.result:
returned SHOW TABLES default behaviour
mysql-test/r/lowercase_table.result:
returned SHOW TABLES default behaviour
mysql-test/r/rename.result:
returned SHOW TABLES default behaviour
mysql-test/r/rpl000009.result:
returned SHOW TABLES default behaviour
mysql-test/r/rpl_error_ignored_table.result:
returned SHOW TABLES default behaviour
mysql-test/r/select.result:
returned SHOW TABLES default behaviour
mysql-test/r/sp.result:
returned SHOW TABLES default behaviour
mysql-test/r/system_mysql_db.result:
returned SHOW TABLES default behaviour
mysql-test/r/view.result:
test of new parameter od SHOW TABLES and default behaviour without parameter
mysql-test/t/view.test:
test of new parameter od SHOW TABLES and default behaviour without parameter
sql/mysql_priv.h:
parameter added to mysqld_show_tables
sql/sql_parse.cc:
parameter added to mysqld_show_tables
sql/sql_show.cc:
showing table type now is controled by new parameter 'FULL' of SHOW TABLES command (SHOW FULL TABLES)
sql/sql_yacc.yy:
showing table type now is controled by new parameter 'FULL' of SHOW TABLES command (SHOW FULL TABLES)
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index f1a32ea0c17..d5fdc668d61 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -130,6 +130,15 @@ id select_type table type possible_keys key key_len ref rows Extra Warnings: Note 1003 select `v6`.`c` AS `c` from `test`.`v6` show tables; +Tables_in_test +t1 +v1 +v2 +v3 +v4 +v5 +v6 +show full tables; Tables_in_test table_type t1 BASE TABLE v1 VIEW @@ -1043,7 +1052,7 @@ drop table t1; CREATE VIEW v02 AS SELECT * FROM DUAL; ERROR HY000: No tables used SHOW TABLES; -Tables_in_test table_type +Tables_in_test CREATE VIEW v1 AS SELECT EXISTS (SELECT 1 UNION SELECT 2); select * from v1; EXISTS (SELECT 1 UNION SELECT 2) |