Suggestion Order Changes
MikeyC
Posts: 249 Bronze 3
I am using SQL Prompt 4.0.3.12 and have noticed that the order of the suggestions changes when it shouldn't.
For instance try this:
When you get the suggestions at this point the backupfile suggestion is all the way at the bottom of the table list, it is no longer in alphabetical order. It is very annoying that you can't predict where a suggestion is going to be.
For instance try this:
SELECT * FROM msdb.dbo.backupfile B INNER JOIN msdb.dbo.<cursor>
When you get the suggestions at this point the backupfile suggestion is all the way at the bottom of the table list, it is no longer in alphabetical order. It is very annoying that you can't predict where a suggestion is going to be.
Comments
The reason the table is at the bottom of the list is because once you have referenced a table, SQL Prompt assumes that it's the last table you would want to reference again. I guess they didn't think about self joins
I have logged this as a bug with SQL Prompt 4. Hopefully it will be addressed in a future version.
For your reference the bug tracking code for this issue is SP-2882.