Operational Defect Database
BugZero found this defect 432 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2217522
Fixes an issue where interleaved execution for multi-statement table-valued functions (MSTVFs) uses the OPTIMIZE FOR query hint value and returns an incorrect result on the first execution when the runtime constant value is different from the OPTIMIZE FOR query hint value. After you apply this fix, the interleaved execution will check the OPTIMIZE FOR query hint in all cases to avoid using the OPTIMIZE FOR query hint value on the first execution.
Last update date:
3/15/2023
Affected products:
SQL Server 2022 on Linux
SQL Server 2022 on Windows
Affected releases:
build lower than 16.0.4015.1
Fixed releases:
16.0.4015.1
Description:
Fixes an issue where interleaved execution for multi-statement table-valued functions (MSTVFs) uses the OPTIMIZE FOR query hint value and returns an incorrect result on the first execution when the runtime constant value is different from the OPTIMIZE FOR query hint value. After you apply this fix, the interleaved execution will check the OPTIMIZE FOR query hint in all cases to avoid using the OPTIMIZE FOR query hint value on the first execution.
