[MDEV-31540] Cursor protocol returns incorrect metadata for group_concat() Created: 2023-06-26  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 11.0, 11.1, 11.2
Fix Version/s: 10.4, 10.5, 10.6, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Lena Startseva Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-31005 Make working cursor-protocol Stalled

 Description   

Testcase:

create table t1 (f1 int unsigned, f2 varchar(255));
 
insert into t1 values (1,repeat('a',255)),(2,repeat('b',255));
 
--enable_metadata
 
select f2,group_concat(f1) from t1 group by f2;
 
--disable_metadata
 
drop table t1;

Expected result:

Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
 
def	test	t1	t1	f2	f2	253	255	255	Y	0	0	8
 
def					group_concat(f1)	252	1048576	1	Y	0	0	8

Actual result:

Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
 
def	test	t1	t1	f2	f2	253	255	255	Y	0	0	8
 
def					group_concat(f1)	252	16777215	1	Y	16	0	8


Generated at Thu Feb 08 10:24:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.