[
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)
