diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2012-06-04 17:26:11 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2012-06-04 17:26:11 +0200 |
| commit | 3e3606d21deec2a7508d47740ab7a7a7f5b9b698 (patch) | |
| tree | 5e041eb2fc7ca4f15ff97bfc3dba62840ab802fc /mysql-test/r/subselect_sj.result | |
| parent | afedd72e225654225b20a91b072b012e4c57a9d4 (diff) | |
| parent | 25ada13db06d06050f0361bc434fe2b58303b5f2 (diff) | |
| download | mariadb-git-3e3606d21deec2a7508d47740ab7a7a7f5b9b698.tar.gz | |
merge with 5.3.
Take only test cases from MDEV-136 Non-blocking "set read_only"
Diffstat (limited to 'mysql-test/r/subselect_sj.result')
| -rw-r--r-- | mysql-test/r/subselect_sj.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj.result b/mysql-test/r/subselect_sj.result index 1ceeb541a85..660137affec 100644 --- a/mysql-test/r/subselect_sj.result +++ b/mysql-test/r/subselect_sj.result @@ -2753,4 +2753,18 @@ AND ( alias1.a1, alias2.a1 ) IN ( SELECT c1, c1 FROM t3 ) GROUP BY field1; field1 DROP TABLE t1,t3,t2; +# +# BUG#1002630: Valgrind warnings 'Invalid read' in subselect_engine::calc_const_tables with SELECT +# +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(7); +CREATE TABLE t2 (b INT); +INSERT INTO t2 VALUES (4),(6); +SELECT ( SELECT SUM(a) FROM t1 ) AS t1sum, b +FROM t2 +WHERE (1,1) IN ( SELECT MAX(a), MIN(a) FROM t1 ) +GROUP BY b +HAVING t1sum <> 1; +t1sum b +DROP TABLE t1, t2; set optimizer_switch=@subselect_sj_tmp; |