SQL Prompt mangles statements when certain key combinations

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt mangles statements when certain key combinations

Postby blitzd » Mon Jan 28, 2013 10:32 pm

...occur.

An example:

Code: Select all
INSERT INTO admin.TestTable
        ( ID ,
          TestColumn ,
          TestColumnDateTime
        )
VALUES  ( 0 , -- ID - int
          '' , -- TestColumn - char(10)
          '2013-01-28 21:19:58'  -- TestColumnDateTime - datetime
        )


I have the 0 (ID) highlighted so that I can alter it, it hit 1 and then in very quick succession the down key to start editing the TestColumn value, and I get this:

Code: Select all
INSERT INTO admin.TestTable
        ( ID ,
          TestColumn ,
          TestColumnDateTime
        )
VALUES  ( 1 , -- ID - int
          ' , -- TestColumn - char(10)
          '2013-01-28 21:19:58'  -- TestColumnDateTime - datetime
        )

The closing quote of the TestColumn value has disappeared. I can re-create this quite easily when the sql prompt code suggestions are enabled, and when it is disabled I do NOT see this behaviour at all.

I have been noticing something corrupting my scripts for the last few months now - it often manifests itself by mangling the last characters in a statement. For instance, something like:

Code: Select all
SELECT  ID ,
        TestColumn ,
        TestColumnDateTime
FROM    admin.TestTable
ORDER BY ID DESC


I will often find after editing something else in the statement that it has ended up as:

Code: Select all
SELECT  ID ,
        TestColumn ,
        TestColumnDateTime
FROM    admin.TestTable
ORDER BY ID DESCC


I do not know what key combination leads to that, but again - it doesn't occur when SQL Prompt suggestions are disabled.
blitzd
 
Posts: 32
Joined: Fri Nov 26, 2010 7:30 pm

Postby Manfred.Castro » Thu Jan 31, 2013 7:42 pm

Thank you for reporting this to us.
I was able to reproduce this issue and have logged it in our internal bug tracking system under the reference number SP-4629
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Re:

Postby blitzd » Wed Apr 10, 2013 6:15 pm

Manfred.Castro wrote:Thank you for reporting this to us.
I was able to reproduce this issue and have logged it in our internal bug tracking system under the reference number SP-4629


Is there any status update on this item? It's still occurring for me on a regular basis, and it's really killing my productivity.
blitzd
 
Posts: 32
Joined: Fri Nov 26, 2010 7:30 pm

Postby Manfred.Castro » Wed Apr 10, 2013 6:36 pm

Unfortunately I am unable to provide a timeline for when this bug may be addressed.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby blitzd » Sun Apr 14, 2013 7:32 pm

Thanks Manfred,

I think in light of the lack of support releases for this product I'm going to let my existing support agreement for it expire this year. No sense in paying for nothing.
blitzd
 
Posts: 32
Joined: Fri Nov 26, 2010 7:30 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest