[IGNITE-12852] Comma in field is not supported by COPY command

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.8
• Fix Version/s: 2.14
• Component/s: sql
• Release Note: Fixed parsing quoted delimiters in CSV fields content for SQL command COPY.
• Ignite Flags: Release Notes Required
• Assignee: Anton Kurbanov
• Reporter: YuJue Li
• Created: 01/Apr/20 13:37
• Updated: 25/Aug/22 10:05
• Resolved: 25/Aug/22 06:55

Description

CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a));

a.csv:
1,"a,b",2

COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV;

The copy command fails because there is a comma in the second field,but this is a fully legal and compliant CSV format

Issue Links

• Is contained by: IGNITE-7537 SQL COPY command: implement CSV format options
• is related to: IGNITE-14325 SQL COPY command: when conversion fails, the error does not contain information about line number and the failed value
• links to: GitHub Pull Request #7661
• links to: GitHub Pull Request #10141