[MDEV-28118] Wrong collation of `CAST(.. AS CHAR COLLATE DEFAULT)` Created: 2022-03-18  Updated: 2022-03-23  Resolved: 2022-03-23

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.9.0

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-27743 Remove Lex::charset Closed

 Description    

SET NAMES utf8mb3 COLLATE utf8mb3_bin;
 
SELECT COLLATION(CAST('a' AS CHAR COLLATE DEFAULT));


+----------------------------------------------+
 
| COLLATION(CAST('a' AS CHAR COLLATE DEFAULT)) |
 
+----------------------------------------------+
 
| utf8mb3_bin                                  |
 
+----------------------------------------------+

Looks wrong. The expected behavior is to return default collation for utf8mb3, which is utf8mb3_general_ci.
Generated at Thu Feb 08 09:58:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.