diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2005-01-27 11:06:44 +0300 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2005-01-27 11:06:44 +0300 |
| commit | 7f39357efe2f70b27ea821d0c5ca4951e333c9ac (patch) | |
| tree | bac08c3d1788fc9a94b28b7d569d8221fe0f1ffc /mysql-test/r/ps_1general.result | |
| parent | 9dd5ded124aea4130569c5d412c1e90209b582b9 (diff) | |
| download | mariadb-git-7f39357efe2f70b27ea821d0c5ca4951e333c9ac.tar.gz | |
Fix after review for
ChangeSet
1.1803 05/01/24
Additional fix for WL#1629: SHOW with WHERE(discussed with PeterG)
Diffstat (limited to 'mysql-test/r/ps_1general.result')
| -rw-r--r-- | mysql-test/r/ps_1general.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/ps_1general.result b/mysql-test/r/ps_1general.result index c65d11330ea..f5c71d3ed23 100644 --- a/mysql-test/r/ps_1general.result +++ b/mysql-test/r/ps_1general.result @@ -264,6 +264,18 @@ prepare stmt4 from ' show tables from test like ''t2%'' '; execute stmt4; Tables_in_test (t2%) t2 +prepare stmt4 from ' show columns from t2 where field in (select ?) '; +SET @arg00="a"; +execute stmt4 using @arg00; +Field Type Null Key Default Extra +a int(11) NO PRI +SET @arg00="b"; +execute stmt4 using @arg00; +Field Type Null Key Default Extra +b char(10) YES NULL +SET @arg00=1; +execute stmt4 using @arg00; +Field Type Null Key Default Extra prepare stmt4 from ' show columns from t2 from test like ''a%'' '; execute stmt4; Field Type Null Key Default Extra |