Michael Mior created CASSANDRA-12044:
----------------------------------------

             Summary: Materialized view definition regression in clustering key
                 Key: CASSANDRA-12044
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12044
             Project: Cassandra
          Issue Type: Bug
            Reporter: Michael Mior


This bug was reported on the 
[users|https://mail-archives.apache.org/mod_mbox/cassandra-user/201606.mbox/%3CCAG0vsSJRtRjLJqKsd3M8X-8nXpPwRj7Q80mNkuy8sy%2B%2B%3D%2BocHA%40mail.gmail.com%3E]
 mailing list. The following definitions work in 3.0.3 but fail in 3.0.7.

{code}
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);
{code}

After running bisect, I've narrowed it down to commit 
[86ba227|https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=commit;h=86ba227477b9f8595eb610ecaf950cfbc29dd36b]
 from [CASSANDRA-11475|https://issues.apache.org/jira/browse/CASSANDRA-11475].



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to