[ https://issues.apache.org/jira/browse/CASSANDRA-11602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15264120#comment-15264120 ]
Sylvain Lebresne commented on CASSANDRA-11602: ---------------------------------------------- bq. and to warn if it is dropped when using a {{SELECT *}} I'd actually be in favor of rejecting that too. First because silently ignoring columns is bound to surprise/confuse user, and this whether users gets the warning or not. If they don't get it it's confusing, but if they get it, it's a bit scary for new comer as they won't know if they are doing something wrong or not. Second, because if we ever do find a way to include static columns, we'd have a breaking change here since user would have been used to them being ignored. And third, because the only argument for allowing that is the minor convenience of not having to list columns manually, but if you do so you're getting a client warning which is annoying/distracting, so you'll kind of end up listing columns manually anyway. > 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 > Assignee: Carl Yeksigian > Fix For: 3.0.x, 3.x > > > {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)