Error building Database project with UDF aggregate - by Genius_p

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 790837 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 6/24/2013 10:59:51 PM
Access Restriction Public

Description

We have database project.
In this projct we have user-defined aggregate function with property [Microsoft.SqlServer.Server.SqlUserDefinedAggregate].

Function name is "SumStr".

When we use this function in SQL procedure in "PIVOT" statment, building the database project is:
- success whithout warnings and errors for SQL-procedure;

- success whith warning for SQL-scalar-function: "Warning 1 SQL71502: Function: [dbo].[DatabaseScalarFunction1] has an unresolved reference to object [dbo].[SumStr]." 

- building whith error for SQL-view or inline-functions: "SQL71501: View: [dbo].[View1] has an unresolved reference to object [dbo].[SumStr]." 


But! when we use this compiled function on SQL server side - all queries in view or table-valued functions who use this function, are performed without error. 
Sign in to post a comment.
Posted by Microsoft on 8/5/2013 at 5:19 PM
Hello Genius_p,

Thank you for your feedback. We have fixed this issue, and It should be resolved in the next release of DacFx.

Thanks
Ali Badereddin