|
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%";
-------------------------
-------------------------
| 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.
|