[jira] [Created] (CALCITE-6434) Specify identifier quoting for HiveSqlDialect and SparkSqlDialect

2024-06-11 Thread xiong duan (Jira)
xiong duan created CALCITE-6434: --- Summary: Specify identifier quoting for HiveSqlDialect and SparkSqlDialect Key: CALCITE-6434 URL: https://issues.apache.org/jira/browse/CALCITE-6434 Project: Calcite

[jira] [Created] (CALCITE-6431) Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect

2024-06-07 Thread xiong duan (Jira)
xiong duan created CALCITE-6431: --- Summary: Implement the SINGLE_VALUE aggregation in HiveSqlDialect And SparkSQLDialect Key: CALCITE-6431 URL: https://issues.apache.org/jira/browse/CALCITE-6431

[jira] [Created] (CALCITE-6430) SINGLE_VALUE rewrite to wrong sql when the sub-query return one not-null value and NULL value in PostgreSQL、MySQL、HSQL dialect

2024-06-07 Thread xiong duan (Jira)
xiong duan created CALCITE-6430: --- Summary: SINGLE_VALUE rewrite to wrong sql when the sub-query return one not-null value and NULL value in PostgreSQL、MySQL、HSQL dialect Key: CALCITE-6430 URL:

[jira] [Created] (CALCITE-6424) Enable RLIKE function in MySQL library

2024-05-30 Thread xiong duan (Jira)
xiong duan created CALCITE-6424: --- Summary: Enable RLIKE function in MySQL library Key: CALCITE-6424 URL: https://issues.apache.org/jira/browse/CALCITE-6424 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6423) Invalid unparse for CHAR without precision in MySQLDialect

2024-05-28 Thread xiong duan (Jira)
xiong duan created CALCITE-6423: --- Summary: Invalid unparse for CHAR without precision in MySQLDialect Key: CALCITE-6423 URL: https://issues.apache.org/jira/browse/CALCITE-6423 Project: Calcite

[jira] [Created] (CALCITE-6419) Invalid unparse for VARCHAR without precision in HiveSqlDialect And SparkSqlDialect

2024-05-24 Thread xiong duan (Jira)
xiong duan created CALCITE-6419: --- Summary: Invalid unparse for VARCHAR without precision in HiveSqlDialect And SparkSqlDialect Key: CALCITE-6419 URL: https://issues.apache.org/jira/browse/CALCITE-6419

[jira] [Created] (CALCITE-6417) Map value constructor and Array value constructor unparsed incorrectly for HiveSqlDialect

2024-05-23 Thread xiong duan (Jira)
xiong duan created CALCITE-6417: --- Summary: Map value constructor and Array value constructor unparsed incorrectly for HiveSqlDialect Key: CALCITE-6417 URL: https://issues.apache.org/jira/browse/CALCITE-6417

[jira] [Created] (CALCITE-6416) Remove unnecessary SUBSTRING rewrite in SparkSqlDialect

2024-05-23 Thread xiong duan (Jira)
xiong duan created CALCITE-6416: --- Summary: Remove unnecessary SUBSTRING rewrite in SparkSqlDialect Key: CALCITE-6416 URL: https://issues.apache.org/jira/browse/CALCITE-6416 Project: Calcite

[jira] [Created] (CALCITE-6415) Invalid unparse for TIMESTAMP with HiveSqlDialect

2024-05-22 Thread xiong duan (Jira)
xiong duan created CALCITE-6415: --- Summary: Invalid unparse for TIMESTAMP with HiveSqlDialect Key: CALCITE-6415 URL: https://issues.apache.org/jira/browse/CALCITE-6415 Project: Calcite Issue

[jira] [Created] (CALCITE-5929) Improve LogicalWindow print plan to add the constant value

2023-08-14 Thread xiong duan (Jira)
xiong duan created CALCITE-5929: --- Summary: Improve LogicalWindow print plan to add the constant value Key: CALCITE-5929 URL: https://issues.apache.org/jira/browse/CALCITE-5929 Project: Calcite

[jira] [Created] (CALCITE-5797) Release Calcite 1.35.0

2023-06-24 Thread xiong duan (Jira)
xiong duan created CALCITE-5797: --- Summary: Release Calcite 1.35.0 Key: CALCITE-5797 URL: https://issues.apache.org/jira/browse/CALCITE-5797 Project: Calcite Issue Type: Test

[jira] [Created] (CALCITE-5769) Optimizing 'CAST(e AS t) IS NOT NULL' to 'e IS NOT NULL'

2023-06-07 Thread xiong duan (Jira)
xiong duan created CALCITE-5769: --- Summary: Optimizing 'CAST(e AS t) IS NOT NULL' to 'e IS NOT NULL' Key: CALCITE-5769 URL: https://issues.apache.org/jira/browse/CALCITE-5769 Project: Calcite

[jira] [Created] (CALCITE-5750) SQL throws exception when the Filter include id = ARRAY [1,2,3]

2023-06-05 Thread xiong duan (Jira)
xiong duan created CALCITE-5750: --- Summary: SQL throws exception when the Filter include id = ARRAY [1,2,3] Key: CALCITE-5750 URL: https://issues.apache.org/jira/browse/CALCITE-5750 Project: Calcite

[jira] [Created] (CALCITE-5749) Join table with different database name and same table name will throw exception

2023-06-04 Thread xiong duan (Jira)
xiong duan created CALCITE-5749: --- Summary: Join table with different database name and same table name will throw exception Key: CALCITE-5749 URL: https://issues.apache.org/jira/browse/CALCITE-5749

[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

[jira] [Created] (CALCITE-5181) Sum aggregate function return wong result

2022-06-05 Thread xiong duan (Jira)
xiong duan created CALCITE-5181: --- Summary: Sum aggregate function return wong result Key: CALCITE-5181 URL: https://issues.apache.org/jira/browse/CALCITE-5181 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5156) Support implicit type cast for IN Sub-query

2022-05-16 Thread xiong duan (Jira)
xiong duan created CALCITE-5156: --- Summary: Support implicit type cast for IN Sub-query Key: CALCITE-5156 URL: https://issues.apache.org/jira/browse/CALCITE-5156 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5140) The Github CI failed in Linux (OpenJ9 8)

2022-05-08 Thread xiong duan (Jira)
xiong duan created CALCITE-5140: --- Summary: The Github CI failed in Linux (OpenJ9 8) Key: CALCITE-5140 URL: https://issues.apache.org/jira/browse/CALCITE-5140 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5139) Improve Join print plan to add the CorrelationId info

2022-05-07 Thread xiong duan (Jira)
xiong duan created CALCITE-5139: --- Summary: Improve Join print plan to add the CorrelationId info Key: CALCITE-5139 URL: https://issues.apache.org/jira/browse/CALCITE-5139 Project: Calcite

[jira] [Created] (CALCITE-5138) Join on condition generates wrong plan when the condition is sub-query

2022-05-07 Thread xiong duan (Jira)
xiong duan created CALCITE-5138: --- Summary: Join on condition generates wrong plan when the condition is sub-query Key: CALCITE-5138 URL: https://issues.apache.org/jira/browse/CALCITE-5138 Project:

[jira] [Created] (CALCITE-5132) When the IN-list that include NUll value is converted to Values as a SCALA subquery will return wrong result

2022-05-04 Thread xiong duan (Jira)
xiong duan created CALCITE-5132: --- Summary: When the IN-list that include NUll value is converted to Values as a SCALA subquery will return wrong result Key: CALCITE-5132 URL:

[jira] [Created] (CALCITE-5117) Optimize the EXISTS sub-query by Metadata RowCount

2022-04-26 Thread xiong duan (Jira)
xiong duan created CALCITE-5117: --- Summary: Optimize the EXISTS sub-query by Metadata RowCount Key: CALCITE-5117 URL: https://issues.apache.org/jira/browse/CALCITE-5117 Project: Calcite Issue

[jira] [Created] (CALCITE-5112) Upgrade Jetty version to 9.4.44.v202109272

2022-04-25 Thread xiong duan (Jira)
xiong duan created CALCITE-5112: --- Summary: Upgrade Jetty version to 9.4.44.v202109272 Key: CALCITE-5112 URL: https://issues.apache.org/jira/browse/CALCITE-5112 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5021) Double JOIN is created for NOT IN when IN-list that the values all non-nullable is converted to Values

2022-02-24 Thread xiong duan (Jira)
xiong duan created CALCITE-5021: --- Summary: Double JOIN is created for NOT IN when IN-list that the values all non-nullable is converted to Values Key: CALCITE-5021 URL:

[jira] [Created] (CALCITE-4993) Simplify EQUALS or NOT-EQUALS with other number comparison

2022-01-21 Thread xiong duan (Jira)
xiong duan created CALCITE-4993: --- Summary: Simplify EQUALS or NOT-EQUALS with other number comparison Key: CALCITE-4993 URL: https://issues.apache.org/jira/browse/CALCITE-4993 Project: Calcite

[jira] [Created] (CALCITE-4988) ((A IS NOT NULL OR B) AND A) can't be simplify to (A) When A is deterministic

2022-01-17 Thread xiong duan (Jira)
xiong duan created CALCITE-4988: --- Summary: ((A IS NOT NULL OR B) AND A) can't be simplify to (A) When A is deterministic Key: CALCITE-4988 URL: https://issues.apache.org/jira/browse/CALCITE-4988