[jira] [Commented] (CALCITE-943) gt operator not implemented for java.sql.Timestamp

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14978987#comment-14978987 ] 

Julian Hyde commented on CALCITE-943:
-------------------------------------

I created a test case; see https://github.com/julianhyde/calcite/tree/943-gt-timestamp-bind. It only seems to occur when bind variables are involved.

> gt operator not implemented for java.sql.Timestamp
> --------------------------------------------------
>
>                 Key: CALCITE-943
>                 URL: https://issues.apache.org/jira/browse/CALCITE-943
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.4.0-incubating
>         Environment: jdk 1.8.0_20 linux mint 17.2
>            Reporter: Anıl Chalil
>            Assignee: Julian Hyde
>            Priority: Minor
>
>  when i run that query
> "select * from TEST.timeseries where tarih > ? and tarih < ? "
> where tarih column has type timestamp from csv like
> tarih:timestamp,sensor:string,temp:int
> 2015-10-26 10:51:36,sensor67,88
> 2015-10-26 10:51:36,sensor89,96
> 2015-10-26 10:51:36,sensor91,88
> 2015-10-26 10:51:36,sensor35,80
> 2015-10-26 10:51:36,sensor37,84
> 2015-10-26 10:51:36,sensor15,96
> it throws
> Caused by: java.lang.NoSuchMethodException:
> org.apache.calcite.runtime.SqlFunctions.gt(java.sql.Timestamp,
> java.sql.Timestamp)
>    at java.lang.Class.getMethod(Class.java:1773)
>    at org.apache.calcite.linq4j.tree.Types.lookupMethod(Types.java:337)
> Seems like gt function does not support Timestamps.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)