[CASSANDRA-17879] It is not possible to autocomplete "WITH" when creating materialized view

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.28, 3.11.14, 4.0.7, 4.1-rc1, 4.1, 5.0-alpha1, 5.0
• Component/s: CQL/Interpreter
• Bug Category: Correctness - API / Semantic Implementation
• Severity: Low
• Complexity: Normal
• Discovered By: User Report
• Platform: All
• Since Version: 3.0.0

Source Control Link

https://github.com/apache/cassandra/commit/83c1f7713bf24ec4873cfa9f76f2efccc8a23278

Test and Documentation Plan

1. updated and ran the unit test:

pytest test_cqlsh_completion.py -k test_complete_in_create_materializedview

2. validated with live CQLSH session also

• Assignee: Brad Schoening
• Reporter: Stefan Miklosovic

Authors

Brad Schoening

Reviewers

Brandon Williams, Stefan Miklosovic

• Created: 07/Sep/22 14:42
• Updated: 12/Sep/23 13:03
• Resolved: 04/Oct/22 19:22

Description

I noticed that when I type this:

CREATE MATERIALIZED VIEW ks.mv2 AS SELECT * FROM t WHERE k IS NOT NULL AND c1 IS NOT NULL AND c2 IS NOT NULL PRIMARY KEY (c1,k,c2) <TAB>

nothing happens after pressing tab, there should be options shown as for table case.

Issue Links

• is related to: CASSANDRA-16640 Round out cqlsh completion test coverage
• links to: https://github.com/apache/cassandra/pull/1890