Beautifier mangles query with model clause

[PaoloM]

Hello,
I noticed that if I try to beautify a SQL query that uses the MODEL clause, the beautifier will remove the square bracket characters, so that its syntax becomes invalid. I tried it with the following query:

select integer_value
from dual
where 1=2
model
dimension by ( 0 as key )
measures ( 0 as integer_value )
rules upsert ( integer_value[ for key from 1 to 10 increment 1 ] = cv(key) )

and I am using PSD version 7.1.5.1398.

Thanks,
Paolo

 

[Marco Kalter]

This is indeed a known restriction. It's on the to-do list.

 

[Claus Pedersen]

This is also present in V8.

IMHO, this is not a known restriction, this is a bug. The beautifier must only manipulate with white spaces (space, tab and line feeds), not with any other character.