SQL Prompt mangles statements when certain key combinations
blitzd
Posts: 40
...occur.
An example:
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:
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:
I will often find after editing something else in the statement that it has ended up as:
I do not know what key combination leads to that, but again - it doesn't occur when SQL Prompt suggestions are disabled.
An example:
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:
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:
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:
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.
Comments
I was able to reproduce this issue and have logged it in our internal bug tracking system under the reference number SP-4629
Product Support
Red Gate Software
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.
Product Support
Red Gate Software
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.