How can we help you today? How can we help you today?

SQL Prompt mangles statements when certain key combinations

...occur.

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.
blitzd
0

Comments

5 comments

Sort by
  • Manfred.Castro
    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
    0
  • blitzd
    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
    0
  • Manfred.Castro
    Unfortunately I am unable to provide a timeline for when this bug may be addressed.
    Manfred.Castro
    0
  • blitzd
    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
    0
  • rlively
    Was this bug ever fixed?
    rlively
    0

Add comment

Please sign in to leave a comment.