What are the challenges you face when working across database platforms? Take the survey
Options

Semicolum bug in 6.4.0.633

jmeyerjmeyer Posts: 70 Bronze 2
edited September 24, 2014 1:18PM in SQL Prompt
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

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    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.
  • Options
    jmeyerjmeyer Posts: 70 Bronze 2
    This seems to be fixed in 6.4.0.642.

    Thanks for the quick turn-around.

    Jens
Sign In or Register to comment.