Red Gate forums :: View topic - SQL Prompt 6.4 beta (6.4.0.300 - 18th July)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

SQL Prompt 6.4 beta (6.4.0.300 - 18th July)

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Go to page 1, 2, 3  Next
Author Message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Wed Jun 04, 2014 10:42 am    Post subject: SQL Prompt 6.4 beta (6.4.0.300 - 18th July) Reply with quote

SQL Prompt beta 6.4.0.300 - 18th July 2014

The SQL Prompt beta includes:

  • insert semicolons (UserVoice)
  • execute current statement (UserVoice)
  • BEGIN...END block highlighting (UserVoice)
  • rename variables (UserVoice) and aliases (UserVoice)
  • improved support for aliases in UPDATE (UserVoice)
  • improved loading dialog box
  • startup performance improvement
  • single suggestion pop-up improvement
  • qualify object names improvements

Download this release

Full release notes


Version history
6.4.0.300 - 18th July

  • Comments are now preserved when completing ALTERs (UserVoice and Forum post)
  • Support for connecting as a user on contained database (Used to display "Login failed for user...")
  • Execute to cursor added as Ctrl+Shift+F5 (Forum post)

6.4.0.292 - 17th July

  • Fix for execute current statement not selecting the correct text (Forum post)
  • Execute current statement now works when connected to an Azure server
  • $USER$ snippet placeholder will now resolve to the connected user rather than the windows user
  • Caret stays in the same location after a Format SQL if positioned at start of line (Forum post)

6.4.0.286 - 16th July

  • Scroll position is now maintained after applying Format SQL (Forum post)
  • Fix for ON being misaligned if table hints are used in a join clause (UserVoice)

6.4.0.284 - 16th July

  • No longer freezes when disabling/enabling suggestions during a database load

6.4.0.282 - 15th July

  • Generated aliases are now enclosed in square brackets if option set (UserVoice)
  • If enclose square brackets is off Prompt will avoid generating aliases that match keywords
  • Qualify object names and apply casing options are now only applied to the selected text (rather than entire line)

6.4.0.279 - 14th July

  • Added an option to limit the maximum script size that tab history will save (defaults to 1MB)
  • Fixes for qualify object names with columns (Forum post)

6.4.0.266 - 10th July

  • Added Alt+Shift+F5 to execute current batch (this is in addition to Shift+F5 to execute current statement)
  • Columns and datatypes in object definition box are now sortable (Forum post)
  • Fix for too many suggestions (Forum post)

6.4.0.256 - 7th July

  • Snippet manager now keeps edited and created snippets in view after refreshing list
  • Database loading dialog now has a tooltip on hover to show database names when multiple databases are loading

6.4.0.255 - 3rd July

  • Reduced locking on UI thread during database loading (hopefully fixing the forum post below)

6.4.0.249 - 3rd July

  • Generated comments are placed on the same line as data in INSERT statements if "Place commas at start" has been set (UserVoice and UserVoice)

6.4.0.245 - 2nd July

  • Minor fix for default schema syntax on system databases having too many suggestions
  • Character limit removed from create snippet text box
  • Qualify object names improvements:

    • New option for qualifying with aliases (UserVoice)
    • Changes are now highlighted
    • No longer displays errors if temporary tables are created in the script
    • Now uses the existing suggestion cache rather than recaching some objects
    • Will replace table qualification with its alias if table has been aliased


6.4.0.206 - 23rd June

  • INSERT and SELECT formatting tweak is now optional (Forum post)
  • Column suggestions are now displayed for a table alias rather than a table of the same name (Forum post)

6.4.0.204 - 20th June

  • Parameter info tooltip is now only displayed after typing (or with the shortcut ctrl+shift+space) and can be hidden with escape
  • Fix for columns suggestions not filtered by alias (Forum post)
  • Table keyword now cased as a datatype in declare statements and table valued functions (Forum post)

6.4.0.184 - 9th June

  • Fix for some assemblies not being digitally signed correctly (causing false positives with anti-virus software)

6.4.0.177 - 9th June

  • Rename alias improvements
  • Now hides green highlights after inserting semicolons if suggestions are disabled
  • Support for suggestions using default schema syntax (eg "master..sp_help")
  • System objects shown if fully qualified to system database
  • SSMS built in intellisense disabled on startup if prompt is enabled (Forum post)
  • INSERT and SELECT formatting tweak (Forum post)

6.4.0.167 - 4th June

  • No longer throws exception with connection coloring in certain circumstances

6.4.0.165 - 4th June

  • Initial release


Feedback
If you have any problems with this release, please post them on this forum.

If you have any suggestions for improvements, please post them on our suggestions forum so other users can vote for them.


Last edited by Aaron Law on Fri Jul 18, 2014 2:09 pm; edited 28 times in total
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Wed Jun 04, 2014 11:12 am    Post subject: Reply with quote

For users of the connection coloring feature: it's now possible to tweak the colors or add new categories by changing
Code:
%localappdata%/Red Gate/SQL Prompt 6/ConnectionColoringCategories.xml

Editing xml files obviously isn't ideal and we are hoping to have a UI to edit these but the first step towards that is getting them loaded from a file which is in this build.
Back to top
View user's profile Send private message
KevinGreiner



Joined: 05 Mar 2012
Posts: 19
Location: United States

PostPosted: Thu Jun 19, 2014 7:41 pm    Post subject: Reply with quote

In this release, SQL Prompt doesn't scroll the suggestion popup list based on the table alias.

Given the following code, what would you expect the suggestion popup to contain?

select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID

I would expect the suggestion list to contain only b.* columns. But it doesn't. Instead, I am shown both a.* and b.* columns. At a minimum, the suggestion list should be scrolled to the first b.* column.

When working with SQL that contains many joins and table alias, this bug means that I need to lift my hands off the keyboard and scroll the list with the mouse. It's not very efficient.

Kevin
Back to top
View user's profile Send private message
David Priddle



Joined: 28 Jan 2014
Posts: 36
Location: Red Gate Software, Cambridge

PostPosted: Fri Jun 20, 2014 1:07 pm    Post subject: Reply with quote

Hi Kevin,

Thanks for finding this for us!

We've fixed this in the latest beta build (6.4.0.204). You can either download it from the download link in this post, or through Check for Updates.

Please let us know if this works for you, and if you find any more problems.

Best regards,

David
Back to top
View user's profile Send private message Send e-mail
KevinGreiner



Joined: 05 Mar 2012
Posts: 19
Location: United States

PostPosted: Fri Jun 20, 2014 1:28 pm    Post subject: Reply with quote

Thanks, David. The suggestion list is populated as expected with the 204 beta.
Back to top
View user's profile Send private message
KevinGreiner



Joined: 05 Mar 2012
Posts: 19
Location: United States

PostPosted: Fri Jun 20, 2014 1:58 pm    Post subject: Reply with quote

OK, I found another problem. Using the same example,

select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID

If a table named [b] exists in the current database, only the columns of that table will be suggested. The columns of the table alias "b" are not shown.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Fri Jun 20, 2014 2:43 pm    Post subject: Reply with quote

Hi Kevin,
I'm looking into recreating this now but I don’t think I'm seeing the same behaviour as you, in the example you've listed I get suggestions from TableB:



Can you think of anything else that might help us reproduce your issue here?

Thanks,
Aaron.
Back to top
View user's profile Send private message
KevinGreiner



Joined: 05 Mar 2012
Posts: 19
Location: United States

PostPosted: Fri Jun 20, 2014 3:35 pm    Post subject: Reply with quote

Looks like the suggestions for the first field are fine. It's the second field that is wrong.

Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Fri Jun 20, 2014 3:42 pm    Post subject: Reply with quote

Thanks Kevin! I can recreate it fine here with the second field, I'll see what we can do about a fix for this.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Mon Jun 23, 2014 3:09 pm    Post subject: Reply with quote

Hi Kevin,

This should be fixed in the latest beta build (6.4.0.206) - thank you for the awesome repro steps!
Back to top
View user's profile Send private message
KevinGreiner



Joined: 05 Mar 2012
Posts: 19
Location: United States

PostPosted: Wed Jul 02, 2014 6:18 pm    Post subject: Reply with quote

I notice a lag of 2-3 seconds after using Ctrl-Shift-D to refresh suggestions.

I would like to enable auto-refresh of the suggestion but this lag makes it quite painful when the SSMS UI freezes for 2-3 seconds. This is a development db with several devs making changes.

Here are the counts of objects in the current database.

74 CHECK constraints
2405 Default or DEFAULT constraints
432 FOREIGN KEY constraints
3 Inlined table-functions
1925 PRIMARY KEY or UNIQUE constraints
69 Scalar functions
1399 Stored procedures
67 System tables
12 Table functions
17 Triggers
2124 User tables
305 Views
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Thu Jul 03, 2014 9:09 am    Post subject: Reply with quote

Hi Kevin,

I'm having difficulty recreating this here. Prompt should start up a thread for refreshing suggestions to avoid locking the UI, but it sounds like it's going wrong somewhere for you.
I'm think it's not solely related to database size since I've given it a go on one of our giant test databases (~180,000 procs and ~20,000 tables)
To help narrow it down:
1. Is this issue new in 6.4 (I'm wondering if it's related to the loading dialog changes we've made) or does it lock up in 6.3 too?
2. Is it only on that database/server or does it lock up even if connecting to a local instance?

Thank you!
Aaron.
Back to top
View user's profile Send private message
KevinGreiner



Joined: 05 Mar 2012
Posts: 19
Location: United States

PostPosted: Thu Jul 03, 2014 2:36 pm    Post subject: Reply with quote

I'm fairly certain this issue is new. I love the new loading dialog and that it's placed at a consistent place on the screen.

The UI freeze is before the dialog is shown. As soon as the small window appears, the UI is responsive again.

I'm unable to reproduce locally even with a large number of objects. Typically, I work remotely, using db servers remotely via VPN connections.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 189
Location: Red Gate Software

PostPosted: Thu Jul 03, 2014 3:50 pm    Post subject: Reply with quote

It does sound like it's related to a slow connection, although I'm still struggling to recreate it here even over a slower connection.

I've had an attempt at reducing the amount of work we do on the UI thread with the progress dialog which might reduce the UI lock up - could you see if 6.4.0.255 helps?
Back to top
View user's profile Send private message
jmeyer



Joined: 05 Jun 2009
Posts: 15

PostPosted: Fri Jul 11, 2014 3:17 pm    Post subject: Reply with quote

Control-B, Control-Q does not work if I try to format an INSERT INTO table() SELECT columns FROM table1 WHERE condition statement.
I'm also having problems qualifying object names when there are linked server in the query. This one predates SQL Prompt 6.4 beta.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page 1, 2, 3  Next
Page 1 of 3

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group