[jira] [Updated] (CALCITE-986) User-defined function with Date or Timestamp parameters

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

     [ https://issues.apache.org/jira/browse/CALCITE-986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde updated CALCITE-986:
--------------------------------
    Affects Version/s:     (was: 1.4.0-incubating)

> User-defined function with Date or Timestamp parameters
> -------------------------------------------------------
>
>                 Key: CALCITE-986
>                 URL: https://issues.apache.org/jira/browse/CALCITE-986
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.3.0-incubating
>            Reporter: Wei Hu
>            Assignee: Julian Hyde
>             Fix For: 1.6.0
>
>
> the field type is date  and I want to realize the MY_FUNC(date)
> I use JavaTypeFactory.createSqlType to define the columns
> *SQL : select MY_FUNC(date)  from table;*
> if I set my function's argument type to java.sql.Date, calcite will report Exception:
> _/Caused by: org.codehaus.commons.compiler.CompileException: Line 124, Column 45: No applicable constructor/method found for actual parameters "int"; /_
> if I set the function's argument type to  int, calcite will report Exception:
> _/Caused by: org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature MY_FUNCTION(<DATE>)/



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