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

Semicolon

Hi Redgate Team

The following code will fails due to a missing semicolon which should be inserted automatically

BEGIN TRAN -- missing semicolon here...
WITH CTE_A
AS
(select 1)
ROLLBACK TRAN

Would be nice to see the fix in the next release - thanks!

Torsten
torsten.strauss
0

Comments

4 comments

Sort by
  • Tianjiao_Li
    Thanks for reporting!

    We've logged it as a bug and please keep an eye on the release note!
    Tianjiao_Li
    0
  • torsten.strauss
    Hi Tianjiao,

    it seems the issue is caused by the WITH command.
    Formatting the following code fails as well
    EXEC TEST @TEST = @TEST -- missing semicolon here...

WITH CTE_TEST
AS	( SELECT 1 AS TEST )
SELECT CTE_@test

    Torsten
    torsten.strauss
    0
  • Tianjiao_Li
    Hi @torsten.strauss

    Thanks again for sharing this with us.

    I've added a note to the bug report!
    Tianjiao_Li
    0
  • Tianjiao_Li
    Hi @torsten.strauss

    I'm pleased to let you know we've fixed this issue in the latest release.

    Thank you.
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.