[jira] [Created] (CASSANDRA-13609) COPY FROM not handling newlines within field

["David Sturrock (JIRA)" <ji...@apache.org>]

David Sturrock created CASSANDRA-13609:
------------------------------------------

             Summary: COPY FROM not handling newlines within field
                 Key: CASSANDRA-13609
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13609
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
         Environment: CQL 5.0.1

            Reporter: David Sturrock
            Priority: Minor
             Fix For: 3.0.9


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 "?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org