[jira] [Resolved] (PHOENIX-564) Issue with SQL parser

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-564.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Issue with SQL parser
> ---------------------
>
>                 Key: PHOENIX-564
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-564
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: bennychow
>
> Phoenix is unable to parse this having clause:  
> select
> "WEB_STAT_ALIAS"."DOMAIN" as "c0"
> from "WEB_STAT" "WEB_STAT_ALIAS"
> group by "WEB_STAT_ALIAS"."DOMAIN" having
> (
>    (
>       NOT
>       (
>          (sum("WEB_STAT_ALIAS"."ACTIVE_VISITOR") is null)
>       )
>       OR NOT((sum("WEB_STAT_ALIAS"."ACTIVE_VISITOR") is null))
>    )
>    OR NOT((sum("WEB_STAT_ALIAS"."ACTIVE_VISITOR") is null))
> )
> order by CASE WHEN "WEB_STAT_ALIAS"."DOMAIN" IS NULL THEN 1 ELSE 0 END,
> "WEB_STAT_ALIAS"."DOMAIN" ASC
> Error: ERROR 603 (42P00): Syntax error. Mismatched input. Expecting "RPAREN", got "is" at line 9, column 50.
> SQLState:  42P00
> ErrorCode: 603
> I noticed that if you remove all instances of the NOT keyword, then Phoenix is able to parse this SQL.



--
This message was sent by Atlassian JIRA
(v6.2#6252)