[MDEV-34478] SHOW COLLATION shows strange NULLs - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 11.4.2
Fix Version/s: N/A
Component/s: Character Sets
Labels:
- collation

Description

MariaDB [(none)]> show collation ;

...

| uca1400_ai_ci                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_ai_cs                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_as_ci                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_as_cs                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_ai_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_ai_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_as_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_as_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_ai_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_ai_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_as_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_as_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_ai_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_ai_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_as_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_as_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_ai_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_ai_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_as_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_as_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_ai_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_ai_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_as_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_as_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_ai_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_ai_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_as_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_as_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_ai_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_ai_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_as_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_as_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_ai_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_ai_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_as_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_as_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_ai_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_ai_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_as_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_as_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_ai_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_ai_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_as_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_as_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_ai_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_ai_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_as_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_as_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_ai_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_ai_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_as_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_as_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_ai_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_ai_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_as_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_as_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_ai_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_ai_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_as_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_as_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_ai_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_ai_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_as_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_as_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

...

I only included the rows that show the problem.

Attachments

Issue Links

is caused by

MDEV-27009 Add UCA-14.0.0 collations

Closed

Activity

People

Assignee:: Unassigned

Reporter:: Federico Razzoli

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2024-06-27 12:55

Updated:: 2024-07-02 00:25

Resolved:: 2024-06-27 14:51

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.