Nick Woolmer

perf(sql): rewrite trivial expressions over same column in GROUP BY queries

1

Closes https://github.com/questdb/questdb/issues/4141 This relates to performance around Clickbench Q35. For Clickbench Q35 on M2 Mac Mini, this speeds up the query from 1.7s to 0.9s. The rewritten query runs using...

Inconsistencies with ALIGN TO CALENDAR TIME ZONE

1

### To reproduce Its unclear if TIME ZONE is working as expected with SAMPLE BY, especially when it comes to DST adjustments. SAMPLE BY operates on UTC timestamps, and will...

Improvements to feature flagging and handling of breaking changes

3

### Is your feature request related to a problem? New features and bugfixes can lead to breaking changes. These are generally for the better, but can sometimes have a wide...

### Is your feature request related to a problem? DDL: ```sql CREATE TABLE test1 ( ts TIMESTAMP, a INT, b INT ) TIMESTAMP(ts) PARTITION BY DAY WAL; ``` Take a...

### Is your feature request related to a problem? A user encountered issues with the following query: ```sql SELECT datediff('d', (SELECT MIN(timestamp) FROM sensor_values), (SELECT MAX(timestamp) FROM sensor_values) ) AS...

Flaky AlterWalTableLineTcpReceiverTest.testAlterCommandTruncateTable()

1

### To reproduce CI build https://dev.azure.com/questdb/questdb/_build/results?buildId=76981&view=ms.vss-test-web.build-test-results-tab&runId=276546&resultId=100686&paneView=debug `[0] SymbolMap does not exist: C:\Users\VSSADM~1\AppData\Local\Temp\junit14626790240805956313\dbRoot\plug~2\room.o` ``` io.questdb.cairo.CairoException: [0] SymbolMap does not exist: C:\Users\VSSADM~1\AppData\Local\Temp\junit14626790240805956313\dbRoot\plug~2\room.o at io.questdb.cairo.CairoException.instance(CairoException.java:310) at io.questdb.cairo.CairoException.critical(CairoException.java:69) at io.questdb.cairo.SymbolMapReaderImpl.of(SymbolMapReaderImpl.java:150) at io.questdb.cairo.SymbolMapReaderImpl.(SymbolMapReaderImpl.java:66) at io.questdb.cairo.TableReader.newSymbolMapReader(TableReader.java:816)...

Support interval scans for designated timestamp WHERE expressions that include OR

1

### Is your feature request related to a problem? QuestDB will optimise some queries into interval scans. This is a modification to the base dataframe cursor, which reduces the range...

domain specific functions for finance and aggregation

2

### Is your feature request related to a problem? Many users of QuestDB are in the finance industry. Within this domain, there are common operations that can be complicated to...

Add a volume-weighted moving average function (VWMA)

10

### Is your feature request related to a problem? Related to: https://github.com/questdb/questdb/issues/4620 We should support VWMA in QuestDB for finance use-cases. VWAP: `sum(price * quantity) / sum(quantity)` VWMA is similar,...