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

[16 Aug 14:08] Mattias Jonsson
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.
[17 Aug 11:28] MySQL Verification Team
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 ......
[19 Aug 13:21] Mattias Jonsson
I agree to make this a feature request :)
[22 Aug 11:32] MySQL Verification Team
Thanks Mr. Jonsson,

This is now a verified feature request.