[jira] [Created] (CASSANDRA-16479) Materialized Views: incorrect where clause reported for quoted identifiers

["Alexandre Dutra (Jira)" <ji...@apache.org>]

Alexandre Dutra created CASSANDRA-16479:
-------------------------------------------

             Summary: 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


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