You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jeremy Hanna (JIRA)" <ji...@apache.org> on 2017/06/22 16:34:11 UTC

[jira] [Updated] (CASSANDRA-12044) Materialized view definition regression in clustering key

     [ https://issues.apache.org/jira/browse/CASSANDRA-12044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeremy Hanna updated CASSANDRA-12044:
-------------------------------------
    Component/s: Materialized Views

> Materialized view definition regression in clustering key
> ---------------------------------------------------------
>
>                 Key: CASSANDRA-12044
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12044
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL, Materialized Views
>            Reporter: Michael Mior
>            Assignee: Carl Yeksigian
>             Fix For: 3.0.9, 3.8
>
>
> 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.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org