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

Regression: Bit and hex string literals changed column names in 10.0.14

Details

    Description

      Bit and hex string literals unintentionally changed column names in 10.0.14 (possibly a fix for MDEV-6688)

      Before the change:

      mysql> SELECT _utf8 X'63', _utf8 B'01111110';
      		 
      +-------------+-------------------+
      		 
      | _utf8 X'63' | _utf8 B'01111110' |
      		 
      +-------------+-------------------+
      		 
      | c           | ~                 |
      		 
      +-------------+-------------------+

      after the change:

      mysql> SELECT _utf8 X'63', _utf8 B'01111110';
      		 
      +---+---+
      		 
      | c | ~ |
      		 
      +---+---+
      		 
      | c | ~ |
      		 
      +---+---+

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          bar Alexander Barkov created issue -
          bar Alexander Barkov made changes -
          Field Original Value New Value
          Summary Regression: Bit string literals changed column names in 10.0.14 Regression: Bit and hex string literals changed column names in 10.0.14
          bar Alexander Barkov made changes -
          Description Bit string literals unintentionally changed column names in 10.0.14 (possibly a fix for MDEV-6688)

          Before the change:
          {code}
          mysql> SELECT _utf8 X'63', _utf8 B'01111110';
          +-------------+-------------------+
          | _utf8 X'63' | _utf8 B'01111110' |
          +-------------+-------------------+
          | c | ~ |
          +-------------+-------------------+
          {code}

          after the change:
          {code}
          mysql> SELECT _utf8 X'63', _utf8 B'01111110';
          +---+---+
          | c | ~ |
          +---+---+
          | c | ~ |
          +---+---+
          {code}
          		 Bit and hex string literals unintentionally changed column names in 10.0.14 (possibly a fix for MDEV-6688)

          Before the change:
          {code}
          mysql> SELECT _utf8 X'63', _utf8 B'01111110';
          +-------------+-------------------+
          | _utf8 X'63' | _utf8 B'01111110' |
          +-------------+-------------------+
          | c | ~ |
          +-------------+-------------------+
          {code}

          after the change:
          {code}
          mysql> SELECT _utf8 X'63', _utf8 B'01111110';
          +---+---+
          | c | ~ |
          +---+---+
          | c | ~ |
          +---+---+
          {code}
          bar Alexander Barkov made changes -
          Fix Version/s 10.0.17 [ 18300 ]
          bar Alexander Barkov made changes -
          Component/s Character Sets [ 10801 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.18 [ 18702 ]
          Fix Version/s 10.0.17 [ 18300 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 59816 ] MariaDB v3 [ 66453 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 66453 ] MariaDB v4 [ 148831 ]

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.