[CASSANDRA-11631] cqlsh COPY FROM fails for null values with non-prepared statements

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1.15, 2.2.7, 3.0.6, 3.6
• Component/s: Legacy/Tools
• Labels: cqlsh
• Severity: Low
• Assignee: Stefania Alborghetti
• Reporter: Robert Stupp

Authors

Stefania Alborghetti

Reviewers

Robert Stupp

• Created: 22/Apr/16 09:27
• Updated: 16/Apr/19 09:30
• Resolved: 27/Apr/16 01:13

Description

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.

Failed to import 1 rows: TypeError - sequence item 2: expected string, NoneType found,  given up without retries

Attached patch should fix the problem.

Issue Links

• is related to: CASSANDRA-11549 cqlsh: COPY FROM ignores NULL values in conversion
• relates to: CASSANDRA-11675 multiple dtest failure in cqlsh_tests.cqlsh_copy_tests.CqlshCopyTest