[
https://issues.apache.org/jira/browse/CALCITE-4916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17452696#comment-17452696
]
xuyang commented on CALCITE-4916:
---------------------------------
Hi ,[~julianhyde] ,here are some issues existed:
# CALCITE-3463
# CALCITE-3051
# CALCITE-1648
# CALCITE-35 // the 1,2,3 above is related to CALCITE-35
# CALCITE-1131
# CALCITE-3038
# CALCITE-2152
The sql following can produce this kind of message "Non-query expression
encountered in illegal context":
# "select * from (emp)"
# "select 1 from emp union 2 + 5"
# "select * from (emp) as x"
# "select * from (emp as x)"
# "create table x (i int not null) as b". (the one of correct sql can be
"create table x (i int not null) as +*table*+ b")
# ......
> Need more exception information about "Non-query expression encountered in
> illegal context"
> -------------------------------------------------------------------------------------------
>
> Key: CALCITE-4916
> URL: https://issues.apache.org/jira/browse/CALCITE-4916
> Project: Calcite
> Issue Type: Improvement
> Reporter: xuyang
> Priority: Major
>
> As a user, in most cases I was confused with the exception with "Non-query
> expression encountered in illegal context", and re-check my entire sql even
> if the sql is too long. I see some issues about this exception have been
> existed. The root cause is that the exception lacks some necessary
> information such as position and expected sequences following. So, maybe the
> exception information can be improved to be more clear to users.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
