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

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

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

            There are no comments yet on this issue.

            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.