Why was the V17 default parameterization_level changed?

[Breck_Carter]

When V17 was introduced, the default for the new parameterization_level was "Simple".

The default has since been changed to 'Off'... why is that?

Is parameterization_level is unsafe to use? 🙂

[chris_keating]

The change in the default value was a side effect of a change made for IQ. It was not because it was unsafe.

There was one defect with parameteritization_Level that was not in the release notes - it will be documented in the future SP. That issue:

================(Build #4919  - Engineering Case #817663)================

If statement was automatically parameterized (parameterization_level Simple 
or Forced) and a parameter value was larger than 250 bytes, it is possible 
that a SQLE_COMMUNICATION_ERROR would be incorrectly reported.  A workaround 
is to set parameterization_level to Off.  This has been fixed.

[Former Member]

Thank you for the information it was very useful..