[CASSANDRA-5628] cqlsh "copy to" fails when there are more than 21 columns

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Not A Problem

Environment

ubuntu 13.04
$ uname -a
Linux ian 3.8.0-23-generic #34-Ubuntu SMP Wed May 29 20:22:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
$ cqlsh --version
cqlsh 2.2.0
$ nodetool -h localhost version
ReleaseVersion: 1.1.12
$ dpkg -l python-cql
1.4.0-1 DB-API 2.0 compliant client library for Cassandra/CQL

• Severity: Normal
• Assignee: Unassigned
• Reporter: Ian Rogers
• Created: 10/Jun/13 11:13
• Updated: 16/Apr/19 09:32
• Resolved: 12/Jun/13 14:38

Description

See the cqlsh script below. If you comment out the "c1" line then the "copy to" command exports 0 rows even though the "select *" works fine!

USE test_keyspace;

DROP TABLE foo;

CREATE TABLE foo (
id varchar PRIMARY KEY,
a0 varchar,
a1 varchar,
a2 varchar,
a3 varchar,
a4 varchar,
a5 varchar,
a6 varchar,
a7 varchar,
a8 varchar,
a9 varchar,
b0 varchar,
b1 varchar,
b2 varchar,
b3 varchar,
b4 varchar,
b5 varchar,
b6 varchar,
b7 varchar,
b8 varchar,
b9 varchar,
c0 varchar,
– c1 varchar, – uncomment this line and the "copy" will fail even though the "select" works fine!
);

insert into foo (id, a1) values ('foo', 'grum');

select * from foo;

copy foo to '/tmp/foo.csv';