Semicolum bug in 6.4.0.633

jmeyer

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

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.

jmeyer

This seems to be fixed in 6.4.0.642.

Thanks for the quick turn-around.

Jens