[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713933#comment-17713933 ] luoping.zhang commented on CALCITE-5656: hi [~libenchao] , please review it. >

[jira] [Assigned] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He reassigned CALCITE-5661: --- Assignee: Runkang He > Introduce another way to convert IN predicate to RelNode when IN li

[jira] [Commented] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713916#comment-17713916 ] Runkang He commented on CALCITE-5661: - [~julianhyde] Thanks for your suggestion, I

[jira] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656 ] luoping.zhang deleted comment on CALCITE-5656: was (Author: JIRAUSER299898): !image-2023-04-19-12-26-32-719.png! > RelToSqlConverter has an error using ordinal for ORDER BY > --

[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713889#comment-17713889 ] luoping.zhang commented on CALCITE-5656: !image-2023-04-19-12-26-32-719.png! >

[jira] [Updated] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] luoping.zhang updated CALCITE-5656: --- Attachment: image-2023-04-19-12-26-32-719.png > RelToSqlConverter has an error using ordina

[jira] [Updated] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] luoping.zhang updated CALCITE-5656: --- Attachment: (was: image-2023-04-18-16-29-44-899.png) > RelToSqlConverter has an error u

[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713887#comment-17713887 ] luoping.zhang commented on CALCITE-5656: *dev design* If the ordinal is not in

[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713883#comment-17713883 ] peng wang commented on CALCITE-5656: I think 'Don't merge project when there is ord

[jira] [Updated] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5656: Labels: pull-request-available (was: ) > RelToSqlConverter has an error using ordinal fo

[jira] [Commented] (CALCITE-111) Support CONVERT function, for changing character sets

[ https://issues.apache.org/jira/browse/CALCITE-111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713881#comment-17713881 ] ZheHu commented on CALCITE-111: --- [~julianhyde] Thanks for your review. I've already seen y

[jira] [Commented] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713846#comment-17713846 ] Dan Zou commented on CALCITE-5655: -- [~libenchao] OK, I will check it after we merge th

[jira] [Comment Edited] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713845#comment-17713845 ] Benchao Li edited comment on CALCITE-5655 at 4/19/23 2:10 AM: ---

[jira] [Commented] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713845#comment-17713845 ] Benchao Li commented on CALCITE-5655: - CC [~FrankZou] since you are the assignee of

[jira] [Commented] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713842#comment-17713842 ] Julian Hyde commented on CALCITE-5655: -- This might be related to CALCITE-5390, whi

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713821#comment-17713821 ] Julian Hyde commented on CALCITE-5615: -- I think we should keep this PR open. These

[jira] [Commented] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713814#comment-17713814 ] Julian Hyde commented on CALCITE-5661: -- If it takes 2 minutes there's probably a q

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713807#comment-17713807 ] Mihai Budiu commented on CALCITE-5615: -- This looks great, thank you. So I guess I

[jira] [Updated] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5661: Description: When IN list is large, the plan generation is time-consuming, after benchmark, when

[jira] [Updated] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5661: Description: When IN list is large, the plan generation is time-consuming, after benchmark, when

[jira] [Updated] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5661: Description: When IN list is large, the plan generation is time-consuming, after benchmark, when

[jira] [Commented] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713806#comment-17713806 ] Runkang He commented on CALCITE-5655: - [~libenchao] Thanks, self-assigned on this i

[jira] [Updated] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

[ https://issues.apache.org/jira/browse/CALCITE-5661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5661: Description: When IN list is large, the plan generation is time-consuming, after benchmark, when

[jira] [Created] (CALCITE-5661) Introduce another way to convert IN predicate to RelNode when IN list is large

Runkang He created CALCITE-5661: --- Summary: Introduce another way to convert IN predicate to RelNode when IN list is large Key: CALCITE-5661 URL: https://issues.apache.org/jira/browse/CALCITE-5661 Projec

[jira] [Comment Edited] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713803#comment-17713803 ] Julian Hyde edited comment on CALCITE-5615 at 4/19/23 12:21 AM: -

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713803#comment-17713803 ] Julian Hyde commented on CALCITE-5615: -- I have created [hydromatic/sql-logic-test

[jira] [Updated] (CALCITE-5660) Implement BigQuery Array Subscript Operators

[ https://issues.apache.org/jira/browse/CALCITE-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5660: -- Description: When indexing an array in BigQuery, you are required to wrap the index in one o

[jira] [Created] (CALCITE-5660) Implement BigQuery Array Subscript Operators

Tanner Clary created CALCITE-5660: - Summary: Implement BigQuery Array Subscript Operators Key: CALCITE-5660 URL: https://issues.apache.org/jira/browse/CALCITE-5660 Project: Calcite Issue Type

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713772#comment-17713772 ] Stamatis Zampetakis commented on CALCITE-5615: -- [~mbudiu] You don't need t

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713738#comment-17713738 ] Mihai Budiu commented on CALCITE-5615: -- The main point of this contribution is to

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713733#comment-17713733 ] Julian Hyde commented on CALCITE-5615: -- If a tool could be used outside of Calcite

[jira] [Updated] (CALCITE-5402) RelToSql generates invalid code if left and right side field names clash

[ https://issues.apache.org/jira/browse/CALCITE-5402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5402: Labels: pull-request-available (was: ) > RelToSql generates invalid code if left and rig

[jira] [Updated] (CALCITE-5659) Allow CAST in an INTERVAL definition

[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5659: Labels: pull-request-available (was: ) > Allow CAST in an INTERVAL definition > ---

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713701#comment-17713701 ] Mihai Budiu commented on CALCITE-5615: -- These are all the dependencies of this pro

[jira] [Commented] (CALCITE-5650) Sql.dialect method in RelToSqlConverterTests ignores dialect type system

[ https://issues.apache.org/jira/browse/CALCITE-5650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713694#comment-17713694 ] Mihai Budiu commented on CALCITE-5650: -- I have added a new commit to my PR which r

[jira] [Commented] (CALCITE-5659) Allow CAST in an INTERVAL definition

[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713690#comment-17713690 ] Julian Hyde commented on CALCITE-5659: -- [~oliverlee], Do you not expect EXTRACT to

[jira] [Commented] (CALCITE-5659) Allow CAST in an INTERVAL definition

[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713682#comment-17713682 ] TJ Banghart commented on CALCITE-5659: -- I wonder if it is better to ease the requi

[jira] [Commented] (CALCITE-5659) Allow CAST in an INTERVAL definition

[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713677#comment-17713677 ] Oliver Lee commented on CALCITE-5659: - PR: https://github.com/apache/calcite/pull/3

[jira] [Created] (CALCITE-5659) Allow CAST in an INTERVAL definition

Oliver Lee created CALCITE-5659: --- Summary: Allow CAST in an INTERVAL definition Key: CALCITE-5659 URL: https://issues.apache.org/jira/browse/CALCITE-5659 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5658) Collection types are un-parsed incorrectly for Apache Spark

Guillaume Massé created CALCITE-5658: Summary: Collection types are un-parsed incorrectly for Apache Spark Key: CALCITE-5658 URL: https://issues.apache.org/jira/browse/CALCITE-5658 Project: Calcit

[jira] [Updated] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5657: Labels: pull-request-available (was: ) > Add ARRAY_DISTINCT for Spark dialect >

[jira] [Updated] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

[ https://issues.apache.org/jira/browse/CALCITE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5657: -- Description: {{ARRAY_DISTINCT}} - Returns the input ARRAY with unique elements. If the array itself

[jira] [Created] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

jackylau created CALCITE-5657: - Summary: Add ARRAY_DISTINCT for Spark dialect Key: CALCITE-5657 URL: https://issues.apache.org/jira/browse/CALCITE-5657 Project: Calcite Issue Type: Improvement

[jira] [Assigned] (CALCITE-5655) Wrong plan for multiple IN/SOME sub-queries with OR predicate

[ https://issues.apache.org/jira/browse/CALCITE-5655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He reassigned CALCITE-5655: --- Assignee: Runkang He > Wrong plan for multiple IN/SOME sub-queries with OR predicate > ---

[jira] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656 ] luoping.zhang deleted comment on CALCITE-5656: was (Author: JIRAUSER299898): !image-2023-04-18-16-29-44-899.png! > RelToSqlConverter has an error using ordinal for ORDER BY > --

[jira] [Commented] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713476#comment-17713476 ] luoping.zhang commented on CALCITE-5656: !image-2023-04-18-16-29-44-899.png! >

[jira] [Updated] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] luoping.zhang updated CALCITE-5656: --- Attachment: image-2023-04-18-16-29-44-899.png > RelToSqlConverter has an error using ordina

[jira] [Assigned] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] luoping.zhang reassigned CALCITE-5656: -- Assignee: luoping.zhang > RelToSqlConverter has an error using ordinal for ORDER BY

[jira] [Commented] (CALCITE-5615) Run SQLLogicTests using Calcite

[ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713465#comment-17713465 ] Stamatis Zampetakis commented on CALCITE-5615: -- I'm fine having it as new

[jira] [Updated] (CALCITE-5656) RelToSqlConverter has an error using ordinal for ORDER BY

[ https://issues.apache.org/jira/browse/CALCITE-5656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] luoping.zhang updated CALCITE-5656: --- Summary: RelToSqlConverter has an error using ordinal for ORDER BY (was: RelToSqlConverter

[jira] [Commented] (CALCITE-5510) RelToSqlConverter should use ordinal for ORDER BY if the dialect allows

[ https://issues.apache.org/jira/browse/CALCITE-5510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713441#comment-17713441 ] luoping.zhang commented on CALCITE-5510: https://issues.apache.org/jira/browse/

[jira] [Commented] (CALCITE-5653) expended casts are missing when IdentifierExpansion is false

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713440#comment-17713440 ] Itiel Sadeh commented on CALCITE-5653: -- I don't think the issue is with the flag n

[jira] [Created] (CALCITE-5656) RelToSqlConverter has an error using ordinal ORDER BY

luoping.zhang created CALCITE-5656: -- Summary: RelToSqlConverter has an error using ordinal ORDER BY Key: CALCITE-5656 URL: https://issues.apache.org/jira/browse/CALCITE-5656 Project: Calcite

[jira] [Updated] (CALCITE-5653) expended casts are missing when IdentifierExpansion is false

[ https://issues.apache.org/jira/browse/CALCITE-5653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5653: Labels: pull-request-available (was: ) > expended casts are missing when IdentifierExpan

[jira] [Commented] (CALCITE-5650) Sql.dialect method in RelToSqlConverterTests ignores dialect type system

[ https://issues.apache.org/jira/browse/CALCITE-5650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713438#comment-17713438 ] Stamatis Zampetakis commented on CALCITE-5650: -- It totally makes sense to

[jira] [Commented] (CALCITE-4771) Add TRY_CAST (MSSQL compatibility)

[ https://issues.apache.org/jira/browse/CALCITE-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713433#comment-17713433 ] Dan Zou commented on CALCITE-4771: -- [~julianhyde] I have read your commit and maybe it