BugZero found this defect 186 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
11/16/2023
SQL Server 2022 on Linux
SQL Server 2022 on Windows
build lower than 16.0.4095.4
16.0.4095.4
Before this update, in some rare cases, if IDENTITY_INSERT is set to ON, the identity value for the target table is set to the highest value in the source table when joining tables, even if the highest value doesn't satisfy the join condition or the predicate. This update improves the current design and fixes this issue. Note: To apply this update, you need to set the QUERY_OPTIMIZER_HOTFIXES database scoped configuration to ON. To turn off this update, you can enable trace flag 13193.