[MCOL-4370] LDI Crash With columnstore_use_import_for_batchinsert = ON/ALWAYS Created: 2020-10-23  Updated: 2020-11-09  Resolved: 2020-11-05

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

Type: Bug Priority: Major
Reporter: Todd Stoffel (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

When using LDI with columnstore_use_import_for_batchinsert = ON/ALWAYS (cpimport), MariaDB will crash if the values contain a curly brace and it is going into an TEXT field.

MariaDB [json]> LOAD DATA INFILE '/tmp/MOCK_DATA.csv' into table test6 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
 
ERROR 2013 (HY000): Lost connection to MySQL server during query


MariaDB [json]> show create table test6;
 
+-------+-------------------------------------------------------------------------------------------+
 
| Table | Create Table                                                                              |
 
+-------+-------------------------------------------------------------------------------------------+
 
| test6 | CREATE TABLE `test6` (
 
  `id` text DEFAULT NULL
 
) ENGINE=Columnstore DEFAULT CHARSET=utf8 |
 
+-------+-------------------------------------------------------------------------------------------+



 Comments   
Comment by Gagan Goel (Inactive) [ 2020-10-26 ]

For QA:

Steps to reproduce and ensure the bug is fixed:

drop table if exists mcol4370_cs;
 
 
 
CREATE TABLE `mcol4370_cs` (
 
  `id` text DEFAULT NULL
 
) engine=columnstore DEFAULT CHARSET=utf8;
 
 
 
LOAD DATA LOCAL INFILE '/tmp/mcol4370.txt' INTO TABLE mcol4370_cs FIELDS TERMINATED BY ',' ENCLOSED BY '"';
 
ERROR 2013 (HY000): Lost connection to MySQL server during query

Contents of /tmp/mcol4370.txt:

"1{"
 
"2"
 
"3"
 
"4"

Comment by Daniel Lee (Inactive) [ 2020-11-04 ]

Reproduced the issue in 5.4.1-1

Comment by Daniel Lee (Inactive) [ 2020-11-04 ]

Build tested: 5.4.1-1 (drone #1058)

engine: 7a1328a2694ad84160c79f05d47bd66cf6f9de4e
server: 1418439d3823fe059b41092af72ab32d5e7cd7ab
buildNo: 1058

Verified the fix in this build. Will retest on 5.4.2-1 when available.

Comment by Daniel Lee (Inactive) [ 2020-11-05 ]

Build verified: 5.4.2-1 hot fix (Enterprise Jenkins build #523)

Server version: 10.5.6-4.5.4.2-MariaDB-enterprise MariaDB Enterprise Server

Comment by Daniel Lee (Inactive) [ 2020-11-09 ]

Build verified: 5.4.3-1 hot fix (Enterprise Jenkins build #854)
Server version: 10.5.6-4.5.4.3-MariaDB-enterprise MariaDB Enterprise Server

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