Bug: Ctrl+Enter after sql keyword jumbles text

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Bug: Ctrl+Enter after sql keyword jumbles text

Postby noodle » Mon Dec 23, 2013 8:50 pm

Howdy,

When I used Ctrl+Enter with my cursor against a sql keyword, the keyword gets jumbled. Depending on the keyword, there must be text above the cursor's line for this to happen.

Example:


Code: Select all
SELECT
*
FROM
sys.objects AS o
WHERE name LIKE '%z%'
GROUP BY| -- cursor here

/* results in */

SELECT
*
FROM
sys.objects AS o
WHERE name LIKE '%z%'

GROUBYBY



Thanks!
-Noodle
noodle
 
Posts: 1
Joined: Mon Dec 23, 2013 8:44 pm

Postby Aaron Law » Tue Dec 24, 2013 11:35 am

Wow that’s pretty odd, thanks for pointing this out and providing the reproduction steps. I'll look into seeing if I can figure out why it's doing that.

Thanks,
Aaron.
Aaron Law
 
Posts: 252
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby Aaron Law » Tue Dec 24, 2013 1:37 pm

I think I have a fix for you in this private build - We didn't take into account that you can insert a newline before the caret when changing the case of a keyword.

Out of curiosity which build are you currently using? (I had to set my keywords to lowercase to reproduce it on 6.2 since prompt should have left "BY" alone as it's already in uppercase)
Aaron Law
 
Posts: 252
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 1 guest