Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3635

Inserting string literals containing '\0' truncates the string after the null terminating character.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: DMLProc
    • Labels:
      None

      Description

      During insertion, CS is truncating a string literal containing a null terminating character to the string before the character. InnoDB however does the insert correctly.

      Here is an example:

      MariaDB [test]> create table c1 (a varchar(10))engine=columnstore;
      Query OK, 0 rows affected (0.218 sec)
       
      MariaDB [test]> insert into c1 values ('a\0b');
      Query OK, 1 row affected (0.235 sec)
       
      MariaDB [test]> select * from c1;
      +------+
      | a    |
      +------+
      | a    |
      +------+
      1 row in set (0.076 sec)
       
      MariaDB [test]> create table i1 (a varchar(10));
      Query OK, 0 rows affected (0.008 sec)
       
      MariaDB [test]> insert into i1 values ('a\0b');
      Query OK, 1 row affected (0.052 sec)
       
      MariaDB [test]> select * from i1;
      +------+
      | a    |
      +------+
      | a b  |
      +------+
      1 row in set (0.001 sec)
      
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            tntnatbry Gagan Goel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.