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

[ https://issues.apache.org/jira/browse/CALCITE-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reopened CALCITE-3658: - > TableModify of Update contains correlated variable by mistake. >

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

[ https://issues.apache.org/jira/browse/CALCITE-3658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17530643#comment-17530643 ] Jiajun Xie commented on CALCITE-3658: - This solution does not solve all the problems, such as the

[jira] [Updated] (CALCITE-5122) Update query with correlated throws AssertionError "field ordinal 0 out of range"

[ https://issues.apache.org/jira/browse/CALCITE-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5122: Summary: Update query with correlated throws AssertionError "field ordinal 0 out of range"

[jira] [Updated] (CALCITE-5122) Update query with correlated throws AssertionError "field ordinal out of range"

[ https://issues.apache.org/jira/browse/CALCITE-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5122: Summary: Update query with correlated throws AssertionError "field ordinal out of range" (was:

[jira] [Commented] (CALCITE-5122) failed to convert update relnode to sqlnode

[ https://issues.apache.org/jira/browse/CALCITE-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17530366#comment-17530366 ] Jiajun Xie commented on CALCITE-5122: - This problem is similar to it CALCITE-3658 Self join table

[jira] [Comment Edited] (CALCITE-5122) failed to convert update relnode to sqlnode

[ https://issues.apache.org/jira/browse/CALCITE-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17530366#comment-17530366 ] Jiajun Xie edited comment on CALCITE-5122 at 4/30/22 9:38 AM: -- This

[jira] [Assigned] (CALCITE-5122) failed to convert update relnode to sqlnode

[ https://issues.apache.org/jira/browse/CALCITE-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5122: --- Assignee: Jiajun Xie > failed to convert update relnode to sqlnode >

[jira] [Commented] (CALCITE-5119) SqlNode#unparse hides an alias table when using CTE

[ https://issues.apache.org/jira/browse/CALCITE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17529161#comment-17529161 ] Jiajun Xie commented on CALCITE-5119: - Parsed SqlNode need to be validated, because the CTE will be

[jira] [Assigned] (CALCITE-3557) ClassCastException for using nested multiset or array inside multiset

[ https://issues.apache.org/jira/browse/CALCITE-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-3557: --- Assignee: Jiajun Xie (was: Jiatao Tao) > ClassCastException for using nested multiset or

[jira] [Comment Edited] (CALCITE-5091) RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic

[ https://issues.apache.org/jira/browse/CALCITE-5091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17520872#comment-17520872 ] Jiajun Xie edited comment on CALCITE-5091 at 4/12/22 1:19 AM: -- I will

[jira] [Commented] (CALCITE-5091) RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic

[ https://issues.apache.org/jira/browse/CALCITE-5091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17520872#comment-17520872 ] Jiajun Xie commented on CALCITE-5091: - I will submit PR when this

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17520871#comment-17520871 ] Jiajun Xie commented on CALCITE-5048: - I revert *RelMdRowCount* and create a new Jira

[jira] [Updated] (CALCITE-5091) RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic

[ https://issues.apache.org/jira/browse/CALCITE-5091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5091: Description: The sql from https://issues.apache.org/jira/browse/CALCITE-5048 {code:java} select

[jira] [Created] (CALCITE-5091) RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic

Jiajun Xie created CALCITE-5091: --- Summary: RelMdRowCount can return more accurate rowCount when fetch is deterministic and offset is dynamic Key: CALCITE-5091 URL: https://issues.apache.org/jira/browse/CALCITE-5091

[jira] [Commented] (CALCITE-5088) Generated model should escape backslashes

[ https://issues.apache.org/jira/browse/CALCITE-5088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17519932#comment-17519932 ] Jiajun Xie commented on CALCITE-5088: - [~julianhyde]  I used your branch(5088-jsonBuilder-escape)

[jira] [Assigned] (CALCITE-4897) Set operation in DML, implicit type conversion is not complete

[ https://issues.apache.org/jira/browse/CALCITE-4897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-4897: --- Assignee: Jiajun Xie > Set operation in DML, implicit type conversion is not complete >

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17519920#comment-17519920 ] Jiajun Xie edited comment on CALCITE-5048 at 4/9/22 7:28 AM: - [~rubenql]  I

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17519920#comment-17519920 ] Jiajun Xie commented on CALCITE-5048: - [~rubenql]  I thought about your opinion carefully, found

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17517179#comment-17517179 ] Jiajun Xie edited comment on CALCITE-5048 at 4/5/22 2:06 AM: - The case that

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17517179#comment-17517179 ] Jiajun Xie edited comment on CALCITE-5048 at 4/5/22 2:04 AM: - The case that

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17517179#comment-17517179 ] Jiajun Xie edited comment on CALCITE-5048 at 4/5/22 2:03 AM: - The case that

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17517179#comment-17517179 ] Jiajun Xie edited comment on CALCITE-5048 at 4/5/22 2:02 AM: - The case that

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17517179#comment-17517179 ] Jiajun Xie commented on CALCITE-5048: - The case that in describe is failed because

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17509234#comment-17509234 ] Jiajun Xie edited comment on CALCITE-5048 at 4/4/22 9:05 AM: - Hi,

[jira] [Commented] (CALCITE-5013) JDBC adapter should retain parentheses if a query in a UNION has a LIMIT clause

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17514391#comment-17514391 ] Jiajun Xie commented on CALCITE-5013: - Thank you very much for your guidance. I was confused before

[jira] [Comment Edited] (CALCITE-5013) JDBC adapter should retain parentheses if a query in a UNION has a LIMIT clause

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513768#comment-17513768 ] Jiajun Xie edited comment on CALCITE-5013 at 3/29/22, 2:25 AM: --- Sorry, I

[jira] [Commented] (CALCITE-5013) JDBC adapter should retain parentheses if a query in a UNION has a LIMIT clause

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17513768#comment-17513768 ] Jiajun Xie commented on CALCITE-5013: - Sorry, I don't know. LIMIT is not a {*}SqlOperator{*}, it is

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

[ https://issues.apache.org/jira/browse/CALCITE-4926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17512860#comment-17512860 ] Jiajun Xie commented on CALCITE-4926: - If you only want to pass the validation phase, you can add a

[jira] [Commented] (CALCITE-5013) JDBC adapter should retain parentheses if a query in a UNION has a LIMIT clause

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17512653#comment-17512653 ] Jiajun Xie commented on CALCITE-5013: - [~julianhyde] Thanks for your reviewing, I added the test

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

[ https://issues.apache.org/jira/browse/CALCITE-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17509234#comment-17509234 ] Jiajun Xie commented on CALCITE-5048: - Hi, [~rubenql].  I found all the code that takes int value

[jira] [Commented] (CALCITE-5049) Error when executing join on Elasticsearch Adapter

[ https://issues.apache.org/jira/browse/CALCITE-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17509189#comment-17509189 ] Jiajun Xie commented on CALCITE-5049: - [~yamaga] Is the filed `ID_ART` text type? Field data is

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

[ https://issues.apache.org/jira/browse/CALCITE-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17509187#comment-17509187 ] Jiajun Xie commented on CALCITE-5051: - Perhaps related to this issue:

[jira] [Commented] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION ... LIMIT

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17501690#comment-17501690 ] Jiajun Xie commented on CALCITE-5013: - This is useful for RelToSql. When preparing merge, I will

[jira] [Resolved] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION ... LIMIT

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5013. - Resolution: Later > Unparse SqlSetOperator should be retained parentheses when generating SQL

[jira] [Reopened] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION ... LIMIT

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reopened CALCITE-5013: - > Unparse SqlSetOperator should be retained parentheses when generating SQL > for UNION ...

[jira] [Comment Edited] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION ... LIMIT

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17501085#comment-17501085 ] Jiajun Xie edited comment on CALCITE-5013 at 3/4/22, 12:02 AM: --- Hello,

[jira] [Commented] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION ... LIMIT

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17501085#comment-17501085 ] Jiajun Xie commented on CALCITE-5013: - Hello, [~julianhyde]. Would you review this pr again?

[jira] [Updated] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION ... LIMIT

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5013: Summary: Unparse SqlSetOperator should be retained parentheses when generating SQL for UNION

[jira] (CALCITE-5015) typo in PartiallyOrderedSet

[ https://issues.apache.org/jira/browse/CALCITE-5015 ] Jiajun Xie deleted comment on CALCITE-5015: - was (Author: jiajunbernoulli): [~Innovimax] This seems to be the same problem as

[jira] [Commented] (CALCITE-5010) Modify RexBuilder to use convertlets to transform the RexCall when possible

[ https://issues.apache.org/jira/browse/CALCITE-5010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17495812#comment-17495812 ] Jiajun Xie commented on CALCITE-5010: - [~tdsilva] I understand your purpose and solution. It is not

[jira] [Commented] (CALCITE-5015) typo in PartiallyOrderedSet

[ https://issues.apache.org/jira/browse/CALCITE-5015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17495536#comment-17495536 ] Jiajun Xie commented on CALCITE-5015: - [~Innovimax] This seems to be the same problem as

[jira] [Commented] (CALCITE-3557) ClassCastException for using nested multiset or array inside multiset

[ https://issues.apache.org/jira/browse/CALCITE-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17495088#comment-17495088 ] Jiajun Xie commented on CALCITE-3557: - Hello, [~yanlin-Lynn].  Would you please review this

[jira] [Updated] (CALCITE-5013) Unparse SqlSetOperator should be retained parentheses when the operand has limit or offset

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5013: Summary: Unparse SqlSetOperator should be retained parentheses when the operand has limit or

[jira] [Updated] (CALCITE-5013) Parentheses should be retained when the operand of SetOp has limit or offset

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5013: Description: - In standard SQL, the operand of union should not have limit  or order by.So

[jira] [Commented] (CALCITE-5013) Parentheses should be retained when the operand of SetOp has limit or offset

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494955#comment-17494955 ] Jiajun Xie commented on CALCITE-5013: - Here is the pr:https://github.com/apache/calcite/pull/2724

[jira] [Commented] (CALCITE-1892) Relbuilder .union(...) should use parentheses after .sortLimit(...) is called

[ https://issues.apache.org/jira/browse/CALCITE-1892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494953#comment-17494953 ] Jiajun Xie commented on CALCITE-1892: - [~julianhyde] I agree that RelBuilder is doing its job

[jira] [Updated] (CALCITE-5013) Parentheses should be retained when the operand of SetOp has limit or offset

[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5013: Summary: Parentheses should be retained when the operand of SetOp has limit or offset (was:

[jira] [Created] (CALCITE-5013) Parentheses should be reserved when the operand of SetOp has limit or offset

Jiajun Xie created CALCITE-5013: --- Summary: Parentheses should be reserved when the operand of SetOp has limit or offset Key: CALCITE-5013 URL: https://issues.apache.org/jira/browse/CALCITE-5013

[jira] [Comment Edited] (CALCITE-4323) View with ORDER BY throws AssertionError during view expansion

[ https://issues.apache.org/jira/browse/CALCITE-4323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17492965#comment-17492965 ] Jiajun Xie edited comment on CALCITE-4323 at 2/16/22, 2:37 AM: ---

[jira] [Commented] (CALCITE-4323) View with ORDER BY throws AssertionError during view expansion

[ https://issues.apache.org/jira/browse/CALCITE-4323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17492965#comment-17492965 ] Jiajun Xie commented on CALCITE-4323: - [~julianhyde] Sorry, I thought there must be a limit if

<    1   2   3   4   5   6