[jira] [Commented] (CALCITE-4640) Propagate table scan hints to JDBC

2021-06-07 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17358552#comment-17358552 ] Ulrich Kramer commented on CALCITE-4640: I already opened  [PR 

[jira] [Created] (CALCITE-4640) Propagate table scan hints to JDBC

2021-06-07 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-4640: -- Summary: Propagate table scan hints to JDBC Key: CALCITE-4640 URL: https://issues.apache.org/jira/browse/CALCITE-4640 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-4640) Propagate table scan hints to JDBC

2021-06-07 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17358552#comment-17358552 ] Ulrich Kramer edited comment on CALCITE-4640 at 6/7/21, 11:59 AM: -- I

[jira] [Commented] (CALCITE-4640) Propagate table scan hints to JDBC

2021-06-07 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17359042#comment-17359042 ] Ulrich Kramer commented on CALCITE-4640: {quote}In your example above, is "VIEW" the name of

[jira] [Created] (CALCITE-4655) NullPointerException in JdbcTable.scan

2021-06-18 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-4655: -- Summary: NullPointerException in JdbcTable.scan Key: CALCITE-4655 URL: https://issues.apache.org/jira/browse/CALCITE-4655 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-4655) NullPointerException in JdbcTable.scan

2021-06-18 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17365325#comment-17365325 ] Ulrich Kramer commented on CALCITE-4655: No I have no unit test for this. It should be

[jira] [Commented] (CALCITE-4655) NullPointerException in JdbcTable.scan

2021-06-20 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17366382#comment-17366382 ] Ulrich Kramer commented on CALCITE-4655: I changed the implementation to use

[jira] [Comment Edited] (CALCITE-4655) NullPointerException in JdbcTable.scan

2021-06-20 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17366382#comment-17366382 ] Ulrich Kramer edited comment on CALCITE-4655 at 6/21/21, 5:10 AM: -- I

[jira] [Commented] (CALCITE-4655) NullPointerException in JdbcTable.scan

2021-06-18 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17365511#comment-17365511 ] Ulrich Kramer commented on CALCITE-4655: I created a

[jira] [Created] (CALCITE-4654) CloneSchema doesn't cache

2021-06-17 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-4654: -- Summary: CloneSchema doesn't cache Key: CALCITE-4654 URL: https://issues.apache.org/jira/browse/CALCITE-4654 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-4688) SqlLibraryOperators.TO_TIMESTAMP has incorrect return type

2021-07-09 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-4688: -- Summary: SqlLibraryOperators.TO_TIMESTAMP has incorrect return type Key: CALCITE-4688 URL: https://issues.apache.org/jira/browse/CALCITE-4688 Project: Calcite

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

2023-11-03 Thread Ulrich Kramer (Jira)
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

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

2023-11-03 Thread Ulrich Kramer (Jira)
[ 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

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

2023-11-03 Thread Ulrich Kramer (Jira)
[ 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

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

2023-11-08 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17783917#comment-17783917 ] Ulrich Kramer commented on CALCITE-6090: The problem is cause by the

[jira] [Created] (CALCITE-5243) SELECT NULL AS C causes NoSuchMethodException: java.sql.ResultSet.getVoid(int)

2022-08-25 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-5243: -- Summary: SELECT NULL AS C causes NoSuchMethodException: java.sql.ResultSet.getVoid(int) Key: CALCITE-5243 URL: https://issues.apache.org/jira/browse/CALCITE-5243

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

2022-10-31 Thread Ulrich Kramer (Jira)
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

[jira] [Created] (CALCITE-5282) JdbcValues should add CAST on NULL values

2022-09-12 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-5282: -- Summary: JdbcValues should add CAST on NULL values Key: CALCITE-5282 URL: https://issues.apache.org/jira/browse/CALCITE-5282 Project: Calcite Issue

[jira] [Commented] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-14 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17603911#comment-17603911 ] Ulrich Kramer commented on CALCITE-5286: We are using version 1.31.1.  I also think that line

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

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-5284: --- Summary: JDBC rules create inefficient plan (was: JDBC rules create incorrect plan) >

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

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-5284: --- Description: The following unit test for {{JdbcAdapterTest}} fails: {code:java} @Test

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

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17603431#comment-17603431 ] Ulrich Kramer commented on CALCITE-5284: You are absolutely correct, it's only an inefficient

[jira] [Created] (CALCITE-5284) JDBC rules create incorrect plan

2022-09-13 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-5284: -- Summary: JDBC rules create incorrect plan Key: CALCITE-5284 URL: https://issues.apache.org/jira/browse/CALCITE-5284 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-5282) JdbcValues should add CAST on NULL values

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17603484#comment-17603484 ] Ulrich Kramer commented on CALCITE-5282: Hi [~zabetak], thank you for this hint. I had a look

[jira] [Commented] (CALCITE-5282) JdbcValues should add CAST on NULL values

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17603535#comment-17603535 ] Ulrich Kramer commented on CALCITE-5282: I managed to get it work, at least for the things, we

[jira] [Commented] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-18 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17606416#comment-17606416 ] Ulrich Kramer commented on CALCITE-5286: [~jiajunbernoulli], we are not using EnumerableLimit.

[jira] [Commented] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-26 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17609310#comment-17609310 ] Ulrich Kramer commented on CALCITE-5286: Hi [~jiajunbernoulli], it's quite hard to reproduce

[jira] [Created] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-13 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-5286: -- Summary: Join with parameterized LIMIT throws AssertionError "not a literal" Key: CALCITE-5286 URL: https://issues.apache.org/jira/browse/CALCITE-5286 Project:

[jira] [Commented] (CALCITE-5282) JdbcValues should add CAST on NULL values

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17603565#comment-17603565 ] Ulrich Kramer commented on CALCITE-5282: This sounds great. > JdbcValues should add CAST on

[jira] [Updated] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

2022-09-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-5286: --- Description: A query like the following one {code:java} select T."name", T."valueLeverId",

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

2022-10-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17617086#comment-17617086 ] Ulrich Kramer commented on CALCITE-5284: Is there someone who could answer [~libenchao]

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

2022-12-19 Thread Ulrich Kramer (Jira)
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-5284) JDBC rules create inefficient plan

2022-11-21 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17637058#comment-17637058 ] Ulrich Kramer commented on CALCITE-5284: Could this also be related to missing table

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

2022-11-22 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

2022-11-22 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17637108#comment-17637108 ] Ulrich Kramer commented on CALCITE-5284: Hi [~zabetak], thanks for your answer. Your suspicion

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

2022-11-30 Thread Ulrich Kramer (Jira)
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

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

2022-11-30 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641319#comment-17641319 ] Ulrich Kramer commented on CALCITE-5354: I opened a new one:

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

2022-11-27 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17639810#comment-17639810 ] Ulrich Kramer commented on CALCITE-5354: Thank you. That's great. > JDBC with UNNEST not

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

2022-11-28 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17640067#comment-17640067 ] Ulrich Kramer commented on CALCITE-5354: Hi [~jiajunbernoulli], I was quite sure, that the

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

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

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

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

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

2022-11-24 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17638545#comment-17638545 ] Ulrich Kramer commented on CALCITE-5354: Hi [~jiajunbernoulli], your PR works great for this

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

2022-11-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17632158#comment-17632158 ] Ulrich Kramer commented on CALCITE-5354: I will try to provide a PR for this. > JDBC with

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

2022-11-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633508#comment-17633508 ] Ulrich Kramer commented on CALCITE-5354: [~jiajunbernoulli], that's great. My solution would

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

2023-07-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741880#comment-17741880 ] Ulrich Kramer commented on CALCITE-5832: After catching the exception  {code:java} try {

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

2023-07-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741876#comment-17741876 ] Ulrich Kramer commented on CALCITE-5832: This log statement is never reached. The exception is

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

2023-07-11 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17741889#comment-17741889 ] Ulrich Kramer commented on CALCITE-5832: This is the incomplete graphviz output. The

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

2023-07-10 Thread Ulrich Kramer (Jira)
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...

2023-06-28 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

2023-05-08 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720431#comment-17720431 ] Ulrich Kramer commented on CALCITE-5693: I opened a PR for this:

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

2023-05-08 Thread Ulrich Kramer (Jira)
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-6221) Invalid query generated when the same table is joined multiple times

2024-01-24 Thread Ulrich Kramer (Jira)
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:

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

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

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

2024-02-06 Thread Ulrich Kramer (Jira)
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:

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

2024-02-06 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17815135#comment-17815135 ] Ulrich Kramer commented on CALCITE-6249: See also [this

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

2024-02-06 Thread Ulrich Kramer (Jira)
[ 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

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

2024-02-07 Thread Ulrich Kramer (Jira)
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

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

2024-02-07 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17815301#comment-17815301 ] Ulrich Kramer commented on CALCITE-6251: It's already there. > innerEnumerator in

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

2024-02-16 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17818013#comment-17818013 ] Ulrich Kramer commented on CALCITE-6268: We would like to implement a special caching of the

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

2024-02-16 Thread Ulrich Kramer (Jira)
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:

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

2023-12-06 Thread Ulrich Kramer (Jira)
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:

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

2023-12-06 Thread Ulrich Kramer (Jira)
[ 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

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

2023-12-19 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17798492#comment-17798492 ] Ulrich Kramer commented on CALCITE-5409: Hi [~zabetak], could you have a look at my PR? Is

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

2023-12-12 Thread Ulrich Kramer (Jira)
[ 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

2023-12-12 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17795810#comment-17795810 ] Ulrich Kramer commented on CALCITE-5832: We fixed this by changing the default row count of all

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

2023-12-12 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17795817#comment-17795817 ] Ulrich Kramer commented on CALCITE-5832: I modified

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

2023-12-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832 ] Ulrich Kramer deleted comment on CALCITE-5832: was (Author: kramerul): It seems that [this

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

2023-12-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796272#comment-17796272 ] Ulrich Kramer commented on CALCITE-5832: [This

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

2023-12-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796263#comment-17796263 ] Ulrich Kramer commented on CALCITE-5832: It seems that [this

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

2023-12-21 Thread Ulrich Kramer (Jira)
[ 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

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

2023-12-21 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799475#comment-17799475 ] Ulrich Kramer commented on CALCITE-5409: Sorry for reopening this issue. It's really a

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

2023-12-21 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799478#comment-17799478 ] Ulrich Kramer commented on CALCITE-4188: I also created a PR for this issue:

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

2023-12-11 Thread Ulrich Kramer (Jira)
[ 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:

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

2024-01-03 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802063#comment-17802063 ] Ulrich Kramer edited comment on CALCITE-6157 at 1/3/24 8:47 AM: The

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

2024-01-03 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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

2024-01-03 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802063#comment-17802063 ] Ulrich Kramer edited comment on CALCITE-6157 at 1/3/24 8:52 AM: The

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

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

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

2023-12-05 Thread Ulrich Kramer (Jira)
[ 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

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

2024-01-31 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813084#comment-17813084 ] Ulrich Kramer commented on CALCITE-6236: I closed 3660 > EnumerableBatchNestedLoopJoin uses

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

2024-02-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813247#comment-17813247 ] Ulrich Kramer commented on CALCITE-6236: Another possibility would be to store the filter

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

2024-02-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813280#comment-17813280 ] Ulrich Kramer commented on CALCITE-6236: I would also prefer the solution with the selectivity.

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

2024-02-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813279#comment-17813279 ] Ulrich Kramer commented on CALCITE-6236: As far as I understand it, the suggestion to save the

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

2024-02-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813311#comment-17813311 ] Ulrich Kramer commented on CALCITE-6236: My example is quite simple. But I have not written a

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

2024-02-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813245#comment-17813245 ] Ulrich Kramer commented on CALCITE-6236: Falling back to {{Join.estimateRowCount}} or

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

2024-02-01 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813161#comment-17813161 ] Ulrich Kramer commented on CALCITE-6236: I tested PR 3661 in our environment. It solves our

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

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

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

2024-02-02 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813620#comment-17813620 ] Ulrich Kramer commented on CALCITE-6236: [~rubenql] , thanks for the information. I also

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

2024-02-02 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813585#comment-17813585 ] Ulrich Kramer commented on CALCITE-6236: I created a PR based on the filter selectivity. >

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

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

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

2024-02-02 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17813605#comment-17813605 ] Ulrich Kramer commented on CALCITE-6236: Perhaps, it's really better to store the

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

2024-01-31 Thread Ulrich Kramer (Jira)
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

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

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

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

2024-01-30 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer commented on CALCITE-6221: Now, I restricted the renaming of the fields in SQL to

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

2024-01-30 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:09 PM: - Now,

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

2024-01-30 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:06 PM: - Now,

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

2024-01-30 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:09 PM: - Now,

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

2024-01-30 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812296#comment-17812296 ] Ulrich Kramer edited comment on CALCITE-6221 at 1/30/24 1:14 PM: - Now,

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

2024-01-31 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812646#comment-17812646 ] Ulrich Kramer commented on CALCITE-6221: I will try to modify the PR in this direction > JDBC

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

2024-01-31 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17812741#comment-17812741 ] Ulrich Kramer commented on CALCITE-6236: It would be great, if you could prepare a PR. >

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

2024-01-24 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810736#comment-17810736 ] Ulrich Kramer commented on CALCITE-6221: Yes, it's minimal. Everything works if - second column

  1   2   >