Toad World® Forums

Formatter indents first column in column list incorrectly when a hint is present

All,

When I put a hint in a select statement, the first line after the hint gets indented incorrectly.
Here is the sample query to show the effect:

select table_name, tablespace_name
from all_tables
where owner = ‘STOCK_STATS’
order by 1, 2;

The example below how this query is formatted with/without a hint:

Formatter_indent_after_hint.png

This is not new for version 12.7. The issue has existed at least since 12.1.
But: can it be resolved? To me it looks like an error.

BTW: any comment between the select comment and the first column definition
will result in this effect. It does not need to be a real hint.

My formatter options are as follows:

252 5.266.0 5.273 2 2 140 2 2 2 2 1 1 1 2 1 0 2 0 1 0 0 0 S 1 1 1 S 1 1 1 SO 1 1 S 1 S 1 1 1 S 1 1 1 S S 1 1 1 1 1 1 3 1 1 S S 1 1 S 1 1 S 1 1 1 1 SO 99 1 1 SO 1 1 1 2 0 by Toad formatter

Kind regards,
Abe Kornelis.

Thanks for the info. I logged it (QP-856).

Andre