[CASSANDRA-13609] COPY FROM not handling newlines within field

• Type: Bug
• Status: Open
• Priority: Low
• Resolution: Unresolved
• Fix Version/s: 3.0.x
• Component/s: Legacy/CQL

Environment

CQL 5.0.1

• Severity: Low
• Assignee: Unassigned
• Reporter: David Sturrock
• Created: 15/Jun/17 16:08
• Updated: 16/Apr/19 09:30

Description

When using Copy From to import data from a CSV file, if it comes across a row like like this:

10.0, 10.0, 0.0, "UX JSY AIO PETE
10% off Toys Catalogue 10.00% -1.00 ", "Canterbury"
10.0, 10.0,......

It will treat the newline after PETE as the end of the first row

While this makes sense since it's treating each line as a new row, it's also supposed to treat content between "s as a field but instead finishes half way through a field. Shouldn't the fact that it's inside a field take precedence here and have it continue reading until it finds a closing "?

Issue Links

• is duplicated by: CASSANDRA-8675 COPY TO/FROM broken for newline characters