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

Materialized view definition regression in clustering key

    XMLWordPrintableJSON

Details

    • Normal

    Description

      This bug was reported on the users mailing list. The following definitions work in 3.0.3 but fail in 3.0.7.

      CREATE TABLE ks.pa (
          id bigint,
          sub_id text,
          name text,
          class text,
          r_id bigint,
          k_id bigint,
          created timestamp,
          priority int,
          updated timestamp,
          value text,
          PRIMARY KEY (id, sub_id, name)
      );
      
      CREATE ks.mv_pa AS
          SELECT k_id, name, value, sub_id, id, class, r_id
          FROM ks.pa
          WHERE k_id IS NOT NULL AND name IS NOT NULL AND value IS NOT NULL AND sub_id IS NOT NULL AND id IS NOT NULL
          PRIMARY KEY ((k_id, name), value, sub_id, id);
      

      After running bisect, I've narrowed it down to commit 86ba227 from CASSANDRA-11475.

      Attachments

        Issue Links

          Activity

            People

              carlyeks Carl Yeksigian
              mmior Michael Mior
              Carl Yeksigian
              Sylvain Lebresne
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: