[jira] [Commented] (CALCITE-6018) Support nullable parameters in UDFs

2023-09-20 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767390#comment-17767390 ] Vladimir Sitnikov commented on CALCITE-6018: Just in case, {{@Parameter(optional=true}}

[jira] [Commented] (CALCITE-6011) Add the RelRule that pushes the Filter past a Window

2023-09-20 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767383#comment-17767383 ] LakeShen commented on CALCITE-6011: --- Hi [~julianhyde] ,thanks for your reply,my idea is also to name

[jira] [Created] (CALCITE-6018) Support nullable parameters in UDFs

2023-09-20 Thread Vladimir Sitnikov (Jira)
Vladimir Sitnikov created CALCITE-6018: -- Summary: Support nullable parameters in UDFs Key: CALCITE-6018 URL: https://issues.apache.org/jira/browse/CALCITE-6018 Project: Calcite Issue

[jira] [Updated] (CALCITE-6018) Support nullable parameters in UDFs

2023-09-20 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-6018: --- Affects Version/s: 1.35.0 > Support nullable parameters in UDFs >

[jira] [Updated] (CALCITE-6015) AssertionError during optimization of EXTRACT expression

2023-09-20 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6015: Labels: pull-request-available (was: ) > AssertionError during optimization of EXTRACT

[jira] [Commented] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

2023-09-20 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767370#comment-17767370 ] Vladimir Sitnikov commented on CALCITE-5960: Currently Calcite has no tests with

[jira] [Commented] (CALCITE-5995) add cache to dejsonize function in JsonFunctions

2023-09-20 Thread xiaogang zhou (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767362#comment-17767362 ] xiaogang zhou commented on CALCITE-5995: I have enabled the .editorconfig and reformatted code

[jira] [Commented] (CALCITE-5984) Cannot fully disable trimming unused fields using Calcite configs

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767352#comment-17767352 ] Julian Hyde commented on CALCITE-5984: -- As I said, I don't know. > Cannot fully disable trimming

[jira] [Comment Edited] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767345#comment-17767345 ] Ran Tao edited comment on CALCITE-5960 at 9/21/23 12:51 AM: I have added a

[jira] [Commented] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767345#comment-17767345 ] Ran Tao commented on CALCITE-5960: -- I have add simple case by casting row type, because the family of

[jira] [Comment Edited] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767345#comment-17767345 ] Ran Tao edited comment on CALCITE-5960 at 9/21/23 12:51 AM: I have added

[jira] [Commented] (CALCITE-5978) Add REGEXP_INSTR function (enabled in BigQuery library)

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767342#comment-17767342 ] Julian Hyde commented on CALCITE-5978: -- [~jerin_john], A few late review comments. You don't need

[jira] [Commented] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767340#comment-17767340 ] Ran Tao commented on CALCITE-5960: -- [~julianhyde] Actually, it can be covered by 'select * from

[jira] [Commented] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767326#comment-17767326 ] Julian Hyde commented on CALCITE-5960: -- I saw that it is a simple fix. Can you add a test case? I

[jira] [Commented] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767324#comment-17767324 ] Julian Hyde commented on CALCITE-6012: -- Wow, by sheer coincidence, a duplicate seems to have

[jira] [Commented] (CALCITE-5995) add cache to dejsonize function in JsonFunctions

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767323#comment-17767323 ] Julian Hyde commented on CALCITE-5995: -- Please ask on the dev list. > add cache to dejsonize

[jira] [Commented] (CALCITE-6011) Add the RelRule that pushes the Filter past a Window

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767321#comment-17767321 ] Julian Hyde commented on CALCITE-6011: -- Sounds awesome; looking forward to it. Can we call it

[jira] [Commented] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767319#comment-17767319 ] Julian Hyde commented on CALCITE-6012: -- [~oliverlee], Cancel that. It seems that this case cannot

[jira] [Updated] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6012: - Affects Version/s: 1.35.0 > CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE

[jira] [Commented] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767316#comment-17767316 ] Julian Hyde commented on CALCITE-6012: -- [~oliverlee], Would you mind taking a look at this? My

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

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767311#comment-17767311 ] Julian Hyde commented on CALCITE-6007: -- What happens with the example query I gave above? > CTE

[jira] [Commented] (CALCITE-6016) Cannot execute SQL on Snowflake connection with error : java.lang.IllegalArgumentException: Multiple entries with same key: CLASSES=JdbcTable {CLASSES} and CLASSES=Jd

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767310#comment-17767310 ] Julian Hyde commented on CALCITE-6016: -- Based on the error message, it looks as if Snowflake has

[jira] [Updated] (CALCITE-6016) Cannot execute SQL on Snowflake connection with error : java.lang.IllegalArgumentException: Multiple entries with same key: CLASSES=JdbcTable {CLASSES} and CLASSES=Jdbc

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6016: - Description: Might be similar to : DRILL-7415 I am connected to Snowflake datasource using

[jira] [Comment Edited] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-20 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767264#comment-17767264 ] Tanner Clary edited comment on CALCITE-6013 at 9/20/23 7:52 PM:

[jira] [Commented] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-20 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767264#comment-17767264 ] Tanner Clary commented on CALCITE-6013: --- [~julianhyde]Yes I agree, however I think for queries

[jira] [Commented] (CALCITE-6017) The content of github link about the released versions in history doc is empty

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767249#comment-17767249 ] Julian Hyde commented on CALCITE-6017: -- The page used to contain releases, e.g. [releases as of

[jira] [Comment Edited] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767236#comment-17767236 ] Julian Hyde edited comment on CALCITE-6013 at 9/20/23 7:06 PM: --- Does this

[jira] [Updated] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6013: - Description: If you have a test like the following (modified from

[jira] [Commented] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-20 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767236#comment-17767236 ] Julian Hyde commented on CALCITE-6013: -- Does this scenario give an error? The plan has some unused

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

2023-09-20 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767195#comment-17767195 ] Stamatis Zampetakis commented on CALCITE-5957: -- As far as I see the consensus is to make

[jira] [Updated] (CALCITE-6017) The content of github link about the released versions in history doc is empty

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Description: In calcite history page, we have a description in history.md: {noformat} For a full list

[jira] [Comment Edited] (CALCITE-6017) The content of github link about the released versions in history doc is empty

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767175#comment-17767175 ] Ran Tao edited comment on CALCITE-6017 at 9/20/23 3:55 PM: --- [~shenlang] we

[jira] [Commented] (CALCITE-6017) The github link about the released version in calcite's doc may has no reference value

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767173#comment-17767173 ] Ran Tao commented on CALCITE-6017: -- Maybe i'm wrong, because even though

[jira] [Updated] (CALCITE-6017) The content of github link about the released versions in history doc is empty

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Summary: The content of github link about the released versions in history doc is empty (was: The

[jira] [Commented] (CALCITE-6017) The github link about the released version in calcite's doc may has no reference value

2023-09-20 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767159#comment-17767159 ] LakeShen commented on CALCITE-6017: --- Hi [~taoran] ,the title `has no reference value` is not

[jira] [Updated] (CALCITE-6017) The github link about the released version in calcite's history doc is empty

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Summary: The github link about the released version in calcite's history doc is empty (was: The

[jira] [Updated] (CALCITE-6013) Unnecessary measures added as projects during rel construction

2023-09-20 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6013: Labels: pull-request-available (was: ) > Unnecessary measures added as projects during

[jira] [Updated] (CALCITE-6017) The content of github link about the released versions in history doc is empty

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Description: In calcite history page, we have a description: {noformat} For a full list of releases,

[jira] [Commented] (CALCITE-6017) The github link about the released version in calcite's history doc is empty

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17767175#comment-17767175 ] Ran Tao commented on CALCITE-6017: -- [~shenlang] we have a description in history.md to let user visit

[jira] [Created] (CALCITE-6017) The github link of released versions in doc may has no reference value

2023-09-20 Thread Ran Tao (Jira)
Ran Tao created CALCITE-6017: Summary: The github link of released versions in doc may has no reference value Key: CALCITE-6017 URL: https://issues.apache.org/jira/browse/CALCITE-6017 Project: Calcite

[jira] [Updated] (CALCITE-6017) The github link of released versions in doc may have no reference value

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Summary: The github link of released versions in doc may have no reference value (was: The github

[jira] [Updated] (CALCITE-6017) The github link about the released version in calcite's doc has no reference value

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Summary: The github link about the released version in calcite's doc has no reference value (was: The

[jira] [Updated] (CALCITE-6017) The github link about the released version in calcite's doc may has no reference value

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Summary: The github link about the released version in calcite's doc may has no reference value (was:

[jira] [Updated] (CALCITE-6017) The github link of released versions in doc may have no reference value

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Description: In calcite history page, we have a description:   For a full list of releases, see

[jira] [Updated] (CALCITE-6017) The github link of released versions in doc may has no reference value

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6017: - Labels: doc (was: ) > The github link of released versions in doc may has no reference value >

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

2023-09-20 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759018#comment-17759018 ] Ran Tao edited comment on CALCITE-5948 at 9/20/23 12:57 PM: this issue has