[Bug?] Select * from Store as s <return>
paschott
Posts: 71 Bronze 4
Not sure how to categorize this. I don't think this is an option that I've missed, but this didn't happen in 3.x. When I type something like:
SELECT * FROM St -- and then autocomplete so it becomes:
Select * from Store as s
If I then hit ENTER to start a new line, the "as s" changes to "as SELECT" which I often don't catch right away. It works as expected if I hit a space after the "as s", but not if I hit ENTER.
Am I missing a setting here or should this be filed as a bug? I can consistently reproduce this on any table name that starts with an S, U, D, or I - each one of those will change to "SELECT", "UPDATE", "DELETE", or "INSERT" if I hit ENTER after the alias.
--Quick note - this seems to happen even when I take "ENTER" off of the keys that will auto-complete. I don't think I had that option turned off before, though.
SELECT * FROM St -- and then autocomplete so it becomes:
Select * from Store as s
If I then hit ENTER to start a new line, the "as s" changes to "as SELECT" which I often don't catch right away. It works as expected if I hit a space after the "as s", but not if I hit ENTER.
Am I missing a setting here or should this be filed as a bug? I can consistently reproduce this on any table name that starts with an S, U, D, or I - each one of those will change to "SELECT", "UPDATE", "DELETE", or "INSERT" if I hit ENTER after the alias.
--Quick note - this seems to happen even when I take "ENTER" off of the keys that will auto-complete. I don't think I had that option turned off before, though.
Comments
I was not able to replicate the issue.
Can you kindly email us your SQL Prompt settings at support@red-gate.com and I will generate a call reference for you and we can proceed from there?
Kindly let me know your view on this.
Note: Please include this forum link in your email.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com