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

DNAMES: column names do not work with non-trivial encodings

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.0
    • Component/s: None
    • Labels:
      None

      Description

      A column created with a name in koi8r cannot be found:

      set names koi8r;
      
      select column_exists(column_create('имя','value'),'имя');
      # +---------------------------------------------------------+
      # | column_exists(column_create('имя','value'),'имя')       |
      # +---------------------------------------------------------+
      # |                                                       0 |
      # +---------------------------------------------------------+
      

      At the same time, for values it works:

      set names koi8r;
       select column_get(column_create('name','значение'),'name' as char(16)) = 'значение';
      +----------------------------------------------------------------------------------------------+
      | column_get(column_create('name','значение'),'name' as char(16)) = 'значение'                 |
      +----------------------------------------------------------------------------------------------+
      |                                                                                            1 |
      +----------------------------------------------------------------------------------------------+
      

      bzr version-info

      revision-id: elenst@ubuntu11.home-20120813090607-jtuq5p0umts16h5h
      date: 2012-08-13 13:06:07 +0400
      build-date: 2012-08-16 05:11:01 +0400
      revno: 3490
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              sanja Oleksandr Byelkin added a comment -

              fixed

              Show
              sanja Oleksandr Byelkin added a comment - fixed

                People

                • Assignee:
                  sanja Oleksandr Byelkin
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: