Beautifier

[Dan Kraemer]

Can the beautifier move the "AND" conditions to the left side and also keep one "AND" condition per line? Also, can it ident expresssions in parenthesis instead of just wrapping? See example below. Finally, it looks like hints throw it off as well.

Thanks,

Dan

SELECT /*+ first_rows index( cc aps_pk )*/
COUNT(*)
1,
2,
3
FROM AU_DAILY_SHIFTS aa,
AU_PARTIAL_DAILY_XREFS bb,
AU_ALL_PARTIAL_SHIFTS cc
WHERE bus_day = idt
AND aa.aast1_aast1_id = gc_att_shift_typ
AND aa.aas_id = bb.aas_aas_id
AND cc.aps_id = bb.aps_aps_id
AND ( (1 = 1)
OR (2 = 2)
);

 

[Marco Kalter]

It's on the to-do list for 6.0.

 

[Ben]

Originally posted by Marco Kalter:
It's on the to-do list for 6.0.

SQL 'hints' still seem to throw the version 6.0.3 beautifier.

Was this missed? Or is there a setting that I have not spotted ?

Thanks,
Ben

 

[Marco Kalter]

What exactly goes wrong?

 

[Ben]

Hi,

If I add a hint the Beautifier can not align the columns in the selection criteria:

SELECT /*+ ORDERED */
COLUMN1,
COLUMN2
FROM TEST_TAB

It only works this SQL if I remove the hint:

SELECT COLUMN1,
COLUMN2
FROM TEST_TAB

This is on Version 7.0.1.1066 (MBCS).

Please comment.

Thanks,

Ben

 

[Marco Kalter]

Hmm, I guess this still is not correct. We'll fix it.