[jira] [Updated] (CALCITE-6418) Expression with ALL aggregate return unexpected result.

2024-05-23 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6418: Description: I expect that: {noformat} SELECT i=ALL(SELECT i FROM (values(1),

[jira] [Created] (CALCITE-6418) Expression with ALL aggregate return unexpected result.

2024-05-23 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6418: --- Summary: Expression with ALL aggregate return unexpected result. Key: CALCITE-6418 URL: https://issues.apache.org/jira/browse/CALCITE-6418 Project:

[jira] [Created] (CALCITE-6350) Unexpected result from UNION with literals expression

2024-04-04 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6350: --- Summary: Unexpected result from UNION with literals expression Key: CALCITE-6350 URL: https://issues.apache.org/jira/browse/CALCITE-6350 Project:

[jira] [Commented] (CALCITE-6248) Illegal dates are accepted by casts

2024-02-26 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17820972#comment-17820972 ] Evgeny Stanilovsky commented on CALCITE-6248: - honestly i think we need to follow the

[jira] [Commented] (CALCITE-6248) Illegal dates are accepted by casts

2024-02-11 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17816490#comment-17816490 ] Evgeny Stanilovsky commented on CALCITE-6248: - [~mbudiu] plz check discussion here [1] and

[jira] [Commented] (CALCITE-6248) Illegal dates are accepted by casts

2024-02-06 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17815104#comment-17815104 ] Evgeny Stanilovsky commented on CALCITE-6248: - [~mbudiu] such a problem was fixed in

[jira] [Assigned] (CALCITE-6211) SUBSTRING with Integer.MIN_VALUE as a second parameter raise unexpected exception

2024-01-18 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-6211: --- Assignee: Evgeny Stanilovsky > SUBSTRING with Integer.MIN_VALUE as a

[jira] [Created] (CALCITE-6211) SUBSTRING with Integer.MIN_VALUE as a second parameter raise unexpected exception

2024-01-17 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6211: --- Summary: SUBSTRING with Integer.MIN_VALUE as a second parameter raise unexpected exception Key: CALCITE-6211 URL: https://issues.apache.org/jira/browse/CALCITE-6211

[jira] [Commented] (CALCITE-6210) Cast to VARBINARY causes an assertion failure

2024-01-17 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17808016#comment-17808016 ] Evgeny Stanilovsky commented on CALCITE-6210: - as for me - correct exception need to be

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

2024-01-10 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17805010#comment-17805010 ] Evgeny Stanilovsky commented on CALCITE-6180: - Ok i take a standard : --- begin --- uses

[jira] [Assigned] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-6190: --- Assignee: Evgeny Stanilovsky > Incorrect precision derivation for

[jira] [Assigned] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-6190: --- Assignee: Mihai Budiu (was: Evgeny Stanilovsky) > Incorrect precision

[jira] [Commented] (CALCITE-6192) DEFAULT expression with NULL value throws unexpected exception

2024-01-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17804581#comment-17804581 ] Evgeny Stanilovsky commented on CALCITE-6192: - [~mbudiu] thanks ! fix is ready for review

[jira] [Assigned] (CALCITE-6192) DEFAULT expression with NULL value throws unexpected exception

2024-01-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-6192: --- Assignee: Evgeny Stanilovsky > DEFAULT expression with NULL value throws

[jira] [Updated] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6190: Description: Test highlights the problem : {code:java} @Test void

[jira] [Created] (CALCITE-6192) DEFAULT expression with NULL value throws unexpected exception

2024-01-08 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6192: --- Summary: DEFAULT expression with NULL value throws unexpected exception Key: CALCITE-6192 URL: https://issues.apache.org/jira/browse/CALCITE-6192

[jira] [Updated] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-04 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6190: Description: Test highlights the problem : {code:java} @Test void

[jira] [Created] (CALCITE-6190) Incorrect precision derivation for negative numeric types

2024-01-04 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6190: --- Summary: Incorrect precision derivation for negative numeric types Key: CALCITE-6190 URL: https://issues.apache.org/jira/browse/CALCITE-6190 Project:

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

2024-01-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17802400#comment-17802400 ] Evgeny Stanilovsky commented on CALCITE-6180: - [~julianhyde] thanks, my evidence: i check

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

2024-01-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6180: Summary: Append possibility to escape backslash in LIKE expression (was: Append

[jira] [Updated] (CALCITE-6180) Backslash cannot be escaped in LIKE ESCAPE operator

2023-12-27 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6180: Labels: pull-request-available (was: pull) > Backslash cannot be escaped in

[jira] [Updated] (CALCITE-6180) Backslash cannot be escaped in LIKE ESCAPE operator

2023-12-27 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-6180: Labels: pull (was: pull-request-available) > Backslash cannot be escaped in

[jira] [Created] (CALCITE-6180) Backslash cannot be escaped in LIKE ESCAPE operator

2023-12-27 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6180: --- Summary: Backslash cannot be escaped in LIKE ESCAPE operator Key: CALCITE-6180 URL: https://issues.apache.org/jira/browse/CALCITE-6180 Project: Calcite

[jira] [Commented] (CALCITE-6111) Explicit cast from expression to numeric type doesn't check overflow

2023-11-12 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17785378#comment-17785378 ] Evgeny Stanilovsky commented on CALCITE-6111: - [~mbudiu] [~mbudiu]  FYI ^ > Explicit cast

[jira] [Created] (CALCITE-6111) Explicit cast from expression to numeric type doesn't check overflow

2023-11-12 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-6111: --- Summary: Explicit cast from expression to numeric type doesn't check overflow Key: CALCITE-6111 URL: https://issues.apache.org/jira/browse/CALCITE-6111

[jira] [Commented] (CALCITE-5950) Default column expression does not substitute the corresponding values when inserting

2023-10-13 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17774886#comment-17774886 ] Evgeny Stanilovsky commented on CALCITE-5950: - thanks, done. > Default column expression

[jira] [Updated] (CALCITE-5950) Default column expression does not substitute the corresponding values when inserting

2023-10-13 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5950: Summary: Default column expression does not substitute the corresponding values

[jira] [Updated] (CALCITE-5950) Default column constraint is erroneously processed

2023-10-13 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5950: Description: II change table.iq a bit and found a problem with processing

[jira] [Updated] (CALCITE-5950) Default column constraint is erroneously processed

2023-10-13 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5950: Summary: Default column constraint is erroneously processed (was: Default

[jira] [Updated] (CALCITE-5950) Default column constraint is erroneously processed.

2023-10-13 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5950: Description: II change table.iq a bit and found a problem with processing

[jira] [Updated] (CALCITE-5950) Default column constraint is erroneously processed.

2023-10-12 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5950: Fix Version/s: 1.36.0 > Default column constraint is erroneously processed. >

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

2023-09-23 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17768291#comment-17768291 ] Evgeny Stanilovsky commented on CALCITE-5957: - [~Runking] feel free to move forward,

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

2023-09-21 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767826#comment-17767826 ] Evgeny Stanilovsky commented on CALCITE-5957: - '900-01-01' should be accepted and '9-01-01'

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766775#comment-17766775 ] Evgeny Stanilovsky commented on CALCITE-5957: - ok i check, all these cases : ("900-01-01" ,

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766765#comment-17766765 ] Evgeny Stanilovsky edited comment on CALCITE-5957 at 9/19/23 11:40 AM:

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766765#comment-17766765 ] Evgeny Stanilovsky edited comment on CALCITE-5957 at 9/19/23 11:39 AM:

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-5957: --- Assignee: (was: Evgeny Stanilovsky) > Valid DATE '1945-2-2' is not

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766765#comment-17766765 ] Evgeny Stanilovsky commented on CALCITE-5957: - "900-01-01" ok i take a look on it a bit

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5957: Labels: (was: pull-request-available) > Valid DATE '1945-2-2' is not accepted

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766659#comment-17766659 ] Evgeny Stanilovsky edited comment on CALCITE-5957 at 9/19/23 6:42 AM:

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

2023-09-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766659#comment-17766659 ] Evgeny Stanilovsky commented on CALCITE-5957: - [~zabetak] as i can see from iso standard

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

2023-09-14 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765453#comment-17765453 ] Evgeny Stanilovsky commented on CALCITE-5957: - [~lchistov1987] just remind you that it`s

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

2023-09-11 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763695#comment-17763695 ] Evgeny Stanilovsky commented on CALCITE-5957: - [~zabetak] hello, seems there is no activity

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

2023-09-07 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17762576#comment-17762576 ] Evgeny Stanilovsky commented on CALCITE-5957: - patch is reviewed, wait for merge. > Valid

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

2023-09-01 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17761217#comment-17761217 ] Evgeny Stanilovsky commented on CALCITE-5957: - [~Runking]review is still desirable ) thanks

[jira] [Created] (CALCITE-5969) LITERAL_AGG erroneously assembled after deserialization

2023-08-31 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5969: --- Summary: LITERAL_AGG erroneously assembled after deserialization Key: CALCITE-5969 URL: https://issues.apache.org/jira/browse/CALCITE-5969 Project:

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

2023-08-29 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759866#comment-17759866 ] Evgeny Stanilovsky commented on CALCITE-5957: - [~Runking], [~shenlang] i don`t dig deeper

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

2023-08-29 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky reassigned CALCITE-5957: --- Assignee: Evgeny Stanilovsky > Valid DATE '1945-2-2' is not accepted due

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

2023-08-28 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759481#comment-17759481 ] Evgeny Stanilovsky commented on CALCITE-5923: - [~Runking] yep, i think we need to fix it,

[jira] [Commented] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-08-28 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759472#comment-17759472 ] Evgeny Stanilovsky commented on CALCITE-5678: - [~zabetak] seems we need to fix it and cover

[jira] [Commented] (CALCITE-5950) Default column constraint is erroneously processed.

2023-08-23 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17758123#comment-17758123 ] Evgeny Stanilovsky commented on CALCITE-5950: - PR is ready for review, besides some CI /

[jira] [Created] (CALCITE-5950) Default column constraint is erroneously processed.

2023-08-22 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5950: --- Summary: Default column constraint is erroneously processed. Key: CALCITE-5950 URL: https://issues.apache.org/jira/browse/CALCITE-5950 Project: Calcite

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-07-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739504#comment-17739504 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 7/3/23 9:04 AM:

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-07-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739504#comment-17739504 ] Evgeny Stanilovsky commented on CALCITE-5708: - [~gian] thanks for review ! i change all

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-07-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: 1.35.0 > Change SUBSTRING result if either of parameters is NULL

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-07-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: (was: 1.35.0) > Change SUBSTRING result if either of

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-29 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738874#comment-17738874 ] Evgeny Stanilovsky commented on CALCITE-5708: - thanks, yes he leave 2 comments, i fixed

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-29 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17738392#comment-17738392 ] Evgeny Stanilovsky commented on CALCITE-5708: - i read on dev-list that ready issues need to

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17730498#comment-17730498 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/8/23 10:36 AM:

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17730498#comment-17730498 ] Evgeny Stanilovsky commented on CALCITE-5708: - As i can see mentioned functions _not using

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-08 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: 1.35.0 > Change SUBSTRING result if either of parameters is NULL

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-07 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: (was: 1.35.0) > Change SUBSTRING result if either of

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

2023-06-07 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Summary: Change SUBSTRING result if either of parameters is NULL literal (was:

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-06-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Fix Version/s: 1.35.0 > Change SUBSTRING result if either of parameters is NULL

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-06-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 10:01 AM:

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-06-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 9:13 AM:

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-06-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 9:08 AM:

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-06-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 9:06 AM:

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-06-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725091#comment-17725091 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/2/23 7:40 AM:

[jira] [Updated] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-30 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5703: Fix Version/s: 1.35.0 > Reduce amount of generated runtime code >

[jira] [Commented] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-26 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726641#comment-17726641 ] Evgeny Stanilovsky commented on CALCITE-5703: - got it, i change a code and the tests, so

[jira] [Commented] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-24 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726056#comment-17726056 ] Evgeny Stanilovsky commented on CALCITE-5703: - [~Sergey Nuyanzin] ok i understand, but if i

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-22 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Labels: patch-available (was: pull-request-available) > Change SUBSTRING result

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-22 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17725091#comment-17725091 ] Evgeny Stanilovsky commented on CALCITE-5708: - I additionally change PR. Talking about

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-21 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Labels: (was: patch-available pull-request-available) > Change SUBSTRING

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-19 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17724354#comment-17724354 ] Evgeny Stanilovsky commented on CALCITE-5708: - It`s work due to type coercion in your case.

[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-18 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17724120#comment-17724120 ] Evgeny Stanilovsky edited comment on CALCITE-5708 at 5/19/23 5:22 AM:

[jira] [Commented] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-18 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17724120#comment-17724120 ] Evgeny Stanilovsky commented on CALCITE-5708: - ye, i check your expressions and it`s really

[jira] [Updated] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-18 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5708: Labels: patch-available (was: ) > Change SUBSTRING result if either of

[jira] [Created] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL

2023-05-18 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5708: --- Summary: Change SUBSTRING result if either of parameters is NULL Key: CALCITE-5708 URL: https://issues.apache.org/jira/browse/CALCITE-5708 Project:

[jira] [Commented] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-17 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723441#comment-17723441 ] Evgeny Stanilovsky commented on CALCITE-5703: - [~Sergey Nuyanzin] if PR will be accepted

[jira] [Commented] (CALCITE-5699) Posix regex expressions failed while NOT operator is executed with null literals.

2023-05-17 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723356#comment-17723356 ] Evgeny Stanilovsky commented on CALCITE-5699: - I append additional test into BabelTest,

[jira] [Commented] (CALCITE-5698) EXTRACT from INTERVAL partially does not follow the SQL standard

2023-05-16 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17723347#comment-17723347 ] Evgeny Stanilovsky commented on CALCITE-5698: - all done, thanks. > EXTRACT from INTERVAL

[jira] [Updated] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-16 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5703: Labels: patch-available (was: ) > Reduce amount of generated runtime code >

[jira] [Updated] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-16 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5703: Description: In some cases runtime generates code like : {noformat} return

[jira] [Created] (CALCITE-5703) Reduce amount of generated runtime code

2023-05-15 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5703: --- Summary: Reduce amount of generated runtime code Key: CALCITE-5703 URL: https://issues.apache.org/jira/browse/CALCITE-5703 Project: Calcite

[jira] [Commented] (CALCITE-5698) EXTRACT from INTERVAL partially does not follow the SQL standard

2023-05-12 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17722141#comment-17722141 ] Evgeny Stanilovsky commented on CALCITE-5698: - Probably i need to append such a tests into

[jira] [Comment Edited] (CALCITE-5699) Posix regex expressions failed while NOT operator is executed with null literals.

2023-05-12 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17722050#comment-17722050 ] Evgeny Stanilovsky edited comment on CALCITE-5699 at 5/12/23 7:42 AM:

[jira] [Commented] (CALCITE-5699) Posix regex expressions failed while NOT operator is executed with null literals.

2023-05-12 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17722050#comment-17722050 ] Evgeny Stanilovsky commented on CALCITE-5699: - Probably i need to append such a tests into

[jira] [Comment Edited] (CALCITE-5699) Posix regex expressions failed while NOT operator is executed with null literals.

2023-05-12 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17722050#comment-17722050 ] Evgeny Stanilovsky edited comment on CALCITE-5699 at 5/12/23 7:23 AM:

[jira] [Created] (CALCITE-5699) Posix regex expressions failed while NOT operator is executed with null literals.

2023-05-11 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5699: --- Summary: Posix regex expressions failed while NOT operator is executed with null literals. Key: CALCITE-5699 URL: https://issues.apache.org/jira/browse/CALCITE-5699

[jira] [Created] (CALCITE-5698) EXTRACT from INTERVAL partially does not follow the SQL standard

2023-05-11 Thread Evgeny Stanilovsky (Jira)
Evgeny Stanilovsky created CALCITE-5698: --- Summary: EXTRACT from INTERVAL partially does not follow the SQL standard Key: CALCITE-5698 URL: https://issues.apache.org/jira/browse/CALCITE-5698

[jira] [Commented] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-10 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17721335#comment-17721335 ] Evgeny Stanilovsky commented on CALCITE-5678: - new approach is ready for review. > Calcite

[jira] [Updated] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-10 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5678: Labels: patch-available (was: ) > Calcite should reject date literals not

[jira] [Updated] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-05 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Evgeny Stanilovsky updated CALCITE-5678: Labels: (was: patch-available) > Calcite should reject date literals not

[jira] [Commented] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-04 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17719163#comment-17719163 ] Evgeny Stanilovsky commented on CALCITE-5678: - You are right, i will change it soon. >

[jira] [Commented] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-03 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718802#comment-17718802 ] Evgeny Stanilovsky commented on CALCITE-5678: - In such a case this validation approach

[jira] [Comment Edited] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718497#comment-17718497 ] Evgeny Stanilovsky edited comment on CALCITE-5678 at 5/2/23 9:30 AM:

[jira] [Comment Edited] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17718497#comment-17718497 ] Evgeny Stanilovsky edited comment on CALCITE-5678 at 5/2/23 9:30 AM:

[jira] (CALCITE-5678) Calcite should reject date literals not satisfying Gregorian calendar, per SQL standard

2023-05-02 Thread Evgeny Stanilovsky (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5678 ] Evgeny Stanilovsky deleted comment on CALCITE-5678: - was (Author: zstan): # from LocalDateTime  java doc we can found:  {noformat} The ISO-8601 calendar system is the modern civil

  1   2   >