[PHOENIX-836] Cast syntax is not in line with standard SQL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Unassigned
• Reporter: Gabriel Reid
• Created: 11/Mar/14 20:59
• Updated: 12/Mar/14 23:53
• Resolved: 12/Mar/14 23:53

Description

It seems the cast syntax in Phoenix is not in line with SQL-92/99 (1), as well as other common SQL databases (2 & 3).

A typical cast statement in SQL is written as

SELECT CAST(ID AS INTEGER) FROM MYTAB;

but this leads to a parse error in Phoenix. Instead, Phoenix expects cast statements to be written as follows (I believe the parentheses are optional here)

SELECT (CAST ID AS INTEGER) FROM MYTAB;

(1) http://savage.net.au/SQL/sql-99.bnf.html#cast%20specification
(2) http://docs.oracle.com/javadb/10.8.2.2/ref/rrefsqlj33562.html
(3) http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html#function_cast