on 2019 Jul 28 12:49 PM
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? 🙂
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.