How can we help you today? How can we help you today?

Find invalid objects: false positive on $PARTITION statement

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.
weswinkler
0

Comments

1 comment

Sort by
  • Brian Donahue
    Thanks for letting us know. I have logged a bug report with the development team as SP-4488.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.