cancel
Showing results for 
Search instead for 
Did you mean: 

Why was the V17 default parameterization_level changed?

Breck_Carter
Participant
1,186

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

Accepted Solutions (0)

Answers (1)

Answers (1)

chris_keating
Product and Topic Expert
Product and Topic Expert

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
0 Kudos

Thank you for the information it was very useful..