[MDEV-30050] Inconsistent results of DISTINCT with NOPAD Created: 2022-11-21  Updated: 2023-10-24  Resolved: 2023-10-24

Status: Closed
Project: MariaDB Server
Component/s: Character Sets
Affects Version/s: 10.4
Fix Version/s: 10.8.8, 10.4.32, 10.5.23, 10.6.16, 10.9.8, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2, 11.3.1

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

Issue Links:
Relates
relates to MDEV-25904 New collation functions to compare In... Closed
relates to MDEV-27670 Assertion `(cs->state & 0x20000) == 0... Closed
relates to MDEV-27768 MDEV-25440: Assertion `(cs->state & 0... Closed
relates to MDEV-30048 Prefix keys for CHAR work differently... Closed
relates to MDEV-30072 Wrong ORDER BY for a partitioned pref... Closed
relates to MDEV-30034 UNIQUE USING HASH accepts duplicate e... Closed

 Description    

CREATE OR REPLACE TABLE t1 (c CHAR(100) COLLATE utf8mb3_unicode_nopad_ci);
 
INSERT INTO t1 VALUES ('ss'),('ß');
 
SET big_tables=0;
 
SELECT DISTINCT c FROM t1;


+------+
 
| c    |
 
+------+
 
| ss   |
 
| ß    |
 
+------+


SET big_tables=1;
 
SELECT DISTINCT c FROM t1;


+------+
 
| c    |
 
+------+
 
| ss   |
 
+------+



 Comments   
Comment by Alexander Barkov [ 2023-07-20 ]

Pushed earlier to a stage branch in a single patch with MDEV-30048.
Waiting for a review for MDEV-30048.

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