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

Semicolum bug in 6.4.0.633

Repo: 
DECLARE @cmd VARCHAR(1000);

DECLARE @filelist TABLE (filelist_name VARCHAR(255));

SET @cmd = 'dir /B /A:-D';

INSERT  INTO @filelist
        (filelist_name)
        EXEC master.sys.xp_cmdshell
          @cmd;
Pressing Ctrl-B, Ctrl-C multiple times will insert multiple semicolons in the last line of code behind "@cmd;". This bug also exists in private build 6.4.0.634
jmeyer
0

Comments

2 comments

Sort by
  • Aaron L
    Hi Jens,

    I've got another private build with a fix for you here. (it looks like it was a knock on from this bug fix with the semicolons after an exec)

    I didn't realise you could use an INSERT/EXEC like that - it's pretty cool :)

    Thank you for pointing out these issues, it's really helpful to have your simple recreation steps!

    Thanks,
    Aaron.
    Aaron L
    0
  • jmeyer
    This seems to be fixed in 6.4.0.642.

    Thanks for the quick turn-around.

    Jens
    jmeyer
    0

Add comment

Please sign in to leave a comment.