diff options
| author | Evgeny Potemkin <epotemkin@mysql.com> | 2008-10-27 15:04:51 +0300 |
|---|---|---|
| committer | Evgeny Potemkin <epotemkin@mysql.com> | 2008-10-27 15:04:51 +0300 |
| commit | fbb6efeb514ff5039fd7dda0d27210eb80d9ff9e (patch) | |
| tree | 1c74c8ce1a6a3c25bbb30bb2a6ce46ab7c224b08 /mysql-test/r/explain.result | |
| parent | 8d108cb53b48601aa0f570c918284e579ccff16b (diff) | |
| parent | e27e56078388c2005b46073b5b295edcba79f359 (diff) | |
| download | mariadb-git-fbb6efeb514ff5039fd7dda0d27210eb80d9ff9e.tar.gz | |
Merged fix for the bug#37870.
Diffstat (limited to 'mysql-test/r/explain.result')
| -rw-r--r-- | mysql-test/r/explain.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index 742dc5ae49d..ee3a4ba3387 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -155,3 +155,18 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select 1 AS `1` from (select count(distinct `test`.`t1`.`a`) AS `COUNT(DISTINCT t1.a)` from `test`.`t1` join `test`.`t2` group by `test`.`t1`.`a`) `s1` DROP TABLE t1,t2; +# +# Bug#37870: Usage of uninitialized value caused failed assertion. +# +create table t1 (dt datetime not null); +create table t2 (dt datetime not null); +insert into t1 values ('2001-01-01 1:1:1'), ('2001-01-01 1:1:1'); +insert into t2 values ('2001-01-01 1:1:1'), ('2001-01-01 1:1:1'); +flush tables; +EXPLAIN SELECT OUTR.dt FROM t1 AS OUTR WHERE OUTR.dt IN (SELECT INNR.dt FROM t2 AS INNR WHERE OUTR.dt IS NULL ); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY OUTR ALL NULL NULL NULL NULL 2 Using where +2 DEPENDENT SUBQUERY INNR ALL NULL NULL NULL NULL 2 Using where +SELECT OUTR.dt FROM t1 AS OUTR WHERE OUTR.dt IN (SELECT INNR.dt FROM t2 AS INNR WHERE OUTR.dt IS NULL ); +dt +drop tables t1, t2; |