[jira] [Created] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-18 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5708: --- Summary: Change SUBSTRING result if either of parameters is NULL Key: CALCITE-5708 URL: https://issues.apache.org/jira/browse/CALCITE-5708 Project: Calci

[jira] [Created] (CALCITE-5709) Add TO_BASE32 and FROM_BASE32 functions (enabled in BigQuery library)

2023-05-18 Thread Dan Zou (Jira)
Dan Zou created CALCITE-5709: Summary: Add TO_BASE32 and FROM_BASE32 functions (enabled in BigQuery library) Key: CALCITE-5709 URL: https://issues.apache.org/jira/browse/CALCITE-5709 Project: Calcite

[jira] [Created] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-05-18 Thread jackylau (Jira)
jackylau created CALCITE-5710: - Summary: Add ARRAY_MAX and ARRAY_MIN for Spark dialect Key: CALCITE-5710 URL: https://issues.apache.org/jira/browse/CALCITE-5710 Project: Calcite Issue Type: Impro

[jira] [Created] (CALCITE-5711) Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect

2023-05-18 Thread xiong duan (Jira)
xiong duan created CALCITE-5711: --- Summary: Implement the SINGLE_VALUE aggregation in PostgreSQL Dialect Key: CALCITE-5711 URL: https://issues.apache.org/jira/browse/CALCITE-5711 Project: Calcite

Re: Translate join predicates into filters

2023-05-18 Thread Julian Hyde
I expect that your table works if you put the filter in the WHERE clause, e.g. SELECT * FROM Books AS b WHERE b.id IN (1, 10, 27) and it does so using FilterTableScanRule (which matches a Filter on top of a Scan of a FilterableTable). But you need a new planner rule that can

[jira] [Created] (CALCITE-5712) FilterableTable with Kotlin coroutine and logback fails.

2023-05-18 Thread Min-Seok Kim (Jira)
Min-Seok Kim created CALCITE-5712: - Summary: FilterableTable with Kotlin coroutine and logback fails. Key: CALCITE-5712 URL: https://issues.apache.org/jira/browse/CALCITE-5712 Project: Calcite