BUG : Beautifier removed [/] needed for model clause

[orca777]

PL/SQL-Developer 7.1.1.1339
Oracle 10.2

Hi Devteam,

I want of beautify a SQL statement with model clause. After this the brackets [ ] are removed.

SELECT Integer_Value AS MONTH
  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 12 INCREMENT 1 ] = Cv(Key))

After beautifying ...

SELECT Integer_Value AS MONTH
  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 12 Increment 1 = Cv(Key))

Karl

 

[Marco Kalter]

There is no explicit support for model clauses, but this if of course not right. We'll fix it.

 

[andyh]

Marco,

Do you have a plan for when this will be fixed?

 

[Marco Kalter]

This will be fixed in 8.0.