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

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

    XMLWordPrintable

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.
          • Stalled

          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.
          • In Progress
          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

            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.