[jira] [Created] (CALCITE-6523) Oracle SUBSTR semantics different from Calcite

2024-08-11 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6523: -- Summary: Oracle SUBSTR semantics different from Calcite Key: CALCITE-6523 URL: https://issues.apache.org/jira/browse/CALCITE-6523 Project: Calcite Issue

[jira] [Updated] (CALCITE-6523) Oracle SUBSTR semantics different from Calcite

2024-08-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6523: --- Description: Oracle's `SUBSTR` has very different semantics. For example, if the length of

[jira] [Commented] (CALCITE-6523) Oracle SUBSTR semantics different from Calcite

2024-08-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872671#comment-17872671 ] suibianwanwan commented on CALCITE-6523: I noticed that in [CALCITE-4427|https

[jira] [Comment Edited] (CALCITE-6523) Oracle SUBSTR semantics different from Calcite

2024-08-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872671#comment-17872671 ] suibianwanwan edited comment on CALCITE-6523 at 8/11/24 9:41 AM:

[jira] [Updated] (CALCITE-6523) Oracle SUBSTR semantics different from Calcite

2024-08-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6523: --- Description: Oracle's `SUBSTR` has very different semantics. For example, if the length of

[jira] [Updated] (CALCITE-6523) SUBSTRING via JDBC Adapter on Oracle Returns Unexpected Results

2024-08-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6523: --- Description: I tried to submit the SQL to Calcite as follows, Calcite's JDBC adapter conve

[jira] [Updated] (CALCITE-6523) SUBSTRING via JDBC Adapter on Oracle Returns Unexpected Results

2024-08-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6523: --- Description: I tried to submit the SQL to Calcite as follows, Calcite's JDBC adapter conve

[jira] [Commented] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-08-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873181#comment-17873181 ] suibianwanwan commented on CALCITE-6346: [~kramerul] I agree with your. And I’

[jira] [Comment Edited] (CALCITE-6523) SUBSTRING via JDBC Adapter on Oracle Returns Unexpected Results

2024-08-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873448#comment-17873448 ] suibianwanwan edited comment on CALCITE-6523 at 8/14/24 8:32 AM:

[jira] [Commented] (CALCITE-6523) SUBSTRING via JDBC Adapter on Oracle Returns Unexpected Results

2024-08-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873448#comment-17873448 ] suibianwanwan commented on CALCITE-6523: [~julianhyde] You're right, this comes

[jira] [Closed] (CALCITE-6523) SUBSTRING via JDBC Adapter on Oracle Returns Unexpected Results

2024-08-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan closed CALCITE-6523. -- Resolution: Duplicate > SUBSTRING via JDBC Adapter on Oracle Returns Unexpected Results > ---

[jira] [Created] (CALCITE-6528) JoinUnifyRule may alter semantics in some cases

2024-08-14 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6528: -- Summary: JoinUnifyRule may alter semantics in some cases Key: CALCITE-6528 URL: https://issues.apache.org/jira/browse/CALCITE-6528 Project: Calcite Issue

[jira] [Commented] (CALCITE-6528) JoinUnifyRule may alter semantics in some cases

2024-08-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873621#comment-17873621 ] suibianwanwan commented on CALCITE-6528: [~julianhyde] I think yes, a valid exp

[jira] [Assigned] (CALCITE-6528) JoinUnifyRule may alter semantics in some cases

2024-08-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6528: -- Assignee: suibianwanwan > JoinUnifyRule may alter semantics in some cases >

[jira] [Comment Edited] (CALCITE-6528) JoinUnifyRule may alter semantics in some cases

2024-08-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873621#comment-17873621 ] suibianwanwan edited comment on CALCITE-6528 at 8/14/24 4:50 PM:

[jira] [Assigned] (CALCITE-6534) Fix type mismatches when pulling up Calc nodes in JoinUnifyRule

2024-08-17 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6534: -- Assignee: suibianwanwan > Fix type mismatches when pulling up Calc nodes in JoinUnif

[jira] [Created] (CALCITE-6534) Fix type mismatches when pulling up Calc nodes in JoinUnifyRule

2024-08-17 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6534: -- Summary: Fix type mismatches when pulling up Calc nodes in JoinUnifyRule Key: CALCITE-6534 URL: https://issues.apache.org/jira/browse/CALCITE-6534 Project: Calcit

[jira] [Commented] (CALCITE-6534) Fix type mismatches when pulling up Calc nodes in JoinUnifyRule

2024-08-17 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874615#comment-17874615 ] suibianwanwan commented on CALCITE-6534: Although these two issues address diff

[jira] [Updated] (CALCITE-6534) Fix type mismatches when pulling up Calc in JoinUnifyRule

2024-08-17 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6534: --- Summary: Fix type mismatches when pulling up Calc in JoinUnifyRule (was: Fix type mismatch

[jira] [Updated] (CALCITE-6534) Adjust type when pulling up Calc in JoinUnifyRule

2024-08-18 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6534: --- Summary: Adjust type when pulling up Calc in JoinUnifyRule (was: Fix type mismatches when

[jira] [Commented] (CALCITE-6346) JdbcAdapter: Cast for dynamic filter arguments is lost

2024-08-18 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874651#comment-17874651 ] suibianwanwan commented on CALCITE-6346: Thanks for [~corvinkuebler] and [~kram

[jira] [Updated] (CALCITE-6534) Adjust type when pulling up Calc in JoinUnifyRule

2024-08-18 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6534: --- Description: In JoinOnLeftCalcUnifyRule, JoinOnRIghtCalcUnifyRule, JoinOnCalcUnifyRule, ca

[jira] [Closed] (CALCITE-6528) JoinUnifyRule may alter semantics in some cases

2024-08-21 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan closed CALCITE-6528. -- Resolution: Fixed Fixed in  [https://github.com/apache/calcite/commit/906a17f40f00550e3347b34

[jira] [Created] (CALCITE-6551) Add DATE_FORMAT function (enabled in MySQL library)

2024-08-28 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6551: -- Summary: Add DATE_FORMAT function (enabled in MySQL library) Key: CALCITE-6551 URL: https://issues.apache.org/jira/browse/CALCITE-6551 Project: Calcite I

[jira] [Assigned] (CALCITE-6551) Add DATE_FORMAT function (enabled in MySQL library)

2024-08-28 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6551: -- Assignee: suibianwanwan > Add DATE_FORMAT function (enabled in MySQL library) >

[jira] [Commented] (CALCITE-6516) AVG to SUM+COUNT transformation inserts invalid CAST call

2024-08-29 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17877930#comment-17877930 ] suibianwanwan commented on CALCITE-6516: Also, in all the databases I've tested

[jira] [Commented] (CALCITE-6557) Type Assertion Error In LogicalAggregate

2024-08-30 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17878074#comment-17878074 ] suibianwanwan commented on CALCITE-6557: Hi, These seem to be two issues. Asser

[jira] [Updated] (CALCITE-6563) Nested window produce incorrect results in RelToSqlConverter.

2024-09-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6563: --- Description: For example, test in RelToSqlConverterTest: {code:java} @Test void testNestWin

[jira] [Updated] (CALCITE-6563) Nested window produce incorrect results in RelToSqlConverter

2024-09-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6563: --- Summary: Nested window produce incorrect results in RelToSqlConverter (was: Nested window

[jira] [Assigned] (CALCITE-6563) Nested window produce incorrect results in RelToSqlConverter

2024-09-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6563: -- Assignee: suibianwanwan > Nested window produce incorrect results in RelToSqlConvert

[jira] [Commented] (CALCITE-6566) PI function without parentheses shoud failed

2024-09-09 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17880338#comment-17880338 ] suibianwanwan commented on CALCITE-6566: +1, Presto and ClickHouse also support

[jira] [Created] (CALCITE-6586) Some Rules not firing due to RelMdPredicates returning null in VolcanoPlanner

2024-09-17 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6586: -- Summary: Some Rules not firing due to RelMdPredicates returning null in VolcanoPlanner Key: CALCITE-6586 URL: https://issues.apache.org/jira/browse/CALCITE-6586 P

[jira] [Commented] (CALCITE-6613) Make the Background code examples in Calcite official documentation clearer

2024-10-07 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17887271#comment-17887271 ] suibianwanwan commented on CALCITE-6613: Sry, I slipped. > Make the Background

[jira] [Created] (CALCITE-6615) BindableTableScan estimateRowCount does not calculate push down filters

2024-10-07 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6615: -- Summary: BindableTableScan estimateRowCount does not calculate push down filters Key: CALCITE-6615 URL: https://issues.apache.org/jira/browse/CALCITE-6615 Project

[jira] [Assigned] (CALCITE-6613) Make the Background code examples in Calcite official documentation clearer

2024-10-07 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6613: -- Assignee: suibianwanwan > Make the Background code examples in Calcite official docu

[jira] [Created] (CALCITE-6614) InnodbFilterRule incorrectly constructs condition when creating InnodbFilter

2024-10-07 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6614: -- Summary: InnodbFilterRule incorrectly constructs condition when creating InnodbFilter Key: CALCITE-6614 URL: https://issues.apache.org/jira/browse/CALCITE-6614 P

[jira] [Commented] (CALCITE-6611) Rules that modify the sort collation cannot be applied in VolcanoPlanner

2024-10-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17887214#comment-17887214 ] suibianwanwan commented on CALCITE-6611: [~caicancai] While solving [CALCITE-65

[jira] [Created] (CALCITE-6611) Rules that modify the sort collation cannot be applied in VolcanoPlanner

2024-10-06 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6611: -- Summary: Rules that modify the sort collation cannot be applied in VolcanoPlanner Key: CALCITE-6611 URL: https://issues.apache.org/jira/browse/CALCITE-6611 Projec

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

2024-10-23 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17892079#comment-17892079 ] suibianwanwan commented on CALCITE-5156: Hi, for the undesirable plan mentioned

[jira] [Created] (CALCITE-6651) Ignore SqlLiteral in implicit Integer type cast

2024-10-29 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6651: -- Summary: Ignore SqlLiteral in implicit Integer type cast Key: CALCITE-6651 URL: https://issues.apache.org/jira/browse/CALCITE-6651 Project: Calcite Issue

[jira] [Commented] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-10-29 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17893970#comment-17893970 ] suibianwanwan commented on CALCITE-6652: Sorry, there seems to be something wro

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-10-29 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17893951#comment-17893951 ] suibianwanwan edited comment on CALCITE-6652 at 10/29/24 7:06 PM: ---

[jira] [Created] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-10-29 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6652: -- Summary: RelDecorrelator can't decorrelate query with limit 1 Key: CALCITE-6652 URL: https://issues.apache.org/jira/browse/CALCITE-6652 Project: Calcite

[jira] [Commented] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-10-29 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17893951#comment-17893951 ] suibianwanwan commented on CALCITE-6652: The optimization for the following que

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-10-29 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17893970#comment-17893970 ] suibianwanwan edited comment on CALCITE-6652 at 10/29/24 7:46 PM: ---

[jira] [Commented] (CALCITE-6651) Use RelBuilder in SqlToRelConverter to construct Union

2024-11-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17895493#comment-17895493 ] suibianwanwan commented on CALCITE-6651: [~mbudiu], Hi, Does this PR meet your

[jira] [Updated] (CALCITE-6651) Use RelBuilder in SqlToRelConverter to construct Union

2024-11-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6651: --- Description: In SqlToRelConverter, one part of Union is constructed by LogicalUnion.create

[jira] [Commented] (CALCITE-6651) Use RelBuilder in SqlToRelConverter to construct Union

2024-11-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17895494#comment-17895494 ] suibianwanwan commented on CALCITE-6651: There's a test in big-query.iq that do

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

2024-10-23 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17892180#comment-17892180 ] suibianwanwan commented on CALCITE-5156: [~nobigo] I read part of the code. Sql

[jira] [Updated] (CALCITE-6520) IN operator returns incorrect result

2024-11-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6520: --- Description: I am trying to query the following SQL in calcite (I changed the withInSubQue

[jira] [Comment Edited] (CALCITE-6520) IN operator returns incorrect result

2024-11-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871811#comment-17871811 ] suibianwanwan edited comment on CALCITE-6520 at 11/12/24 2:36 AM: ---

[jira] [Closed] (CALCITE-6520) IN operator returns incorrect result

2024-11-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan closed CALCITE-6520. -- Resolution: Fixed Fixed in [https://github.com/apache/calcite/commit/c7cace6cca8916875c6b5dc

[jira] [Commented] (CALCITE-6586) Some Rules not firing due to RelMdPredicates returning null in VolcanoPlanner

2024-09-25 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17884839#comment-17884839 ] suibianwanwan commented on CALCITE-6586: [~caicancai] Thank you for your attent

[jira] [Comment Edited] (CALCITE-6586) Some Rules not firing due to RelMdPredicates returning null in VolcanoPlanner

2024-09-26 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17884839#comment-17884839 ] suibianwanwan edited comment on CALCITE-6586 at 9/26/24 5:40 PM:

[jira] [Commented] (CALCITE-6586) Some Rules not firing due to RelMdPredicates returning null in VolcanoPlanner

2024-09-26 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17885122#comment-17885122 ] suibianwanwan commented on CALCITE-6586: I try to add more tests, but sometimes

[jira] [Commented] (CALCITE-6651) Use RelBuilder in SqlToRelConverter to construct Union

2024-11-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17896145#comment-17896145 ] suibianwanwan commented on CALCITE-6651: [~nobigo] I've updated it. The problem

[jira] [Updated] (CALCITE-6651) Use RelBuilder in SqlToRelConverter to construct Union

2024-11-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6651: --- Description: In RelToSqlConverter, some unions are created using LogicalUnion.create() and

[jira] [Commented] (CALCITE-1317) Rewrite "MAX" as "ORDER BY ... LIMIT ..."

2024-11-27 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17901631#comment-17901631 ] suibianwanwan commented on CALCITE-1317: Hi, [~julianhyde]. I am trying to do a

[jira] [Commented] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-08 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903857#comment-17903857 ] suibianwanwan commented on CALCITE-6652: Also, for the case where the order key

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-08 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903857#comment-17903857 ] suibianwanwan edited comment on CALCITE-6652 at 12/8/24 8:04 AM:

[jira] [Updated] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-07 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6652: --- Description: The following query can't decorrelate by RelDecorrelate: {code:java} @Test voi

[jira] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-07 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652 ] suibianwanwan deleted comment on CALCITE-6652: was (Author: JIRAUSER301334): The optimization for the following query is a deterministic optimization, independent of the uniqueness of t

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-07 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903855#comment-17903855 ] suibianwanwan edited comment on CALCITE-6652 at 12/8/24 7:55 AM:

[jira] [Commented] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-07 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903855#comment-17903855 ] suibianwanwan commented on CALCITE-6652: Hi, [~julianhyde]. As discussed in Cal

[jira] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652 ] suibianwanwan deleted comment on CALCITE-6652: was (Author: JIRAUSER301334): Sorry, there seems to be something wrong with the above example SQL.   I prefer relational algebra. and the

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-08 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903855#comment-17903855 ] suibianwanwan edited comment on CALCITE-6652 at 12/8/24 4:16 PM:

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-08 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903855#comment-17903855 ] suibianwanwan edited comment on CALCITE-6652 at 12/8/24 4:18 PM:

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2024-12-09 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903855#comment-17903855 ] suibianwanwan edited comment on CALCITE-6652 at 12/9/24 5:33 PM:

[jira] [Commented] (CALCITE-6748) RelToSqlConverter returns the wrong result when Aggregate is on Sort

2025-01-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17910509#comment-17910509 ] suibianwanwan commented on CALCITE-6748: [~mbudiu] Sorry, I wrote the wrong jir

[jira] [Commented] (CALCITE-6759) SqlToRelConverter will remove the sort with offset

2025-01-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17910036#comment-17910036 ] suibianwanwan commented on CALCITE-6759: [~nobigo] This seems to be a specific

[jira] [Assigned] (CALCITE-6748) RelToSqlConverter returns the wrong result when Aggregate is on Sort

2024-12-27 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6748: -- Assignee: suibianwanwan > RelToSqlConverter returns the wrong result when Aggregate

[jira] [Created] (CALCITE-6748) RelToSqlConverter returns the wrong result when Aggregate is on Sort

2024-12-27 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6748: -- Summary: RelToSqlConverter returns the wrong result when Aggregate is on Sort Key: CALCITE-6748 URL: https://issues.apache.org/jira/browse/CALCITE-6748 Project: C

[jira] [Commented] (CALCITE-6817) Add string representation of default nulls direction for RelNode

2025-02-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924776#comment-17924776 ] suibianwanwan commented on CALCITE-6817: [~mbudiu] I agree with you as it relat

[jira] [Commented] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2025-02-06 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924762#comment-17924762 ] suibianwanwan commented on CALCITE-6652: [~mbudiu] You are right. This seems to

[jira] [Comment Edited] (CALCITE-6652) RelDecorrelator can't decorrelate query with limit 1

2025-02-05 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17903855#comment-17903855 ] suibianwanwan edited comment on CALCITE-6652 at 2/5/25 12:36 PM:

[jira] [Commented] (CALCITE-6681) NullPointerException in ProjectCorrelateTransposeRule

2025-02-05 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924043#comment-17924043 ] suibianwanwan commented on CALCITE-6681: I suspect this is a bug in CorrelatePr

[jira] [Commented] (CALCITE-6824) FieldTrimmer corrupts plan in query that compares two BOOLEAN subqueries

2025-02-11 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17925919#comment-17925919 ] suibianwanwan commented on CALCITE-6824: I suspect the error occurs in SubQuery

[jira] [Created] (CALCITE-6825) Add support for ALL, SOME, ANY in RelToSqlConverter

2025-02-10 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6825: -- Summary: Add support for ALL, SOME, ANY in RelToSqlConverter Key: CALCITE-6825 URL: https://issues.apache.org/jira/browse/CALCITE-6825 Project: Calcite I

[jira] [Commented] (CALCITE-6824) FieldTrimmer corrupts plan in query that compares two BOOLEAN subqueries

2025-02-12 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926333#comment-17926333 ] suibianwanwan commented on CALCITE-6824: [~julianhyde] Hi, Can you assign it to

[jira] [Commented] (CALCITE-6798) Null direction emulation in MySQL and Hive is incorrect when null direction is not specified

2025-01-24 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17916641#comment-17916641 ] suibianwanwan commented on CALCITE-6798: Hi, [~VAE]. I don't think it's a bug,

[jira] [Commented] (CALCITE-5626) Sub-query with fully qualified table name throws table not found exception in validation phase

2025-01-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17912541#comment-17912541 ] suibianwanwan commented on CALCITE-5626: Hi, [~julianhyde] [~Runking]. I agree

[jira] [Comment Edited] (CALCITE-5626) Sub-query with fully qualified table name throws table not found exception in validation phase

2025-01-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17912541#comment-17912541 ] suibianwanwan edited comment on CALCITE-5626 at 1/13/25 2:03 PM:

[jira] [Updated] (CALCITE-6744) Returns null when the column origin contains the correlation variable

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6744: --- Description: The Correlate is not currently supported when metadata gets the column origin

[jira] [Updated] (CALCITE-6744) Returns null when the column origin contains the correlation variable

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6744: --- Description: The Correlate is not currently supported when metadata gets the column origin

[jira] [Updated] (CALCITE-6744) Returns null when the column origin contains the correlation variable

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6744: --- Summary: Returns null when the column origin contains the correlation variable (was: Suppo

[jira] [Commented] (CALCITE-6759) SqlToRelConverter will remove the sort with offset

2025-01-04 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17909736#comment-17909736 ] suibianwanwan commented on CALCITE-6759: [~julianhyde] [~mbudiu]. +1, from the

[jira] [Created] (CALCITE-6744) Support getColumnOrigins for correlate in RelMdColumnOrigins

2024-12-23 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6744: -- Summary: Support getColumnOrigins for correlate in RelMdColumnOrigins Key: CALCITE-6744 URL: https://issues.apache.org/jira/browse/CALCITE-6744 Project: Calcite

[jira] [Assigned] (CALCITE-6744) Support getColumnOrigins for correlate in RelMdColumnOrigins

2024-12-23 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6744: -- Assignee: suibianwanwan > Support getColumnOrigins for correlate in RelMdColumnOrigi

[jira] [Commented] (CALCITE-5626) Sub-query with fully qualified table name throws table not found exception in validation phase

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17913153#comment-17913153 ] suibianwanwan commented on CALCITE-5626: [~julianhyde] I've pared the test and

[jira] [Updated] (CALCITE-6744) Returns null when the column origin contains the correlation variable

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6744: --- Description: The Correlate is not currently supported when metadata gets the column origin

[jira] [Updated] (CALCITE-6744) RelMetadataQuery.getColumnOrigins should return null when column origin Includes correlation variables

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6744: --- Summary: RelMetadataQuery.getColumnOrigins should return null when column origin Includes c

[jira] [Commented] (CALCITE-6744) RelMetadataQuery.getColumnOrigins should return null when column origin Includes correlation variables

2025-01-14 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17913150#comment-17913150 ] suibianwanwan commented on CALCITE-6744: I've revised the title. How does this

[jira] [Assigned] (CALCITE-6759) SqlToRelConverter will remove the sort with offset

2025-01-02 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan reassigned CALCITE-6759: -- Assignee: suibianwanwan > SqlToRelConverter will remove the sort with offset > -

[jira] [Created] (CALCITE-6759) SqlToRelConverter will Remove the sort with offset

2025-01-02 Thread suibianwanwan (Jira)
suibianwanwan created CALCITE-6759: -- Summary: SqlToRelConverter will Remove the sort with offset Key: CALCITE-6759 URL: https://issues.apache.org/jira/browse/CALCITE-6759 Project: Calcite Is

[jira] [Updated] (CALCITE-6759) SqlToRelConverter will remove the sort with offset

2025-01-02 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6759: --- Summary: SqlToRelConverter will remove the sort with offset (was: SqlToRelConverter will R

[jira] [Updated] (CALCITE-6744) RelMetadataQuery.getColumnOrigins should return null when column origin includes correlation variables

2025-01-16 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] suibianwanwan updated CALCITE-6744: --- Summary: RelMetadataQuery.getColumnOrigins should return null when column origin includes c

[jira] [Commented] (CALCITE-6824) FieldTrimmer corrupts plan in query that compares two BOOLEAN subqueries

2025-02-12 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926676#comment-17926676 ] suibianwanwan commented on CALCITE-6824: A smaller reproduction in RelOptRulesT

[jira] [Comment Edited] (CALCITE-6824) FieldTrimmer corrupts plan in query that compares two BOOLEAN subqueries

2025-02-12 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926676#comment-17926676 ] suibianwanwan edited comment on CALCITE-6824 at 2/13/25 7:57 AM:

[jira] [Commented] (CALCITE-6824) FieldTrimmer corrupts plan in query that compares two BOOLEAN subqueries

2025-02-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926702#comment-17926702 ] suibianwanwan commented on CALCITE-6824: [~asolimando] Thanks, I got it! I’ve m

[jira] [Commented] (CALCITE-6824) JOIN_SUB_QUERY_TO_CORRELATE rule produces an incorrect plan when operands are not empty

2025-02-13 Thread suibianwanwan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17927025#comment-17927025 ] suibianwanwan commented on CALCITE-6824: [~asolimando] Thanks for the clarifica

  1   2   >