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

[Bug?] Select * from Store as s <return>

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

Comments

1 comment

Sort by
  • Anu D
    Many thanks for your post.

    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.
    Anu D
    0

Add comment

Please sign in to leave a comment.