Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
5.4.1
-
None
Description
Build tested: 5.4.1-1
This test is related to the following ColumnStore MTR test cases:
mcs6769_function_CNX_GROUP_CONCAT_SM.test
mcs6770_function_CNX_GROUP_CONCAT_SS.test
mcs6842_function_CNXPP_GROUP_CONCAT_SM.test
mcs6843_function_CNXPP_GROUP_CONCAT_SS.test
This issue occurs when MEDIUMTEXT or LONGTEXT data type is used.
It works for TEXT or TINYTEXT.
There is only one row in the test table
MariaDB [mytest]> select * from datatypetestm;
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CIDX | CBIGINT | CDECIMAL1 | CDECIMAL4 | CDECIMAL4_2 | CDECIMAL5 | CDECIMAL9 | CDECIMAL9_2 | CDECIMAL10 | CDECIMAL18 | CDECIMAL18_2 | CINTEGER | CSMALLINT | CTINYINT | CDOUBLE | CFLOAT | CDATE | CDATETIME | CTIME | CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7 | CCHAR8 | CCHAR9 | CCHAR255 | CVCHAR1 | CVCHAR2 | CVCHAR3 | CVCHAR4 | CVCHAR5 | CVCHAR6 | CVCHAR7 | CVCHAR8 | CVCHAR255 | CTEXT | CBLOB | CMEDIUMINT | CTINYTEXT | CTINYBLOB | CMEDIUMTEXT | CMEDIUMBLOB | CLONGTEXT | CLONGBLOB | CTIMESTAMP |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1 | -72036854775806 | -9 | -999 | -9.99 | -999 | -999999 | -9999.99 | -9999999 | -9999999999999 | -99999999999.99 | -7483646 | -766 | -26 | -1.797693231e108 | -3.40287e18 | 1997-01-01 | 1997-01-01 00:00:00 | 13:00:00 | a | aa | aaa | aaaa | aaaaa | aaaaaa | aaaaaaa | aaaaaaaa | aaaaaaaaa | aaaaaaaaaa | a | aa | aaa | aaaa | aaaaa | aaaaaa | aaaaaaa | aaaaaaaa | aaaaaaaaaa | texttexttext | blobblobblob | 1000 | tinytext | tinyblob | mediumtestmediumtest | mediumblobmediumblob | longtextlongtextlongtext | longbloblongbloblongblob | 2020-08-13 03:14:07 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.065 sec)
MariaDB [mytest]> select CMEDIUMTEXT, CLONGTEXT, CCHAR3 from datatypetestm;
----------------------------------------------------
| CMEDIUMTEXT | CLONGTEXT | CCHAR3 |
----------------------------------------------------
| mediumtestmediumtest | longtextlongtextlongtext | aaa |
----------------------------------------------------
1 row in set (0.021 sec)
MariaDB [mytest]> show variables like "%max_length_for_sort_data%";
-------------------------------+
| Variable_name | Value |
-------------------------------+
| max_length_for_sort_data | 1024 |
-------------------------------+
I also set the max_length_for_sort_data variable to 68192 or 8388608 (the max value). It did not make any difference.
MariaDB [mytest]> select GROUP_CONCAT(CMEDIUMTEXT,CCHAR3) from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CMEDIUMTEXT,CCHAR3,'Calpont') from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CMEDIUMTEXT,CCHAR3,'Calpont' separator '#') from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CMEDIUMTEXT,CCHAR3,'Calpont' ORDER BY CIDX ASC) from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CLONGTEXT,CCHAR3) from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CLONGTEXT,CCHAR3,'Calpont') from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CLONGTEXT,CCHAR3,'Calpont' separator '#') from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select GROUP_CONCAT(CLONGTEXT,CCHAR3,'Calpont' ORDER BY CIDX ASC) from datatypetestm;
ERROR 1815 (HY000): Internal error: IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CMEDIUMTEXT, GROUP_CONCAT(CMEDIUMTEXT,CCHAR3) from datatypetestm group by cidx, CMEDIUMTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CMEDIUMTEXT, GROUP_CONCAT(CMEDIUMTEXT,CCHAR3,'Calpont') from datatypetestm group by cidx, CMEDIUMTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CMEDIUMTEXT, GROUP_CONCAT(CMEDIUMTEXT,CCHAR3,'Calpont' separator '#') from datatypetestm group by cidx, CMEDIUMTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CMEDIUMTEXT, GROUP_CONCAT(CMEDIUMTEXT,CCHAR3,'Calpont' ORDER BY CIDX ASC) from datatypetestm group by cidx, CMEDIUMTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CLONGTEXT, GROUP_CONCAT(CLONGTEXT,CCHAR3) from datatypetestm group by cidx, CLONGTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CLONGTEXT, GROUP_CONCAT(CLONGTEXT,CCHAR3,'Calpont') from datatypetestm group by cidx, CLONGTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CLONGTEXT, GROUP_CONCAT(CLONGTEXT,CCHAR3,'Calpont' separator '#') from datatypetestm group by cidx, CLONGTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.
MariaDB [mytest]> select cidx, CLONGTEXT, GROUP_CONCAT(CLONGTEXT,CCHAR3,'Calpont' ORDER BY CIDX ASC) from datatypetestm group by cidx, CLONGTEXT ;
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups() IDB-2003: Aggregation/Distinct memory limit is exceeded.