[jira] [Commented] (CALCITE-2653) Correct the operator syntax of String Function SUBSTRING in reference.md

2018-11-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16673628#comment-16673628 ] Julian Hyde commented on CALCITE-2653: -- I am confused. The SQL standard syntax is {{SUBSTRING(x

[jira] [Commented] (CALCITE-2645) SESSION_END() is transformed to RexInputRef, which is always equal to SESSION_START()

2018-11-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16673417#comment-16673417 ] Rui Wang commented on CALCITE-2645: --- [~danny0405] Thanks for this information. I will take another

[jira] [Comment Edited] (CALCITE-2645) SESSION_END() is transformed to RexInputRef, which is always equal to SESSION_START()

2018-11-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672662#comment-16672662 ] Rui Wang edited comment on CALCITE-2645 at 11/2/18 5:04 PM: Correct me if I

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

2018-11-02 Thread Jark Wu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16673003#comment-16673003 ] Jark Wu commented on CALCITE-1912: -- Thanks [~julianhyde], I am looking forward to seeing any

[jira] [Commented] (CALCITE-2649) Allow RelBuilder to create field references to aliased relations without knowing the size of the stack

2018-11-02 Thread Stamatis Zampetakis (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672833#comment-16672833 ] Stamatis Zampetakis commented on CALCITE-2649: -- Thanks for the clarifications

[jira] [Comment Edited] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-02 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672821#comment-16672821 ] Hongze Zhang edited comment on CALCITE-2266 at 11/2/18 9:40 AM: Hi

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-02 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672821#comment-16672821 ] Hongze Zhang commented on CALCITE-2266: --- Hi [~michaelmior], [~julianhyde], [~vlsi], Thank you

[jira] [Updated] (CALCITE-2653) Correct the operator syntax of String Function SUBSTRING in reference.md

2018-11-02 Thread winifredtang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] winifredtang updated CALCITE-2653: -- Description: I wonder if we can change the operator syntax of String Function SUBSTRING from

[jira] [Updated] (CALCITE-2653) Correct the operator syntax of String Function SUBSTRING in reference.md

2018-11-02 Thread winifredtang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] winifredtang updated CALCITE-2653: -- Description: I wonder if we can change the operator syntax of String Function SUBSTRING from

[jira] [Updated] (CALCITE-2653) Correct the operator syntax of String Function SUBSTRING in reference.md

2018-11-02 Thread winifredtang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] winifredtang updated CALCITE-2653: -- Description: I wonder if we can change the operator syntax of String Function SUBSTRING from

[jira] [Updated] (CALCITE-2653) Correct the operator syntax of String Function SUBSTRING in reference.md

2018-11-02 Thread winifredtang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] winifredtang updated CALCITE-2653: -- Summary: Correct the operator syntax of String Function SUBSTRING in reference.md (was:

[jira] [Created] (CALCITE-2653) Correct the description of String Function SUBSTRING in reference.md

2018-11-02 Thread winifredtang (JIRA)
winifredtang created CALCITE-2653: - Summary: Correct the description of String Function SUBSTRING in reference.md Key: CALCITE-2653 URL: https://issues.apache.org/jira/browse/CALCITE-2653 Project:

[jira] [Commented] (CALCITE-2645) SESSION_END() is transformed to RexInputRef, which is always equal to SESSION_START()

2018-11-02 Thread Yuzhao Chen (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672774#comment-16672774 ] Yuzhao Chen commented on CALCITE-2645: -- For our physical implementation, we see SESSION_END(ts)

[jira] [Commented] (CALCITE-2405) In Babel parser: allow to use some reserved keyword as identifier

2018-11-02 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672682#comment-16672682 ] Enrico Olivelli commented on CALCITE-2405: -- Great work. I took a look to the patch. I will

[jira] [Commented] (CALCITE-2406) SqlValidator: allow to use raw string literals for timestamps as in MySQL

2018-11-02 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672679#comment-16672679 ] Enrico Olivelli commented on CALCITE-2406: -- [~julianhyde] I have updated the title and

[jira] [Updated] (CALCITE-2406) SqlValidator: allow to use raw string literals for timestamps as in MySQL

2018-11-02 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Enrico Olivelli updated CALCITE-2406: - Description: I have some case of incompatibility between MySQL (actually on HerdDB

[jira] [Updated] (CALCITE-2406) SqlValidator: allow to use raw string literals for timestamps as in MySQL

2018-11-02 Thread Enrico Olivelli (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Enrico Olivelli updated CALCITE-2406: - Summary: SqlValidator: allow to use raw string literals for timestamps as in MySQL

[jira] [Commented] (CALCITE-2645) SESSION_END() is transformed to RexInputRef, which is always equal to SESSION_START()

2018-11-02 Thread Rui Wang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672662#comment-16672662 ] Rui Wang commented on CALCITE-2645: --- Correct me if I am wrong: in physical implementation, session

[jira] [Commented] (CALCITE-2645) SESSION_END() is transformed to RexInputRef, which is always equal to SESSION_START()

2018-11-02 Thread Yuzhao Chen (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672657#comment-16672657 ] Yuzhao Chen commented on CALCITE-2645: -- Actually the SELECT SESSION_END(ts), SESSION_START(ts) all