diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-12-03 22:40:11 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-12-03 22:40:11 +0200 |
| commit | c2780e1258f335d4886d69b2ca03e0f6068b17ec (patch) | |
| tree | 8974b31b36cdaed725ab25ce63f4dc1c58a16e94 /mysql-test | |
| parent | 67aec82f792d65ebc2fe49574c5cb02ce2d1c727 (diff) | |
| parent | 8127cea5124e44444370df61f0483c18f8c2dcab (diff) | |
| download | mariadb-git-c2780e1258f335d4886d69b2ca03e0f6068b17ec.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-qc-4.1
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 8 |
2 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 53b92fe50f1..4ad234244bf 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2005,3 +2005,8 @@ explain select a from t1 where c=2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where drop table t1; +create table t1 (s1 int,s2 int); +insert into t1 values (20,15); +select * from t1 where (('a',null) <=> (select 'a',s2 from t1 where s1 = 0)); +s1 s2 +drop table t1; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 19bfaa6194a..c3a10a835e2 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1301,3 +1301,11 @@ explain select a from t1 where c=2; do @a:= (select sum(a) from t1 where b > @b); explain select a from t1 where c=2; drop table t1; + +# +# Equal operation under row and empty subquery +# +create table t1 (s1 int,s2 int); +insert into t1 values (20,15); +select * from t1 where (('a',null) <=> (select 'a',s2 from t1 where s1 = 0)); +drop table t1; |