Beautifier: HAVING clause not beautified

[braykov]

The HAVING clause is not beautified.
I presume it should be beautified like the WHERE clause but it isn't.
And the beautifier window does not have separate setting for HAVING.

Build 1362

 

[Marco Kalter]

Can you give an example?

 

[braykov]

Sure:

SELECT x
      ,COUNT(x)
  FROM Table_x t
 WHERE 1 = 1
   AND 2 = 2
 GROUP BY x
HAVING x > 10 AND x < 20

This is beautified. Observe how both where clauses fall on different rows, but the having - doesn't.
And with bigger queries it piles on a loooong row

 

[Sachin]

I agree. It does not beautify the having clause even in release 7.1.2.1363.
Please fix this, cannot use the beautify feature if this is not fixed.

 

[Marco Kalter]

Okay, I see what you mean. We'll enhance this.