[jira] [Created] (CASSANDRA-10147) Base table PRIMARY KEY can be assumed to be NOT NULL in MV creation

[Jonathan Ellis (JIRA)]

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)