MarkMpn / Sql4Cds

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

V9 fixes #483

Closed MarkMpn closed 2 months ago

MarkMpn commented 3 months ago

Fixed error with DeleteMultiple requests - #469 Enable CUD operations on principalobjectaccess - #423 Fixed paging errors with DISTINCT queries - #470 Fixed paging errors when ordering by optionset value Fixed errors when using joins with subqueries in the ON clause - #476 Fixed errors when using joins inside [NOT] EXISTS subqueries - #474 Fixed incorrect results when applying aliases to virtual columns - #477 Added debug visualizer Improved folding of queries using index spools - apply sorts and not-null filter to source Improved primary key calculation - #479 Added recycle bin access via bin schema - #471 Fixed max length calculation for string columns Added support for ___pid virtual columns for lookups to elastic tables - #482 Use column order setting to also control parameter ordering for TVF & sproc - #473 Avoid InvalidProgramException when combining type conversions with logical operators - #484