[CASSANDRA-11602] Materialized View Does Not Have Static Columns

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.6, 3.6
• Component/s: Feature/Materialized Views, Legacy/Coordination
• Severity: Normal
• Assignee: Carl Yeksigian
• Reporter: Ravishankar Rajendran

Authors

Carl Yeksigian

Reviewers

Sylvain Lebresne

• Created: 19/Apr/16 03:10
• Updated: 16/Apr/19 09:30
• Resolved: 02/May/16 20:24

Description

CREATE TABLE "team" (teamname text, manager text, location text static, PRIMARY KEY ((teamname), manager));

INSERT INTO team (teamname, manager, location) VALUES ('Red Bull1', 'Ricciardo11', 'Australian');
INSERT INTO team (teamname, manager, location) VALUES ('Red Bull2', 'Ricciardo12', 'Australian');
INSERT INTO team (teamname, manager, location) VALUES ('Red Bull2', 'Ricciardo13', 'Australian');

select * From team;

CREATE MATERIALIZED VIEW IF NOT EXISTS "teamMV" AS SELECT "teamname", "manager", "location" FROM "team" WHERE "teamname" IS NOT NULL AND "manager" is NOT NULL AND "location" is NOT NULL PRIMARY KEY("manager", "teamname");

select * from "teamMV";

The teamMV does not have "location" column. Static columns are not getting created in MV.