You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/11 22:00:44 UTC
[jira] [Created] (PHOENIX-836) Cast syntax is not in line with
standard SQL
Gabriel Reid created PHOENIX-836:
------------------------------------
Summary: Cast syntax is not in line with standard SQL
Key: PHOENIX-836
URL: https://issues.apache.org/jira/browse/PHOENIX-836
Project: Phoenix
Issue Type: Bug
Reporter: Gabriel Reid
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
{code}
SELECT CAST(ID AS INTEGER) FROM MYTAB;
{code}
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)
{code}
SELECT (CAST ID AS INTEGER) FROM MYTAB;
{code}
(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
--
This message was sent by Atlassian JIRA
(v6.2#6252)