[MCOL-5573] cpimport incorrectly truncating TEXT columns Created: 2023-09-08  Updated: 2023-09-22  Resolved: 2023-09-21

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 23.10.0

Type: Task Priority: Major
Reporter: alexey vorovich (Inactive) Assignee: Gagan Goel (Inactive)
Resolution: Fixed Votes: 0
Labels: rm_stability

Sprint: 2023-10, 2023-11
Assigned for Review: Roman Roman
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 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/'



 Comments   
Comment by Gagan Goel (Inactive) [ 2023-09-19 ]

For QA: To test the fix, the above failing MTR test case (columnstore/devregression.mcs7252_regression_MCOL-669) should now run successfully with the fix.

Comment by Daniel Lee (Inactive) [ 2023-09-21 ]

Build verified: develop branch

engine: 7f9c624626767445271b5bf6bde2081c7533a852
server: 33ee6715a5ddbf75fccd023c9bb55d862240de33
buildNo: 8704

Generated at Thu Feb 08 02:58:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.