cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-10147) Base table PRIMARY KEY can be assumed to be NOT NULL in MV creation
Date Thu, 20 Aug 2015 20:45:46 GMT
Jonathan Ellis created CASSANDRA-10147:
------------------------------------------

             Summary: Base table PRIMARY KEY can be assumed to be NOT NULL in MV creation
                 Key: CASSANDRA-10147
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10147
             Project: Cassandra
          Issue Type: Improvement
          Components: Core
            Reporter: Jonathan Ellis
            Assignee: Carl Yeksigian
            Priority: Minor
             Fix For: 3.0.0 rc1


{code}
CREATE TABLE users (
    id uuid PRIMARY KEY,
    username text,
    email text,
    age int
);

CREATE MATERIALIZED VIEW users_by_username AS SELECT * FROM users WHERE username IS NOT NULL
PRIMARY KEY (username, id);

InvalidRequest: code=2200 [Invalid query] message="Primary key column 'id' is required to
be filtered by 'IS NOT NULL'"
{code}



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

Mime
View raw message