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

cpimport incorrectly truncating TEXT columns

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 23.10.0
    • None
    • 2023-10, 2023-11

    Description

      Here is the failing MTR test:

      ]0;mtr: spent 1:07:13 on 3569 tests. 0:04:05 (217 tests) left, 0 failedcolumnstore/devregression.mcs7252_regression_MCOL-669 [ fail ]
              Test ended at 2023-09-19 08:03:39
      ]0;mtr: spent 1:07:17 on 3570 tests. 0:04:04 (216 tests) left, 1 failed
      mysqltest: At line 29: query 'INSERT INTO MCOL_669_b SELECT * FROM MCOL_669_a' failed: <Unknown> (9999): Values saturated
       
      The result from queries just before the failure was:
      USE tpch1;
      drop table if exists MCOL_669_a;
      drop table if exists MCOL_669_B;
      CREATE TABLE MCOL_669_a (a int, b text) engine=columnstore;
      CREATE TABLE MCOL_669_b (a int, b text) engine=columnstore;
      INSERT INTO MCOL_669_a VALUES (1, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (2, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (3, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (4, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (5, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (6, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (7, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_a VALUES (8, REPEAT('MariaDB ', 7500));
      INSERT INTO MCOL_669_b SELECT * FROM MCOL_669_a;
       
       - saving '/usr/share/mysql-test/var/log/columnstore/devregression.mcs7252_regression_MCOL-669/' to '/usr/share/mysql-test/var/log/devregression.mcs7252_regression_MCOL-669/'
      

      Attachments

        Activity

          People

            tntnatbry Gagan Goel (Inactive)
            alexey.vorovich alexey vorovich (Inactive)
            Roman Roman
            Daniel Lee Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.