[17.1.391] Formatter error?

Toad for Oracle - Beta
1

When I format the following statement, it looks as expected with my settings:

BEGIN
   DELETE FROM table_name
         WHERE column_name IN (SELECT *
                                 FROM DUAL
                                WHERE 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' = 'X');
END;
/

However, the following statement is not formatted correctly in my opinion:

BEGIN
   DELETE FROM
      table_name
         WHERE column_name IN
                  (SELECT column_name FROM TABLE(table_function('XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX')));
END;
/

I would expect this:

BEGIN
   DELETE FROM table_name
         WHERE column_name IN (SELECT column_name 
                                 FROM TABLE(table_function('XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX')));
END;
/

The right margin is set to 120 in the formatter options.

FmtPlus.opt.txt (1.2 KB)

2

Hello Dirk,

You're fully right, I fixed it (QP-4133).
It will appear in component QP5.dll as of version 5.404.

Thanks for reporting!
Andre