- Microsoft.Build.Sql version: 2.1.0
- .net core & windows platforms
Steps to Reproduce:
- Install msbuild templates
- Create new blank project (dotnet new sqlproj)
- Add test file
aa.sql (with an error), such as:
create table aa
(x int, y int)
go
create proc zz
as
begin
select z from aa
end
- Build with
dotnet build
Expected output:
aa.sql(10,11): Build error SQL71501: Procedure: [dbo].[zz] has an unresolved reference to object [dbo].[aa].[z].
Actual output:
aa.sql(10,11,10,11): Build error SQL71501: Procedure: [dbo].[zz] has an unresolved reference to object [dbo].[aa].[z].
The error line and column are repeated. This leads to issues in VS Code for example when clicking on the output. It cannot locate the error position.
Steps to Reproduce:
aa.sql(with an error), such as:dotnet buildExpected output:
aa.sql(10,11): Build error SQL71501: Procedure: [dbo].[zz] has an unresolved reference to object [dbo].[aa].[z].Actual output:
aa.sql(10,11,10,11): Build error SQL71501: Procedure: [dbo].[zz] has an unresolved reference to object [dbo].[aa].[z].The error line and column are repeated. This leads to issues in VS Code for example when clicking on the output. It cannot locate the error position.