Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-7305

CQL3, Static columns not returning rows if values are not set

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 2.0.9
    • Component/s: None
    • Labels:
      None
    • Severity:
      Normal

      Description

      Just a quick note on static columns, if you create some cql rows using clustered columns and don't provide a value for a static column, then selecting the row key with the (null) static column won't return any rows.

      create table statictest( a int, b text static, c text, PRIMARY KEY (a, c));
      insert into statictest (a, c) values (1, 'test');
      select a,b from statictest;

      (0 rows)

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              slebresne Sylvain Lebresne Assign to me
              Reporter:
              patcho2005 Patrick Callaghan
              Authors:
              Sylvain Lebresne
              Reviewers:
              Tom Hobbs

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment