search

vmware-archive / sql-to-dbsp-compiler

Compiler translating SQL view definitions into DBSP circuits (https://github.com/vmware/database-stream-processor)
Other
28 stars 4 forks source link

Calcite constant-folds EXTRACT expressions without regards to SQL dialect #98

Open mihaibudiu opened 1 year ago

mihaibudiu commented 1 year ago

Asked a question about it on the Calcite Jira https://issues.apache.org/jira/browse/CALCITE-759

mihaibudiu commented 1 year ago

There is no easy workaround. We probably have to define our own SQL dialect and stick with it rather than allow people to emulate existing dialects.