Wei Hu created CALCITE-986:
------------------------------
Summary: Scalar Function for UDF problem when argument type is
Date or Timestamp
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, 1.4.0-incubating
Reporter: Wei Hu
Assignee: Julian Hyde
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)
