diff options
author | Georgi Kodinov <joro@sun.com> | 2009-06-04 13:26:18 +0300 |
---|---|---|
committer | Georgi Kodinov <joro@sun.com> | 2009-06-04 13:26:18 +0300 |
commit | 8c18db4c8eb7fff4c94e11b96f14b51ab1f19cfa (patch) | |
tree | c78cd97041f7537234e71d1fb700c6954735a18c /mysql-test/r/innodb_mysql.result | |
parent | d7bfc76deccc60636a4fbb4bebc386b9ec6bb184 (diff) | |
parent | a037071a75cb388a17083ac0cca74e93b2dfd5d6 (diff) | |
download | mariadb-git-8c18db4c8eb7fff4c94e11b96f14b51ab1f19cfa.tar.gz |
merged 36995 to 5.1-bugteam
Diffstat (limited to 'mysql-test/r/innodb_mysql.result')
-rw-r--r-- | mysql-test/r/innodb_mysql.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_mysql.result b/mysql-test/r/innodb_mysql.result index 83a2a2111d5..7e4359e1f92 100644 --- a/mysql-test/r/innodb_mysql.result +++ b/mysql-test/r/innodb_mysql.result @@ -1420,6 +1420,18 @@ t1 CREATE TABLE `t1` ( CONSTRAINT `f2_ref` FOREIGN KEY (`f2`) REFERENCES `t1` (`f1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DROP TABLE t1; +# +# Bug #36995: valgrind error in remove_const during subquery executions +# +create table t1 (a bit(1) not null,b int) engine=myisam; +create table t2 (c int) engine=innodb; +explain +select b from t1 where a not in (select b from t1,t2 group by a) group by a; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +2 DEPENDENT SUBQUERY t1 system NULL NULL NULL NULL 0 const row not found +2 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 1 +DROP TABLE t1,t2; End of 5.0 tests CREATE TABLE `t2` ( `k` int(11) NOT NULL auto_increment, |