[jira] [Created] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

rebey created CALCITE-5582: -- Summary: Not in or not exist subquery can't work with Oracle db Key: CALCITE-5582 URL: https://issues.apache.org/jira/browse/CALCITE-5582 Project: Calcite Issue Type: Bu

[jira] [Comment Edited] (CALCITE-5568) Decorrelate will fail. If the RelNode tree has LogicalValues

[ https://issues.apache.org/jira/browse/CALCITE-5568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17699940#comment-17699940 ] libopeng edited comment on CALCITE-5568 at 3/14/23 11:57 AM:

[jira] [Commented] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700126#comment-17700126 ] Zou commented on CALCITE-5582: -- [~rebey] could you please add a test in Calcite to reprodu

[jira] [Resolved] (CALCITE-5572) Release Calcite 1.34.0

[ https://issues.apache.org/jira/browse/CALCITE-5572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-5572. -- Fix Version/s: 1.34.0 Resolution: Fixed Fixed in https://github.com/a

[jira] [Created] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

libopeng created CALCITE-5583: - Summary: Rel2Sql will get an error when select * and join is present Key: CALCITE-5583 URL: https://issues.apache.org/jira/browse/CALCITE-5583 Project: Calcite Is

[jira] [Created] (CALCITE-5584) Publish website action only triggers for the last commit in the chain

Stamatis Zampetakis created CALCITE-5584: Summary: Publish website action only triggers for the last commit in the chain Key: CALCITE-5584 URL: https://issues.apache.org/jira/browse/CALCITE-5584

[jira] [Updated] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5583: -- Description: Rel2Sql will get an error when select * and join is present {code:java} LogicalJoin(cond

[jira] [Resolved] (CALCITE-5577) Map value constructor is unparsed incorrectly for SparkSqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-5577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5577. - Fix Version/s: 1.35.0 Resolution: Fixed Fixed via https://github.com/apache/calcite/com

[jira] [Updated] (CALCITE-5553) RelStructuredTypeFlattener produces bad plan for single field struct

[ https://issues.apache.org/jira/browse/CALCITE-5553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li updated CALCITE-5553: Summary: RelStructuredTypeFlattener produces bad plan for single field struct (was: Calcite RelS

[jira] [Resolved] (CALCITE-5553) RelStructuredTypeFlattener produces bad plan for single field struct

[ https://issues.apache.org/jira/browse/CALCITE-5553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5553. - Fix Version/s: 1.35.0 Resolution: Fixed Fixed via https://github.com/apache/calcite/com

[jira] [Commented] (CALCITE-5584) Publish website action only triggers for the last commit in the chain

[ https://issues.apache.org/jira/browse/CALCITE-5584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700235#comment-17700235 ] Stamatis Zampetakis commented on CALCITE-5584: -- To rectify the situation I

[jira] [Updated] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5567: Labels: pull-request-available (was: ) > Failed to apply plugin 'de.thetaphi.forbiddenap

[jira] [Resolved] (CALCITE-5440) Bump gradle to 7.6.1

[ https://issues.apache.org/jira/browse/CALCITE-5440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin resolved CALCITE-5440. -- Fix Version/s: avatica-1.24.0 1.35.0 Resolution: Fixed > Bu

[jira] [Commented] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700299#comment-17700299 ] Sergey Nuyanzin commented on CALCITE-5567: -- I merged upgrade of gradle. to bu

[jira] [Commented] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700305#comment-17700305 ] Julian Hyde commented on CALCITE-5567: -- Thanks Sergey. Iirc the gradle upgrade is

[jira] [Commented] (CALCITE-5584) Publish website action only triggers for the last commit in the chain

[ https://issues.apache.org/jira/browse/CALCITE-5584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700308#comment-17700308 ] Julian Hyde commented on CALCITE-5584: -- A documented manual way to publish the sit

[jira] [Commented] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700309#comment-17700309 ] Julian Hyde commented on CALCITE-5583: -- Can you evolve this into a minimal test ca

[jira] [Created] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

Tanner Clary created CALCITE-5585: - Summary: Add STRPOS() Function (Enabled for BigQuery) Key: CALCITE-5585 URL: https://issues.apache.org/jira/browse/CALCITE-5585 Project: Calcite Issue Type

[jira] [Updated] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary updated CALCITE-5585: -- Description: BigQuery supports the {{STRPOS()}} function with accepts 2 {{STRINGS}} as argum

[jira] [Updated] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

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

[jira] [Commented] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700328#comment-17700328 ] Sergey Nuyanzin commented on CALCITE-5567: -- There an issue with such approach

[jira] [Closed] (CALCITE-5528) RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent to the original one

[ https://issues.apache.org/jira/browse/CALCITE-5528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pinhan Zhao closed CALCITE-5528. Resolution: Fixed > RelOptRulesTest testPushAggregateThroughJoin7 optimized query not equivalent

[jira] [Commented] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700364#comment-17700364 ] Julian Hyde commented on CALCITE-5567: -- I don't know the details, but if our utili

[jira] [Commented] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700368#comment-17700368 ] Julian Hyde commented on CALCITE-5585: -- Sounds good, but let's stick to Calcite te

[jira] [Commented] (CALCITE-5585) Add STRPOS() Function (Enabled for BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700371#comment-17700371 ] Julian Hyde commented on CALCITE-5585: -- On second thoughts, definitely yes. {{POSI

[jira] [Commented] (CALCITE-5567) Failed to apply plugin 'de.thetaphi.forbiddenapis' when running ./gradlew build w/ java19

[ https://issues.apache.org/jira/browse/CALCITE-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700419#comment-17700419 ] Sergey Nuyanzin commented on CALCITE-5567: -- Hm... looks like there are some is

[jira] [Created] (CALCITE-5586) Replace boostport/hbase-phoenix-all-in-one docker image with f21global/hbase-phoenix-all-in-one

Francis Chuang created CALCITE-5586: --- Summary: Replace boostport/hbase-phoenix-all-in-one docker image with f21global/hbase-phoenix-all-in-one Key: CALCITE-5586 URL: https://issues.apache.org/jira/browse/CALCITE

[jira] [Resolved] (CALCITE-5586) Replace boostport/hbase-phoenix-all-in-one docker image with f21global/hbase-phoenix-all-in-one

[ https://issues.apache.org/jira/browse/CALCITE-5586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-5586. - Resolution: Fixed > Replace boostport/hbase-phoenix-all-in-one docker image with > f21

[jira] [Updated] (CALCITE-5586) Replace boostport/hbase-phoenix-all-in-one docker image with f21global/hbase-phoenix-all-in-one

[ https://issues.apache.org/jira/browse/CALCITE-5586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang updated CALCITE-5586: Description: Due to docker discontinuing free team plans, the boostport docker organizati

[jira] [Updated] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] rebey updated CALCITE-5582: --- Description: a subquery sql with "not in" or "not exists " be change to a left join sql by calcite,but it

[jira] [Commented] (CALCITE-5582) Not in or not exist subquery can't work with Oracle db

[ https://issues.apache.org/jira/browse/CALCITE-5582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700451#comment-17700451 ] rebey commented on CALCITE-5582: Hi [~FrankZou] , I added a demo and change picture to

[jira] [Updated] (CALCITE-5574) Break MockCatalogReaderSimple#init into smaller methods

[ https://issues.apache.org/jira/browse/CALCITE-5574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5574: Labels: pull-request-available (was: ) > Break MockCatalogReaderSimple#init into smaller

[jira] [Updated] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5583: -- Description: Rel2Sql will get an error when select * and join is present {code:java} LogicalProject(c

[jira] [Commented] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700477#comment-17700477 ] libopeng commented on CALCITE-5583: --- [~julianhyde] I wrote a unit test that you can t

[jira] [Comment Edited] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700477#comment-17700477 ] libopeng edited comment on CALCITE-5583 at 3/15/23 3:07 AM:

[jira] [Comment Edited] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700477#comment-17700477 ] libopeng edited comment on CALCITE-5583 at 3/15/23 3:08 AM:

[jira] [Updated] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5583: -- Description: Rel2Sql will get an error when select * and join is present {code:java} LogicalProject(c

[jira] [Updated] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] libopeng updated CALCITE-5583: -- Description: Rel2Sql will get an error when select * and join is present {code:java} LogicalProject(c

[jira] [Updated] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5583: Labels: pull-request-available (was: ) > Rel2Sql will get an error when select * and joi

[jira] [Commented] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700485#comment-17700485 ] libopeng commented on CALCITE-5583: --- I changed the RelNode on it {code:java} LogicalP

[jira] [Comment Edited] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700485#comment-17700485 ] libopeng edited comment on CALCITE-5583 at 3/15/23 3:53 AM:

[jira] [Comment Edited] (CALCITE-5583) Rel2Sql will get an error when select * and join is present

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700485#comment-17700485 ] libopeng edited comment on CALCITE-5583 at 3/15/23 3:55 AM:

[jira] [Commented] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17700517#comment-17700517 ] Sergey Nuyanzin commented on CALCITE-5570: -- Thanks for clarification Julian.