MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

[Bug?] (ver9.1.0) JOIN between NULLs does not work correctly #491

Closed hiroyuki0415 closed 2 months ago

hiroyuki0415 commented 2 months ago

NULL = NULL appears to evaluate to true

SELECT   e.logicalname,
         e.collectionschemaname,
         e2.logicalname,
         e2.collectionschemaname
FROM     metadata.entity AS e
         LEFT OUTER JOIN
         metadata.entity AS e2
         ON e.collectionschemaname = e2.collectionschemaname
ORDER BY e.logicalname, e2.logicalname;

スクリーンショット 2024-06-19 13 29 01