[
https://issues.apache.org/jira/browse/CASSANDRA-11631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15256169#comment-15256169
]
Stefania commented on CASSANDRA-11631:
--------------------------------------
I've fixed the CI problems on trunk in [this
commit|https://github.com/stef1927/cassandra/commit/f0e3bd1be35519c31e0055b14cb697459237b1ac].
We need to round microseconds to milliseconds in the timestamp format when
exporting with COPY TO, to ensure we can import the same files with a COPY FROM
without prepared statements.
CI pending on all branches since I've also added more tests with prepared
statements disabled.
> cqlsh COPY FROM fails for null values with non-prepared statements
> ------------------------------------------------------------------
>
> Key: CASSANDRA-11631
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11631
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Reporter: Robert Stupp
> Assignee: Stefania
> Priority: Minor
> Labels: cqlsh
> Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x
>
>
> cqlsh's {{COPY FROM ... WITH PREPAREDSTATEMENTS = False}} fails if the row
> contains null values. Reason is that the {{','.join(r)}} in
> {{make_non_prepared_batch_statement}} doesn't seem to handle {{None}}, which
> results in this error message.
> {code}
> Failed to import 1 rows: TypeError - sequence item 2: expected string,
> NoneType found, given up without retries
> {code}
> Attached patch should fix the problem.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
