diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-11-12 15:02:25 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-11-12 15:02:25 +0100 |
commit | 441192bfb0e620b49cb58eaef96132151531fc54 (patch) | |
tree | 8dba9e5585ed2172e520f721ba4e8861bb7b3ef7 /mysql-test/r/ps_max_subselect-5113.result | |
parent | c98a054fdeab9c2d3a637cf4fce57a2f9756dcc8 (diff) | |
download | mariadb-git-441192bfb0e620b49cb58eaef96132151531fc54.tar.gz |
MDEV-5113 Wrong result (extra row) and valgrind warnings in Item_maxmin_subselect::any_value on 2nd execution of PS with SELECT subquery
When setting Item_func_not_all::test_sum_item or Item_func_not_all::test_sub_item,
reset the other one to NULL - they can never be set both. When a PS is reexecuted,
different executions might be optimized differently and a wrong test_su*_item
might stay set from the previous execution.
Diffstat (limited to 'mysql-test/r/ps_max_subselect-5113.result')
-rw-r--r-- | mysql-test/r/ps_max_subselect-5113.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/ps_max_subselect-5113.result b/mysql-test/r/ps_max_subselect-5113.result new file mode 100644 index 00000000000..427ef628ead --- /dev/null +++ b/mysql-test/r/ps_max_subselect-5113.result @@ -0,0 +1,16 @@ +CREATE TABLE t1 (b INT NOT NULL); +INSERT INTO t1 VALUES (0),(8); +PREPARE stmt FROM ' + SELECT 1 FROM t1 AS o + WHERE o.b >= ALL ( + SELECT a2.b FROM t1 AS a1 LEFT JOIN t1 AS a2 ON ( a2.b = a1.b ) + WHERE a1.b <= a2.b + ) +'; +EXECUTE stmt; +1 +1 +EXECUTE stmt; +1 +1 +DROP TABLE t1; |