[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868080#comment-17868080 ] Caican Cai commented on CALCITE-6489: - I agree to close this PR first. I will adapt the new arrow

[jira] [Closed] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6489. --- Resolution: Not A Bug > Add more data types to the Arrow test set >

[jira] [Commented] (CALCITE-6292) Support more Arrow types

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868074#comment-17868074 ] Caican Cai commented on CALCITE-6292: - [~asolimando]I agree with your approach. I will try to adapt

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17868072#comment-17868072 ] Caican Cai commented on CALCITE-6489: - [~asolimando] Hello, thank you for your reply. I just wanted

[jira] [Comment Edited] (CALCITE-6493) Improve Calcite development documentation

[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867922#comment-17867922 ] Caican Cai edited comment on CALCITE-6493 at 7/23/24 2:21 AM: --

[jira] [Commented] (CALCITE-6493) Improve Calcite development documentation

[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867922#comment-17867922 ] Caican Cai commented on CALCITE-6493: - It seems difficult to add all of them to LintTest, because I

[jira] [Commented] (CALCITE-6493) Improve Calcite development documentation

[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867788#comment-17867788 ] Caican Cai commented on CALCITE-6493: - I think we can put the jira specification in README so that

[jira] [Updated] (CALCITE-6493) Improve Calcite development documentation

[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6493: Description: I noticed that in the jira submission process (like me), some terms are not

[jira] [Updated] (CALCITE-6493) Improve Calcite development documentation

[ https://issues.apache.org/jira/browse/CALCITE-6493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6493: Component/s: site Affects Version/s: 1.37.0 > Improve Calcite development

[jira] [Created] (CALCITE-6493) Improve Calcite development documentation

Caican Cai created CALCITE-6493: --- Summary: Improve Calcite development documentation Key: CALCITE-6493 URL: https://issues.apache.org/jira/browse/CALCITE-6493 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867603#comment-17867603 ] Caican Cai edited comment on CALCITE-6292 at 7/21/24 1:52 PM: --

[jira] [Commented] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867603#comment-17867603 ] Caican Cai commented on CALCITE-6292: - [~asolimando][~julianhyde][~hongyuguo] Hi Can I submit it in

[jira] [Comment Edited] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867581#comment-17867581 ] Caican Cai edited comment on CALCITE-6489 at 7/21/24 8:56 AM: --

[jira] [Comment Edited] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867528#comment-17867528 ] Caican Cai edited comment on CALCITE-6489 at 7/21/24 8:56 AM: -- yes, I

[jira] [Comment Edited] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867528#comment-17867528 ] Caican Cai edited comment on CALCITE-6489 at 7/21/24 8:55 AM: -- yes, I

[jira] [Commented] (CALCITE-6305) Increase coverage of unit tests for the Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867590#comment-17867590 ] Caican Cai commented on CALCITE-6305: - This may require a lot of testing, and it may be a long

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867581#comment-17867581 ] Caican Cai commented on CALCITE-6489: - [~asolimando]thank you. I have submitted a PR > Add more

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867528#comment-17867528 ] Caican Cai commented on CALCITE-6489: - I thought I would create a new dataset that could be

[jira] [Comment Edited] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867528#comment-17867528 ] Caican Cai edited comment on CALCITE-6489 at 7/20/24 3:24 PM: -- yes, I

[jira] [Comment Edited] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867523#comment-17867523 ] Caican Cai edited comment on CALCITE-6292 at 7/20/24 2:57 PM: -- I have a

[jira] [Commented] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867523#comment-17867523 ] Caican Cai commented on CALCITE-6292: - I have a question, are there any tests for these types? >

[jira] [Assigned] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6489: --- Assignee: Caican Cai > Add more data types to the Arrow test set >

[jira] [Commented] (CALCITE-6489) Add more data types to the Arrow test set

[ https://issues.apache.org/jira/browse/CALCITE-6489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867522#comment-17867522 ] Caican Cai commented on CALCITE-6489: - There is a question at present. If I am in the original

[jira] [Created] (CALCITE-6489) Add more data types to the Arrow test set

Caican Cai created CALCITE-6489: --- Summary: Add more data types to the Arrow test set Key: CALCITE-6489 URL: https://issues.apache.org/jira/browse/CALCITE-6489 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-6305) Increase coverage of unit tests for the Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867496#comment-17867496 ] Caican Cai commented on CALCITE-6305: - let me try it. This jira can help me get familiar with

[jira] [Assigned] (CALCITE-6305) Increase coverage of unit tests for the Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6305: --- Assignee: Caican Cai > Increase coverage of unit tests for the Arrow adapter >

[jira] [Closed] (CALCITE-6456) The MySQL log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6456. --- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-6456) The MySQL log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867448#comment-17867448 ] Caican Cai commented on CALCITE-6456: - Fixed in

[jira] (CALCITE-6484) Sonar analysis fails intermittently due to OOM

[ https://issues.apache.org/jira/browse/CALCITE-6484 ] Caican Cai deleted comment on CALCITE-6484: - was (Author: JIRAUSER302115): https://github.com/apache/calcite/pull/3867 While I was helping with testing, I found that this seems to be

[jira] [Commented] (CALCITE-6484) Sonar analysis fails intermittently due to OOM

[ https://issues.apache.org/jira/browse/CALCITE-6484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867379#comment-17867379 ] Caican Cai commented on CALCITE-6484: - https://github.com/apache/calcite/pull/3867 While I was

[jira] [Commented] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867359#comment-17867359 ] Caican Cai commented on CALCITE-6292: - [~asolimando] thank you. let's go > Support more Arrow type

[jira] [Assigned] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6292: --- Assignee: Caican Cai > Support more Arrow type > --- > >

[jira] [Commented] (CALCITE-6292) Support more Arrow type

[ https://issues.apache.org/jira/browse/CALCITE-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867344#comment-17867344 ] Caican Cai commented on CALCITE-6292: - [~hongyuguo][~julianhyde]Hi, would you mind letting me try?

[jira] [Assigned] (CALCITE-6294) Support IN filter in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6294: --- Assignee: Caican Cai > Support IN filter in Arrow adapter >

[jira] [Commented] (CALCITE-6294) Support IN filter in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867343#comment-17867343 ] Caican Cai commented on CALCITE-6294: - [~hongyuguo]Hi, would you mind letting me try? > Support IN

[jira] [Commented] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17867053#comment-17867053 ] Caican Cai commented on CALCITE-6300: - [~julianhyde] Thanks mihai for the question, it looks like

[jira] [Commented] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17865682#comment-17865682 ] Caican Cai commented on CALCITE-6312: - [~mbudiu] [~njordan]  Thank you, I have completed the PR >

[jira] [Updated] (CALCITE-6456) The MySQL log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6456: Summary: The MySQL log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x) (was: The

[jira] [Updated] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6456: Description: The fact should be that the log function in mysql should be equivalent to LOG(x,

[jira] [Commented] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17865289#comment-17865289 ] Caican Cai commented on CALCITE-6456: - ok，Thanks for reminding > The Mysql log function rule

[jira] [Comment Edited] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17862830#comment-17862830 ] Caican Cai edited comment on CALCITE-6456 at 7/12/24 3:04 AM: -- I fix in

[jira] [Commented] (CALCITE-6460) SortRemoveConstantKeysRule fails with AssertionError due to mismatched collation on resulting Sort

[ https://issues.apache.org/jira/browse/CALCITE-6460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17864223#comment-17864223 ] Caican Cai commented on CALCITE-6460: - good catch > SortRemoveConstantKeysRule fails with

[jira] [Comment Edited] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17863486#comment-17863486 ] Caican Cai edited comment on CALCITE-6300 at 7/6/24 1:33 PM: - [~julianhyde]

[jira] [Commented] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17863486#comment-17863486 ] Caican Cai commented on CALCITE-6300: - [~julianhyde] [~mbudiu] Another solution is to convert

[jira] [Updated] (CALCITE-6457) The ARRAY_CONTAINS function wrongly returns false when arrayComponentType and op1 type are different

[ https://issues.apache.org/jira/browse/CALCITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6457: Summary: The ARRAY_CONTAINS function wrongly returns false when arrayComponentType and op1 type

[jira] [Commented] (CALCITE-6457) The ARRAY_CONTAINS function return false when arrayComponentType and op1 type are different

[ https://issues.apache.org/jira/browse/CALCITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17863444#comment-17863444 ] Caican Cai commented on CALCITE-6457: - thanks > The ARRAY_CONTAINS function return false when

[jira] [Updated] (CALCITE-6457) The ARRAY_CONTAINS function return false when arrayComponentType and op1 type are different

[ https://issues.apache.org/jira/browse/CALCITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6457: Summary: The ARRAY_CONTAINS function return false when arrayComponentType and op1 type are

[jira] [Commented] (CALCITE-6457) The array_contains function return false when arrayComponentType and op1 type are different

[ https://issues.apache.org/jira/browse/CALCITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17863068#comment-17863068 ] Caican Cai commented on CALCITE-6457: - I will show you a spark example later. My spark environment

[jira] [Created] (CALCITE-6457) The array_contains function return false when arrayComponentType and op1 type are differen

Caican Cai created CALCITE-6457: --- Summary: The array_contains function return false when arrayComponentType and op1 type are differen Key: CALCITE-6457 URL: https://issues.apache.org/jira/browse/CALCITE-6457

[jira] [Updated] (CALCITE-6457) The array_contains function return false when arrayComponentType and op1 type are different

[ https://issues.apache.org/jira/browse/CALCITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6457: Summary: The array_contains function return false when arrayComponentType and op1 type are

[jira] [Commented] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17862830#comment-17862830 ] Caican Cai commented on CALCITE-6456: - I fix in [https://github.com/apache/calcite/pull/3839,] >

[jira] [Commented] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

[ https://issues.apache.org/jira/browse/CALCITE-6456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17862633#comment-17862633 ] Caican Cai commented on CALCITE-6456: - [~eveywu] This is my negligence, I feel sorry for it, thank

[jira] [Created] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

Caican Cai created CALCITE-6456: --- Summary: The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x) Key: CALCITE-6456 URL: https://issues.apache.org/jira/browse/CALCITE-6456 Project:

[jira] [Commented] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17862450#comment-17862450 ] Caican Cai commented on CALCITE-6312: - [~tanclary] Thank you, then will log(0) also report an

[jira] [Updated] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6312: Summary: Add LOG function (enabled in PostgreSQL library) (was: Add LOG function (enabled in

[jira] [Updated] (CALCITE-6312) Add LOG function (enabled in PostgreSQL library

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6312: Summary: Add LOG function (enabled in PostgreSQL library (was: Support PostgreSQL LOG) > Add

[jira] [Closed] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6440. --- Resolution: Duplicate > SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g.

[jira] [Commented] (CALCITE-6312) Support PostgreSQL LOG

[ https://issues.apache.org/jira/browse/CALCITE-6312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17861189#comment-17861189 ] Caican Cai commented on CALCITE-6312: - [~njordan] [~tanclary] Hi, I want to know what bigquery will

[jira] [Commented] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17861183#comment-17861183 ] Caican Cai commented on CALCITE-6440: - [~julianhyde] Thank you Julian for your answer. The current

[jira] [Comment Edited] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17861008#comment-17861008 ] Caican Cai edited comment on CALCITE-6440 at 6/30/24 4:17 PM: -- I have

[jira] [Commented] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17861008#comment-17861008 ] Caican Cai commented on CALCITE-6440: - I have submitted a PR, but I think it would be better if it

[jira] [Comment Edited] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860999#comment-17860999 ] Caican Cai edited comment on CALCITE-6440 at 6/30/24 4:14 PM: --

[jira] [Comment Edited] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860999#comment-17860999 ] Caican Cai edited comment on CALCITE-6440 at 6/30/24 2:48 PM: --

[jira] [Comment Edited] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860999#comment-17860999 ] Caican Cai edited comment on CALCITE-6440 at 6/30/24 2:47 PM: --

[jira] [Comment Edited] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860999#comment-17860999 ] Caican Cai edited comment on CALCITE-6440 at 6/30/24 1:57 PM: --

[jira] [Comment Edited] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860999#comment-17860999 ] Caican Cai edited comment on CALCITE-6440 at 6/30/24 1:56 PM: --

[jira] [Commented] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860999#comment-17860999 ] Caican Cai commented on CALCITE-6440: - [~julianhyde] Hi I encountered a little difficulty. I used

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6325: Description: Mysql and spark's log(0, 0), log(0) will return null, bigquery and postgres will

[jira] [Updated] (CALCITE-6325) Add LOG function (enabled in Mysql and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6325: Description: Mysql and spark's log(0， 0) will return null, bigquery and postgres will return an

[jira] [Commented] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is null

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17859521#comment-17859521 ] Caican Cai commented on CALCITE-6440: - [~julianhyde] Thanks, I'm sorry I was busy last week and

[jira] [Updated] (CALCITE-6440) SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6440: Summary: SortRemoveConstantKeysRule should remove NULL literal sort keys (e.g. ORDER BY NULL)

[jira] [Updated] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is null

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6440: Summary: Add optimization to remove sortkey when The Order By parameter in the Sort operator is

[jira] [Comment Edited] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856087#comment-17856087 ] Caican Cai edited comment on CALCITE-6440 at 6/19/24 12:42 AM: --- [~mbudiu]

[jira] [Comment Edited] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856087#comment-17856087 ] Caican Cai edited comment on CALCITE-6440 at 6/19/24 12:42 AM: --- [~mbudiu]

[jira] [Commented] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17856087#comment-17856087 ] Caican Cai commented on CALCITE-6440: - [~mbudiu] I re-edited the jira description, it looks like I

[jira] [Updated] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6440: Summary: Add optimization to remove sortkey when The Order By parameter in the Sort operator is

[jira] [Comment Edited] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855987#comment-17855987 ] Caican Cai edited comment on CALCITE-6440 at 6/18/24 4:14 PM: -- The rule

[jira] [Commented] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855987#comment-17855987 ] Caican Cai commented on CALCITE-6440: - The rule before SortRemoveConstantKeys optimization is

[jira] [Commented] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855971#comment-17855971 ] Caican Cai commented on CALCITE-6439: - It seems that calcite treats null as a Boolean value,

[jira] [Closed] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6439. --- Resolution: Not A Problem > FILTER_INSTANCE in RelOptRule does not take effect >

[jira] [Commented] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855966#comment-17855966 ] Caican Cai commented on CALCITE-6439: - ok, i will test it > FILTER_INSTANCE in RelOptRule does not

[jira] [Commented] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855462#comment-17855462 ] Caican Cai commented on CALCITE-6440: - [~julianhyde] Thanks, but CALCITE-873 seems to lack order by

[jira] [Created] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

Caican Cai created CALCITE-6440: --- Summary: Add optimization to returns empty when The Order By parameter in the Sort operator is empty Key: CALCITE-6440 URL: https://issues.apache.org/jira/browse/CALCITE-6440

[jira] [Reopened] (CALCITE-6439) Add FilterNullTest on RelOptRulesTest

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reopened CALCITE-6439: - > Add FilterNullTest on RelOptRulesTest > - > >

[jira] [Updated] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6439: Summary: FILTER_INSTANCE in RelOptRule does not take effect (was: Add FilterNullTest on

[jira] [Commented] (CALCITE-6439) Add FilterNullTest on RelOptRulesTest

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855262#comment-17855262 ] Caican Cai commented on CALCITE-6439: - I'm sorry, I'm not familiar with the RBO module code yet, so

[jira] [Closed] (CALCITE-6439) Add FilterNullTest on RelOptRulesTest

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6439. --- Resolution: Duplicate > Add FilterNullTest on RelOptRulesTest >

[jira] [Updated] (CALCITE-6439) Add FilterNullTest on RelOptRulesTest

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6439: Issue Type: Wish (was: Bug) Priority: Minor (was: Major) Summary: Add

[jira] [Commented] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855257#comment-17855257 ] Caican Cai commented on CALCITE-6439: - I noticed that this optimization rule will be executed in

[jira] [Commented] (CALCITE-6438) Add optimization to returns empty when the filter operator is a false instance

[ https://issues.apache.org/jira/browse/CALCITE-6438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17855254#comment-17855254 ] Caican Cai commented on CALCITE-6438: - I noticed CoreRules.FILTER_REDUCE_EXPRESSIONS, I will close

[jira] [Closed] (CALCITE-6438) Add optimization to returns empty when the filter operator is a false instance

[ https://issues.apache.org/jira/browse/CALCITE-6438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6438. --- Resolution: Duplicate > Add optimization to returns empty when the filter operator is a false

[jira] [Assigned] (CALCITE-6438) Add optimization to returns empty when the filter operator is a false instance

[ https://issues.apache.org/jira/browse/CALCITE-6438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai reassigned CALCITE-6438: --- Assignee: Caican Cai > Add optimization to returns empty when the filter operator is a

[jira] [Updated] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6439: Description: test example {code:java} @Test void testFilterNull() { final String sql = "select

[jira] [Updated] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6439: Fix Version/s: (was: 1.36.0) > FILTER_INSTANCE in RelOptRule does not take effect >

[jira] [Created] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

Caican Cai created CALCITE-6439: --- Summary: FILTER_INSTANCE in RelOptRule does not take effect Key: CALCITE-6439 URL: https://issues.apache.org/jira/browse/CALCITE-6439 Project: Calcite Issue

[jira] [Created] (CALCITE-6438) Add optimization to returns empty when the filter operator is a false instance

Caican Cai created CALCITE-6438: --- Summary: Add optimization to returns empty when the filter operator is a false instance Key: CALCITE-6438 URL: https://issues.apache.org/jira/browse/CALCITE-6438

[jira] [Commented] (CALCITE-6411) Support Collect in ToLogicalConverter

[ https://issues.apache.org/jira/browse/CALCITE-6411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17850671#comment-17850671 ] Caican Cai commented on CALCITE-6411: - [~nobigo] Thanks, as you can see from my comments above, I

[jira] [Comment Edited] (CALCITE-6411) Support Collect in ToLogicalConverter

[ https://issues.apache.org/jira/browse/CALCITE-6411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17849313#comment-17849313 ] Caican Cai edited comment on CALCITE-6411 at 5/24/24 2:30 PM: --

[jira] [Comment Edited] (CALCITE-6411) Support Collect in ToLogicalConverter

[ https://issues.apache.org/jira/browse/CALCITE-6411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17849313#comment-17849313 ] Caican Cai edited comment on CALCITE-6411 at 5/24/24 2:26 PM: --

[jira] [Comment Edited] (CALCITE-6411) Support Collect in ToLogicalConverter

[ https://issues.apache.org/jira/browse/CALCITE-6411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17849313#comment-17849313 ] Caican Cai edited comment on CALCITE-6411 at 5/24/24 2:22 PM: -- Is the

  1   2   3   4   5   >