diff options
Diffstat (limited to 'mysql-test/main/group_min_max.test')
-rw-r--r-- | mysql-test/main/group_min_max.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/group_min_max.test b/mysql-test/main/group_min_max.test index cf9952e817d..0fa91e4d72b 100644 --- a/mysql-test/main/group_min_max.test +++ b/mysql-test/main/group_min_max.test @@ -1726,6 +1726,23 @@ SELECT DISTINCT owner_id FROM t1 WHERE foo = true GROUP BY owner_id HAVING (COUN DROP TABLE t1; --echo # +--echo # MDEV-30240 Wrong result upon aggregate function with SQL_BUFFER_RESULT +--echo # + +drop table if exists t1,t2; +CREATE TABLE t1 (pk INT PRIMARY KEY); +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (a INT); +INSERT INTO t2 VALUES (1),(2); +SELECT SQL_BUFFER_RESULT MIN(pk) FROM t1, t2; +SELECT MIN(pk) FROM t1, t2; +DROP TABLE t1, t2; + +--echo # +--echo # End of 10.5 tests +--echo # + +--echo # --echo # MDEV-24353: Adding GROUP BY slows down a query --echo # |