Semicolon

torsten.strauss

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

Tianjiao_Li

Thanks for reporting!

We've logged it as a bug and please keep an eye on the release note!

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

Tianjiao_Li

Hi @torsten.strauss

Thanks again for sharing this with us.

I've added a note to the bug report!

Tianjiao_Li

Hi @torsten.strauss

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

Thank you.