For mitigation, disable Scalar UDF inlining by using either of the following options:Ĭhange the definition of UDF2 by adding WITH INLINE = OFF to the definition.ĭisable inlining on the database by using ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = OFF.įor examples of disabling Scalar UDF inlining, see disabling Scalar UDF Inlining without changing compatibility level. OBJECT DEFINITION(view/UDF/TVF/procedure)Ī fix will be provided in a future cumulative update. With the changes related to Scalar UDF Inlining in CU9, a defect was introduced in which an access violation can occur when an object invokes a scalar inlineable UDF (UDF1) with a scalar inlineable UDF (UDF2) that's used as an input parameter: This update contains fixes that were released after the initial release of SQL Server 2019, and it updates the SQL Server and Analysis services components to the following builds. This article describes Cumulative Update package 9 (CU9) for SQL Server 2019. SQL Server 2019 on Linux SQL Server 2019 on Windows Daugiau.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |