Operational Defect Database

BugZero found this defect 648 days ago.

Microsoft SQL Server | 14537603

The optimizer may fail to produce the plan and throw an error when you enable the Scalar User-Defined Function (UDF) Inlining feature and try to update a partitioned view by using the output of the UDF. Here is the error message: Msg 8624, Level 16, State 21, Line <LineNumber> Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

Last update date:

8/11/2022

Affected products:

SQL Server 2019 on Linux

SQL Server 2019 on Windows

Affected releases:

build lower than 15.0.4249.2

Fixed releases:

15.0.4249.2

Description:

The optimizer may fail to produce the plan and throw an error when you enable the Scalar User-Defined Function (UDF) Inlining feature and try to update a partitioned view by using the output of the UDF. Here is the error message: Msg 8624, Level 16, State 21, Line <LineNumber> Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

Additional Resources / Links

Share:

BugZero® Risk Score

What's this?

Coming soon

Status

Unavailable

Learn More

Search:

...