[jira] [Updated] (CALCITE-3011) Support outer joins with AggregateJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3011: Labels: pull-request-available (was: ) > Support outer joins with

[jira] [Updated] (CALCITE-3011) Support outer joins with AggregateJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3011: - Summary: Support outer joins with AggregateJoinTransposeRule (was: Support for outer joins

[jira] [Created] (CALCITE-3011) Support for outer joins with AggregateJoinTransposeRule

Vineet Garg created CALCITE-3011: Summary: Support for outer joins with AggregateJoinTransposeRule Key: CALCITE-3011 URL: https://issues.apache.org/jira/browse/CALCITE-3011 Project: Calcite

[jira] [Updated] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3008: Labels: pull-request-available (was: ) > Making AuxiliaryConverter Pluggable >

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820604#comment-16820604 ] Haisheng Yuan commented on CALCITE-3008: {quote} That's actually a good point.

[jira] [Comment Edited] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820660#comment-16820660 ] Chunwei Lei edited comment on CALCITE-2453 at 4/18/19 2:52 AM: --- I am not

[jira] [Assigned] (CALCITE-3007) Type mismatch for ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned CALCITE-3007: Assignee: Vineet Garg > Type mismatch for ANY subquery in project >

[jira] [Updated] (CALCITE-3007) Type mismatch for ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3007: Labels: pull-request-available sub-query (was: sub-query) > Type mismatch for ANY

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 3:02 AM:

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 3:01 AM:

[jira] [Commented] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820737#comment-16820737 ] Chunwei Lei commented on CALCITE-3006: -- Thanks [~nkollar]. I opened a PR: 

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820669#comment-16820669 ] Haisheng Yuan commented on CALCITE-2948: The EMPNO is primary key of table emp, so it is

[jira] [Commented] (CALCITE-2882) ConnectionProperties lose effectiveness when connection reopen after expired

[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820595#comment-16820595 ] Stamatis Zampetakis commented on CALCITE-2882: -- Thanks for the PR [~shining]! I did some

[jira] [Reopened] (CALCITE-2882) ConnectionProperties lose effectiveness when connection reopen after expired

[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reopened CALCITE-2882: -- > ConnectionProperties lose effectiveness when connection reopen after expired >

[jira] [Resolved] (CALCITE-2882) ConnectionProperties lose effectiveness when connection reopen after expired

[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-2882. -- Resolution: Fixed > ConnectionProperties lose effectiveness when connection

[jira] [Closed] (CALCITE-2882) ConnectionProperties lose effectiveness when connection reopen after expired

[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis closed CALCITE-2882. Resolution: Fixed Fix Version/s: avatica-1.14.0 Fixed in

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820661#comment-16820661 ] Danny Chan commented on CALCITE-2948: - [~vvysotskyi] The aggregate group set keys are already added

[jira] [Updated] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3006: Labels: pull-request-available (was: ) > Inaccurate information on site, example code

[jira] [Comment Edited] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16815943#comment-16815943 ] Lai Zhou edited comment on CALCITE-2973 at 4/18/19 3:04 AM:

[jira] [Commented] (CALCITE-3009) It should fail if there are duplicate keys in a .xml file

[ https://issues.apache.org/jira/browse/CALCITE-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819783#comment-16819783 ] Chunwei Lei commented on CALCITE-3009: -- I opened a PR: 

[jira] [Updated] (CALCITE-3009) It should fail if there are duplicate keys in a .xml file

[ https://issues.apache.org/jira/browse/CALCITE-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3009: Labels: pull-request-available (was: ) > It should fail if there are duplicate keys in

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819780#comment-16819780 ] Forward Xu commented on CALCITE-2846: - Reference blink now is to write its own

[jira] [Updated] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3005: Labels: pull-request-available (was: ) > Implement string functions: LEFT, RIGHT >

[jira] [Commented] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819897#comment-16819897 ] Julian Hyde commented on CALCITE-3005: -- When proposing functions, please state which databases

[jira] [Commented] (CALCITE-1531) SqlValidatorException when boolean operators are used with NULL

[ https://issues.apache.org/jira/browse/CALCITE-1531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819790#comment-16819790 ] Stamatis Zampetakis commented on CALCITE-1531: -- Hey [~hhlai1990], usually we don't reopen

[jira] [Commented] (CALCITE-2985) Add the JSON_STORAGE_SIZE function

[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819886#comment-16819886 ] Julian Hyde commented on CALCITE-2985: -- I'm not too worried about the size of SqlStdOperatorTable

[jira] [Created] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

Hongze Zhang created CALCITE-3010: - Summary: In SQL parser, move JsonValueExpression into Expression Key: CALCITE-3010 URL: https://issues.apache.org/jira/browse/CALCITE-3010 Project: Calcite

[jira] [Assigned] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang reassigned CALCITE-3010: - Assignee: Hongze Zhang > In SQL parser, move JsonValueExpression into Expression >

[jira] [Commented] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819906#comment-16819906 ] Hongze Zhang commented on CALCITE-3010: --- I'll take this. > In SQL parser, move

[jira] [Updated] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2948: Labels: pull-request-available sub-query (was: sub-query) > SqlToRelConverter generates

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819916#comment-16819916 ] Danny Chan commented on CALCITE-2948: - Hi [~hyuan] [~zabetak] [~julianhyde] [~vgarg]  I have

[jira] [Issue Comment Deleted] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-2948: Comment: was deleted (was: Hi [~hyuan] [~zabetak] [~julianhyde] [~vgarg]  I have applied a

[jira] [Updated] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-3010: -- Description: Below is the syntax definition of {{JsonValueExpression}} from ISO/SEC 19075-6:

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819927#comment-16819927 ] Danny Chan commented on CALCITE-2948: - Hi [~hyuan] [~zabetak] [~julianhyde] [~vgarg]  I have

[jira] [Commented] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819929#comment-16819929 ] Nandor Kollar commented on CALCITE-3006: Ooops I forgot the link to the page, here it is:

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819972#comment-16819972 ] Volodymyr Vysotskyi commented on CALCITE-2948: -- [~danny0405], the aggregation for these

[jira] [Updated] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-3010: -- Description: Below is the syntax definition of {{JsonValueExpression}} from ISO/SEC 19075-6:

[jira] [Commented] (CALCITE-1531) SqlValidatorException when boolean operators are used with NULL

[ https://issues.apache.org/jira/browse/CALCITE-1531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819945#comment-16819945 ] Danny Chan commented on CALCITE-1531: - This kind of in the scope of implicit type coercion. >

[jira] [Commented] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820094#comment-16820094 ] Nandor Kollar commented on CALCITE-3006: Sure, go ahead! I recently met with this Apache

[jira] [Commented] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820092#comment-16820092 ] Chunwei Lei commented on CALCITE-3006: -- {quote}For me, this part of the doc looks outdated.

[jira] [Assigned] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-3006: Assignee: Chunwei Lei > Inaccurate information on site, example code doesn't compile >

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820205#comment-16820205 ] Rong Rong commented on CALCITE-3008: Thanks [~hyuan] for the quick response. I will start

[jira] [Updated] (CALCITE-2969) Improve design of join-like relational expressions

[ https://issues.apache.org/jira/browse/CALCITE-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-2969: Labels: pull-request-available (was: ) > Improve design of join-like relational

[jira] [Commented] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820220#comment-16820220 ] Chunwei Lei commented on CALCITE-2453: -- Thanks [~julianhyde]. I reviewed the PR and I believe it