diff options
| author | bell@sanja.is.com.ua <> | 2004-02-18 01:08:52 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-02-18 01:08:52 +0200 |
| commit | 14b9fa3588a35c8e7df3961eba06e6e590eabfcf (patch) | |
| tree | 65aff983542f7b988996319163a7a3e003e845f4 /mysql-test | |
| parent | 8a865250c4180ee197c4626560eb46c2cea0a696 (diff) | |
| download | mariadb-git-14b9fa3588a35c8e7df3961eba06e6e590eabfcf.tar.gz | |
revision of fix_fields() calls (BUG2838)
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 8 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index ee3492c8111..cf5ec33ba40 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -1614,3 +1614,9 @@ select 2 in (select * from t1); 1 SET SQL_SELECT_LIMIT=default; drop table t1; +create table t1(val varchar(10)); +insert into t1 values ('aaa'), ('bbb'),('eee'),('mmm'),('ppp'); +select count(*) from t1 as w1 where w1.val in (select w2.val from t1 as w2 where w2.val like 'm%') and w1.val in (select w3.val from t1 as w3 where w3.val like 'e%'); +count(*) +0 +drop table if exists t1; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 42fb2afbe89..70428bedac8 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1060,3 +1060,11 @@ select sum(a) from (select * from t1) as a; select 2 in (select * from t1); SET SQL_SELECT_LIMIT=default; drop table t1; + +# +# Item_cond fix field +# +create table t1(val varchar(10)); +insert into t1 values ('aaa'), ('bbb'),('eee'),('mmm'),('ppp'); +select count(*) from t1 as w1 where w1.val in (select w2.val from t1 as w2 where w2.val like 'm%') and w1.val in (select w3.val from t1 as w3 where w3.val like 'e%'); +drop table if exists t1; |