7.1.0.88 bug
jsreynolds1
Posts: 94 Silver 2
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.
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.
Comments
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
I can confirm this is fixed in the latest release.
Best,
John