[jira] [Commented] (CALCITE-6401) JDBC adapter cannot push down joins with complex JOIN condition

[ https://issues.apache.org/jira/browse/CALCITE-6401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17863055#comment-17863055 ] Ulrich Kramer commented on CALCITE-6401: [~nobigo], thank you for fixing this

[jira] [Commented] (CALCITE-6436) JDBC adapter generates SQL with missing round brackets when WHERE clause contains parameter

[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861326#comment-17861326 ] Ulrich Kramer commented on CALCITE-6436: [~nobigo], this would be great. Thank

[jira] [Updated] (CALCITE-6436) JDBC adapter generates SQL with missing round brackets when WHERE condition which contains calculations

[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6436: --- Summary: JDBC adapter generates SQL with missing round brackets when WHERE condition which

[jira] [Updated] (CALCITE-6436) JDBC adapter generates SQL with missing round brackets when WHERE clause contains parameter

[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6436: --- Summary: JDBC adapter generates SQL with missing round brackets when WHERE clause contains

[jira] [Updated] (CALCITE-6436) Missing round brackets in WHERE condition which contains calculations

[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6436: --- Description: Running the following unit test in {{JdbcAdapterTest}} fails with {code:java

[jira] [Created] (CALCITE-6436) Missing round brackets in WHERE condition which contains calculations

Ulrich Kramer created CALCITE-6436: -- Summary: Missing round brackets in WHERE condition which contains calculations Key: CALCITE-6436 URL: https://issues.apache.org/jira/browse/CALCITE-6436 Project:

[jira] [Updated] (CALCITE-6436) Missing round brackets in WHERE condition which contains calculations

[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6436: --- Description: Running the following unit test in {{JdbcAdapterTest}} fails with {code:java

[jira] [Updated] (CALCITE-6401) JDBC adapter cannot push down joins with complex JOIN condition

[ https://issues.apache.org/jira/browse/CALCITE-6401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6401: --- Description: JDBC adapter (in JdbcJoinRule) cannot push down joins with conditions which i

[jira] [Created] (CALCITE-6401) JDBC adapter cannot push down joins with complex JOIN condition

Ulrich Kramer created CALCITE-6401: -- Summary: JDBC adapter cannot push down joins with complex JOIN condition Key: CALCITE-6401 URL: https://issues.apache.org/jira/browse/CALCITE-6401 Project: Calcit

[jira] [Comment Edited] (CALCITE-6373) Distinct optimization produces broken sql query

[ https://issues.apache.org/jira/browse/CALCITE-6373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17840282#comment-17840282 ] Ulrich Kramer edited comment on CALCITE-6373 at 4/24/24 4:32 AM:

[jira] [Commented] (CALCITE-6373) Distinct optimization produces broken sql query

[ https://issues.apache.org/jira/browse/CALCITE-6373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17840282#comment-17840282 ] Ulrich Kramer commented on CALCITE-6373: I'm aware of the fact that the formatt

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

[ https://issues.apache.org/jira/browse/CALCITE-6346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17840024#comment-17840024 ] Ulrich Kramer commented on CALCITE-6346: This seems to be related to {{RexSimpl

[jira] [Commented] (CALCITE-6373) Distinct optimization produces broken sql query

[ https://issues.apache.org/jira/browse/CALCITE-6373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17840011#comment-17840011 ] Ulrich Kramer commented on CALCITE-6373: We fixed the issue using this commit:

[jira] [Commented] (CALCITE-6268) Support implementing custom JdbcSchema

[ https://issues.apache.org/jira/browse/CALCITE-6268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17818013#comment-17818013 ] Ulrich Kramer commented on CALCITE-6268: We would like to implement a special c

[jira] [Created] (CALCITE-6268) Support implementing custom JdbcSchema

Ulrich Kramer created CALCITE-6268: -- Summary: Support implementing custom JdbcSchema Key: CALCITE-6268 URL: https://issues.apache.org/jira/browse/CALCITE-6268 Project: Calcite Issue Type: Ne

[jira] [Commented] (CALCITE-6251) innerEnumerator in EnumerableDefaults::correlateBatchJoin is not closed

[ https://issues.apache.org/jira/browse/CALCITE-6251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815301#comment-17815301 ] Ulrich Kramer commented on CALCITE-6251: It's already there. > innerEnumerator

[jira] [Created] (CALCITE-6251) innerEnumerator in EnumerableDefaults::correlateBatchJoin is not closed

Ulrich Kramer created CALCITE-6251: -- Summary: innerEnumerator in EnumerableDefaults::correlateBatchJoin is not closed Key: CALCITE-6251 URL: https://issues.apache.org/jira/browse/CALCITE-6251 Project

[jira] [Commented] (CALCITE-6249) RelNode::estimatedRowCount should not be used in computeSelfCost

[ https://issues.apache.org/jira/browse/CALCITE-6249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815163#comment-17815163 ] Ulrich Kramer commented on CALCITE-6249: Yes, I will create a PR for this issue

[jira] [Commented] (CALCITE-6249) RelNode::estimatedRowCount should not be used in computeSelfCost

[ https://issues.apache.org/jira/browse/CALCITE-6249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815135#comment-17815135 ] Ulrich Kramer commented on CALCITE-6249: See also [this commit|https://github.

[jira] [Created] (CALCITE-6249) RelNode::estimatedRowCount should not be used in computeSelfCost

Ulrich Kramer created CALCITE-6249: -- Summary: RelNode::estimatedRowCount should not be used in computeSelfCost Key: CALCITE-6249 URL: https://issues.apache.org/jira/browse/CALCITE-6249 Project: Calci

[jira] [Updated] (CALCITE-6249) RelNode::estimatedRowCount should not be used in computeSelfCost

[ https://issues.apache.org/jira/browse/CALCITE-6249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6249: --- Description: {{RelNode::estimatedRowCount}} is still used in many place inside {{computeSe

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813620#comment-17813620 ] Ulrich Kramer commented on CALCITE-6236: [~rubenql] , thanks for the informatio

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813605#comment-17813605 ] Ulrich Kramer commented on CALCITE-6236: Perhaps, it's really better to store t

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813598#comment-17813598 ] Ulrich Kramer commented on CALCITE-6236: Yes, it breaks also my PR. > Enumerab

[jira] [Comment Edited] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813585#comment-17813585 ] Ulrich Kramer edited comment on CALCITE-6236 at 2/2/24 9:23 AM: -

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813585#comment-17813585 ] Ulrich Kramer commented on CALCITE-6236: I created a PR based on the filter sel

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813311#comment-17813311 ] Ulrich Kramer commented on CALCITE-6236: My example is quite simple. But I have

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813280#comment-17813280 ] Ulrich Kramer commented on CALCITE-6236: I would also prefer the solution with

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813279#comment-17813279 ] Ulrich Kramer commented on CALCITE-6236: As far as I understand it, the suggest

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813247#comment-17813247 ] Ulrich Kramer commented on CALCITE-6236: Another possibility would be to store

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813245#comment-17813245 ] Ulrich Kramer commented on CALCITE-6236: Falling back to {{Join.estimateRowCoun

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813161#comment-17813161 ] Ulrich Kramer commented on CALCITE-6236: I tested PR 3661 in our environment. I

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17813084#comment-17813084 ] Ulrich Kramer commented on CALCITE-6236: I closed 3660 > EnumerableBatchNested

[jira] [Commented] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812741#comment-17812741 ] Ulrich Kramer commented on CALCITE-6236: It would be great, if you could prepar

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812646#comment-17812646 ] Ulrich Kramer commented on CALCITE-6221: I will try to modify the PR in this di

[jira] [Created] (CALCITE-6236) EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation

Ulrich Kramer created CALCITE-6236: -- Summary: EnumerableBatchNestedLoopJoin uses wrong row count for cost calculation Key: CALCITE-6236 URL: https://issues.apache.org/jira/browse/CALCITE-6236 Project

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812318#comment-17812318 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:39 PM:

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812318#comment-17812318 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:38 PM:

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812318#comment-17812318 ] Ulrich Kramer commented on CALCITE-6221: I also thought about applying {{Filter

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:14 PM:

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:09 PM:

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:09 PM:

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:06 PM:

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812296#comment-17812296 ] Ulrich Kramer commented on CALCITE-6221: Now, I restricted the renaming of the

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812256#comment-17812256 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 12:29 PM: ---

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812256#comment-17812256 ] Ulrich Kramer commented on CALCITE-6221: I will try to keep the changes as smal

[jira] [Comment Edited] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812256#comment-17812256 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 10:35 AM: ---

[jira] [Commented] (CALCITE-6221) JDBC adapter generates invalid query when the same table is joined multiple times

[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17810736#comment-17810736 ] Ulrich Kramer commented on CALCITE-6221: Yes, it's minimal. Everything works if

[jira] [Created] (CALCITE-6221) Invalid query generated when the same table is joined multiple times

Ulrich Kramer created CALCITE-6221: -- Summary: Invalid query generated when the same table is joined multiple times Key: CALCITE-6221 URL: https://issues.apache.org/jira/browse/CALCITE-6221 Project: C

[jira] [Comment Edited] (CALCITE-6157) SqlValidatorImpl breaks join condition when inlining table alias

[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17802063#comment-17802063 ] Ulrich Kramer edited comment on CALCITE-6157 at 1/3/24 8:52 AM: -

[jira] [Commented] (CALCITE-6157) SqlValidatorImpl breaks join condition when inlining table alias

[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17802063#comment-17802063 ] Ulrich Kramer commented on CALCITE-6157: The problem is caused by a change in {

[jira] [Comment Edited] (CALCITE-6157) SqlValidatorImpl breaks join condition when inlining table alias

[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17802063#comment-17802063 ] Ulrich Kramer edited comment on CALCITE-6157 at 1/3/24 8:47 AM: -

[jira] [Commented] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17799478#comment-17799478 ] Ulrich Kramer commented on CALCITE-4188: I also created a PR for this issue: ht

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17799475#comment-17799475 ] Ulrich Kramer commented on CALCITE-5409: Sorry for reopening this issue. It's r

[jira] [Closed] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer closed CALCITE-5409. -- Resolution: Duplicate > Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOI

[jira] [Commented] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17798492#comment-17798492 ] Ulrich Kramer commented on CALCITE-5409: Hi [~zabetak], could you have a look

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796272#comment-17796272 ] Ulrich Kramer commented on CALCITE-5832: [This change|https://github.com/sap-c

[jira] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832 ] Ulrich Kramer deleted comment on CALCITE-5832: was (Author: kramerul): It seems that [this change|https://github.com/sap-contributions/calcite/commit/dfbec0164e6d9da3f8ae34043d74030a048

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796263#comment-17796263 ] Ulrich Kramer commented on CALCITE-5832: It seems that [this change|https://gi

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17795817#comment-17795817 ] Ulrich Kramer commented on CALCITE-5832: I modified {{RelSubset$CheapestPlanRep

[jira] [Updated] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-5832: --- Attachment: screenshot-1.png > CyclicMetadataException thrown in complex JOIN > ---

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17795810#comment-17795810 ] Ulrich Kramer commented on CALCITE-5832: We fixed this by changing the default

[jira] [Updated] (CALCITE-6157) SqlValidatorImpl breaks join condition when inlining table alias

[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6157: --- Summary: SqlValidatorImpl breaks join condition when inlining table alias (was: SqlValidat

[jira] [Updated] (CALCITE-6157) SqlValidatorImpl breaks join condition

[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6157: --- Description: When switching from 1.35.0 to 1.36.0, {{SqlValidatorImpl}} breaks the join co

[jira] [Created] (CALCITE-6157) SqlValidatorImpl breaks join condition

Ulrich Kramer created CALCITE-6157: -- Summary: SqlValidatorImpl breaks join condition Key: CALCITE-6157 URL: https://issues.apache.org/jira/browse/CALCITE-6157 Project: Calcite Issue Type: Bu

[jira] [Comment Edited] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17793291#comment-17793291 ] Ulrich Kramer edited comment on CALCITE-5409 at 12/5/23 1:53 PM:

[jira] [Reopened] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer reopened CALCITE-5409: I provided a PR for this issue. > Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NEST

[jira] [Commented] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783945#comment-17783945 ] Ulrich Kramer commented on CALCITE-6090: See also https://github.com/sap-contr

[jira] [Comment Edited] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783917#comment-17783917 ] Ulrich Kramer edited comment on CALCITE-6090 at 11/8/23 8:52 AM:

[jira] [Comment Edited] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783937#comment-17783937 ] Ulrich Kramer edited comment on CALCITE-6090 at 11/8/23 8:51 AM:

[jira] [Commented] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783937#comment-17783937 ] Ulrich Kramer commented on CALCITE-6090: Changing [this block|https://github.c

[jira] [Comment Edited] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783917#comment-17783917 ] Ulrich Kramer edited comment on CALCITE-6090 at 11/8/23 8:21 AM:

[jira] [Commented] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783917#comment-17783917 ] Ulrich Kramer commented on CALCITE-6090: The problem is cause by the {{Aggregat

[jira] [Updated] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6090: --- Description: Adding the following unit test to {{JdbcAdapterTest}} leads to an error {code:

[jira] [Comment Edited] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783885#comment-17783885 ] Ulrich Kramer edited comment on CALCITE-6090 at 11/8/23 6:08 AM:

[jira] [Commented] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783885#comment-17783885 ] Ulrich Kramer commented on CALCITE-6090: My initial assumption is not correct.

[jira] [Updated] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6090: --- Description: Adding the following unit test to {{JdbcAdapterTest}} leads to an error {code:

[jira] [Updated] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6090: --- Description: Adding the following unit test to {{JdbcAdapterTest}} leads to an error {code:

[jira] [Created] (CALCITE-6090) Jdbc adapter may create wrong sql for joins

Ulrich Kramer created CALCITE-6090: -- Summary: Jdbc adapter may create wrong sql for joins Key: CALCITE-6090 URL: https://issues.apache.org/jira/browse/CALCITE-6090 Project: Calcite Issue Typ

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741889#comment-17741889 ] Ulrich Kramer commented on CALCITE-5832: This is the incomplete graphviz output

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741880#comment-17741880 ] Ulrich Kramer commented on CALCITE-5832: After catching the exception  {code:j

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741876#comment-17741876 ] Ulrich Kramer commented on CALCITE-5832: This log statement is never reached. T

[jira] [Created] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

Ulrich Kramer created CALCITE-5832: -- Summary: CyclicMetadataException thrown in complex JOIN Key: CALCITE-5832 URL: https://issues.apache.org/jira/browse/CALCITE-5832 Project: Calcite Issue

[jira] [Commented] (CALCITE-1593) JoinAssociateRule throws Exception in thread "main" java.lang.AssertionError: Internal error: Error while applying...

[ https://issues.apache.org/jira/browse/CALCITE-1593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738048#comment-17738048 ] Ulrich Kramer commented on CALCITE-1593: We fixed a similar problem by changing

[jira] [Commented] (CALCITE-5693) AssertionError with UNION using CTE

[ https://issues.apache.org/jira/browse/CALCITE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17720431#comment-17720431 ] Ulrich Kramer commented on CALCITE-5693: I opened a PR for this: https://github

[jira] [Created] (CALCITE-5693) AssertionError with UNION using CTE

Ulrich Kramer created CALCITE-5693: -- Summary: AssertionError with UNION using CTE Key: CALCITE-5693 URL: https://issues.apache.org/jira/browse/CALCITE-5693 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-5441) Unknown Types value with Postgres and NULL value in dynamic parameter

Ulrich Kramer created CALCITE-5441: -- Summary: Unknown Types value with Postgres and NULL value in dynamic parameter Key: CALCITE-5441 URL: https://issues.apache.org/jira/browse/CALCITE-5441 Project:

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17641319#comment-17641319 ] Ulrich Kramer commented on CALCITE-5354: I opened a new one: https://issues.ap

[jira] [Created] (CALCITE-5409) Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE

Ulrich Kramer created CALCITE-5409: -- Summary: Jdbc doesn't support EnumerableRules.ENUMERABLE_BATCH_NESTED_LOOP_JOIN_RULE Key: CALCITE-5409 URL: https://issues.apache.org/jira/browse/CALCITE-5409 Pro

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17640067#comment-17640067 ] Ulrich Kramer commented on CALCITE-5354: Hi [~jiajunbernoulli], I was quite su

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17639810#comment-17639810 ] Ulrich Kramer commented on CALCITE-5354: Thank you. That's great. > JDBC with

[jira] [Comment Edited] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17638545#comment-17638545 ] Ulrich Kramer edited comment on CALCITE-5354 at 11/25/22 7:52 AM: ---

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17638545#comment-17638545 ] Ulrich Kramer commented on CALCITE-5354: Hi [~jiajunbernoulli], your PR works

[jira] [Comment Edited] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17638545#comment-17638545 ] Ulrich Kramer edited comment on CALCITE-5354 at 11/25/22 7:51 AM: ---

[jira] [Commented] (CALCITE-5284) JDBC rules create inefficient plan

[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17637141#comment-17637141 ] Ulrich Kramer commented on CALCITE-5284: I opened a pull request for this issue

[jira] [Commented] (CALCITE-5284) JDBC rules create inefficient plan

[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17637108#comment-17637108 ] Ulrich Kramer commented on CALCITE-5284: Hi [~zabetak], thanks for your answer

[jira] [Commented] (CALCITE-5284) JDBC rules create inefficient plan

[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17637058#comment-17637058 ] Ulrich Kramer commented on CALCITE-5284: Could this also be related to missing

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17633508#comment-17633508 ] Ulrich Kramer commented on CALCITE-5354: [~jiajunbernoulli], that's great. My s

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17632158#comment-17632158 ] Ulrich Kramer commented on CALCITE-5354: I will try to provide a PR for this.

[jira] [Created] (CALCITE-5354) JDBC with UNNEST not working

Ulrich Kramer created CALCITE-5354: -- Summary: JDBC with UNNEST not working Key: CALCITE-5354 URL: https://issues.apache.org/jira/browse/CALCITE-5354 Project: Calcite Issue Type: Bug

  1   2   >