Ravishankar Rajendran created CASSANDRA-11602:
-------------------------------------------------
Summary: Materialized View Doest Not have Static Columns
Key: CASSANDRA-11602
URL: https://issues.apache.org/jira/browse/CASSANDRA-11602
Project: Cassandra
Issue Type: Bug
Reporter: Ravishankar Rajendran
Fix For: 3.4
{quote}
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";
{quote}
The teamMV does not have "location" column. Static columns are not getting
created in MV.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
