Beautifier bug

[AVP]

Code:

with t as (select 1 as n from dual) select 1 from dual union all select 1 from t where t.n = 1 and t.n > 5

Result:

with t as
 (select 1 as n from dual)
select 1
from dual
union all
select 1
from t
where t.n = 1 and
 t.n > 5

Wrong identation on the last line.
Can't reproduce bug without "with" subquery or 1st part of the union.

My preferences:

Spoiler

Version=1
RightMargin=120
Indent=2
UseTabCharacter=FALSE
TabCharacterSize=2
AlignDeclarationGroups=TRUE
AlignAssignmentGroups=TRUE
KeywordCase=0
IdentifierCase=0
UseSpecialCase=TRUE
ItemList.Format=1
ItemList.Align=TRUE
ItemList.CommaAfter=TRUE
ItemList.AtLeftMargin=FALSE
EmptyLines=2
ThenOnNewLine=TRUE
LoopOnNewLine=TRUE
DML.LeftAlignKeywords=TRUE
DML.LeftAlignItems=FALSE
DML.OnOneLineIfPossible=TRUE
DML.WhereSplitAndOr=TRUE
DML.WhereAndOrAfterExpression=TRUE
DML.WhereAndOrUnderWhere=FALSE
DML.JoinSplitBeforeOn=FALSE
DML.InsertItemList.Format=1
DML.InsertItemList.Align=FALSE
DML.InsertItemList.CommaAfter=TRUE
DML.InsertItemList.AtLeftMargin=FALSE
DML.SelectItemList.Format=2
DML.SelectItemList.Align=TRUE
DML.SelectItemList.CommaAfter=TRUE
DML.SelectItemList.AtLeftMargin=FALSE
DML.UpdateItemList.Format=1
DML.UpdateItemList.Align=TRUE
DML.UpdateItemList.CommaAfter=TRUE
DML.UpdateItemList.AtLeftMargin=FALSE
ParameterDeclarationList.Format=1
ParameterDeclarationList.Align=TRUE
ParameterDeclarationList.CommaAfter=TRUE
ParameterDeclarationList.AtLeftMargin=FALSE
RecordFieldList.Format=1
RecordFieldList.Align=TRUE
RecordFieldList.CommaAfter=TRUE
RecordFieldList.AtLeftMargin=FALSE
SplitAndOr=TRUE
AndOrAfterExpression=TRUE
[SpecialCase]

PL/SQL Developer Version 12.0.1.1814 (32 bit)

 

[Marco Kalter]

That is indeed not quite right. We'll fix it.