[jira] [Commented] (CALCITE-5956) Support parsing non-standard collection types

2023-08-26 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759225#comment-17759225 ] hongyu guo commented on CALCITE-5956: - Hi, [~julianhyde], thank you for your commen

[jira] [Commented] (CALCITE-5956) Support parsing non-standard collection types

2023-08-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759231#comment-17759231 ] Jiajun Xie commented on CALCITE-5956: - IMO: The core module supports too many parsi

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

2023-08-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759235#comment-17759235 ] Jiajun Xie commented on CALCITE-5944: - Would anyone please  review it?     > Add

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

2023-08-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759235#comment-17759235 ] Jiajun Xie edited comment on CALCITE-5944 at 8/26/23 10:34 AM: --

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in multi

[jira] [Updated] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5948: - Description: First, we need to reach a consensus to allow types of the same family to coexist in multi

[jira] [Commented] (CALCITE-5923) Some test cases in `SqlOperatorTest` violates the test fixture's design principle

2023-08-26 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759257#comment-17759257 ] Runkang He commented on CALCITE-5923: - [~julianhyde] Thanks for clarifying the esse

[jira] [Updated] (CALCITE-5957) Validate DATE '1945-2-2' is not accepted due to regression

2023-08-26 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5957: Description: DATE '1945-2-2' is a valid date. In CALCITE-5923 when we turn on the result check of

[jira] [Created] (CALCITE-5957) Validate DATE '1945-2-2' is not accepted due to regression

2023-08-26 Thread Runkang He (Jira)
Runkang He created CALCITE-5957: --- Summary: Validate DATE '1945-2-2' is not accepted due to regression Key: CALCITE-5957 URL: https://issues.apache.org/jira/browse/CALCITE-5957 Project: Calcite

[jira] [Updated] (CALCITE-5957) Valid DATE '1945-2-2' is not accepted due to regression

2023-08-26 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Runkang He updated CALCITE-5957: Summary: Valid DATE '1945-2-2' is not accepted due to regression (was: Validate DATE '1945-2-2'

[jira] [Commented] (CALCITE-5923) Some test cases in `SqlOperatorTest` violates the test fixture's design principle

2023-08-26 Thread Runkang He (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759259#comment-17759259 ] Runkang He commented on CALCITE-5923: - The new Jira is CALCITE-5957. > Some test c

[jira] [Resolved] (CALCITE-5914) Cache compiled regular expressions in SQL function runtime

2023-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5914. -- Fix Version/s: 1.36.0 Resolution: Fixed Fixed in [2a96512c|https://github.com/apache/

[jira] [Commented] (CALCITE-5914) Cache compiled regular expressions in SQL function runtime

2023-08-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759275#comment-17759275 ] Julian Hyde commented on CALCITE-5914: -- [~thomas.rebele], My change does not go as

[jira] [Assigned] (CALCITE-5940) Add the Rules to optimize Limit

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen reassigned CALCITE-5940: - Assignee: LakeShen > Add the Rules to optimize Limit > --- > >

[jira] [Commented] (CALCITE-4850) Wrong result retrieving from ARRAY with mixed INTEGER and DECIMAL elements

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759306#comment-17759306 ] Ran Tao commented on CALCITE-4850: -- calcite-5948 is parent issue of this. > Wrong res

[jira] [Commented] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759307#comment-17759307 ] Ran Tao commented on CALCITE-5948: -- calcite-4850 is a child issue of this. > Explicit

[jira] (CALCITE-5948) Explicit casting should be made if the type of an element in ARRAY/MAP not equals with the derived component type

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948 ] Ran Tao deleted comment on CALCITE-5948: -- was (Author: lemonjing): calcite-4850 is a child issue of this. > Explicit casting should be made if the type of an element in ARRAY/MAP not > equals

[jira] (CALCITE-4850) Wrong result retrieving from ARRAY with mixed INTEGER and DECIMAL elements

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4850 ] Ran Tao deleted comment on CALCITE-4850: -- was (Author: lemonjing): calcite-5948 is parent issue of this. > Wrong result retrieving from ARRAY with mixed INTEGER and DECIMAL elements >

[jira] [Created] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread LakeShen (Jira)
LakeShen created CALCITE-5958: - Summary: Make the value be nonReservedKeywords(consistent with Postgres) Key: CALCITE-5958 URL: https://issues.apache.org/jira/browse/CALCITE-5958 Project: Calcite

[jira] [Updated] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5958: -- Description: Now in the  > Make the value be nonReservedKeywords(consistent with Postgres) >

[jira] [Updated] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5958: -- Attachment: image-2023-08-27-12-33-24-000.png > Make the value be nonReservedKeywords(consistent with

[jira] [Updated] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5958: -- Attachment: image-2023-08-27-12-34-53-322.png > Make the value be nonReservedKeywords(consistent with

[jira] [Updated] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5958: -- Description: Now in the Postgres, value could be field alias,for example: {code:java} select 1 + 1 as

[jira] [Updated] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5958: -- Description: Now in the Postgres, value could be field alias,for example: {code:java} select 1 + 1 as

[jira] [Created] (CALCITE-5959) Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

2023-08-26 Thread LakeShen (Jira)
LakeShen created CALCITE-5959: - Summary: Cast(200 as boolean) should return true(consistent with Postgres and Mysql) Key: CALCITE-5959 URL: https://issues.apache.org/jira/browse/CALCITE-5959 Project: Calc

[jira] [Updated] (CALCITE-5959) Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5959: -- Description: For the sql : {code:java} select cast(200 as boolean)  {code} The  > Cast(200 as boolea

[jira] [Updated] (CALCITE-5959) Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5959: -- Description: For the sql : {code:java} select cast(200 as boolean)  {code} The Postgres and  was:

[jira] [Updated] (CALCITE-5959) Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5959: -- Description: For the sql : {code:java} select cast(200 as boolean)  {code} The result The Postgres an

[jira] [Updated] (CALCITE-5959) Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5959: -- Description: For the sql : {code:java} select cast(200 as boolean)  {code} The above results are true

[jira] [Updated] (CALCITE-5959) Cast(200 as boolean) should return true(consistent with Postgres and Mysql)

2023-08-26 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5959: -- Attachment: image-2023-08-27-12-56-11-390.png > Cast(200 as boolean) should return true(consistent wi

[jira] [Commented] (CALCITE-5958) Make the value be nonReservedKeywords(consistent with Postgres)

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17759320#comment-17759320 ] Ran Tao commented on CALCITE-5958: -- [~shenlang] hi Shen, FYI. value is sql reserved ke

[jira] [Created] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
Ran Tao created CALCITE-5960: Summary: Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE Key: CALCITE-5960 URL: https://issues.apache.org/jira/browse/CALCITE-5960

[jira] [Updated] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) Unexpected type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Description: current RexToLixTranslator#scaleIntervalToNumber will scale interval to number. but it th

[jira] [Updated] (CALCITE-5960) Inapplicable type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of NPE

2023-08-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5960: - Summary: Inapplicable type should pass through the RexToLixTranslator#scaleIntervalToNumber instead of