Red Gate forums :: View topic - SQL Prompt mangles statements when certain key combinations
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt mangles statements when certain key combinations

 Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
blitzd



Joined: 26 Nov 2010
Posts: 26
PostPosted: Mon Jan 28, 2013 10:32 pm    Post subject: SQL Prompt mangles statements when certain key combinations Reply with quote
...occur.

An example:

Code:
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:
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  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  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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 122
PostPosted: Thu Jan 31, 2013 7:42 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
blitzd



Joined: 26 Nov 2010
Posts: 26
PostPosted: Wed Apr 10, 2013 6:15 pm    Post subject: Re: Reply with quote
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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 122
PostPosted: Wed Apr 10, 2013 6:36 pm    Post subject: Reply with quote
Unfortunately I am unable to provide a timeline for when this bug may be addressed.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
blitzd



Joined: 26 Nov 2010
Posts: 26
PostPosted: Sun Apr 14, 2013 7:32 pm    Post subject: Reply with quote
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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 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