Cassandra
  1. Cassandra
  2. CASSANDRA-5628

cqlsh "copy to" fails when there are more than 21 columns

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Not a Problem
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      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';

        Activity

        Hide
        Jonathan Ellis added a comment -

        Does this affect 1.2 as well?

        Show
        Jonathan Ellis added a comment - Does this affect 1.2 as well?
        Hide
        Ian Rogers added a comment -

        Tested with this version and it worked fine (tested with 50 columns)

        $ cqlsh --version
        cqlsh 3.0.2
        $ nodetool -h localhost version
        ReleaseVersion: 1.2.5

        But we can't upgrade from 1.1.* to 1.2 due to the incompatible changes in cql etc. unfortunately.

        Show
        Ian Rogers added a comment - Tested with this version and it worked fine (tested with 50 columns) $ cqlsh --version cqlsh 3.0.2 $ nodetool -h localhost version ReleaseVersion: 1.2.5 But we can't upgrade from 1.1.* to 1.2 due to the incompatible changes in cql etc. unfortunately.
        Hide
        Jonathan Ellis added a comment -

        Noted.

        Show
        Jonathan Ellis added a comment - Noted.

          People

          • Assignee:
            Unassigned
            Reporter:
            Ian Rogers
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development