Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
Description
According to this doc https://calcite.apache.org/docs/reference.html the EXTRACT function should work in Calcite. So I'm trying a query with EXTRACT in CSVTest:
@Test public void testSelectx() throws SQLException {
checkSql("model", "select extract(year from JOINEDAT) from EMPS ");
}
the query failed due to:
java.lang.ClassCastException: java.sql.Date cannot be cast to java.lang.Integer
I also tried to change column JOINDAT's type to timestamp and datetime, but end up with similar exceptions.
Attachments
Issue Links
- duplicates
-
CALCITE-1569 Code generation for fields of type java.sql.Date
- Closed
- relates to
-
CALCITE-1569 Code generation for fields of type java.sql.Date
- Closed