summaryrefslogtreecommitdiff
path: root/mysql-test/include/mix1.inc
diff options
context:
space:
mode:
authorGeorgi Kodinov <joro@sun.com>2009-06-04 13:26:18 +0300
committerGeorgi Kodinov <joro@sun.com>2009-06-04 13:26:18 +0300
commit8c18db4c8eb7fff4c94e11b96f14b51ab1f19cfa (patch)
treec78cd97041f7537234e71d1fb700c6954735a18c /mysql-test/include/mix1.inc
parentd7bfc76deccc60636a4fbb4bebc386b9ec6bb184 (diff)
parenta037071a75cb388a17083ac0cca74e93b2dfd5d6 (diff)
downloadmariadb-git-8c18db4c8eb7fff4c94e11b96f14b51ab1f19cfa.tar.gz
merged 36995 to 5.1-bugteam
Diffstat (limited to 'mysql-test/include/mix1.inc')
-rw-r--r--mysql-test/include/mix1.inc10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/include/mix1.inc b/mysql-test/include/mix1.inc
index 303f896cdfe..3f7b44bd9ef 100644
--- a/mysql-test/include/mix1.inc
+++ b/mysql-test/include/mix1.inc
@@ -1171,6 +1171,16 @@ CREATE TABLE t1 (f1 INTEGER PRIMARY KEY COMMENT 'My ID#', f2 INTEGER DEFAULT NUL
SHOW CREATE TABLE t1;
DROP TABLE t1;
+--echo #
+--echo # Bug #36995: valgrind error in remove_const during subquery executions
+--echo #
+
+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;
+DROP TABLE t1,t2;
+
--echo End of 5.0 tests
# Fix for BUG#19243 "wrong LAST_INSERT_ID() after ON DUPLICATE KEY