[
https://issues.apache.org/jira/browse/CASSANDRA-9664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14804757#comment-14804757
]
Andy Tolbert commented on CASSANDRA-9664:
-----------------------------------------
One small nit I noticed that isn't technically a bug is that the whereClause in
system_schema.views quotes all column names, even if they are all in lowercase
(don't need to be quoted identifiers):
{quote}
"game" IS NOT NULL AND "year" IS NOT NULL AND "month" IS NOT NULL AND "score"
IS NOT NULL AND "user" IS NOT NULL AND "day" IS NOT NULL
{quote}
is this ok? I'm not concerned about it, but thought i'd bring it up.
> Allow MV's select statements to be more complex
> -----------------------------------------------
>
> Key: CASSANDRA-9664
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9664
> Project: Cassandra
> Issue Type: New Feature
> Reporter: Carl Yeksigian
> Assignee: Tyler Hobbs
> Labels: client-impacting, doc-impacting
> Fix For: 3.0.0 rc1
>
>
> [Materialized Views|https://issues.apache.org/jira/browse/CASSANDRA-6477] add
> support for a syntax which includes a {{SELECT}} statement, but only allows
> selection of direct columns, and does not allow any filtering to take place.
> We should add support to the MV {{SELECT}} statement to bring better parity
> with the normal CQL {{SELECT}} statement, specifically simple functions in
> the selected columns, as well as specifying a {{WHERE}} clause.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
