[jira] [Closed] (CALCITE-5945) Forced join order SQL hint.

2023-08-20 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin closed CALCITE-5945. - Resolution: Won't Fix Wrong project. > Forced join order SQL hint. >

[jira] [Created] (CALCITE-5945) Forced join order SQL hint.

2023-08-20 Thread Vladimir Steshin (Jira)
Vladimir Steshin created CALCITE-5945: - Summary: Forced join order SQL hint. Key: CALCITE-5945 URL: https://issues.apache.org/jira/browse/CALCITE-5945 Project: Calcite Issue Type: Task

[jira] [Comment Edited] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-14 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754067#comment-17754067 ] Vladimir Steshin edited comment on CALCITE-5915 at 8/14/23 12:15 PM:

[jira] [Commented] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-14 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754067#comment-17754067 ] Vladimir Steshin commented on CALCITE-5915: --- [~shenlang], thank you. I've realized what's

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-13 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Description: Not sure if it is a bug becuase the query plans in this case might not

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-13 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Description: Not sure if it is a bug becuase the query plans in this case might not

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Description: Not sure if it is a bug becuase the query plans in this case might not

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Description: Not sure if it is a bug becuase the query plans in this case might not

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Description: Not sure if it is a bug becuase the query plans in this case might not

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Attachment: SqlHintsInSubqueriesWithDisabledExpanding.java > Missing SQL hints in

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Attachment: (was: SqlHintsInSubqueriesWithDisabledExpanding.java) > Missing SQL

[jira] [Created] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
Vladimir Steshin created CALCITE-5915: - Summary: Missing SQL hints in not-expanded subqueries. Key: CALCITE-5915 URL: https://issues.apache.org/jira/browse/CALCITE-5915 Project: Calcite

[jira] [Updated] (CALCITE-5915) Missing SQL hints in not-expanded subqueries.

2023-08-10 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5915: -- Attachment: SqlHintsInSubqueriesWithDisabledExpanding.java > Missing SQL hints in

[jira] [Updated] (CALCITE-5154) Boolean clause is not recognized as boolean in Join-On's subquery.

2022-05-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5154: -- Description: Not the best example, I believe, but shows strange type checking:

[jira] [Updated] (CALCITE-5154) Boolean clause is not recognized as boolean in Join-On's subquery.

2022-05-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-5154: -- Description: Not the best example, I believe, but shows strange type checking:

[jira] [Created] (CALCITE-5154) Boolean clause is not recognized as boolean in Join-On's subquery.

2022-05-16 Thread Vladimir Steshin (Jira)
Vladimir Steshin created CALCITE-5154: - Summary: Boolean clause is not recognized as boolean in Join-On's subquery. Key: CALCITE-5154 URL: https://issues.apache.org/jira/browse/CALCITE-5154

[jira] [Commented] (CALCITE-4943) Type mismatch in Project / HepPlanner: INTEGER to JavaType(int)

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17461224#comment-17461224 ] Vladimir Steshin commented on CALCITE-4943: --- [~julianhyde], 1.29 > Type mismatch in Project

[jira] [Commented] (CALCITE-685) Correlated scalar sub-query in SELECT clause throws

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17461108#comment-17461108 ] Vladimir Steshin commented on CALCITE-685: -- If I'm correct, one should look into

[jira] [Updated] (CALCITE-4945) Runtime compilation fails on subquery.

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4945: -- Summary: Runtime compilation fails on subquery. (was: Compilation failes on

[jira] [Updated] (CALCITE-4945) Compilation failes on subquery

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4945: -- Affects Version/s: 1.29.0 > Compilation failes on subquery >

[jira] [Created] (CALCITE-4945) Compilation failes on subquery

2021-12-16 Thread Vladimir Steshin (Jira)
Vladimir Steshin created CALCITE-4945: - Summary: Compilation failes on subquery Key: CALCITE-4945 URL: https://issues.apache.org/jira/browse/CALCITE-4945 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4926: -- Affects Version/s: 1.28.0 > 'ORDER BY' misses alias/table of own 'WITH' >

[jira] [Updated] (CALCITE-4943) Type mismatch in Project / HepPlaner: INTEGER to JavaType(int)

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4943: -- Affects Version/s: 1.29.0 > Type mismatch in Project / HepPlaner: INTEGER to

[jira] [Updated] (CALCITE-4943) Type mismatch in Project / HepPlaner: INTEGER to JavaType(int)

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4943: -- Priority: Major (was: Minor) > Type mismatch in Project / HepPlaner: INTEGER to

[jira] [Commented] (CALCITE-685) Correlated scalar sub-query in SELECT clause throws

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17461060#comment-17461060 ] Vladimir Steshin commented on CALCITE-685: -- [~julianhyde], I meant 1.29. Thanks. The bug is

[jira] [Commented] (CALCITE-685) Correlated scalar sub-query in SELECT clause throws

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17460739#comment-17460739 ] Vladimir Steshin commented on CALCITE-685: -- On Calcite 1.19.0 from master branch I got:

[jira] [Updated] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4926: -- Labels: with (was: orderby) > 'ORDER BY' misses alias/table of own 'WITH' >

[jira] [Updated] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4926: -- Labels: (was: with) > 'ORDER BY' misses alias/table of own 'WITH' >

[jira] [Updated] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4926: -- Labels: orderby (was: ) > 'ORDER BY' misses alias/table of own 'WITH' >

[jira] [Updated] (CALCITE-4943) Type mismatch in Project / HepPlaner: INTEGER to JavaType(int)

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4943: -- Labels: sub-query (was: ) > Type mismatch in Project / HepPlaner: INTEGER to

[jira] [Updated] (CALCITE-4943) Type mismatch in Project / HepPlaner: INTEGER to JavaType(int)

2021-12-16 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4943: -- Description: Found by JdbcTest. Test query: {code:sql} CalciteAssert.hr()

[jira] [Created] (CALCITE-4943) Type conversin in Project / HepPlaner: INTEGER to JavaType(int)

2021-12-16 Thread Vladimir Steshin (Jira)
Vladimir Steshin created CALCITE-4943: - Summary: Type conversin in Project / HepPlaner: INTEGER to JavaType(int) Key: CALCITE-4943 URL: https://issues.apache.org/jira/browse/CALCITE-4943 Project:

[jira] [Updated] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-09 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4926: -- Description: "SELECT * FROM emp ORDER BY (WITH t AS (SELECT 1) SELECT * FROM t)"

[jira] [Updated] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-09 Thread Vladimir Steshin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Steshin updated CALCITE-4926: -- Description: "SELECT * FROM emp ORDER BY (WITH t AS (SELECT 1) SELECT * FROM t)"

[jira] [Created] (CALCITE-4926) 'ORDER BY' misses alias/table of own 'WITH'

2021-12-08 Thread Vladimir Steshin (Jira)
Vladimir Steshin created CALCITE-4926: - Summary: 'ORDER BY' misses alias/table of own 'WITH' Key: CALCITE-4926 URL: https://issues.apache.org/jira/browse/CALCITE-4926 Project: Calcite