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-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org