I typically format things without looking. This one took us about 15 min to figure out what had happened.

It is a delete clause at heart. When SQL prompt formatted it, it made some odd assumptions for joins which weren't there if we changed it simply to a select.
Both top and bottom have been formatted. The bottom you can see the changes it just made (incorrectly) in green.
Note that this is a table joining itself again on a different column.

NKJEf4p.png
jsreynolds1
0

Comments

2 comments

  • David Priddle
    Hi John,

    Thanks for picking this up! We've just put out a new beta build which should fix this issue for you. It can be downloaded through Check for Updates or through the beta forum post.

    Please let me know if you have any problems.

    Best regards,

    David
    David Priddle
    0
  • jsreynolds1
    David,

    I can confirm this is fixed in the latest release.

    Best,

    John
    jsreynolds1
    0

Add comment

Please sign in to leave a comment.