diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2016-12-07 23:34:01 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2016-12-07 23:34:01 +0530 |
| commit | 527df98a8b1bb33ade6a8c83a8928350524a2894 (patch) | |
| tree | 532acc3dd869614f3a0e1f59748152dbb32fec20 | |
| parent | e99990c631905cd923257331ef124a2bc9276e0d (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
| -rw-r--r-- | mysql-test/r/group_by_innodb.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/group_by_innodb.test | 9 | ||||
| -rw-r--r-- | sql/sql_select.cc | 1 |
3 files changed, 17 insertions, 0 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/group_by_innodb.test b/mysql-test/t/group_by_innodb.test index e072a94fada..89eff0f6080 100644 --- a/mysql-test/t/group_by_innodb.test +++ b/mysql-test/t/group_by_innodb.test @@ -125,4 +125,13 @@ 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 diff --git a/sql/sql_select.cc b/sql/sql_select.cc index 2db9a2b8482..f345d3c9687 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -3144,6 +3144,7 @@ JOIN::destroy() */ tmp_table_param.cleanup(); tmp_join->tmp_table_param.copy_field= 0; + cleanup(1); DBUG_RETURN(tmp_join->destroy()); } cond_equal= 0; |