CTE is not returning data

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
tomashiba
Posts: 2
Joined: Wed 19 Aug 2015 13:05

CTE is not returning data

Post by tomashiba » Sat 25 Feb 2017 19:15

A CTE needs ";" (semicolon) before the "WITH" keyword, in previous version ";" was not required when the "WITH" keyword was first statement in a file or after "GO", this has changed in version 5.4.215.
Now without the semicolon in front of "WITH", the query is not returning anything, no errors are reported and the "Output/General" windows just displays:
Changed database context to 'MyDatabase'.
DML succeeded [0.002s]
Execute succeeded [< 0,001s]
The same query is returning records in SSMS.
Semi-colon insertion (Edit/Advanced/InsertSemicolons) is not inserting semicolons before "WITH" in CTE either, are these bugs?

alexa

Re: CTE is not returning data

Post by alexa » Mon 27 Feb 2017 14:51

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

Post Reply