diff options
| author | Monty <monty@mariadb.org> | 2021-02-15 01:33:06 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2021-02-15 01:33:06 +0200 |
| commit | 34c654024cd915d117234a40dd51063d9d4c4d04 (patch) | |
| tree | c9e2ca5ab4f3f2f3d112ab25b1090b84f395e6e3 /mysql-test/main/group_by.test | |
| parent | b3df194e31eb2e76a319d8d4195163df596447a6 (diff) | |
| download | mariadb-git-34c654024cd915d117234a40dd51063d9d4c4d04.tar.gz | |
MDEV-24855 ER_CRASHED_ON_USAGE or Assertion `length <= column->length'
When creating a summary temporary table with bit fields used in the sum
expression with several parameters, like GROUP_CONCAT(), the counting of
bits needed in the record was wrong.
The reason we got an assert in Aria was because the bug caused a memory
overwrite in the record and Aria noticed that the data was 'impossible.
Diffstat (limited to 'mysql-test/main/group_by.test')
| -rw-r--r-- | mysql-test/main/group_by.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/group_by.test b/mysql-test/main/group_by.test index 15bc1791022..87315e903e9 100644 --- a/mysql-test/main/group_by.test +++ b/mysql-test/main/group_by.test @@ -1717,6 +1717,18 @@ FROM t1 JOIN t2 ON c = b GROUP BY b WITH ROLLUP; DROP TABLE t1,t2; --echo # +--echo # MDEV-24855 ER_CRASHED_ON_USAGE or Assertion `length <= column->length' +--echo # failed in ma_blockrec.c +--echo # + +CREATE TABLE t1 (a BIT(5), c BINARY(179)); +INSERT INTO t1 VALUES (b'1100','foo'),(b'0','bar'); +--disable_result_log +SELECT c, GROUP_CONCAT(CASE NULL WHEN 0 THEN a END, CASE 'foo' WHEN c THEN 1 END) AS f FROM t1 GROUP BY ExtractValue('<a></a>', '/a'), UUID(); +--enable_result_log +DROP TABLE t1; + +--echo # --echo # MDEV-6129: Server crashes during UNION with ORDER BY field IS NULL --echo # |