Complex SQL shows error in SQL editor

Changed Resolution from Open to Works as Designed

Changed Status from New to Feedback Requested

Changed Assigned User from - to @User_306070

---

Just ignore the error and save your report. It should execute OK. I think there was a clause in the manual about query editor showing error in complex queries because Studio can't syntax check all possibilities.

Changed Assigned User from @User_306070 to @mrabbi

---

The SQL editor is not a complex editor for all kind of SQL dialects. For that kind of tasks there are many softwares out there. It is meant to help users in writing SQL queries that are supposed to be used in their report.Like Hozawa said, it's possible that complex queries might not be fully recognized. But you can save them anyway. Same as for the Expression Editor. In the last months we worked in enhancing the support to different user requests in order to make it more complete as possible.If you provide an example of the query that is giving you the error, we can take a look and see if the modifications to the current grammar is possible.Please provide also information about which is the target DBMS (i.e. Oracle, MySQL, Postgres).Regards,Massimo.

Changed Resolution from Works as Designed to Open

Changed Assigned User from @mrabbi to @chicuslavic

---

I added some syntax support for oracle analytical functions and (+) operator in version 6.0

 

however we do not support all SQL dialects and don't validate the query against the database, it's just a basic sql select

Changed Resolution from Open to Fixed

Changed Status from Feedback Requested to Resolved

---