diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-10-31 23:03:27 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-10-31 23:03:27 +0200 |
| commit | c9fa9615a3a3fe88430f5f867655ff84f7dbb7dc (patch) | |
| tree | 319cf19f806cf44cdeb5110b29907a78ab1d83c3 /mysql-test/t/subselect.test | |
| parent | ab9fb4ea752731bb04cfbd844902ae34c63123ab (diff) | |
| parent | 8b09f4b074f1b31453fd142b7f3417b33fc0b6f2 (diff) | |
| download | mariadb-git-c9fa9615a3a3fe88430f5f867655ff84f7dbb7dc.tar.gz | |
merge
sql/sql_select.cc:
Auto merged
sql/sql_select.h:
Auto merged
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 3648210b943..576e96c5c18 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1020,3 +1020,13 @@ select * from t1 where 'f' > any (select s1 from t1); select * from t1 where 'f' > any (select s1 from t1 union select s1 from t1); explain select * from t1 where 'f' > any (select s1 from t1 union select s1 from t1); drop table t1; + +# +# filesort in subquery (restoring join_tab) +# +CREATE TABLE t1 (number char(11) NOT NULL default '') TYPE=MyISAM CHARSET=latin1; +INSERT INTO t1 VALUES ('69294728265'),('18621828126'),('89356874041'),('95895001874'); +CREATE TABLE t2 (code char(5) NOT NULL default '',UNIQUE KEY code (code)) TYPE=MyISAM CHARSET=latin1; +INSERT INTO t2 VALUES ('1'),('1226'),('1245'),('1862'),('18623'),('1874'),('1967'),('6'); +select c.number as phone,(select p.code from t2 p where c.number like concat(p.code, '%') order by length(p.code) desc limit 1) as code from t1 c; +drop table t1, t2; |