From dd569c6e17e6704755ce20c65f64a5164b6bee54 Mon Sep 17 00:00:00 2001 From: Varun Gupta Date: Wed, 7 Dec 2016 01:16:06 +0530 Subject: MDEV-11162 Assertion `num_records == m_idx_array.size()' failed in Filesort_buffer::alloc_sort_buffer(uint, uint) Result file added and test added to the group_by_innodb test file --- mysql-test/r/group_by_innodb.result | 7 +++++++ mysql-test/t/bug-11162.test | 6 ------ mysql-test/t/group_by_innodb.test | 10 ++++++++++ 3 files changed, 17 insertions(+), 6 deletions(-) delete mode 100644 mysql-test/t/bug-11162.test (limited to 'mysql-test') diff --git a/mysql-test/r/group_by_innodb.result b/mysql-test/r/group_by_innodb.result index 381e0d7493c..803efb8fd5c 100644 --- a/mysql-test/r/group_by_innodb.result +++ b/mysql-test/r/group_by_innodb.result @@ -123,4 +123,11 @@ id xtext optionen 2 number 22,25 1 select Kabel mit Stecker 5-polig,Kabel ohne Stecker DROP TABLE t1, t2; +CREATE TABLE t1 (i INT) ENGINE=InnoDB; +SELECT ( SELECT DISTINCT GROUP_CONCAT(SLEEP(0)) FROM t1 GROUP BY i ); +( SELECT DISTINCT GROUP_CONCAT(SLEEP(0)) FROM t1 GROUP BY i ) +NULL +SELECT i FROM t1 order by i LIMIT 1; +i +DROP TABLE t1; # End of tests diff --git a/mysql-test/t/bug-11162.test b/mysql-test/t/bug-11162.test deleted file mode 100644 index 5924851a9ac..00000000000 --- a/mysql-test/t/bug-11162.test +++ /dev/null @@ -1,6 +0,0 @@ ---source include/have_innodb.inc - -CREATE TABLE t1 (i INT) ENGINE=InnoDB; -SELECT ( SELECT DISTINCT GROUP_CONCAT(SLEEP(0)) FROM t1 GROUP BY i ); -SELECT i FROM t1 order by i LIMIT 1; -drop table t1; diff --git a/mysql-test/t/group_by_innodb.test b/mysql-test/t/group_by_innodb.test index e072a94fada..074df222294 100644 --- a/mysql-test/t/group_by_innodb.test +++ b/mysql-test/t/group_by_innodb.test @@ -125,4 +125,14 @@ ORDER BY id DESC; DROP TABLE t1, t2; +--echo # +--echo # MDEV-11162: Assertion `num_records == m_idx_array.size()' failed in Filesort_buffer::alloc_sort_buffer(uint, uint) +--echo # + +CREATE TABLE t1 (i INT) ENGINE=InnoDB; +SELECT ( SELECT DISTINCT GROUP_CONCAT(SLEEP(0)) FROM t1 GROUP BY i ); +SELECT i FROM t1 order by i LIMIT 1; +DROP TABLE t1; + --echo # End of tests + -- cgit v1.2.1