[jira] [Created] (CASSANDRA-19252) After upgrading from 3.11.16 to 4.1.3 the CREATE MATERIALIZED VIEW generated by DESCRIBE KEYSPACE is invalid.

["Frank vissing (Jira)" <ji...@apache.org>]

Frank vissing created CASSANDRA-19252:
-----------------------------------------

             Summary: After upgrading from 3.11.16 to 4.1.3 the CREATE MATERIALIZED VIEW generated by DESCRIBE KEYSPACE is invalid.
                 Key: CASSANDRA-19252
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-19252
             Project: Cassandra
          Issue Type: Bug
          Components: Feature/Materialized Views
            Reporter: Frank vissing


After upgrading from 3.11.16 to 4.1.3 the CREATE MATERIALIZED VIEW generated by DESCRIBE KEYSPACE is invalid.
Way back when In a 3.11.x cluster we did
{code:java}
CREATE TABLE myks.devices (
    id text,
    serial text,
    PRIMARY KEY (id)
);
CREATE MATERIALIZED VIEW myks.devices_by_serial AS
    SELECT *
    FROM myks.devices
    WHERE serial IS NOT NULL
    PRIMARY KEY (serial, id)
    WITH CLUSTERING ORDER BY (id ASC);{code}
 


This was perfectley ok back then as KEY's was assumed NOT NULL
so going trough various upgrades our last upgrade from 3.11.16 to 4.1.3 it is no longer possible to use the schema generated by DESCRIBE KEYSPACE myks as this outpts 

 
{code:java}
CREATE MATERIALIZED VIEW myks.devices_by_serial AS
    SELECT *
    FROM myks.devices
    WHERE serial IS NOT NULL
    PRIMARY KEY (serial, id)
    WITH CLUSTERING ORDER BY (id ASC);{code}

but this is no longer valid as it is missing 'AND id IS NOT NULL' to be valid cql. The expected output would be 
{code:java}
CREATE MATERIALIZED VIEW myks.devices_by_serial AS
    SELECT *
    FROM myks.devices
    WHERE serial IS NOT NULL AND id IS NOT NULL
    PRIMARY KEY (serial, id)
    WITH CLUSTERING ORDER BY (id ASC);{code}

There is obviousley no ALTER command that will fix this, but i would have expected the upgraded DESCRIBE to have made valid cql.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org