diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2016-12-07 01:16:06 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2016-12-07 21:59:34 +0530 |
| commit | dd569c6e17e6704755ce20c65f64a5164b6bee54 (patch) | |
| tree | 76b3bf37a9df6f0323cbb7d6e629acd9ae89b964 | |
| parent | 7f4c2478a10e05408244d85c2da3cacb2da5a69a (diff) | |
| download | mariadb-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
| -rw-r--r-- | mysql-test/r/group_by_innodb.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/bug-11162.test | 6 | ||||
| -rw-r--r-- | mysql-test/t/group_by_innodb.test | 10 |
3 files changed, 17 insertions, 6 deletions
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 + |