Bug in Sql Formatter

Bug in Sql Formatter

Postby hansjoergp » Thu 01 Jun 2017 05:37

If you format the following sql-statement I get the error "SQL3.sql: Error (41,1): '')'' expected"
SELECT ROUND ( 500
/ ( 2
/ 1
)
) test2
FROM dual

I think that this is also the problem in the Document outline window which does not display the correct outline
hansjoergp
 
Posts: 12
Joined: Wed 31 May 2017 14:33

Re: Bug in Sql Formatter

Postby alexa » Thu 01 Jun 2017 14:02

This is not the issue of dbForge. Oracle itself requires the row not to start with /. You have to bring / to the end of the previous row.
alexa
Devart Team
 
Posts: 2171
Joined: Fri 24 Jun 2011 14:17

Re: Bug in Sql Formatter

Postby hansjoergp » Tue 06 Jun 2017 06:09

The problem is that we have a lot of code which uses this style, because the formatter which we have used until now used this style....oracle executed this statements until now without any problems
hansjoergp
 
Posts: 12
Joined: Wed 31 May 2017 14:33

Re: Bug in Sql Formatter

Postby alexa » Tue 06 Jun 2017 08:48

Thank you for bringing this to our attention.

We will investigate this issue and will try to fix it in one of the next product versions.
alexa
Devart Team
 
Posts: 2171
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle