Toad World® Forums

Formatting SQL error


#1

The formatting tool has a problem when you have a hint and a comment using --+. If you try to format the following query, you will get an error: UNRECOGNIZED CONSTRUCT OR SYNTAX ERROR
**
SELECT** /*+ RULE */

  •   --+ comment*      *
    

FROM DUAL

Thanks.
-Charlie


#2

Spot on! I will raise enhancement request for Formatter developers on your behalf.

Rgds,
Andrew


#3

Hey Charlie,

This bug has been addressed in the new QP5 formatter. You can test it on the new 6.1 beta when it’s ready.

Gwen