search

edp963 / davinci

Davinci is a DVsaaS (Data Visualization as a Service) Platform
https://edp963.github.io/davinci
Apache License 2.0
4.91k stars 1.82k forks source link

SQL syntax is not supported (as shown in the figure) #2121

Open HongXiang1314 opened 3 years ago

HongXiang1314 commented 3 years ago

select from ( with tv as ( select from dual ) select from tv) union
select from (with tv as ( select from dual ) select from tv)

scottsut commented 3 years ago

Please post the error message.

HongXiang1314 commented 3 years ago

StatementCallback; bad SQL grammar [with tv as ( select from dual ) select from tv) union select from (with tv as ( select from dual ) select from ( select from tv)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束 1