[jira] [Commented] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-15 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17874087#comment-17874087 ] EveyWu commented on CALCITE-6521: -- [~julianhyde]Thank you for your suggestion, I'll e

[jira] [Commented] (CALCITE-6242) The "exists" library function throws a "param not found" error when a column is used in lambda evaluation logic.

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872181#comment-17872181 ] EveyWu commented on CALCITE-6242: -- [~hongyuguo] Hi~ if you don't mind, I would like t

[jira] [Comment Edited] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872166#comment-17872166 ] EveyWu edited comment on CALCITE-6521 at 8/9/24 1:30 AM: -- [~j

[jira] [Commented] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872166#comment-17872166 ] EveyWu commented on CALCITE-6521: -- [~julianhyde] Thanks for reply, I found that the a

[jira] [Updated] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6521: Description: {code:java} SELECT n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),

[jira] [Updated] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6521: Description: {code:java} SELECT n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Issue Type: Improvement (was: Bug) > alias generation issue about correlated subquery handling > ---

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Priority: Minor (was: Blocker) > alias generation issue about correlated subquery handling > ---

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Priority: Blocker (was: Minor) > alias generation issue about correlated subquery handling > ---

[jira] [Created] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-08 Thread EveyWu (Jira)
EveyWu created CALCITE-6521: Summary: CROSS JOIN UNNEST The results do not match expectations. Key: CALCITE-6521 URL: https://issues.apache.org/jira/browse/CALCITE-6521 Project: Calcite Issue Ty

[jira] [Updated] (CALCITE-6521) CROSS JOIN UNNEST The results do not match expectations.

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6521: Description: {code:java} SELECT n, a FROM ( VALUES (ARRAY[2, 5], ARRAY['dog', 'cat', 'bird']),

[jira] [Updated] (CALCITE-6463) alias generation issue about correlated subquery handling

2024-08-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6463: Issue Type: Bug (was: Improvement) > alias generation issue about correlated subquery handling > ---

[jira] [Comment Edited] (CALCITE-6372) Support ASOF joins

2024-07-31 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869943#comment-17869943 ] EveyWu edited comment on CALCITE-6372 at 7/31/24 3:46 PM: --- W

[jira] [Updated] (CALCITE-6372) Support ASOF joins

2024-07-31 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6372: Attachment: image-2024-07-31-23-42-31-044.png > Support ASOF joins > -- > >

[jira] [Updated] (CALCITE-6372) Support ASOF joins

2024-07-31 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6372: Attachment: (was: image-2024-07-31-23-42-31-044.png) > Support ASOF joins > -- > >

[jira] [Commented] (CALCITE-6372) Support ASOF joins

2024-07-31 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869943#comment-17869943 ] EveyWu commented on CALCITE-6372: -- Why consider using snowflake's syntax definition?

[jira] [Commented] (CALCITE-6450) Postgres CONCAT_WS function throws exception when parameter type is (, )

2024-07-05 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17863238#comment-17863238 ] EveyWu commented on CALCITE-6450: -- [~nobigo] If you don't mind, I will take over this

[jira] [Updated] (CALCITE-6447) Extract common expressions for disjunctions in Join

2024-06-27 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6447: Attachment: (was: image-2024-06-27-15-05-55-779.png) > Extract common expressions for disjunctions in

[jira] [Comment Edited] (CALCITE-6447) Extract common expressions for disjunctions in Join

2024-06-27 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860357#comment-17860357 ] EveyWu edited comment on CALCITE-6447 at 6/27/24 7:08 AM: --- [

[jira] [Comment Edited] (CALCITE-6447) Extract common expressions for disjunctions in Join

2024-06-27 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860357#comment-17860357 ] EveyWu edited comment on CALCITE-6447 at 6/27/24 7:02 AM: --- [

[jira] [Comment Edited] (CALCITE-6447) Extract common expressions for disjunctions in Join

2024-06-27 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860357#comment-17860357 ] EveyWu edited comment on CALCITE-6447 at 6/27/24 7:01 AM: --- [

[jira] [Comment Edited] (CALCITE-6447) Extract common expressions for disjunctions in Join

2024-06-27 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860357#comment-17860357 ] EveyWu edited comment on CALCITE-6447 at 6/27/24 7:01 AM: --- [

[jira] [Commented] (CALCITE-6447) Extract common expressions for disjunctions in Join

2024-06-27 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860357#comment-17860357 ] EveyWu commented on CALCITE-6447: -- [~frostruan] I think this is expected too, this PR

[jira] [Updated] (CALCITE-6446) Add CONCAT_WS function (enabled in Spark library)

2024-06-23 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6446: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Updated] (CALCITE-6446) Add CONCAT_WS function (enabled in Spark library)

2024-06-23 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6446: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Created] (CALCITE-6446) Add CONCAT_WS function (enabled in Spark library)

2024-06-23 Thread EveyWu (Jira)
EveyWu created CALCITE-6446: Summary: Add CONCAT_WS function (enabled in Spark library) Key: CALCITE-6446 URL: https://issues.apache.org/jira/browse/CALCITE-6446 Project: Calcite Issue Type: Imp

[jira] [Updated] (CALCITE-6445) Add REVERSE function (enabled in Spark library)

2024-06-23 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6445: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Created] (CALCITE-6445) Add REVERSE function (enabled in Spark library)

2024-06-23 Thread EveyWu (Jira)
EveyWu created CALCITE-6445: Summary: Add REVERSE function (enabled in Spark library) Key: CALCITE-6445 URL: https://issues.apache.org/jira/browse/CALCITE-6445 Project: Calcite Issue Type: Impro

[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

2024-04-14 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837032#comment-17837032 ] EveyWu commented on CALCITE-6363: -- It's a good idea to add more dynamic filter rules.

[jira] [Commented] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-11 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825227#comment-17825227 ] EveyWu commented on CALCITE-6278: -- done, CALCITE-6320 has been added to follow up. >

[jira] [Updated] (CALCITE-6320) Parse SQL with Hive-style and Spark-style unescaped character literals

2024-03-11 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6320?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6320: Description: # Since Spark 2.0, string literals (including regex patterns) are unescaped in the parser p

[jira] [Created] (CALCITE-6320) Parse SQL with Hive-style and Spark-style unescaped character literals

2024-03-11 Thread EveyWu (Jira)
EveyWu created CALCITE-6320: Summary: Parse SQL with Hive-style and Spark-style unescaped character literals Key: CALCITE-6320 URL: https://issues.apache.org/jira/browse/CALCITE-6320 Project: Calcite

[jira] [Commented] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825003#comment-17825003 ] EveyWu commented on CALCITE-6278: -- [~julianhyde]  The unescape operation has been del

[jira] [Commented] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825002#comment-17825002 ] EveyWu commented on CALCITE-6278: -- 1. Sure, in my opinion, in this case, 'unescaping'

[jira] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180 ] EveyWu deleted comment on CALCITE-6180: -- was (Author: eveywu): 1. Sure, in my opinion, in this case, 'unescaping' means handling backslashes in character literals. 2. Indeed, if a query is b

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Comment Edited] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825000#comment-17825000 ] EveyWu edited comment on CALCITE-6180 at 3/10/24 4:32 AM: --- 1

[jira] [Comment Edited] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825000#comment-17825000 ] EveyWu edited comment on CALCITE-6180 at 3/10/24 4:31 AM: --- 1

[jira] [Comment Edited] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825000#comment-17825000 ] EveyWu edited comment on CALCITE-6180 at 3/10/24 4:30 AM: --- 1

[jira] [Comment Edited] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825000#comment-17825000 ] EveyWu edited comment on CALCITE-6180 at 3/10/24 4:30 AM: --- 1

[jira] [Comment Edited] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825000#comment-17825000 ] EveyWu edited comment on CALCITE-6180 at 3/10/24 4:29 AM: --- S

[jira] [Commented] (CALCITE-6180) Append possibility to escape backslash in LIKE expression

2024-03-09 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17825000#comment-17825000 ] EveyWu commented on CALCITE-6180: -- Sure, in my opinion, in this case, 'unescaping' me

[jira] [Comment Edited] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824900#comment-17824900 ] EveyWu edited comment on CALCITE-6278 at 3/9/24 3:54 AM: -- [~j

[jira] [Commented] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824900#comment-17824900 ] EveyWu commented on CALCITE-6278: -- [~julianhyde] Thanks for the review. 1. "Since Sp

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Attachment: image-2024-03-09-11-38-08-797.png > Add REGEXP, REGEXP_LIKE function (enabled in Spark libra

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Attachment: image-2024-03-09-11-37-27-816.png > Add REGEXP, REGEXP_LIKE function (enabled in Spark libra

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Attachment: image-2024-03-09-11-13-49-064.png > Add REGEXP, REGEXP_LIKE function (enabled in Spark libra

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Attachment: (was: image-2024-03-09-11-12-51-658.png) > Add REGEXP, REGEXP_LIKE function (enabled in

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-08 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Attachment: image-2024-03-09-11-12-51-658.png > Add REGEXP, REGEXP_LIKE function (enabled in Spark libra

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Fix Version/s: (was: 1.37.0) > Add REGEXP, REGEXP_LIKE function (enabled in Spark library) > ---

[jira] [Comment Edited] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824226#comment-17824226 ] EveyWu edited comment on CALCITE-6278 at 3/7/24 2:39 AM: -- # F

[jira] [Comment Edited] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824226#comment-17824226 ] EveyWu edited comment on CALCITE-6278 at 3/7/24 1:32 AM: -- # F

[jira] [Comment Edited] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824226#comment-17824226 ] EveyWu edited comment on CALCITE-6278 at 3/7/24 1:30 AM: -- # F

[jira] [Commented] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824226#comment-17824226 ] EveyWu commented on CALCITE-6278: -- # Fixed summary symbol issue # Sure, in spark, RL

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Updated] (CALCITE-6278) Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Summary: Add REGEXP, REGEXP_LIKE function (enabled in Spark library) (was: Add REGEXP、REGEXP_LIKE func

[jira] [Updated] (CALCITE-6278) Add REGEXP、REGEXP_LIKE function (enabled in Spark library)

2024-03-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Fix Version/s: 1.37.0 > Add REGEXP、REGEXP_LIKE function (enabled in Spark library) > ---

[jira] [Updated] (CALCITE-6278) Add REGEXP、REGEXP_LIKE function (enabled in Spark library)

2024-03-02 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Summary: Add REGEXP、REGEXP_LIKE function (enabled in Spark library) (was: Add REGEXP function (enabled

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17822349#comment-17822349 ] EveyWu commented on CALCITE-6285: -- I agree with you > Function ARRAY_INSERT produces

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17822347#comment-17822347 ] EveyWu commented on CALCITE-6285: -- Another simpler way, can we keep consistent with t

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17822343#comment-17822343 ] EveyWu commented on CALCITE-6285: -- I think the Spark version update causes the proble

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: (was: image-2024-03-01-10-35-11-673.png) > Function ARRAY_INSERT produces an incorrect re

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: image-2024-03-01-10-35-11-673.png > Function ARRAY_INSERT produces an incorrect result for ne

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: (was: image-2024-03-01-10-31-55-853.png) > Function ARRAY_INSERT produces an incorrect re

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: image-2024-03-01-10-31-55-853.png > Function ARRAY_INSERT produces an incorrect result for ne

[jira] [Updated] (CALCITE-6278) Add REGEXP function (enabled in Spark library)

2024-02-22 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6278: Description: Add Spark functions that have been implemented but have different OperandTypes/Returns. Ad

[jira] [Updated] (CALCITE-6260) Add already implemented functions in Spark library

2024-02-22 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6260: Attachment: (was: image-2024-02-22-21-09-22-394.png) > Add already implemented functions in Spark lib

[jira] [Created] (CALCITE-6278) Add REGEXP function (enabled in Spark library)

2024-02-22 Thread EveyWu (Jira)
EveyWu created CALCITE-6278: Summary: Add REGEXP function (enabled in Spark library) Key: CALCITE-6278 URL: https://issues.apache.org/jira/browse/CALCITE-6278 Project: Calcite Issue Type: Improv

[jira] [Commented] (CALCITE-6260) Add already implemented functions in Spark library

2024-02-22 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17819645#comment-17819645 ] EveyWu commented on CALCITE-6260: -- [~caicancai]  Thank you for your advice, I will sp

[jira] [Updated] (CALCITE-6260) Add already implemented functions in Spark library

2024-02-22 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6260: Attachment: image-2024-02-22-21-09-22-394.png > Add already implemented functions in Spark library >

[jira] [Updated] (CALCITE-6259) The implementation of the Log library operator does not match the actual dialect behavior.

2024-02-12 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6259: Attachment: (was: image-2024-02-12-21-52-45-462.png) > The implementation of the Log library operator

[jira] [Created] (CALCITE-6260) Add already implemented functions in Spark library

2024-02-12 Thread EveyWu (Jira)
EveyWu created CALCITE-6260: Summary: Add already implemented functions in Spark library Key: CALCITE-6260 URL: https://issues.apache.org/jira/browse/CALCITE-6260 Project: Calcite Issue Type: Im

[jira] [Commented] (CALCITE-6259) Return the result with the log10 and log functions of argument 0

2024-02-12 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17816612#comment-17816612 ] EveyWu commented on CALCITE-6259: -- log10 is defined in the SqlStdOperatorTable,  In m

[jira] [Updated] (CALCITE-6259) Return the result with the log10 and log functions of argument 0

2024-02-12 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6259: Attachment: image-2024-02-12-21-52-45-462.png > Return the result with the log10 and log functions of arg

[jira] [Comment Edited] (CALCITE-6259) Return the result with the log10 and log functions of argument 0

2024-02-11 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17816489#comment-17816489 ] EveyWu edited comment on CALCITE-6259 at 2/12/24 5:25 AM: --- h

[jira] [Commented] (CALCITE-6259) Return the result with the log10 and log functions of argument 0

2024-02-11 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17816489#comment-17816489 ] EveyWu commented on CALCITE-6259: -- hi [~caicancai]  I think we can optimize the log

[jira] [Comment Edited] (CALCITE-6259) Return the result with the log10 and log functions of argument 0

2024-02-11 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17816489#comment-17816489 ] EveyWu edited comment on CALCITE-6259 at 2/12/24 5:24 AM: --- h

[jira] [Commented] (CALCITE-6257) StarRocks dialect implementation

2024-02-11 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17816467#comment-17816467 ] EveyWu commented on CALCITE-6257: -- hi [~caicancai]    Similar to Presto and Trino, I

[jira] [Created] (CALCITE-6258) Map value constructor is unparsed incorrectly for PrestoSqlDialect

2024-02-10 Thread EveyWu (Jira)
EveyWu created CALCITE-6258: Summary: Map value constructor is unparsed incorrectly for PrestoSqlDialect Key: CALCITE-6258 URL: https://issues.apache.org/jira/browse/CALCITE-6258 Project: Calcite

[jira] [Created] (CALCITE-6257) StarRocks dialect implementation

2024-02-10 Thread EveyWu (Jira)
EveyWu created CALCITE-6257: Summary: StarRocks dialect implementation Key: CALCITE-6257 URL: https://issues.apache.org/jira/browse/CALCITE-6257 Project: Calcite Issue Type: New Feature

[jira] [Comment Edited] (CALCITE-6246) Unable to find the correct function signature when using named parameters with omitting arguments

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815107#comment-17815107 ] EveyWu edited comment on CALCITE-6246 at 2/7/24 5:51 AM: -- hi

[jira] [Comment Edited] (CALCITE-6246) Unable to find the correct function signature when using named parameters with omitting arguments

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815107#comment-17815107 ] EveyWu edited comment on CALCITE-6246 at 2/7/24 5:50 AM: -- I c

[jira] [Commented] (CALCITE-6246) Unable to find the correct function signature when using named parameters with omitting arguments

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815107#comment-17815107 ] EveyWu commented on CALCITE-6246: -- I can't reproduce this case. In my opinion, functi

[jira] [Commented] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815032#comment-17815032 ] EveyWu commented on CALCITE-6241: -- Hi [~shenlang]  Since many functions cannot be pl

[jira] [Updated] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Attachment: image-2024-02-07-07-08-59-868.png > Enable a few existing functions to Spark library > --

[jira] [Updated] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Attachment: (was: image-2024-02-06-17-11-31-144.png) > Enable a few existing functions to Spark libra

[jira] [Commented] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17814696#comment-17814696 ] EveyWu commented on CALCITE-6241: -- [~hongyuguo]   thanks for your advice,Comparing t

[jira] [Updated] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Attachment: image-2024-02-06-17-11-31-144.png > Enable a few existing functions to Spark library > --

[jira] [Updated] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Description: Add Spark as a supported library for functions that have already been implemented for other

[jira] [Updated] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Description: Add Spark as a supported library for functions that have already been implemented for other

[jira] [Updated] (CALCITE-5809) Enable already available functions in Apache Spark Library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-5809: Summary: Enable already available functions in Apache Spark Library (was: enable already available funct

[jira] [Updated] (CALCITE-6241) Enable a few existing functions to Spark library

2024-02-06 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Summary: Enable a few existing functions to Spark library (was: Add a few existing functions to Spark li

[jira] [Updated] (CALCITE-6241) Add a few existing functions to Spark library

2024-02-03 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Description: Add Spark as a supported library for functions that have already been implemented for other

[jira] [Updated] (CALCITE-6241) Add a few existing functions to Spark library

2024-02-03 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Description: Add Spark as a supported library for functions that have already been implemented for other

[jira] [Updated] (CALCITE-6241) Add a few existing functions to Spark library

2024-02-03 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Priority: Minor (was: Major) > Add a few existing functions to Spark library > -

[jira] [Created] (CALCITE-6241) Add a few existing functions to Spark library

2024-02-03 Thread EveyWu (Jira)
EveyWu created CALCITE-6241: Summary: Add a few existing functions to Spark library Key: CALCITE-6241 URL: https://issues.apache.org/jira/browse/CALCITE-6241 Project: Calcite Issue Type: Improve

[jira] [Updated] (CALCITE-6241) Add a few existing functions to Spark library

2024-02-03 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6241: Description: Add Spark as a supported library for functions that have already been implemented for other

[jira] [Commented] (CALCITE-6231) JDBC adapter generates "UNNEST" when it should generate "UNNEST ... WITH ORDINALITY"

2024-01-30 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17812268#comment-17812268 ] EveyWu commented on CALCITE-6231: -- [~julianhyde] thanks for the modification,I have c

  1   2   >