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

View cuts off the end of string with the utf8 character set in INSERT function

Details

    Description

      Case:

      SELECT HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20));
      		 
      CREATE VIEW v1 AS SELECT HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20));
      		 
      SELECT * FROM v1;
      		 
      DROP VIEW v1;

      Expected that result for the first select and select from view will be the same but this is not so:
      Actual result:

      SELECT HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20));
      		 
      HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20))
      		 
      D120D18E
      		 
       
      		 
      SELECT * FROM v1;
      		 
      HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20))
      		 
      D120D1

      Expected result:

      SELECT * FROM v1;
      		 
      HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20))
      		 
      D120D18E

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31512 Cursor protocol cuts off the end of string with the utf8 character set in INSERT function

          • Major - Major loss of function.
          • Closed
          relates to

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28651 quote(NULL) returns incorrect result in view ('NU' instead of 'NULL')

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31512 Cursor protocol cuts off the end of string with the utf8 character set in INSERT function

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            lstartseva Lena Startseva created issue -
            lstartseva Lena Startseva made changes -
            Field Original Value New Value
            lstartseva Lena Startseva made changes -
            lstartseva Lena Startseva made changes -
            lstartseva Lena Startseva made changes -
            Assignee Alexander Barkov [ bar ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.0 [ 28320 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.1 [ 28549 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.5 [ 29506 ]
            bar Alexander Barkov made changes -
            Fix Version/s 10.6.21 [ 29953 ]
            Fix Version/s 10.11.11 [ 29954 ]
            Fix Version/s 11.2.7 [ 29955 ]
            Fix Version/s 11.4.5 [ 29956 ]
            Fix Version/s 11.6.2 [ 29908 ]
            Fix Version/s 11.7.1 [ 29913 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.2 [ 28603 ]
            Fix Version/s 11.4 [ 29301 ]
            bar Alexander Barkov made changes -
            Component/s OTHER [ 10125 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            bar Alexander Barkov made changes -

            People

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