Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
create or replace table t (fld varchar(1)) default character set ucs2; |
insert into t values ('x'),('a'),('b'); |
select fld, natural_sort_key(fld) from t order by natural_sort_key(fld); |
drop table t; |
preview-10.7-MDEV-4742-natural-sort 50d54ba96 |
MariaDB [test]> select fld, natural_sort_key(fld) from t order by natural_sort_key(fld); |
+------+-----------------------+ |
| fld | natural_sort_key(fld) |
|
+------+-----------------------+ |
| x | NULL | |
| a | NULL | |
| b | NULL | |
+------+-----------------------+ |
3 rows in set (0.002 sec) |
Happens with ucs2, utf16, utf16le, utf32.
Attachments
Issue Links
- is caused by
-
MDEV-4742 A function for native natural sorting / natural compare
- Closed