Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-16479

Materialized Views: incorrect where clause reported for quoted identifiers

    XMLWordPrintableJSON

Details

    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.

      Attachments

        Issue Links

          Activity

            People

              blerer Benjamin Lerer
              adutra Alexandre Dutra
              Benjamin Lerer
              Andres de la Peña
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h