Find invalid objects: false positive on $PARTITION statement

weswinkler

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:

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.

Brian Donahue

Thanks for letting us know. I have logged a bug report with the development team as SP-4488.