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

HEX(COLUMN_CREATE(.. AS CHAR ...)) fails with --view-protocol

Details

    Description

      I add this line into dyncol.test:

      SELECT hex(column_create(1,'1212' AS CHAR CHARACTER SET utf8mb3 COLLATE utf8mb3_bin)) AS ex;

      and record the test.

      Now if I run mtr with --view-protocol, it fails with the following output:

      CURRENT_TEST: main.dyncol
      		 
      --- /home/bar/maria-git/10.5.dyncol/mysql-test/main/dyncol.result	2024-03-28 13:16:42.482595620 +0400
      		 
      +++ /home/bar/maria-git/10.5.dyncol/mysql-test/main/dyncol.reject	2024-03-28 13:17:05.012598834 +0400
      		 
      @@ -1951,4 +1951,4 @@
      		 
       #
      		 
       SELECT hex(column_create(1,'1212' AS CHAR CHARACTER SET utf8mb3 COLLATE utf8mb3_bin)) AS ex;
      		 
       ex
      		 
      -0001000100035331323132
      		 
      +0001000100032131323132

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25829 Change default Unicode collation to uca1400_ai_ci

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33696 main.dyncol and ctype_unicode_casefold_bmp.inc in --view

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-29446 Change SHOW CREATE TABLE to display default collations

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Assignee Alexander Barkov [ bar ]
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2024-03-29 05:00:18.0 2024-03-29 05:00:17.51
            bar Alexander Barkov made changes -
            Fix Version/s 10.5.25 [ 29626 ]
            Fix Version/s 10.6.18 [ 29627 ]
            Fix Version/s 10.11.8 [ 29630 ]
            Fix Version/s 11.0.6 [ 29628 ]
            Fix Version/s 11.1.5 [ 29629 ]
            Fix Version/s 11.2.4 [ 29631 ]
            Fix Version/s 11.4.2 [ 29633 ]
            Fix Version/s 11.5.1 [ 29634 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 11.5 [ 29506 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]

            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.