feat(sql): add support for indexing of symbol columns in materialized views#5961
feat(sql): add support for indexing of symbol columns in materialized views#5961bluestreak01 merged 4 commits intomasterfrom
Conversation
bluestreak01
changed the title
[PR Coverage check]😍 pass : 51 / 55 (92.73%) file detail
|
|
Fix #: Prevent Crash on NULL in WHERE Clause Description Changes Made Added null check in WhereClauseParser.evaluate to handle NULL values in WHERE clauses. Added a new test case to verify the fix. No changes to public APIs or documentation required. Reproducer Start QuestDB (version 7.4.0 or later with this patch). Create a table: CREATE TABLE test (ts TIMESTAMP, value INT) TIMESTAMP(ts); Insert a record with a NULL value: INSERT INTO test VALUES ('2025-07-19T10:00:00', NULL); Run the query: SELECT * FROM test WHERE value = NULL; Expected result: Query returns an empty result set without crashing. Testing Added JUnit test testNullInWhereClause in core/src/test/java/io/questdb/test/WhereClauseTest.java. Ran mvn test to confirm all tests pass. Manually tested the reproducer query on a local QuestDB instance. Related Issue Checklist Code adheres to QuestDB coding standards. Tests added to cover the fix. No breaking changes introduced. Reproducer provided for verification. Additional Notes Submitted by |
|
@rohit-7620 please don't spam the PRs |
Added docs pages for alter matview.. add index/drop index, related to questdb/questdb#5961 Changed concept pages for indices and matviews Sorted the left sidebar slightly, as it was out of alphabetical order for some SQL subsections.
3 participants
Supported syntax:
SQL will calculate correct index capacity automatically based on the current data in the view:
Index capacity can still be specified manually:
alter materialized view view_1 alter column sym add index capacity 16;Drop index: