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:
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