[jira] [Updated] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5678: Labels: (was: patch-available) > Calcite should reject date literals not satisf

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5688: Labels: pull-request-available (was: ) > Support TRUNCATE TABLE DDL statement in Babel p

[jira] [Updated] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sumeet updated CALCITE-5688: Summary: Support TRUNCATE TABLE DDL statement in Babel parser (was: Support TRUNCATE TABLE statement in

[jira] [Created] (CALCITE-5688) Support TRUNCATE TABLE statement in Babel parser

Sumeet created CALCITE-5688: --- Summary: Support TRUNCATE TABLE statement in Babel parser Key: CALCITE-5688 URL: https://issues.apache.org/jira/browse/CALCITE-5688 Project: Calcite Issue Type: Task

[jira] [Created] (CALCITE-5687) lazy get scheme

yiku123 created CALCITE-5687: Summary: lazy get scheme Key: CALCITE-5687 URL: https://issues.apache.org/jira/browse/CALCITE-5687 Project: Calcite Issue Type: New Feature Components: cor

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when the type is array

[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719613#comment-17719613 ] jackylau commented on CALCITE-5674: --- [~libenchao] thanks, i will submit a pr to fix i

[jira] [Updated] (CALCITE-5530) RelToSqlConverter[ORDER BY] generates an incorrect field alias when 2 projection fields have the same name

[ https://issues.apache.org/jira/browse/CALCITE-5530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5530: Component/s: jdbc-adapter (was: core) > RelToSqlConverter[ORDER BY] generate

[jira] [Updated] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5506: Component/s: jdbc-adapter (was: core) > RelToSqlConverter should retain the

[jira] [Resolved] (CALCITE-5506) RelToSqlConverter should retain the aggregation logic when Project without RexInputRef on the Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5506. - Fix Version/s: 1.35.0 Resolution: Fixed Fixed via [https://github.com/apache/calcite/co

[jira] [Resolved] (CALCITE-5680) Wrong plan for multiple IN sub-queries with only literal operands

[ https://issues.apache.org/jira/browse/CALCITE-5680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5680. - Fix Version/s: 1.35.0 Resolution: Fixed Fixed via [https://github.com/apache/calcite/co

[jira] [Commented] (CALCITE-5685) Support MySQL CONVERT function that works on data types

[ https://issues.apache.org/jira/browse/CALCITE-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719573#comment-17719573 ] ZheHu commented on CALCITE-5685: They both work on converting data types, here are some

[jira] [Resolved] (CALCITE-5653) Validation error when using aggregation from the select list in ORDER BY with DISTINCT query

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5653. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [788a4404|https://github.com/apache/

[jira] [Resolved] (CALCITE-5547) JOIN USING returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5547. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [372346f3|https://github.com/apache/

[jira] [Commented] (CALCITE-5684) Parser fails to differentiate between empty string '' and escaped string literal single quote

[ https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719541#comment-17719541 ] Julian Hyde commented on CALCITE-5684: -- I'm surprised, also. Make sure you don't h

[jira] [Commented] (CALCITE-5685) Support MySQL CONVERT function that works on data types

[ https://issues.apache.org/jira/browse/CALCITE-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719540#comment-17719540 ] Julian Hyde commented on CALCITE-5685: -- Can you describe how this differs from CAL

[jira] [Commented] (CALCITE-5653) Validation error when using aggregation from the select list in ORDER BY with DISTINCT query

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719536#comment-17719536 ] Julian Hyde commented on CALCITE-5653: -- I'm going to see whether I can find a simp

[jira] [Commented] (CALCITE-5653) Validation error when using aggregation from the select list in ORDER BY with DISTINCT query

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719494#comment-17719494 ] Julian Hyde commented on CALCITE-5653: -- Please add new commits, don't force push.

[jira] [Resolved] (CALCITE-3959) Implement INSTR function

[ https://issues.apache.org/jira/browse/CALCITE-3959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3959. -- Fix Version/s: 1.35.0 Resolution: Fixed Fixed in [9ea86247|https://github.com/apache/

[jira] [Commented] (CALCITE-5653) Validation error when using aggregation from the select list in ORDER BY with DISTINCT query

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719418#comment-17719418 ] Itiel Sadeh commented on CALCITE-5653: -- Thanks for the explanation. I've fixed th

[jira] [Updated] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Rebele updated CALCITE-5686: --- Description: The following block in org.apache.calcite.linq4j.tree.Shuttle prevents replac

[jira] [Created] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

Thomas Rebele created CALCITE-5686: -- Summary: Generalize return types of the linq4j expression shuttle Key: CALCITE-5686 URL: https://issues.apache.org/jira/browse/CALCITE-5686 Project: Calcite

[jira] [Updated] (CALCITE-5685) Support MySQL CONVERT function that works on data types

[ https://issues.apache.org/jira/browse/CALCITE-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZheHu updated CALCITE-5685: --- Description: CONVERT function in MySQL has two usage： # convert(s USING transcodingName): as described in

[jira] [Commented] (CALCITE-5547) JOIN USING returns incorrect column names

[ https://issues.apache.org/jira/browse/CALCITE-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719286#comment-17719286 ] Jiajun Xie commented on CALCITE-5547: - It's not difficult to fix.   {code:java} se

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when the type is array

[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719267#comment-17719267 ] Benchao Li commented on CALCITE-5674: - I agree with you that we should keep the col

[jira] [Commented] (CALCITE-5684) Parser fails to differentiate between empty string '' and escaped string literal single quote

[ https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719259#comment-17719259 ] Benchao Li commented on CALCITE-5684: - [~zineeddine998] That the version of Calcite

[jira] [Updated] (CALCITE-5685) Support MySQL CONVERT function that works on data types

[ https://issues.apache.org/jira/browse/CALCITE-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZheHu updated CALCITE-5685: --- Description: CONVERT function in MySQL has two usage： # convert(s USING transcodingName): as described in

[jira] [Comment Edited] (CALCITE-5674) Cast expr to target type should respect nullable when the type is array

[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719234#comment-17719234 ] jackylau edited comment on CALCITE-5674 at 5/4/23 9:38 AM: --- w

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when the type is array

[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719234#comment-17719234 ] jackylau commented on CALCITE-5674: --- why i found this is here i supports the flink bu

[jira] [Created] (CALCITE-5685) Support MySQL CONVERT function that works on data types

ZheHu created CALCITE-5685: -- Summary: Support MySQL CONVERT function that works on data types Key: CALCITE-5685 URL: https://issues.apache.org/jira/browse/CALCITE-5685 Project: Calcite Issue Type: I

[jira] [Commented] (CALCITE-5684) Parser fails to differentiate between empty string '' and escaped string literal single quote

[ https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719202#comment-17719202 ] Dan Zou commented on CALCITE-5684: -- [~zineeddine998] Could you please add a complete e

[jira] [Updated] (CALCITE-5684) Parser fails to differentiate between empty string '' and escaped string literal single quote

[ https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zine eddine Zidane updated CALCITE-5684: Description: In the example query below (redshift):   {code:java} SELECT CASE WH

[jira] [Updated] (CALCITE-5684) Parser fails to differentiate between empty string '' and escaped string literal single quote

[ https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zine eddine Zidane updated CALCITE-5684: Summary: Parser fails to differentiate between empty string '' and escaped string

[jira] [Created] (CALCITE-5684) Parser fails to differentiate between empty string '' and escaped string literal quote

Zine eddine Zidane created CALCITE-5684: --- Summary: Parser fails to differentiate between empty string '' and escaped string literal quote Key: CALCITE-5684 URL: https://issues.apache.org/jira/browse/CALCITE-