All,
I'm currently on Toad 12.8.0.25.
The formatter is generating an incorrect indent for the second when clause in the following case statement (which is part of a Multi-column by order by clause):
case /* Relevance of database */
when prm.database_name = g_my_database_name then 99999 -- exact match
--**!! when prm.database_name = g_my_database_group then 99000 -- group match
when prm.database_name = '-' then 0 -- irrelevant
else length(translate(prm.database_name, '.%', '.')) -- the more precise the name, the higher the ranking
end desc
After formatting it looks like this:
As you (hopefully) can see, the when clause that follows the comment line is insufficiently indented.
After uncommenting the commented-out when clause and reformatting I get correctly aligned when clauses:
Since I've been having problems posting this issue, I'll attach the formatter file later...