[jira] [Resolved] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5277. Resolution: Fixed Done in

[jira] [Updated] (CALCITE-4887) Filter subQuery remove not fully optimized

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4887: --- Fix Version/s: (was: 1.32.0) > Filter subQuery remove not fully optimized >

[jira] [Commented] (CALCITE-4887) Filter subQuery remove not fully optimized

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17601935#comment-17601935 ] Ruben Q L commented on CALCITE-4887: It seems there has been no activity on this ticket for months,

[jira] [Updated] (CALCITE-5052) Calcite testkit issue loading resources from jar in DiffRepository (bazel)

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5052: --- Priority: Major (was: Blocker) > Calcite testkit issue loading resources from jar in

[jira] [Updated] (CALCITE-5052) Calcite testkit issue loading resources from jar in DiffRepository (bazel)

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5052: --- Fix Version/s: (was: 1.32.0) > Calcite testkit issue loading resources from jar in

[jira] [Commented] (CALCITE-5052) Calcite testkit issue loading resources from jar in DiffRepository (bazel)

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17601928#comment-17601928 ] Ruben Q L commented on CALCITE-5052: It seems there has been no activity for months on this ticket.

[jira] [Updated] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5277: --- Description: Currently, EnumerableRelImplementor stashedParameters is a map with no deterministic

[jira] [Updated] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5277: --- Description: Currently, EnumerableRelImplementor stashedParameters is a map with no deterministic

[jira] [Updated] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5277: --- Priority: Major (was: Minor) > Make EnumerableRelImplementor stashedParameters order

[jira] [Updated] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5277: --- Description: Currently, EnumerableRelImplementor stashedParameters is a map with no deterministic

[jira] [Assigned] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5277: -- Assignee: Ruben Q L > Make EnumerableRelImplementor stashedParameters order deterministic

[jira] [Created] (CALCITE-5277) Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate

2022-09-08 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5277: -- Summary: Make EnumerableRelImplementor stashedParameters order deterministic to increase BINDABLE_CACHE hit rate Key: CALCITE-5277 URL:

[jira] [Commented] (CALCITE-5274) Improve DocumentBuilderFactory in DiffRepository test class by using secure features

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17601721#comment-17601721 ] Ruben Q L commented on CALCITE-5274: Thanks for creating the ticket [~pj.fanning]. I have created a

[jira] [Updated] (CALCITE-5274) Improve DocumentBuilderFactory in DiffRepository test class by using secure features

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5274: --- Summary: Improve DocumentBuilderFactory in DiffRepository test class by using secure features

[jira] [Updated] (CALCITE-5274) prevent XXE possibilities in DiffRepository (calcite testkit)

2022-09-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5274: --- Priority: Minor (was: Major) > prevent XXE possibilities in DiffRepository (calcite testkit) >

[jira] [Resolved] (CALCITE-5263) Improve XmlFunctions by using an XML DocumentBuilder

2022-09-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5263. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5274) prevent XXE possibilities in DiffRepository (calcite testkit)

2022-09-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5274: --- Fix Version/s: 1.32.0 > prevent XXE possibilities in DiffRepository (calcite testkit) >

[jira] [Assigned] (CALCITE-5274) prevent XXE possibilities in DiffRepository (calcite testkit)

2022-09-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5274: -- Assignee: Ruben Q L > prevent XXE possibilities in DiffRepository (calcite testkit) >

[jira] [Created] (CALCITE-5263) Improve XmlFunctions by using an XML DocumentBuilder

2022-09-03 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5263: -- Summary: Improve XmlFunctions by using an XML DocumentBuilder Key: CALCITE-5263 URL: https://issues.apache.org/jira/browse/CALCITE-5263 Project: Calcite Issue

[jira] [Resolved] (CALCITE-4999) ARRAY, MULTISET functions should return a collection of scalars if a sub-query returns 1 column

2022-08-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4999. Fix Version/s: 1.32.0 Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5251) Support SQL hint for Snapshot

2022-08-30 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17597590#comment-17597590 ] Ruben Q L commented on CALCITE-5251: bq. BTW, more and more RelNodes implement {{Hintable}} we may

[jira] [Commented] (CALCITE-5251) Support SQL hint for Snapshot

2022-08-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17597140#comment-17597140 ] Ruben Q L commented on CALCITE-5251: I haven't looked at the PR, but please bear in mind that the

[jira] [Commented] (CALCITE-4999) ARRAY, MULTISET functions should return a collection of scalars if a sub-query returns 1 column

2022-08-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17597045#comment-17597045 ] Ruben Q L commented on CALCITE-4999: [~dmsysolyatin] unfortunately this option is not enabled for

[jira] [Commented] (CALCITE-4999) ARRAY, MULTISET functions should return a collection of scalars if a sub-query returns 1 column

2022-08-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584713#comment-17584713 ] Ruben Q L commented on CALCITE-4999: Thanks for the clarification [~dmsysolyatin]. I think the PR

[jira] [Commented] (CALCITE-4999) ARRAY, MULTISET functions should return a collection of scalars if a sub-query returns 1 column

2022-08-24 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584285#comment-17584285 ] Ruben Q L commented on CALCITE-4999: [~dmsysolyatin] don't we need some adjustments on the PR, now

[jira] [Commented] (CALCITE-4999) ARRAY, MULTISET functions should return a collection of scalars if a sub-query returns 1 column

2022-08-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17578922#comment-17578922 ] Ruben Q L commented on CALCITE-4999: Thanks for pushing this forward [~dmsysolyatin]. If my

[jira] [Created] (CALCITE-5221) Upgrade Calcite to Avatica 1.22

2022-07-28 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5221: -- Summary: Upgrade Calcite to Avatica 1.22 Key: CALCITE-5221 URL: https://issues.apache.org/jira/browse/CALCITE-5221 Project: Calcite Issue Type: Task

[jira] [Commented] (CALCITE-5218) Verify HTTP client class before instantiating it

2022-07-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17572288#comment-17572288 ] Ruben Q L commented on CALCITE-5218: CVE-2022-36364: Apache Calcite Avatica JDBC driver

[jira] [Resolved] (CALCITE-5218) Verify HTTP client class before instantiating it

2022-07-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5218. Resolution: Fixed Fixed via

[jira] [Assigned] (CALCITE-5218) Verify HTTP client class before instantiating it

2022-07-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5218: -- Assignee: Ruben Q L > Verify HTTP client class before instantiating it >

[jira] [Updated] (CALCITE-5218) Verify HTTP client class before instantiating it

2022-07-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5218: --- Description: Verify HTTP client class before instantiating it (was: tbd) > Verify HTTP client

[jira] [Updated] (CALCITE-5218) Verify HTTP client class before instantiating it

2022-07-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5218: --- Summary: Verify HTTP client class before instantiating it (was: WIP) > Verify HTTP client class

[jira] [Created] (CALCITE-5218) WIP

2022-07-23 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5218: -- Summary: WIP Key: CALCITE-5218 URL: https://issues.apache.org/jira/browse/CALCITE-5218 Project: Calcite Issue Type: Bug Components: avatica

[jira] [Closed] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2022-07-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L closed CALCITE-2223. -- Resolution: Fixed Closing this bug since the problem has been solved as a side effect of other

[jira] [Commented] (CALCITE-5194) Cannot parse parenthesized UNION in subquery

2022-07-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17565869#comment-17565869 ] Ruben Q L commented on CALCITE-5194: Sorry, I'm a bit late to the party, I confirm my tests run

[jira] [Resolved] (CALCITE-5045) Alias within GroupingSets throws type mis-match exception

2022-06-28 Thread Ruben Q L (Jira)
Title: Message Title Ruben Q L resolved

[jira] [Resolved] (CALCITE-5145) CASE statement within GROUPING SETS throws type mis-match exception

2022-06-28 Thread Ruben Q L (Jira)
Title: Message Title Ruben Q L resolved

[jira] [Updated] (CALCITE-5145) CASE statement within GROUPING SETS throws type mis-match exception

2022-06-28 Thread Ruben Q L (Jira)
Title: Message Title Ruben Q L updated an

[jira] [Resolved] (CALCITE-4897) Implicit type conversion is not complete for set operation in DML

2022-06-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4897. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-4897) Implicit type conversion is not complete for set operation in DML

2022-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4897: --- Fix Version/s: 1.31.0 > Implicit type conversion is not complete for set operation in DML >

[jira] [Updated] (CALCITE-4897) Implicit type conversion is not complete for set operation in DML

2022-06-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4897: --- Summary: Implicit type conversion is not complete for set operation in DML (was: Set operation in

[jira] [Commented] (CALCITE-5126) Implicit column alias for single-column UNNEST should work with any single-column UNNEST’s input

2022-06-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17555745#comment-17555745 ] Ruben Q L commented on CALCITE-5126: bq. But for some reason a restriction was added that

[jira] [Commented] (CALCITE-5126) Implicit column alias for single-column UNNEST should work with any single-column UNNEST’s input

2022-06-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17555614#comment-17555614 ] Ruben Q L commented on CALCITE-5126: [~dmsysolyatin] the problem that you are tying to fix seems to

[jira] [Updated] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-06-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5060: --- Fix Version/s: (was: 1.31.0) > SqlTypeUtil#canAssignFrom cover Map/Row/Multiset >

[jira] [Commented] (CALCITE-5127) Error when executing query with subquery in select list that uses outer column of array type

2022-06-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1787#comment-1787 ] Ruben Q L commented on CALCITE-5127: Given the latest discussions (see comments above), I have

[jira] [Updated] (CALCITE-5127) Error when executing query with subquery in select list that uses outer column of array type

2022-06-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5127: --- Fix Version/s: (was: 1.31.0) > Error when executing query with subquery in select list that

[jira] [Resolved] (CALCITE-5134) Queries with subquery inside select list does not work if subquery uses table from left join

2022-06-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5134. Resolution: Fixed Fixed via

[jira] [Resolved] (CALCITE-5177) Query loses hint after decorrelation

2022-06-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5177. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5188) Review (and improve?) hints

2022-06-10 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5188: --- Description: Hints were initially implemented via CALCITE-482, and later enlarged via

[jira] [Commented] (CALCITE-5177) Query loses hint after decorrelation

2022-06-10 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17552663#comment-17552663 ] Ruben Q L commented on CALCITE-5177: Created follow-up ticket: CALCITE-5188 > Query loses hint

[jira] [Created] (CALCITE-5188) Review (and improve?) hints

2022-06-10 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5188: -- Summary: Review (and improve?) hints Key: CALCITE-5188 URL: https://issues.apache.org/jira/browse/CALCITE-5188 Project: Calcite Issue Type: Task

[jira] [Commented] (CALCITE-3636) Support Hint for Sort

2022-06-10 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17552651#comment-17552651 ] Ruben Q L commented on CALCITE-3636: Is this ticket covered by CALCITE-5107? Shall we close it? >

[jira] [Resolved] (CALCITE-5051) UNION query plan prevents projection push down

2022-06-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5051. Fix Version/s: 1.31.0 Resolution: Fixed Fixed as a side effect of CALCITE-5061 > UNION

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-06-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17551638#comment-17551638 ] Ruben Q L commented on CALCITE-5051: [~gramana] I have verified the unit test in

[jira] [Comment Edited] (CALCITE-5177) Query loses hint after decorrelation

2022-06-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17550215#comment-17550215 ] Ruben Q L edited comment on CALCITE-5177 at 6/8/22 8:26 AM: [~julianhyde] I

[jira] [Updated] (CALCITE-5177) Query loses hint after decorrelation

2022-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5177: --- Labels: pull-request-available (was: ) > Query loses hint after decorrelation >

[jira] [Commented] (CALCITE-5177) Query loses hint after decorrelation

2022-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17550914#comment-17550914 ] Ruben Q L commented on CALCITE-5177: Created [PR|https://github.com/apache/calcite/pull/2829] with

[jira] [Assigned] (CALCITE-5177) Query loses hint after decorrelation

2022-06-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5177: -- Assignee: Ruben Q L > Query loses hint after decorrelation >

[jira] [Commented] (CALCITE-5177) Query loses hint after decorrelation

2022-06-05 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17550215#comment-17550215 ] Ruben Q L commented on CALCITE-5177: [~julianhyde] I totally agree with you. There are a few

[jira] [Commented] (CALCITE-3658) TableModify of Update contains correlated variable by mistake.

2022-06-05 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17550206#comment-17550206 ] Ruben Q L commented on CALCITE-3658: [~jiajunbernoulli] I will take a look at CALCITE-5122's PR,

[jira] [Commented] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17545515#comment-17545515 ] Ruben Q L commented on CALCITE-5177: Problem can be reproduced on Calcite master in

[jira] [Commented] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17545337#comment-17545337 ] Ruben Q L commented on CALCITE-5177: fyi [~danny0405], [~godfreyhe] > Query loses hint after

[jira] [Updated] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5177: --- Description: This seems to be a regression caused by CALCITE-5107, which enlarged the list of

[jira] [Updated] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5177: --- Description: This seems to be a regression caused by CALCITE-5107, which enlarged the list of

[jira] [Updated] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5177: --- Description: This seems to be a regression caused by CALCITE-5107, which enlarged the list of

[jira] [Created] (CALCITE-5177) Query loses hint after decorrelation

2022-06-02 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-5177: -- Summary: Query loses hint after decorrelation Key: CALCITE-5177 URL: https://issues.apache.org/jira/browse/CALCITE-5177 Project: Calcite Issue Type: Bug

[jira] [Comment Edited] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17538687#comment-17538687 ] Ruben Q L edited comment on CALCITE-5073 at 5/18/22 9:34 AM: - Sorry, I will

[jira] [Comment Edited] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17538687#comment-17538687 ] Ruben Q L edited comment on CALCITE-5073 at 5/18/22 9:34 AM: - Sorry, I will

[jira] [Commented] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17538687#comment-17538687 ] Ruben Q L commented on CALCITE-5073: Sorry, I will be a bit busy this and next weeks, I will not

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17538682#comment-17538682 ] Ruben Q L commented on CALCITE-5051: [~gramana], I have just merged CALCITE-5061 into master, could

[jira] [Resolved] (CALCITE-5061) Improve recursive application of the field trimming

2022-05-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5061. Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5073) JoinConditionPushRule cannot infer 'LHS.C1 = LHS.C2' from 'LHS.C1 = RHS.C1 AND LHS.C2 = RHS.C1'

2022-05-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17537568#comment-17537568 ] Ruben Q L commented on CALCITE-5073: [~libenchao], [~nobigo] any updates here? It seems the

[jira] [Updated] (CALCITE-5061) Improve recursive application of the field trimming

2022-05-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5061: --- Fix Version/s: 1.31.0 > Improve recursive application of the field trimming >

[jira] [Commented] (CALCITE-5061) Improve recursive application of the field trimming

2022-05-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17536762#comment-17536762 ] Ruben Q L commented on CALCITE-5061: Created [PR|https://github.com/apache/calcite/pull/2806] with

[jira] [Commented] (CALCITE-5051) UNION query plan prevents projection push down

2022-05-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17536726#comment-17536726 ] Ruben Q L commented on CALCITE-5051: [~gramana] , I have created a

[jira] [Commented] (CALCITE-5061) Improve recursive application of the field trimming

2022-05-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17536548#comment-17536548 ] Ruben Q L commented on CALCITE-5061: [~thomas.rebele], I think [~julianhyde] has a point when he

[jira] [Commented] (CALCITE-5135) Planner#parse can't parse DAY() function

2022-05-06 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532895#comment-17532895 ] Ruben Q L commented on CALCITE-5135: According to Calcite documentation:

[jira] [Resolved] (CALCITE-5003) MergeUnion on types with different collators produces wrong result

2022-05-05 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5003. Resolution: Fixed Fixed via

[jira] [Closed] (CALCITE-3658) TableModify of Update contains correlated variable by mistake.

2022-05-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L closed CALCITE-3658. -- > TableModify of Update contains correlated variable by mistake. >

[jira] [Commented] (CALCITE-3658) TableModify of Update contains correlated variable by mistake.

2022-05-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17530669#comment-17530669 ] Ruben Q L commented on CALCITE-3658: Thanks for update [~jiajunbernoulli]. I have linked the new

[jira] [Comment Edited] (CALCITE-4999) ARRAY function should return an array of scalars if subquery returns 1 column

2022-04-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529889#comment-17529889 ] Ruben Q L edited comment on CALCITE-4999 at 4/29/22 10:22 AM: -- {quote}Is

[jira] [Commented] (CALCITE-4999) ARRAY function should return an array of scalars if subquery returns 1 column

2022-04-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529889#comment-17529889 ] Ruben Q L commented on CALCITE-4999: {quote}Is it necessary to change SqlTypeName to SqlKind in the

[jira] [Updated] (CALCITE-5003) MergeUnion on types with different collators produces wrong result

2022-04-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5003: --- Fix Version/s: 1.31.0 > MergeUnion on types with different collators produces wrong result >

[jira] [Assigned] (CALCITE-5003) MergeUnion on types with different collators produces wrong result

2022-04-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-5003: -- Assignee: Ruben Q L > MergeUnion on types with different collators produces wrong result >

[jira] [Commented] (CALCITE-5123) Calcite errors on columns starting with a digit

2022-04-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529294#comment-17529294 ] Ruben Q L commented on CALCITE-5123: Correct, quoted identifiers do support starting with a digit

[jira] [Commented] (CALCITE-5123) Calcite errors on columns starting with a digit

2022-04-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529279#comment-17529279 ] Ruben Q L commented on CALCITE-5123: [~lfdversluis], there was a discussion about this topic on the

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528776#comment-17528776 ] Ruben Q L commented on CALCITE-5113: Sounds good, [~libenchao]. Please open a separate ticket to

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') returns a different number than mysql

2022-04-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528602#comment-17528602 ] Ruben Q L commented on CALCITE-5113: Thanks for the confirmation [~itxiangkui]. Regarding your last

[jira] [Commented] (CALCITE-5113) function week(date 'xxx') return an error number

2022-04-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17528063#comment-17528063 ] Ruben Q L commented on CALCITE-5113: [~itxiangkui], if I understand your description, you are

[jira] [Commented] (CALCITE-4999) ARRAY function should return an array of scalars if subquery returns 1 column

2022-04-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17527578#comment-17527578 ] Ruben Q L commented on CALCITE-4999: bq. I have removed whitespace changes from

[jira] [Resolved] (CALCITE-5048) Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

2022-04-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5048. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-5048) Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

2022-04-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-5048: --- Fix Version/s: 1.31.0 > Query with parameterized LIMIT and correlated sub-query throws

[jira] [Commented] (CALCITE-5048) Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

2022-04-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17520410#comment-17520410 ] Ruben Q L commented on CALCITE-5048: Personally, I would refrain from touching {{RelMdRowCount}}

[jira] [Commented] (CALCITE-5048) Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

2022-04-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17518691#comment-17518691 ] Ruben Q L commented on CALCITE-5048: Thanks for the PR [~jiajunbernoulli]. I have some doubts about

[jira] [Resolved] (CALCITE-5079) Update tutorial code demo.

2022-04-07 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5079. Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-5060) SqlTypeUtil#canAssignFrom cover Map/Row/Multiset

2022-04-04 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17516818#comment-17516818 ] Ruben Q L commented on CALCITE-5060: [~lam167], as Julian has already mentioned, we need more than

[jira] [Comment Edited] (CALCITE-5048) Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

2022-04-04 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17516709#comment-17516709 ] Ruben Q L edited comment on CALCITE-5048 at 4/4/22 9:24 AM: Hello

[jira] [Commented] (CALCITE-5048) Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"

2022-04-04 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17516709#comment-17516709 ] Ruben Q L commented on CALCITE-5048: Hello [~jiajunbernoulli], for some reason, I cannot assign the

[jira] [Commented] (CALCITE-5078) ORDER BY gets confused by upper/lower case

2022-04-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17515898#comment-17515898 ] Ruben Q L commented on CALCITE-5078: [~mamo], as others have mentioned, this is the expected

[jira] [Resolved] (CALCITE-5075) Build fails due to rat check on Gemfile.lock

2022-03-31 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5075. Resolution: Fixed Done via

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