How can we help you today? How can we help you today?

New formatting styles - alignment after 'where exists' incorrect

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.
JoDouglass
0

Comments

3 comments

Sort by
  • 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.
    Russell D
    0
  • 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!
    James R
    0
  • JoDouglass
    Excellent, thanks for the updates!
    JoDouglass
    0

Add comment

Please sign in to leave a comment.