Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34478

SHOW COLLATION shows strange NULLs

    XMLWordPrintable

Details

    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

          Activity

            People

              Unassigned Unassigned
              f_razzoli Federico Razzoli
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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