From a68fb2d8219f6bccc573009600e9f23e89226a5e Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:04:16 +0200 Subject: Adding upstream version 1:10.6.11. Signed-off-by: Daniel Baumann --- mysql-test/main/ps_max_subselect-5113.test | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 mysql-test/main/ps_max_subselect-5113.test (limited to 'mysql-test/main/ps_max_subselect-5113.test') diff --git a/mysql-test/main/ps_max_subselect-5113.test b/mysql-test/main/ps_max_subselect-5113.test new file mode 100644 index 00000000..255e81c1 --- /dev/null +++ b/mysql-test/main/ps_max_subselect-5113.test @@ -0,0 +1,20 @@ +# +# MDEV-5113 Wrong result (extra row) and valgrind warnings in Item_maxmin_subselect::any_value on 2nd execution of PS with SELECT subquery +# + +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; +EXECUTE stmt; + +DROP TABLE t1; + -- cgit v1.2.3