[jira] [Comment Edited] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112139#comment-16112139 ] sunjincheng edited comment on CALCITE-1908 at 8/3/17 4:17 AM: -- Hi,

[jira] [Comment Edited] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112139#comment-16112139 ] sunjincheng edited comment on CALCITE-1908 at 8/3/17 4:16 AM: -- Hi,

[jira] [Comment Edited] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112139#comment-16112139 ] sunjincheng edited comment on CALCITE-1908 at 8/3/17 4:16 AM: -- Hi,

[jira] [Commented] (CALCITE-1920) Add IS_NOT_NULL predicate on not-nullable equi-join keys

2017-08-02 Thread Ted Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112147#comment-16112147 ] Ted Xu commented on CALCITE-1920: - Looks like CALCITE-1526 already fixed this one. > Add IS_NOT_NULL

[jira] [Closed] (CALCITE-1920) Add IS_NOT_NULL predicate on not-nullable equi-join keys

2017-08-02 Thread Ted Xu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Xu closed CALCITE-1920. --- Resolution: Duplicate > Add IS_NOT_NULL predicate on not-nullable equi-join keys >

[jira] [Comment Edited] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112139#comment-16112139 ] sunjincheng edited comment on CALCITE-1908 at 8/3/17 3:57 AM: -- Hi,

[jira] [Commented] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112139#comment-16112139 ] sunjincheng commented on CALCITE-1908: -- Hi, [~julianhyde] Thanks for tell me more detail. I think

[jira] [Updated] (CALCITE-1921) Add DAY as Reserved Function Name, And add day() build-in scalar function

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sunjincheng updated CALCITE-1921: - Description: I want add `DAY()` as build-in scalar function in calcite. It's looks like as

[jira] [Updated] (CALCITE-1921) Add DAY as Reserved Function Name, And add day() build-in scalar function

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sunjincheng updated CALCITE-1921: - Summary: Add DAY as Reserved Function Name, And add day() build-in scalar function (was: Add

[jira] [Updated] (CALCITE-1921) Add DAY as Reserved Function Name

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sunjincheng updated CALCITE-1921: - Description: http://jtc1sc32.org/doc/N2301-2350/32N2311T-text_for_ballot-CD_9075-2.pdf

[jira] [Created] (CALCITE-1921) Add DAY as Reserved Function Name

2017-08-02 Thread sunjincheng (JIRA)
sunjincheng created CALCITE-1921: Summary: Add DAY as Reserved Function Name Key: CALCITE-1921 URL: https://issues.apache.org/jira/browse/CALCITE-1921 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-1897) Support operator "%" as an alternative to "mod"

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16112078#comment-16112078 ] sunjincheng commented on CALCITE-1897: -- Hi [~julianhyde], I have opened the PR.

[jira] [Created] (CALCITE-1920) Add IS_NOT_NULL predicate on not-nullable equi-join keys

2017-08-02 Thread Ted Xu (JIRA)
Ted Xu created CALCITE-1920: --- Summary: Add IS_NOT_NULL predicate on not-nullable equi-join keys Key: CALCITE-1920 URL: https://issues.apache.org/jira/browse/CALCITE-1920 Project: Calcite Issue

[jira] [Resolved] (CALCITE-1919) NullPointerException when target in ReflectiveSchema belongs to unnamed (root) package

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-1919. -- Resolution: Fixed Fix Version/s: 1.14.0 Fixed in

[jira] [Updated] (CALCITE-1919) NullPointerException when target in ReflectiveSchema belongs to unnamed (root) package

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1919: - Summary: NullPointerException when target in ReflectiveSchema belongs to unnamed (root) package

[jira] [Commented] (CALCITE-1240) Avatica client written in Golang

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111771#comment-16111771 ] Julian Hyde commented on CALCITE-1240: -- The vote on general@incubator

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

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111521#comment-16111521 ] Julian Hyde commented on CALCITE-1917: -- Your query makes sense. I think we should do it. I see why

[jira] [Commented] (CALCITE-1918) Add support for Regular Expression Operators (RLIKE)

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111502#comment-16111502 ] Julian Hyde commented on CALCITE-1918: -- What's wrong with {{SIMILAR TO}}, which is standard and

[jira] [Commented] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111462#comment-16111462 ] Julian Hyde commented on CALCITE-1908: -- Yes, we should support implicit conversion, if that is what

[jira] [Commented] (CALCITE-1913) Include DB version in SqlDialect

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111432#comment-16111432 ] Julian Hyde commented on CALCITE-1913: -- Use your discretion and come up with a pull request. >

[jira] [Commented] (CALCITE-1919) NPE when target in ReflectiveSchema has no package was defined

2017-08-02 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111381#comment-16111381 ] Julian Hyde commented on CALCITE-1919: -- Reviewing now. > NPE when target in ReflectiveSchema has

[jira] [Commented] (CALCITE-1913) Include DB version in SqlDialect

2017-08-02 Thread Jess Balint (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16111236#comment-16111236 ] Jess Balint commented on CALCITE-1913: -- What would you suggest at this point? > Include DB version

[jira] [Commented] (CALCITE-1919) NPE when target in ReflectiveSchema has no package was defined

2017-08-02 Thread Lim Chee Hau (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16110730#comment-16110730 ] Lim Chee Hau commented on CALCITE-1919: --- I have created a PR here:

[jira] [Created] (CALCITE-1919) NPE when target in ReflectiveSchema has no package was defined

2017-08-02 Thread Lim Chee Hau (JIRA)
Lim Chee Hau created CALCITE-1919: - Summary: NPE when target in ReflectiveSchema has no package was defined Key: CALCITE-1919 URL: https://issues.apache.org/jira/browse/CALCITE-1919 Project: Calcite

[jira] [Commented] (CALCITE-1908) Mod function got exception in MOD(34.5,3), MOD(19,6.7) situation.

2017-08-02 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16110490#comment-16110490 ] sunjincheng commented on CALCITE-1908: -- Oracle supported implicit conversions, e.g.: MOD(11.6, 2)