A value set runs the row once per value; a Set parameter gets the set itself

All 6 scenarios hold

The "Adding any of" column binds to a scalar parameter, so the row expands into one invocation per value. The "To set" column binds to a Set parameter, so the whole set is passed as one argument.

expected outcome broken scenario
ScenarioAdding any ofTo setMakes size?
Values already present
  • 1
  • 2
  • 3
  • 1
  • 2
  • 3
3
New values
  • 4
  • 5
  • 6
  • 1
  • 2
  • 3
4