Find invalid objects: false positive on $PARTITION statement

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Find invalid objects: false positive on $PARTITION statement

Postby weswinkler » Fri Aug 03, 2012 6:41 pm

SQL Prompt's "Find invalid objects" feature incorrectly flags the use of $PARTITION function/statement as invalid. (SQL Prompt 5.3.4.1)

Repro: embed any valid statement calling the $PARTITION statement in a sproc. Ask SQL Prompt to find invalid objects in the database.

My example:
Code: Select all
CREATE SPROC MySproc
...
select @PARTITION=$PARTITION.pfValidPartitionFunction(@InputData)
...


In my case, @PARTITION and @InputData are valid local variables in the sproc. pfValidPartitionFunctionis a valid partition function in the database.
weswinkler
 
Posts: 32
Joined: Tue Nov 11, 2008 8:12 pm

Postby Brian Donahue » Mon Aug 06, 2012 1:59 pm

Thanks for letting us know. I have logged a bug report with the development team as SP-4488.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests