Question Re: Why was the V17 default parameterization_level changed? in Technology Q&A

Why was the V17 default parameterization_level changed?

Breck_Carter — Sun, 28 Jul 2019 11:49:43 GMT

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? 🙂

Re: Why was the V17 default parameterization_level changed?

chris_keating — Mon, 29 Jul 2019 06:41:43 GMT

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.

Re: Why was the V17 default parameterization_level changed?

Former Member — Thu, 01 Aug 2019 06:27:30 GMT

Thank you for the information it was very useful..