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

Too long values are silently truncated without errors or warnings upon UPDATE

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None

    Description

      Server 10.7 8dd4794c4, Columnstore 6.1.1

      MariaDB [db]> create table t (c char(4)) engine=Columnstore;
      Query OK, 0 rows affected (0.632 sec)
       
      MariaDB [db]> insert into t values ('foo');
      Query OK, 1 row affected (0.194 sec)
       
      MariaDB [db]> insert into t values ('foobar');
      ERROR 1406 (22001): Data too long for column 'c' at row 1
      MariaDB [db]> update t set c = 'foobar';
      Query OK, 1 row affected (0.276 sec)
      Rows matched: 1  Changed: 1  Warnings: 0
       
      MariaDB [db]> select * from t;
      +------+
      | c    |
      +------+
      | foob |
      +------+
      1 row in set (0.034 sec)
      

      So, INSERT is dutifully rejected, but UPDATE is accepted without any complaint.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              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.