What are the challenges you face when working across database platforms? Take the survey
Options

Find invalid objects: false positive on $PARTITION statement

weswinklerweswinkler Posts: 54 New member
edited August 6, 2012 8:59AM in SQL Prompt Previous Versions
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.

Comments

Sign In or Register to comment.