7.1.0.88 bug

jsreynolds1jsreynolds1 Posts: 55 Bronze 2
edited October 20, 2015 4:28PM in SQL Prompt
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

Comments

Sign In or Register to comment.