Home Dashboard Directory Help
Search

Error building Database project with UDF aggregate by Genius_p


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 790837
Opened: 6/24/2013 10:59:51 PM
Access Restriction: Public
0
Workaround(s)
view
2
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
DBpr.zip 6/24/2013 268 KB