[jira] [Commented] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761850#comment-17761850 ] Ruben Q L commented on CALCITE-5952: bq. My new proposal is "SemiJoinJoinTransposeRule should check

[jira] [Commented] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761830#comment-17761830 ] Ruben Q L commented on CALCITE-5952: {quote}Maybe just "SemiJoinJoinTransposeRule should not push

[jira] [Commented] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761799#comment-17761799 ] Ruben Q L commented on CALCITE-5952: Thanks [~lchistov1987]. IMO both tests are complementary (and

[jira] [Comment Edited] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761799#comment-17761799 ] Ruben Q L edited comment on CALCITE-5952 at 9/4/23 11:54 AM: - Thanks

[jira] [Resolved] (CALCITE-5965) Avoid unnecessary String concatenations in the RexFieldAccess constructor to improve the performance

[ https://issues.apache.org/jira/browse/CALCITE-5965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5965. Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5967) UnsupportedOperationException while implementing a call that requires a special collator

[ https://issues.apache.org/jira/browse/CALCITE-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17760270#comment-17760270 ] Ruben Q L commented on CALCITE-5967: Thanks for the feedback [~julianhyde], no apologies needed, as

[jira] [Updated] (CALCITE-5967) UnsupportedOperationException while implementing a call that requires a special collator

[ https://issues.apache.org/jira/browse/CALCITE-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5967: --- Summary: UnsupportedOperationException while implementing a call that requires a special collator

[jira] [Updated] (CALCITE-5967) UnsupportedOperationException while implementing a call that requires a special collator

[ https://issues.apache.org/jira/browse/CALCITE-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5967: --- Summary: UnsupportedOperationException while implementing a call that requires a special collator

[jira] [Updated] (CALCITE-5967) UnsupportedOperationException while implementing call that requires a special collator

[ https://issues.apache.org/jira/browse/CALCITE-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5967: --- Description: Regression introduced by a minor change within CALCITE-5914, detected while testing

[jira] [Commented] (CALCITE-5967) UnsupportedOperationException while implementing call that requires a special collator

[ https://issues.apache.org/jira/browse/CALCITE-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17760020#comment-17760020 ] Ruben Q L commented on CALCITE-5967: Problem can be reproduced by adding this test into

[jira] [Created] (CALCITE-5967) UnsupportedOperationException while implementing call that requires a special collator

Ruben Q L created CALCITE-5967: -- Summary: UnsupportedOperationException while implementing call that requires a special collator Key: CALCITE-5967 URL: https://issues.apache.org/jira/browse/CALCITE-5967

[jira] [Commented] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17758083#comment-17758083 ] Ruben Q L commented on CALCITE-5952: The rule-based test that you proposed is totally relevant and

[jira] [Commented] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17757957#comment-17757957 ] Ruben Q L commented on CALCITE-5952: I meant showing e.g. a query/plan with employee, department,

[jira] [Commented] (CALCITE-5952) Semi-Join incorrectly reordered with Left-Join by SemiJoinJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17757919#comment-17757919 ] Ruben Q L commented on CALCITE-5952: Would it be possible to have a test showing the expected

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17757918#comment-17757918 ] Ruben Q L commented on CALCITE-5732: If someone could please help me out reviewing the PR, I'd

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Component/s: core > EnumerableHashJoin and EnumerableMergeJoin on composite key return rows >

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17755846#comment-17755846 ] Ruben Q L commented on CALCITE-5732: Note: it was verified that the proposed patch fixes also

[jira] [Commented] (CALCITE-5934) calcite avatica calculation error

[ https://issues.apache.org/jira/browse/CALCITE-5934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17755403#comment-17755403 ] Ruben Q L commented on CALCITE-5934: [~leepb] could this be caused by CALCITE-5732? > calcite

[jira] [Resolved] (CALCITE-5843) Constant expression with nested casts causes a compiler crash

[ https://issues.apache.org/jira/browse/CALCITE-5843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5843. Resolution: Fixed Fixed via

[jira] [Resolved] (CALCITE-5903) RelMdCollation does not define collations for EnumerableLimit

[ https://issues.apache.org/jira/browse/CALCITE-5903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5903. Resolution: Fixed Fixed via  

[jira] [Created] (CALCITE-5903) RelMdCollation does not define collations for EnumerableLimit

Ruben Q L created CALCITE-5903: -- Summary: RelMdCollation does not define collations for EnumerableLimit Key: CALCITE-5903 URL: https://issues.apache.org/jira/browse/CALCITE-5903 Project: Calcite

[jira] [Resolved] (CALCITE-5882) Compile-time evaluation of SPLIT function returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5882. Resolution: Fixed Fixed via  

[jira] [Updated] (CALCITE-5882) Compile-time evaluation of SPLIT function returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5882: --- Fix Version/s: 1.36.0 > Compile-time evaluation of SPLIT function returns incorrect result >

[jira] [Resolved] (CALCITE-5879) AssertionError during constant reduction of SPLIT expression that returns NULL

[ https://issues.apache.org/jira/browse/CALCITE-5879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5879. Resolution: Fixed Fixed via  

[jira] [Resolved] (CALCITE-5877) AssertionError during MOD operation if result scale is greater than maximum numeric scale

[ https://issues.apache.org/jira/browse/CALCITE-5877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5877. Resolution: Fixed Done via

[jira] [Updated] (CALCITE-5879) Calcite crashes with AssertionFailure during evaluation of constant SPLIT expression

[ https://issues.apache.org/jira/browse/CALCITE-5879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5879: --- Fix Version/s: 1.36.0 > Calcite crashes with AssertionFailure during evaluation of constant SPLIT

[jira] [Updated] (CALCITE-5867) Add BLOB data type in SqlTypeName

[ https://issues.apache.org/jira/browse/CALCITE-5867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5867: --- Fix Version/s: (was: 1.35.0) > Add BLOB data type in SqlTypeName >

[jira] [Commented] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17745596#comment-17745596 ] Ruben Q L commented on CALCITE-5865: [~nobigo], the problem [should be

[jira] [Comment Edited] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17745506#comment-17745506 ] Ruben Q L edited comment on CALCITE-5865 at 7/21/23 9:22 AM: - Thanks for

[jira] [Commented] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17745506#comment-17745506 ] Ruben Q L commented on CALCITE-5865: Thanks for the indo [~nobigo]. I have created a PR to fix this

[jira] [Updated] (CALCITE-5865) ClassCastException with FLOOR and CEIL on conformances that are not builtin

[ https://issues.apache.org/jira/browse/CALCITE-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5865: --- Priority: Blocker (was: Major) > ClassCastException with FLOOR and CEIL on conformances that are

[jira] [Updated] (CALCITE-5857) set org.apache.calcite.sql.validateScopeChild to protected or public

[ https://issues.apache.org/jira/browse/CALCITE-5857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5857: --- Affects Version/s: (was: 1.36.0) > set org.apache.calcite.sql.validateScopeChild to protected

[jira] [Updated] (CALCITE-5857) set org.apache.calcite.sql.validateScopeChild to protected or public

[ https://issues.apache.org/jira/browse/CALCITE-5857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5857: --- Fix Version/s: (was: 1.34.0) (was: 1.35.0) > set

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Fix Version/s: 1.36.0 > EnumerableHashJoin and EnumerableMergeJoin on composite key return rows >

[jira] [Resolved] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5839. Resolution: Fixed Fixed via

[jira] [Comment Edited] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742445#comment-17742445 ] Ruben Q L edited comment on CALCITE-5839 at 7/12/23 2:46 PM: - Thanks for

[jira] [Commented] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742445#comment-17742445 ] Ruben Q L commented on CALCITE-5839: Thanks for the quick confirmation [~zabetak]! I will create a

[jira] [Updated] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5839: --- Fix Version/s: 1.35.0 > EnumerableInterpretable#StaticFieldDetector can overwrite its flag and

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742433#comment-17742433 ] Ruben Q L commented on CALCITE-5732: Created [PR#3311|https://github.com/apache/calcite/pull/3311]

[jira] [Comment Edited] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742430#comment-17742430 ] Ruben Q L edited comment on CALCITE-5839 at 7/12/23 1:43 PM: - Credits to

[jira] [Comment Edited] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742430#comment-17742430 ] Ruben Q L edited comment on CALCITE-5839 at 7/12/23 1:43 PM: - Credits to

[jira] [Commented] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742430#comment-17742430 ] Ruben Q L commented on CALCITE-5839: Credits to [~thomas.rebele] for finding this. [~zabetak],

[jira] [Created] (CALCITE-5839) EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result

Ruben Q L created CALCITE-5839: -- Summary: EnumerableInterpretable#StaticFieldDetector can overwrite its flag and return an incorrect result Key: CALCITE-5839 URL: https://issues.apache.org/jira/browse/CALCITE-5839

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17742332#comment-17742332 ] Ruben Q L commented on CALCITE-5732: I'll try to work on a solution for this one. I'm thinking that

[jira] [Assigned] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5732: -- Assignee: Ruben Q L > EnumerableHashJoin and EnumerableMergeJoin on composite key return

[jira] [Updated] (CALCITE-1776) Implement CORR and REGR_* aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-1776: --- Fix Version/s: (was: 1.35.0) > Implement CORR and REGR_* aggregate functions >

[jira] [Commented] (CALCITE-1776) Implement CORR and REGR_* aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17740729#comment-17740729 ] Ruben Q L commented on CALCITE-1776: [~Sergey Nuyanzin], I'm sorry, but it seems that this old PR

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17740593#comment-17740593 ] Ruben Q L commented on CALCITE-5715: [~libenchao], at first sight, the change seems reasonable, and

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5731: --- Fix Version/s: (was: 1.35.0) > cast to row type should throw exception when contains null/not

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738290#comment-17738290 ] Ruben Q L commented on CALCITE-5731: [~jackylau] I'm removing the "fixVersion=1.35" from this one.

[jira] [Updated] (CALCITE-5731) Cast to row type should throw exception when contains null/not null constraint

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5731: --- Summary: Cast to row type should throw exception when contains null/not null constraint (was:

[jira] [Commented] (CALCITE-5715) Prune old nodes after projection merging in ProjectMergeRule

[ https://issues.apache.org/jira/browse/CALCITE-5715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738289#comment-17738289 ] Ruben Q L commented on CALCITE-5715: [~libenchao] what's the status on this one? Given the

[jira] [Commented] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738288#comment-17738288 ] Ruben Q L commented on CALCITE-5539: [~jackylau] if I understand correctly, the problem is that

[jira] [Updated] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

[ https://issues.apache.org/jira/browse/CALCITE-5539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5539: --- Fix Version/s: (was: 1.35.0) > GREATEST/LEAST/COALESCE OperandTypes is not correct, which

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Fix Version/s: (was: 1.35.0) > EnumerableHashJoin and EnumerableMergeJoin on composite key

[jira] [Commented] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738282#comment-17738282 ] Ruben Q L commented on CALCITE-5686: Thanks [~julianhyde] for checking this. I know that

[jira] [Updated] (CALCITE-5686) Generalize return types of the linq4j expression shuttle

[ https://issues.apache.org/jira/browse/CALCITE-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5686: --- Priority: Minor (was: Major) > Generalize return types of the linq4j expression shuttle >

[jira] [Commented] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738285#comment-17738285 ] Ruben Q L commented on CALCITE-5732: [~viggoc] since this is not a regression (it seems indeed an

[jira] [Resolved] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4679. Resolution: Fixed > Search/sarg simplification leaves is not null(literal) unsimplified >

[jira] [Resolved] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL, Postgresql, BigQuery and MSSQL)

[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5771. Fix Version/s: 1.35.0 Resolution: Fixed > Apply two different NULL semantics for CONCAT

[jira] [Reopened] (CALCITE-4679) Search/sarg simplification leaves is not null(literal) unsimplified

[ https://issues.apache.org/jira/browse/CALCITE-4679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-4679: > Search/sarg simplification leaves is not null(literal) unsimplified >

[jira] [Reopened] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5757: > Incorrect return type for BigQuery TRUNC functions >

[jira] [Resolved] (CALCITE-5757) Incorrect return type for BigQuery TRUNC functions

[ https://issues.apache.org/jira/browse/CALCITE-5757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5757. Fix Version/s: 1.35.0 Resolution: Fixed > Incorrect return type for BigQuery TRUNC

[jira] [Reopened] (CALCITE-5771) Apply two different NULL semantics for CONCAT function(enabled in MySQL, Postgresql, BigQuery and MSSQL)

[ https://issues.apache.org/jira/browse/CALCITE-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5771: > Apply two different NULL semantics for CONCAT function(enabled in MySQL, > Postgresql, BigQuery

[jira] [Comment Edited] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737204#comment-17737204 ] Ruben Q L edited comment on CALCITE-5716 at 6/26/23 4:15 PM: - After some

[jira] [Comment Edited] (CALCITE-5683) Two level nested correlated sub-query throws exception during decorrelation

[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737228#comment-17737228 ] Ruben Q L edited comment on CALCITE-5683 at 6/26/23 4:11 PM: - Thanks

[jira] [Comment Edited] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737225#comment-17737225 ] Ruben Q L edited comment on CALCITE-5789 at 6/26/23 4:11 PM: - Done in

[jira] [Resolved] (CALCITE-5683) Two level nested correlated sub-query throws exception during decorrelation

[ https://issues.apache.org/jira/browse/CALCITE-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5683. Resolution: Fixed Done in

[jira] [Resolved] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5789. Resolution: Fixed Done in

[jira] [Commented] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737204#comment-17737204 ] Ruben Q L commented on CALCITE-5716: After some discussion between [~libenchao] and myself, it was

[jira] [Reopened] (CALCITE-5716) Two level nested correlated subquery translates to incorrect ON condition

[ https://issues.apache.org/jira/browse/CALCITE-5716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reopened CALCITE-5716: > Two level nested correlated subquery translates to incorrect ON condition >

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Assigned] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5789: -- Assignee: Ruben Q L > Query with two nested subqueries where the inner-most references the

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Fix Version/s: 1.35.0 > Query with two nested subqueries where the inner-most references the >

[jira] [Commented] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17735414#comment-17735414 ] Ruben Q L commented on CALCITE-5789: If somehow the variableSet when SubQueryRemoveRule is

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Attachment: debugger.png > Query with two nested subqueries where the inner-most references the >

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Updated] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

[ https://issues.apache.org/jira/browse/CALCITE-5789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5789: --- Description: Problem can be reproduced with the following query (to be added e.g. in

[jira] [Created] (CALCITE-5789) Query with two nested subqueries where the inner-most references the outer-most table returns wrong result

Ruben Q L created CALCITE-5789: -- Summary: Query with two nested subqueries where the inner-most references the outer-most table returns wrong result Key: CALCITE-5789 URL:

[jira] [Resolved] (CALCITE-5728) Add ARRAY_TO_STRING function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5728. Resolution: Fixed Done via

[jira] [Resolved] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5401. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5401: --- Fix Version/s: 1.35.0 > Rule fired by HepPlanner can return Volcano's RelSubset >

[jira] [Updated] (CALCITE-5745) CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5745: --- Fix Version/s: 1.35.0 > CONCAT2 function (enabled in Oracle library) gets wrong result when one of

[jira] [Updated] (CALCITE-5745) CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5745: --- Summary: CONCAT2 function (enabled in Oracle library) gets wrong result when one of the arguments

[jira] [Updated] (CALCITE-5728) Add ARRAY_TO_STRING function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5728: --- Fix Version/s: 1.35.0 > Add ARRAY_TO_STRING function (enabled in BigQuery library) >

[jira] [Updated] (CALCITE-5732) EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5732: --- Summary: EnumerableHashJoin and EnumerableMergeJoin on composite key return rows matching

[jira] [Updated] (CALCITE-5401) Rule fired by HepPlanner can return Volcano's RelSubset

[ https://issues.apache.org/jira/browse/CALCITE-5401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5401: --- Fix Version/s: (was: 1.35.0) > Rule fired by HepPlanner can return Volcano's RelSubset >

[jira] [Resolved] (CALCITE-5730) Initial null values can be dropped by EnumerableLimitSort with offset

[ https://issues.apache.org/jira/browse/CALCITE-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5730. Resolution: Fixed Fixed via

[jira] [Comment Edited] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728250#comment-17728250 ] Ruben Q L edited comment on CALCITE-5732 at 6/1/23 3:45 PM: I see. The

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728251#comment-17728251 ] Ruben Q L commented on CALCITE-5731: What's the problem with the current status (that goes beyond

[jira] [Commented] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728250#comment-17728250 ] Ruben Q L commented on CALCITE-5732: I see. The problem is that both algorithms check for a null

[jira] [Commented] (CALCITE-5732) EnumerableJoin should not return rows matching condition 'null = null'

[ https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728105#comment-17728105 ] Ruben Q L commented on CALCITE-5732: [~viggoc] just to confirm: the bug occurs with both HashJoin

<    1   2   3   4   5   6   7   8   9   10   >