how to get EXTRACT function working in CSVTest

hi experts, 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 ");

Re: SqlSpecialOperator.createCall method is overridden only for some nodes

Hi Julian, thanks for the reply. It's definitely not causing incorrect behavior and I guess it's better to leave it as is, since it may break other users code. If we'll return in SqlOperator.createCall SqlInsert instead SqlBasicCall class cast exception may occur for those who casted SqlCall to

RE: Null literals in AggregateReduceFunctionsRule

Thanks Julian for your reply! I created jira case[1] and I will try submit a pull request in near future. [1] https://issues.apache.org/jira/browse/CALCITE-1621 Regards, Anton Mushin -Original Message- From: Julian Hyde [mailto:jh...@apache.org] Sent: Tuesday, February 07, 2017 5:05

[jira] [Created] (CALCITE-1621) Adding a cast around the null literal in aggregate rules

Anton Mushin created CALCITE-1621: - Summary: Adding a cast around the null literal in aggregate rules Key: CALCITE-1621 URL: https://issues.apache.org/jira/browse/CALCITE-1621 Project: Calcite