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

Materialized Views: incorrect where clause reported for quoted identifiers

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            blerer Benjamin Lerer Assign to me
            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

                Slack

                  Issue deployment