diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-07-19 12:07:33 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-07-19 12:07:33 +0300 |
| commit | 10d0dca6b4a1be61df17cc017d8073d6543ecf26 (patch) | |
| tree | 2925f0f68f3f04abbd4988de5d8909f9a8de854b /mysql-test/r/view.result | |
| parent | 9fc19ce8f507c89eed604f9968a897b37b0b065f (diff) | |
| download | mariadb-git-10d0dca6b4a1be61df17cc017d8073d6543ecf26.tar.gz | |
standard values for table type in SHOW TABLES (BUG#4603)
mysql-test/r/connect.result:
standard values for table type in SHOW TABLES
mysql-test/r/ctype_recoding.result:
standard values for table type in SHOW TABLES
mysql-test/r/drop.result:
standard values for table type in SHOW TABLES
mysql-test/r/greedy_optimizer.result:
fixed results
mysql-test/r/lowercase_table.result:
standard values for table type in SHOW TABLES
mysql-test/r/ps_1general.result:
standard values for table type in SHOW TABLES
mysql-test/r/rename.result:
standard values for table type in SHOW TABLES
mysql-test/r/rpl000009.result:
standard values for table type in SHOW TABLES
mysql-test/r/rpl_error_ignored_table.result:
standard values for table type in SHOW TABLES
mysql-test/r/select.result:
standard values for table type in SHOW TABLES
mysql-test/r/system_mysql_db.result:
standard values for table type in SHOW TABLES
mysql-test/r/view.result:
standard values for table type in SHOW TABLES
sql/sql_show.cc:
standard values for table type in SHOW TABLES
debugging trap
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 03b771de5d7..98c04b31e96 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -130,14 +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 Type -t1 table -v1 view -v2 view -v3 view -v4 view -v5 view -v6 view +Tables_in_test table_type +t1 BASE TABLE +v1 VIEW +v2 VIEW +v3 VIEW +v4 VIEW +v5 VIEW +v6 VIEW +vt1 VIEW show table status; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment t1 MyISAM 9 Fixed 5 9 45 38654705663 1024 0 NULL # # NULL latin1_swedish_ci NULL @@ -147,6 +148,7 @@ v3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL vie v4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL view v5 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL view v6 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL view +vt1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL view drop view v1,v2,v3,v4,v5,v6; create view v1 (c,d,e,f) as select a,b, a in (select a+2 from t1), a = all (select a from t1) from t1; |