summaryrefslogtreecommitdiff
path: root/mysql-test/t/group_by_innodb.test
diff options
context:
space:
mode:
authorVarun Gupta <varunraiko1803@gmail.com>2016-12-07 01:16:06 +0530
committerVarun Gupta <varunraiko1803@gmail.com>2016-12-07 21:59:34 +0530
commitdd569c6e17e6704755ce20c65f64a5164b6bee54 (patch)
tree76b3bf37a9df6f0323cbb7d6e629acd9ae89b964 /mysql-test/t/group_by_innodb.test
parent7f4c2478a10e05408244d85c2da3cacb2da5a69a (diff)
downloadmariadb-git-bb-10.0.11162.tar.gz
MDEV-11162 Assertion `num_records == m_idx_array.size()' failed in Filesort_buffer::alloc_sort_buffer(uint, uint)bb-10.0.11162
Result file added and test added to the group_by_innodb test file
Diffstat (limited to 'mysql-test/t/group_by_innodb.test')
-rw-r--r--mysql-test/t/group_by_innodb.test10
1 files changed, 10 insertions, 0 deletions
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
+