phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <>
Subject [jira] [Resolved] (PHOENIX-3347) Set conformance level to PhoenixSqlConformance
Date Tue, 08 Nov 2016 22:14:58 GMT


Maryann Xue resolved PHOENIX-3347.
    Resolution: Fixed

> Set conformance level to PhoenixSqlConformance
> ----------------------------------------------
>                 Key: PHOENIX-3347
>                 URL:
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Eric Lomore
>            Assignee: Maryann Xue
> Current conformance settings do not allow SELECT statements without a FROM clause. Either
need to change conformance or stop supporting SELECT without FROM as Phoenix currently does.
> According to the Calcite parser,
> {{FROM is mandatory in standard SQL, optional in dialects such as MySQL, PostgreSQL.
The parser allows SELECT without FROM, but the validator fails if conformance is, say, STRICT_2003.}}
> Based on, we are using ORACLE_10 conformance which
does not support this
> {code}setPropertyIfNotSpecified(
>                 info2,
>                 CalciteConnectionProperty.CONFORMANCE.camelName(),
>                 SqlConformance.ORACLE_10.toString()){code}
> Confirming this is the fact that it is specifically the SqlValidator throwing the exception
in relevant test cases
> {{Caused by: org.apache.calcite.sql.validate.SqlValidatorException: SELECT must have
a FROM clause}}

This message was sent by Atlassian JIRA

View raw message