MySQL Bugs: #108152: PARTITION BY LIST COLUMNS does not normalize/format the list values

Bug #108152	PARTITION BY LIST COLUMNS does not normalize/format the list values
Submitted:	16 Aug 2022 14:08	Modified:	22 Aug 2022 11:32
Reporter:	Mattias Jonsson	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Partitions	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The values in LIST COLUMNS partitions are not normalised/formatted to what the output from its columns would look like, but seems to be kept as-is from how they were created.

How to repeat:
create table t (a int, b varchar(255), c datetime, d varchar(255))
partition by list columns (a,b,c)
(partition p0 values in ((1,"aa",'20220101'),(2,"BB",'2021-01-01')),
 partition p1 values in ((1,"bb",'2023-01-01 00:01:02'),(3,"aA",'20230102030405')),
 partition p3 values in ((2,"Aa",'2021-09-09 12:00:00'),(3,"Bb",'2020-02-02 02:02:02')));
show create table t;

Suggested fix:
Normalise/format the constants according to the column type normal output.

Hi Mr. Jonsson,

Thank you for your bug report.

However , it is not a bug. 

But, if you would agree, that would be a nice feature request. If you agree to make this report a feature request, we shall be happy to verify it ......

I agree to make this a feature request :)

Thanks Mr. Jonsson,

This is now a verified feature request.