New formatting styles - alignment after 'where exists' incorrect

JoDouglass

First off, thanks for the new formatting styles - they're excellent, and I'm now able to get very close to how I prefer to write SQL. However, I have noticed an issue.

I use the "right aligned to statement" clause alignment option, and I've noticed that after a 'where exists', any 'and' clauses get lined up with the word 'exists' rather than with 'where'.

This behaviour isn't replicated if you have a 'where' clause followed by an 'and exists'; in this case, the 'where' and the 'and' line up, as I would expect.

Russell D

Hi @JoDouglass thanks for reporting this, it's been raised as an issue, and I'll update you when I have more information.

James R

Hi @JoDouglass,

Just to let you know we've found a fix for this issue - it's a known bug with the Microsoft SQL Parser we use in SQL Prompt. We'll hopefully have it released in a few days

Thanks!

JoDouglass

Excellent, thanks for the updates!