diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-09-22 01:55:17 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-09-22 01:55:17 +0400 |
| commit | 42b928ca05fca3ae8858566622a3a483a70aa3fc (patch) | |
| tree | 71a762654c05d375112c3a135d6c598cdfb109d9 /mysql-test/r | |
| parent | 0df523d1f3c7005c95b137dfb299939770330aa4 (diff) | |
| download | mariadb-git-42b928ca05fca3ae8858566622a3a483a70aa3fc.tar.gz | |
Fix after previous cset: update test results
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/subselect_sj2_mat.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj2_mat.result b/mysql-test/r/subselect_sj2_mat.result index 5a5d0065d64..3541653a863 100644 --- a/mysql-test/r/subselect_sj2_mat.result +++ b/mysql-test/r/subselect_sj2_mat.result @@ -760,6 +760,23 @@ LEFT JOIN t2 AS SQ4_alias3 ON SQ4_alias3.f10 GROUP BY field2; field2 drop table t1, t2, t3; +# +# BUG#849763: Wrong result with second execution of prepared statement with semijoin + view +# +CREATE TABLE t1 ( c varchar(1)) engine=innodb; +INSERT INTO t1 VALUES ('r'); +CREATE TABLE t2 ( a integer, b varchar(1), c varchar(1)) engine=innodb; +INSERT INTO t2 VALUES (1,'r','r'); +CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1; +PREPARE st1 FROM 'SELECT * FROM t2 WHERE a = SOME (SELECT a FROM v1 WHERE v1.c = t2.c)'; +EXECUTE st1; +a b c +1 r r +EXECUTE st1; +a b c +1 r r +DROP VIEW v1; +DROP TABLE t1, t2; set optimizer_switch=@subselect_sj2_tmp; set optimizer_switch=default; select @@optimizer_switch like '%materialization=on%'; |