fangyc created CALCITE-3018: ------------------------------- Summary: User defined scalar function which returns a Date/Timestamp value causes error. Key: CALCITE-3018 URL: https://issues.apache.org/jira/browse/CALCITE-3018 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.19.0 Reporter: fangyc
I've defined a user defined function that returns a date or timestamp and register it on root schema : {quote} public static java.sql.Date test(long value) { return new java.sql.Date(value); } {quote} {quote}rootSchema.add("my_test", ScalarFunctionImpl.create(CalciteTest.class, "test")); {quote} If I use this function in the select part of a query as the only column, the result works fine: {quote}select my_test(1) from northwind.product {quote} However, if I add an additional column in the select part, the error occurs: {quote}select my_test(1), 2 from northwind.product {quote} Error message: {quote} Exception in thread "main" java.lang.ClassCastException: java.sql.Date cannot be cast to java.lang.Number at org.apache.calcite.avatica.util.AbstractCursor$NumberAccessor.getNumber(AbstractCursor.java:726) at org.apache.calcite.avatica.util.AbstractCursor$DateFromNumberAccessor.getDate(AbstractCursor.java:915) at org.apache.calcite.avatica.AvaticaSite.get(AvaticaSite.java:326) at org.apache.calcite.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:393) {quote} I tried with calcite.debug=true, and the difference seems as follows: * 1 column {quote}/* 51 */ public Object current() { /* 52 */ return org.apache.calcite.runtime.SqlFunctions.toIntOptional(CalciteTest.test(1)); /* 53 */ } {quote} * 2 columns {quote}/* 51 */ public Object current() { /* 52 */ return new Object[] { /* 53 */ CalciteTest.test(1), /* 54 */ 2}; /* 55 */ } {quote} -- This message was sent by Atlassian JIRA (v7.6.3#76005)