You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Benjamin Lerer (Jira)" <ji...@apache.org> on 2021/03/11 14:57:00 UTC
[jira] [Comment Edited] (CASSANDRA-16479) Materialized Views:
incorrect where clause reported for quoted identifiers
[ https://issues.apache.org/jira/browse/CASSANDRA-16479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17299609#comment-17299609 ]
Benjamin Lerer edited comment on CASSANDRA-16479 at 3/11/21, 2:56 PM:
----------------------------------------------------------------------
[~adelapena] I pushed the changes that you suggested [j8|https://app.circleci.com/pipelines/github/blerer/cassandra/111/workflows/ccd213e5-d841-4318-a453-3103ed1827f6], [j11|https://app.circleci.com/pipelines/github/blerer/cassandra/111/workflows/3194f093-399a-4276-a443-25263316fcd9].
Regarding the {{CustomIndexExpression/QualifiedName}} I think it makes sense to test them in a followup ticket.
was (Author: blerer):
[~adelapena] I pushed the changes that you suggested [j8|https://app.circleci.com/pipelines/github/blerer/cassandra/111/workflows/ccd213e5-d841-4318-a453-3103ed1827f6], [j11|https://app.circleci.com/pipelines/github/blerer/cassandra/111/workflows/3194f093-399a-4276-a443-25263316fcd9].
Regarding the {{CustomIndexExpression/QualifiedName}} I think it makes sense to fix them in a followup ticket.
> Materialized Views: incorrect where clause reported for quoted identifiers
> --------------------------------------------------------------------------
>
> Key: CASSANDRA-16479
> URL: https://issues.apache.org/jira/browse/CASSANDRA-16479
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Syntax, Feature/Materialized Views
> Reporter: Alexandre Dutra
> Assignee: Benjamin Lerer
> Priority: Normal
> Fix For: 4.0-rc
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> I believe this is a regression from 3.11.
> Given the following schema:
> {noformat}
> CREATE TABLE t1 ("theKey" int, "theClustering" int, "theValue" int, PRIMARY KEY ("theKey", "theClustering"));
> CREATE MATERIALIZED VIEW mv1 AS SELECT * FROM t1 WHERE "theKey" IS NOT NULL AND "theClustering" IS NOT NULL AND "theValue" IS NOT NULL PRIMARY KEY ("theKey", "theClustering");
> {noformat}
> And given the following query:
> {noformat}
> SELECT where_clause FROM system_schema.views ;
> {noformat}
> With 3.11, I get:
> {noformat}
> "theKey" IS NOT NULL AND "theClustering" IS NOT NULL AND "theValue" IS NOT NULL
> {noformat}
> But with current trunk, I get:
> {noformat}
> theKey IS NOT NULL AND theClustering IS NOT NULL AND theValue IS NOT NULL
> {noformat}
> Note how column names appear in their internal format, not in quoted form.
> Note: the DataStax drivers rely on this info to rebuild the view's DDL query client-side; generated CQL is currently broken with Cassandra 4.0-trunk.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org