diff options
| author | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2005-09-07 16:11:53 +0500 |
|---|---|---|
| committer | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2005-09-07 16:11:53 +0500 |
| commit | 48c3c329b3916ef6a710d5221b8bd4671817fd3c (patch) | |
| tree | e5f6ec356f216efebf1088529375fa791bc20b16 /mysql-test/r/information_schema.result | |
| parent | a777907a51510cec8ab4a502d0924e072b47665d (diff) | |
| download | mariadb-git-48c3c329b3916ef6a710d5221b8bd4671817fd3c.tar.gz | |
Fix for bug#12905 show fields from view behaving erratically with current database
use saved view db name in case of view
Diffstat (limited to 'mysql-test/r/information_schema.result')
| -rw-r--r-- | mysql-test/r/information_schema.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result index 20b2f12f0a8..9a7a0b48f47 100644 --- a/mysql-test/r/information_schema.result +++ b/mysql-test/r/information_schema.result @@ -979,3 +979,14 @@ WHERE TABLE_SCHEMA='test' AND TABLE_TYPE='BASE TABLE'); 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 10 Fixed 0 0 0 # 1024 0 NULL # # NULL latin1_swedish_ci NULL t2 MyISAM 10 Fixed 0 0 0 # 1024 0 NULL # # NULL latin1_swedish_ci NULL +DROP TABLE t1,t2; +create table t1(f1 int); +create view v1 (c) as select f1 from t1; +select database(); +database() +NULL +show fields from test.v1; +Field Type Null Key Default Extra +c int(11) YES NULL +drop view v1; +drop table t1; |