[
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)
