Describe the bug
Executing the following query, I have an error.

To Reproduce
Run the following query

select W.name 
from systemform W
inner join metadata.entity E on E.logicalname=W.objecttypecode
inner join solutioncomponent SC on SC.objectid=E.metadataid and SC.rootcomponentbehavior=0 -- Include subcomponents
where W.publishedon>'2028-12-03'
UNION
select W.name 
from systemform W
where W.publishedon>'2028-12-03'

Expected behavior
No error, and the result of the query

Screenshots

Environment (please complete the following information):

• SQL 4 CDS using XrmToolBox
• Results of SELECT @@VERSION: Microsoft Dataverse - 9.2.25014.228
  SQL 4 CDS - 9.6.0.0
  mars 04 2025 14:14:16
  Copyright © 2020 - 2024 Mark Carrington

Sponsorship
If you find this tool useful, please consider sponsoring its development.