[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] [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-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-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] [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] [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-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] [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] [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] [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

[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] (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] [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] [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] [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] [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-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-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-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] [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] [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=17517179#comment-17517179 ] Jiajun Xie edited comment on CALCITE-5048 at 4/5/22 2:02 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-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] [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] [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] [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] [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] [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] [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-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] [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-5985) FilterTableFunctionTransposeRule should not use "Logical" RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763397#comment-17763397 ] Jiajun Xie edited comment on CALCITE-5985 at 9/10/23 7:10 AM: -- I can't

[jira] [Comment Edited] (CALCITE-5985) FilterTableFunctionTransposeRule should not use "Logical" RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763397#comment-17763397 ] Jiajun Xie edited comment on CALCITE-5985 at 9/10/23 7:12 AM: -- I can't

[jira] [Commented] (CALCITE-5985) FilterTableFunctionTransposeRule should not use "Logical" RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763397#comment-17763397 ] Jiajun Xie commented on CALCITE-5985: - I can't find any unit tests for

[jira] [Comment Edited] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765921#comment-17765921 ] Jiajun Xie edited comment on CALCITE-6007 at 9/16/23 7:51 AM: --

[jira] [Comment Edited] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765921#comment-17765921 ] Jiajun Xie edited comment on CALCITE-6007 at 9/16/23 7:50 AM: --

[jira] [Commented] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765921#comment-17765921 ] Jiajun Xie commented on CALCITE-6007: - [~wenruimeng] , Maybe `CTE` or `With  clause` will be better

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

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765897#comment-17765897 ] Jiajun Xie commented on CALCITE-5570: - [~Sergey Nuyanzin] , Do you have any suggestions? I plan to

[jira] [Commented] (CALCITE-5523) RelToSql converter generates GROUP BY clause with window expression

[ https://issues.apache.org/jira/browse/CALCITE-5523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766053#comment-17766053 ] Jiajun Xie commented on CALCITE-5523: - [~lchistov1987] , Oracle support it.   {code:java} //

[jira] [Comment Edited] (CALCITE-5523) RelToSql converter generates GROUP BY clause with window expression

[ https://issues.apache.org/jira/browse/CALCITE-5523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766053#comment-17766053 ] Jiajun Xie edited comment on CALCITE-5523 at 9/17/23 8:14 AM: --

[jira] [Commented] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763395#comment-17763395 ] Jiajun Xie commented on CALCITE-5931: - Fixed in

[jira] [Resolved] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5931. - Resolution: Fixed > Allow integers like 1.00 in window frame >

[jira] [Resolved] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5944. - Fix Version/s: 1.36.0 Resolution: Fixed > Add metadata for Sample >

[jira] [Commented] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17762924#comment-17762924 ] Jiajun Xie commented on CALCITE-5944: - Fixed in

[jira] [Commented] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763309#comment-17763309 ] Jiajun Xie commented on CALCITE-5931: - [~cbrisson] , Your PR is already dirty because force-pushed

[jira] [Commented] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17760668#comment-17760668 ] Jiajun Xie commented on CALCITE-5931: - [~cbrisson] , You can add a test to `winagg.iq`. e.g.

[jira] [Resolved] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5836. - Fix Version/s: 1.36.0 Resolution: Fixed > Implement Rel2Sql for MERGE >

[jira] [Commented] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765417#comment-17765417 ] Jiajun Xie commented on CALCITE-5836: - Fixed in

[jira] [Commented] (CALCITE-6049) Exception when using division with dynamic param

[ https://issues.apache.org/jira/browse/CALCITE-6049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17774885#comment-17774885 ] Jiajun Xie commented on CALCITE-6049: - - Before 1.22, here is the validate SqlNode for 

[jira] [Resolved] (CALCITE-5825) Add URL_ENCODE and URL_DECODE function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5825. - Resolution: Fixed > Add URL_ENCODE and URL_DECODE function (enabled in Spark library) >

[jira] [Commented] (CALCITE-5825) Add URL_ENCODE and URL_DECODE function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17780310#comment-17780310 ] Jiajun Xie commented on CALCITE-5825: - Fixed in

[jira] [Commented] (CALCITE-5826) Add FIND_IN_SET function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5826?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17781596#comment-17781596 ] Jiajun Xie commented on CALCITE-5826: - Fixed in

[jira] [Resolved] (CALCITE-5826) Add FIND_IN_SET function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5826. - Resolution: Fixed > Add FIND_IN_SET function (enabled in Hive and Spark library) >

[jira] [Created] (CALCITE-6091) Char that in array is truncated in CASE WHEN statement

Jiajun Xie created CALCITE-6091: --- Summary: Char that in array is truncated in CASE WHEN statement Key: CALCITE-6091 URL: https://issues.apache.org/jira/browse/CALCITE-6091 Project: Calcite

[jira] [Updated] (CALCITE-6091) Char that in array is truncated in CASE WHEN statement

[ https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6091: Affects Version/s: (was: 1.34.0) (was: 1.35.0)

[jira] [Updated] (CALCITE-6091) Char that in array or map is truncated in CASE WHEN statement

[ https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6091: Description: {code:java} select case when true then array('abc') when false then

[jira] [Updated] (CALCITE-6091) Char that in array is truncated in CASE WHEN statement

[ https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6091: Description: {code:java} select case when true then array('abc') when false then

[jira] [Updated] (CALCITE-6093) Unstable unit tes in Druid tests

[ https://issues.apache.org/jira/browse/CALCITE-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6093: Description: FAILURE 38.6sec, 235 completed, 1 failed, 6 skipped,

[jira] [Updated] (CALCITE-6093) Unstable unit test in Druid tests

[ https://issues.apache.org/jira/browse/CALCITE-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6093: Summary: Unstable unit test in Druid tests (was: Unstable unit tes in Druid tests) > Unstable

[jira] [Updated] (CALCITE-6091) Char that in array or map is truncated in CASE WHEN statement

[ https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6091: Description: {code:java} select case when true then array('abc') when false then

[jira] [Updated] (CALCITE-6091) Char that in array or map is truncated if CASE WHEN statement contains null

[ https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-6091: Summary: Char that in array or map is truncated if CASE WHEN statement contains null (was: Char

[jira] [Created] (CALCITE-6093) Unstable unit tes in Druid tests

Jiajun Xie created CALCITE-6093: --- Summary: Unstable unit tes in Druid tests Key: CALCITE-6093 URL: https://issues.apache.org/jira/browse/CALCITE-6093 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6091) Char that in array or map is truncated in CASE WHEN statement

[ https://issues.apache.org/jira/browse/CALCITE-6091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17782824#comment-17782824 ] Jiajun Xie commented on CALCITE-6091: - In fact, the issue has been resolved by

[jira] [Commented] (CALCITE-6088) SqlItemOperator fails in RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-6088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17782967#comment-17782967 ] Jiajun Xie commented on CALCITE-6088: - Fixed in

[jira] [Resolved] (CALCITE-6088) SqlItemOperator fails in RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-6088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6088. - Fix Version/s: 1.36.0 Resolution: Fixed > SqlItemOperator fails in RelToSqlConverter >

[jira] [Commented] (CALCITE-6037) The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT_XML/EXISTSNODE is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17780786#comment-17780786 ] Jiajun Xie commented on CALCITE-6037: - Fixed in

[jira] [Resolved] (CALCITE-6037) The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT_XML/EXISTSNODE is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6037. - Resolution: Fixed > The function category of >

[jira] [Assigned] (CALCITE-6088) SqlItemOperator fails in RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-6088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-6088: --- Assignee: Jiajun Xie > SqlItemOperator fails in RelToSqlConverter >

[jira] [Commented] (CALCITE-6022) Support "CREATE TABLE ... LIKE" DDL in server module

[ https://issues.apache.org/jira/browse/CALCITE-6022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17776968#comment-17776968 ] Jiajun Xie commented on CALCITE-6022: - Fixed in

[jira] [Resolved] (CALCITE-6022) Support "CREATE TABLE ... LIKE" DDL in server module

[ https://issues.apache.org/jira/browse/CALCITE-6022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6022. - Resolution: Fixed > Support "CREATE TABLE ... LIKE" DDL in server module >

[jira] [Commented] (CALCITE-5997) OFFSET operator is incorrectly unparsed

[ https://issues.apache.org/jira/browse/CALCITE-5997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766961#comment-17766961 ] Jiajun Xie commented on CALCITE-5997: - Fixed in

[jira] [Resolved] (CALCITE-5997) OFFSET operator is incorrectly unparsed

[ https://issues.apache.org/jira/browse/CALCITE-5997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5997. - Fix Version/s: 1.36.0 Assignee: Mihai Budiu Resolution: Fixed > OFFSET

[jira] [Commented] (CALCITE-6009) Add optimization to remove redundant Limit when its input's row number is less or equal to Limit's fetch

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770829#comment-17770829 ] Jiajun Xie commented on CALCITE-6009: - The PR looks good to me. Just a small suggestion: `Add

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

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770817#comment-17770817 ] Jiajun Xie commented on CALCITE-5570: - Fixed in

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

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5570. - Fix Version/s: 1.36.0 Resolution: Fixed > Support nested map type for SqlDataTypeSpec >

[jira] [Commented] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770990#comment-17770990 ] Jiajun Xie commented on CALCITE-4455: - Would anyone review it?

[jira] [Commented] (CALCITE-6022) Support "CREATE TABLE ... LIKE" DDL

[ https://issues.apache.org/jira/browse/CALCITE-6022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770985#comment-17770985 ] Jiajun Xie commented on CALCITE-6022: - Should we add `server module` in Jira summary? e.g. Support

[jira] [Resolved] (CALCITE-5940) Add the Rule to merge Limit

[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5940. - Resolution: Fixed > Add the Rule to merge Limit > --- > >

[jira] [Commented] (CALCITE-5940) Add the Rule to merge Limit

[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17769535#comment-17769535 ] Jiajun Xie commented on CALCITE-5940: - Fixed in

[jira] [Commented] (CALCITE-5940) Add the Rule to optimize Limit

[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17769394#comment-17769394 ] Jiajun Xie commented on CALCITE-5940: - I will merge the PR, but I think that we can use a more

[jira] [Resolved] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6009. - Resolution: Fixed > Add optimization to remove redundant LIMIT that is more than input row

[jira] [Commented] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17771377#comment-17771377 ] Jiajun Xie commented on CALCITE-6009: - Fixed in

[jira] [Comment Edited] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17771377#comment-17771377 ] Jiajun Xie edited comment on CALCITE-6009 at 10/3/23 8:25 AM: -- Fixed in

[jira] [Commented] (CALCITE-5999) DECIMAL literals are sometimes unparsed looking as DOUBLE literals

[ https://issues.apache.org/jira/browse/CALCITE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766621#comment-17766621 ] Jiajun Xie commented on CALCITE-5999: - Fixed in

[jira] [Resolved] (CALCITE-5999) DECIMAL literals are sometimes unparsed looking as DOUBLE literals

[ https://issues.apache.org/jira/browse/CALCITE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5999. - Fix Version/s: 1.36.0 Assignee: Mihai Budiu Resolution: Fixed > DECIMAL

[jira] [Commented] (CALCITE-5962) Support parse Spark-style syntax "LEFT ANTI JOIN" in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770006#comment-17770006 ] Jiajun Xie commented on CALCITE-5962: - Fixed in

[jira] [Resolved] (CALCITE-5962) Support parse Spark-style syntax "LEFT ANTI JOIN" in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5962. - Resolution: Fixed > Support parse Spark-style syntax "LEFT ANTI JOIN" in Babel parser >

[jira] [Commented] (CALCITE-6006) RelToSqlConverter loses charset information

[ https://issues.apache.org/jira/browse/CALCITE-6006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17774757#comment-17774757 ] Jiajun Xie commented on CALCITE-6006: - Fixed in

[jira] [Resolved] (CALCITE-6006) RelToSqlConverter loses charset information

[ https://issues.apache.org/jira/browse/CALCITE-6006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6006. - Resolution: Fixed > RelToSqlConverter loses charset information >

  1   2   3   4   5   6   >