[DISCUSS] SqlDialect.getCastSpec() doesn't work when unparsing SqlNode tree

alternative method to convert cast types fully in SqlNode tree that can be used during SqlNode.unparse()? Thanks, Pavel Gubin

SQL dialect specific functionality

Not all JDBC datasources support window functions. But JdbcProject is generated regardless of this fact. In the result we get SQL with window function which gives an error when the execution is pushed to the JDBC datasource. What is the best way to avoid such errors based on SQL dialect? Avoid c

SQL dialect specific functionality

Not all JDBC datasources support window functions. But JdbcProject is generated regardless of this fact. In the result we get SQL with window function which gives an error when the execution is pushed to the JDBC datasource. What is the best way to avoid such errors based on SQL dialect? Avoid c

Expected conversion for TIMESTAMPDIFF

Trying to understand expected conversion to SQL for TIMESTAMPDIFF function. According to this bug: https://issues.apache.org/jira/projects/CALCITE/issues/CALCITE-3312 it is converted to something like: CAST(/INT(Reinterpret(

[jira] [Created] (CALCITE-1980) java.lang.IndexOutOfBoundsException when building aggregate on top of project

Pavel Gubin created CALCITE-1980: Summary: java.lang.IndexOutOfBoundsException when building aggregate on top of project Key: CALCITE-1980 URL: https://issues.apache.org/jira/browse/CALCITE-1980

[jira] [Created] (CALCITE-1987) EXTRACT is not implemented for JDBC

Pavel Gubin created CALCITE-1987: Summary: EXTRACT is not implemented for JDBC Key: CALCITE-1987 URL: https://issues.apache.org/jira/browse/CALCITE-1987 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-2015) Planner generates incompatible plan

Pavel Gubin created CALCITE-2015: Summary: Planner generates incompatible plan Key: CALCITE-2015 URL: https://issues.apache.org/jira/browse/CALCITE-2015 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-2206) Window functions pushed to JDBC databases regardless of their support

Pavel Gubin created CALCITE-2206: Summary: Window functions pushed to JDBC databases regardless of their support Key: CALCITE-2206 URL: https://issues.apache.org/jira/browse/CALCITE-2206 Project

[jira] [Created] (CALCITE-2375) EnumerableDefaults.join_() leaks connections

Pavel Gubin created CALCITE-2375: Summary: EnumerableDefaults.join_() leaks connections Key: CALCITE-2375 URL: https://issues.apache.org/jira/browse/CALCITE-2375 Project: Calcite Issue Type

[jira] [Created] (CALCITE-2626) RelBuilder generates wrong field list for join

Pavel Gubin created CALCITE-2626: Summary: RelBuilder generates wrong field list for join Key: CALCITE-2626 URL: https://issues.apache.org/jira/browse/CALCITE-2626 Project: Calcite Issue

[jira] [Created] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

Pavel Gubin created CALCITE-3312: Summary: TIMESTAMPDIFF cannot be converted to SQL Key: CALCITE-3312 URL: https://issues.apache.org/jira/browse/CALCITE-3312 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-3352) ProjectToWindowRule sets wrong collation on generated Window

Pavel Gubin created CALCITE-3352: Summary: ProjectToWindowRule sets wrong collation on generated Window Key: CALCITE-3352 URL: https://issues.apache.org/jira/browse/CALCITE-3352 Project: Calcite