[CALCITE-1629] EXTRACT function not working in CSVTest

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.12.0
• Assignee: Julian Hyde
• Reporter: Hongbin Ma
• Created: 10/Feb/17 06:06
• Updated: 29/Apr/19 17:14
• Resolved: 15/Apr/17 00:25

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.

Issue Links

• duplicates: CALCITE-1569 Code generation for fields of type java.sql.Date
• relates to: CALCITE-1569 Code generation for fields of type java.sql.Date