[CASSANDRA-16479] Materialized Views: incorrect where clause reported for quoted identifiers

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-rc1, 4.0
• Component/s: CQL/Syntax, Feature/Materialized Views
• Bug Category: Correctness
• Severity: Normal
• Complexity: Normal
• Discovered By: User Report
• Platform: All
• Since Version: 4.0-alpha1

Source Control Link

https://github.com/apache/cassandra/commit/92fe6a37fc79b9c545bccd75b93e5126fd1678e9

Test and Documentation Plan

Add a new unit test to check that the problem is fixed for the different supported scenarios

• Assignee: Benjamin Lerer
• Reporter: Alexandre Dutra

Authors

Benjamin Lerer

Reviewers

Andres de la Peña

• Created: 03/Mar/21 13:45
• Updated: 11/Mar/21 17:21
• Resolved: 11/Mar/21 16:54

Description

I believe this is a regression from 3.11.

Given the following schema:

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");

And given the following query:

SELECT where_clause FROM system_schema.views ;

With 3.11, I get:

"theKey" IS NOT NULL AND "theClustering" IS NOT NULL AND "theValue" IS NOT NULL

But with current trunk, I get:

theKey IS NOT NULL AND theClustering IS NOT NULL AND theValue IS NOT NULL

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.

Issue Links

• relates to: CASSANDRA-16510 Make ReadCommand::toCQLString return valid CQL