[jira] [Commented] (CALCITE-2935) Support ANY, SOME, EVERY (also known as BOOL_OR, BOOL_AND) aggregate functions

2019-12-26 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17003524#comment-17003524 ] ShuMing Li commented on CALCITE-2935: - +Note that BOOL_OR and BOOL_AND will essentially be aliases

[jira] [Commented] (CALCITE-3617) Add BOOL_OR Aggregate Function

2019-12-26 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17003521#comment-17003521 ] ShuMing Li commented on CALCITE-3617: - Can I work on this issue? BTW, It's duplicated with

[jira] [Commented] (CALCITE-3628) OOB when using CallCopyingArgHandler to copy sql nodes with hint

2019-12-25 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17003478#comment-17003478 ] ShuMing Li commented on CALCITE-3628: - I think this should be already fixed at

[jira] [Commented] (CALCITE-3349) Add Function DDL into SqlKind DDL enum

2019-09-16 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16930486#comment-16930486 ] ShuMing Li commented on CALCITE-3349: - Just be curious, `SqlCreateFunction` is not implemented of

[jira] [Commented] (CALCITE-3334) Refinement for Substitution-Based MV Matching

2019-09-15 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16930207#comment-16930207 ] ShuMing Li commented on CALCITE-3334: - Good Refinements. It makes `SubstitutionVisitor` more

[jira] [Comment Edited] (CALCITE-3347) IndexOutOfBoundsException in FixNullabilityShuttle when using FilterIntoJoinRule

2019-09-15 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16930205#comment-16930205 ] ShuMing Li edited comment on CALCITE-3347 at 9/16/19 2:55 AM: --

[jira] [Commented] (CALCITE-3347) IndexOutOfBoundsException in FixNullabilityShuttle when using FilterIntoJoinRule

2019-09-15 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16930205#comment-16930205 ] ShuMing Li commented on CALCITE-3347: - [~julianhyde]  I add a simple test in `JdbcTest.java` as

[jira] [Commented] (CALCITE-3323) Handle arbitrary/unknown functions that have ordinary syntax

2019-09-04 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16923004#comment-16923004 ] ShuMing Li commented on CALCITE-3323: - It's an interesting idea. I don't know how to handle

[jira] [Commented] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift

2019-08-22 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16913081#comment-16913081 ] ShuMing Li commented on CALCITE-3280: - Add a review of other databases:   BigQuery :

[jira] [Commented] (CALCITE-3272) TUMBLE Table Value Function

2019-08-21 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912864#comment-16912864 ] ShuMing Li commented on CALCITE-3272: - There is something wrong with the `beam sql` link? > TUMBLE

[jira] [Commented] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift

2019-08-21 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912861#comment-16912861 ] ShuMing Li commented on CALCITE-3280: - Is somebody working this? In our product situation, we still

[jira] [Commented] (CALCITE-1917) Support column reference in "FOR SYSTEM_TIME AS OF"

2019-08-20 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16911072#comment-16911072 ] ShuMing Li commented on CALCITE-1917: - Has this issue already resolved?  I find Calcite already

[jira] [Updated] (CALCITE-3263) Add MD5, SHA1 SQL functions

2019-08-19 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ShuMing Li updated CALCITE-3263: Description: `MD5/SHA1` functions are common UDFs in many SQL engines. We may support them in

[jira] [Updated] (CALCITE-3263) Add MD5, SHA1 SQL functions

2019-08-19 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ShuMing Li updated CALCITE-3263: Description: `MD5/SHA1` functions are common UDFs in many SQL engines. We may support them in

[jira] [Commented] (CALCITE-3263) Add MD5, SHA1 SQL functions

2019-08-19 Thread ShuMing Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16910942#comment-16910942 ] ShuMing Li commented on CALCITE-3263: - Thanks for [~julianhyde]'s replies. I will add a review of

[jira] [Created] (CALCITE-3153) Improve testing in TpcdsTest using assertEqual instead of printing results

2019-06-27 Thread ShuMing Li (JIRA)
ShuMing Li created CALCITE-3153: --- Summary: Improve testing in TpcdsTest using assertEqual instead of printing results Key: CALCITE-3153 URL: https://issues.apache.org/jira/browse/CALCITE-3153 Project:

[jira] [Updated] (CALCITE-2990) fix the document misspelling in RelInput (Shuming Li)

2019-04-11 Thread ShuMing Li (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ShuMing Li updated CALCITE-2990: Issue Type: Bug (was: Improvement) > fix the document misspelling in RelInput (Shuming Li) >

[jira] [Created] (CALCITE-2990) fix the document misspelling in RelInput (Shuming Li)

2019-04-11 Thread ShuMing Li (JIRA)
ShuMing Li created CALCITE-2990: --- Summary: fix the document misspelling in RelInput (Shuming Li) Key: CALCITE-2990 URL: https://issues.apache.org/jira/browse/CALCITE-2990 Project: Calcite