Skip to content

strange build warning output with guid value #481

New issue
New issue
Closed
Closed
strange build warning output with guid value#481
Assignees
zijchen
Labels
area: build sdkRelated to Microsoft.Build.Sql SDKbugSomething isn't workingfixed-pending-releaseFix in upcoming release
@dzsquared

Description

@dzsquared
dzsquared
opened on Aug 9, 2024

Using Microsoft.Build.Sql 0.2.0-preview, but it looks like it also occurs with 0.1.12-preview

.NET SDK 8.0.303

  ➜ ContosoOutdoors (main) ✏️  dotnet build ContosoOutdoors.sqlproj
  Determining projects to restore...
  All projects are up-to-date for restore.
  Creating a model to represent the project...
  Loading project references...
  Loading project files...
  Building the project model and resolving object interdependencies...
  Validating the project model...
  Writing model to /Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/obj/Debug/Model.xml...
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(8,5,8,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[connect_time]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(10,7,10,7): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(4,9,4,9): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[session_id]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(5,5,5,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[client_net_address]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(6,5,6,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_read]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(7,5,7,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_write]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
  ContosoOutdoors -> /Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/bin/Debug/ContosoOutdoors.dll
  Creating a model to represent the project...
  Loading project references...
  Loading project files...
  Building the project model and resolving object interdependencies...
  Validating the project model...
  2 problems have been detected.
  The results are saved in /Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/bin/Debug/ContosoOutdoors.StaticCodeAnalysis.Results.xml.
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/Views/SelectStarView.sql(2,12,2,12): StaticCodeAnalysis warning SR0001: Microsoft.Rules.Data : The shape of the result set produced by a SELECT * statement will change if the underlying table or view structure changes. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/AddProductImage.sql(9,9,9,9): StaticCodeAnalysis warning SR0008: Microsoft.Rules.Data : Potential misuse of system function @@IDENTITY. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(8,5,8,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[connect_time]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(10,7,10,7): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(4,9,4,9): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[session_id]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(5,5,5,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[client_net_address]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(6,5,6,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_read]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(7,5,7,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_write]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
  ContosoOutdoors -> /Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/bin/Debug/ContosoOutdoors.dacpac

Build succeeded.

/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(8,5,8,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[connect_time]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(10,7,10,7): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(4,9,4,9): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[session_id]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(5,5,5,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[client_net_address]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(6,5,6,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_read]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(7,5,7,5): Build warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_write]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/Views/SelectStarView.sql(2,12,2,12): StaticCodeAnalysis warning SR0001: Microsoft.Rules.Data : The shape of the result set produced by a SELECT * statement will change if the underlying table or view structure changes. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/AddProductImage.sql(9,9,9,9): StaticCodeAnalysis warning SR0008: Microsoft.Rules.Data : Potential misuse of system function @@IDENTITY. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(8,5,8,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[connect_time]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(10,7,10,7): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(4,9,4,9): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[session_id]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(5,5,5,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[client_net_address]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(6,5,6,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_read]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(7,5,7,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[last_write]. [/Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/ContosoOutdoors.sqlproj]
    14 Warning(s)
    0 Error(s)

Time Elapsed 00:00:01.59

what I'm finding odd is the lines like /Users/drewsk/Documents/CodeRepos/dzsquared/ContosoOutdoors/ContosoOutdoors/StoredProcedures/GetActiveConnections.sql(8,5,8,5): {5969ae36-de2c-4019-a31d-33e6691eb9e7} warning SQL71562: Procedure: [dbo].[GetActiveConnections] has an unresolved reference to object [master].[sys].[dm_exec_connections].[connect_time]. where instead of build warning or StaticCodeAnalysis warning its a guid

repro files:

ContosoOutdoors.sqlproj

<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build">
  <Sdk Name="Microsoft.Build.Sql" Version="0.2.0-preview" />
  <PropertyGroup>
    <Name>ContosoOutdoors</Name>
    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider</DSP>
    <ModelCollation>1033, CI</ModelCollation>
    <RootNamespace>ContosoOutdoors</RootNamespace>
    <AssemblyName>ContosoOutdoors</AssemblyName>
    <RunSqlCodeAnalysis>True</RunSqlCodeAnalysis>
  </PropertyGroup>
</Project>

Brands.sql

CREATE TABLE dbo.Brands
(
	[BrandSlug] NVARCHAR(255) NOT NULL PRIMARY KEY,
	[BrandName] NVARCHAR(255) NOT NULL
)

SelectStarView.sql

CREATE VIEW dbo.SelectStarView
	AS SELECT * FROM dbo.Brands

GetActiveConnections.sql

CREATE PROCEDURE GetActiveConnections

AS
	SELECT session_id
		, client_net_address
		, last_read
		, last_write
		, connect_time

	FROM master.sys.dm_exec_connections;

RETURN 0

Metadata

Metadata

Assignees

Labels

area: build sdkRelated to Microsoft.Build.Sql SDKbugSomething isn't workingfixed-pending-releaseFix in upcoming release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions