diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-01-28 13:36:05 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-01-28 13:36:05 +0100 |
| commit | 87de27e46b889d86cd872adf8ce613128d379911 (patch) | |
| tree | 87f3ec6d65538b9bc199408f58daaa2ec9e7a702 /mysql-test/r/subselect_sj.result | |
| parent | f08a404a6d87f7c8c7fef1862eaf768cf920677b (diff) | |
| parent | 34e84c227f1cb76771eabf229b4cf1b5292eef25 (diff) | |
| download | mariadb-git-87de27e46b889d86cd872adf8ce613128d379911.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/r/subselect_sj.result')
| -rw-r--r-- | mysql-test/r/subselect_sj.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj.result b/mysql-test/r/subselect_sj.result index 972725e30a4..d9fa9853da5 100644 --- a/mysql-test/r/subselect_sj.result +++ b/mysql-test/r/subselect_sj.result @@ -2768,6 +2768,21 @@ HAVING t1sum <> 1; t1sum b DROP TABLE t1, t2; # +# MDEV-3911: Assertion `fixed == 0' failed in Item_field::fix_fields +# on 2nd execution of PS with semijoin=on and IN subquery +# +CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM; +INSERT INTO t1 VALUES (0,4),(8,6); +CREATE TABLE t2 (c INT, d INT) ENGINE=MyISAM; +INSERT INTO t2 VALUES (7,1),(0,7); +PREPARE stmt FROM ' SELECT * FROM t1 WHERE ( a, b ) IN ( SELECT c, d FROM t2 ) '; +execute stmt; +a b +execute stmt; +a b +deallocate prepare stmt; +drop table t1,t2; +# # MySQL Bug#13340270: assertion table->sort.record_pointers == __null # CREATE TABLE t1 ( |