empty line when formatting a model with no rules keyword

Toad for Oracle - Beta
1

Hi !

The “RULES” keyword is mandatory if you iterate otherwise it is optional. Plain SELECT statements shall not have blank lines.

DEMO:

select*from dual model dimension by(1 x)measures(1 y)rules(y[2]=314);

formats well but …

select*from dual model dimension by(1 x)measures(1 y)(y[2]=314);

Generates an empty line

/* Formatted on 24/06/2013 13:25:45 (QP5 v5.252.13127.32847) */
SELECT *
FROM DUAL
MODEL
DIMENSION BY (1 x)
MEASURES (1 y)

(y [2] = 314);

I have posted the question per email a few weeks ago too, sorry for multiposting. It probably ended up in some spam folder…

2

I’m still working on this one. The model clause is fairly complex and the “generalized” fix takes a bit of time …

Andre