[PHOENIX-3350] Enable utility functions for SELECT queries

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Eric Lomore
• Reporter: Eric Lomore
• Created: 05/Oct/16 18:12
• Updated: 06/Oct/16 23:50
• Resolved: 06/Oct/16 23:50

Description

Some functions such as TO_DATE & TO_CHAR are breaking in SELECT statements. These functions do however work in DDL statements such as create view.

"SELECT * FROM t WHERE k1 = TO_DATE(TO_CHAR(CURRENT_DATE())"
org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature TO_DATE()

But once wrapped in a DDL statement, it executes fine:
"CREATE VIEW v AS SELECT * FROM t WHERE k1 = TO_DATE(TO_CHAR(CURRENT_DATE())