Our internal testing has shown such queries being executed up to 11% faster than previously as always, your results may differ from these depending on environment, configuration, and other factors.
Queries using temporary tables should be noticeably faster with this enhancement. Performance: Internal functions used to copy values between columns have been improved such that computations not necessary when the values are of similar types are no longer performed.Such assignments are no longer permitted. Incompatible Change: Within trigger bodies, INSERT or UPDATE statements containing a SET clause that used OLD or NEW values as assignment targets could raise an assertion or lead to a server exit.
