Operational Defect Database
BugZero found this defect 844 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 14394202
Fixes the following error 104 that occurs when you use scalar User-Defined Function (UDF) lnlining in the ORDER BY clause during the query compilation that has a UNION operator: Msg 104, Level 16, State 1, Line <LineNumber> ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.
Last update date:
1/27/2022
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
Affected releases:
build lower than 15.0.4198.2
Fixed releases:
15.0.4198.2
Description:
Fixes the following error 104 that occurs when you use scalar User-Defined Function (UDF) lnlining in the ORDER BY clause during the query compilation that has a UNION operator: Msg 104, Level 16, State 1, Line <LineNumber> ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.
