Describe the bug
Feature described here: https://markcarrington.dev/2024/06/10/sql-4-cds-v9-1-released/#sharing_&_unsharing_records seems to not work anymore (maybe regression bug ??)
Error message received:
Msg 206, Level 16, State 1, Line 1
Operand type clash: int is incompatible with uniqueidentifier
To Reproduce
Just try to share any record by inserting into POA table (see sql below)
INSERT INTO principalobjectaccess (objectid, objecttypecode, principalid, principaltypecode, accessrightsmask)
VALUES('ed4eac76-4ad3-ef11-8ee9-000d3a67e20f', 'account', 'c8f23980-b1d1-ef11-8ee9-000d3a67e20f', 'systemuser', 3)
Expected behavior
Sharing / Unsharing records work as in version 9.1
Screenshots

Environment (please complete the following information):
- SQL 4 CDS edition: XrmToolBox
- Results of
SELECT @@VERSION:
Microsoft Dataverse - 9.2.25042.222
SQL 4 CDS - 9.6.1.0
May 05 2025 07:25:54
Copyright © 2020 - 2025 Mark Carrington
Additional context
N/A
Describe the bug
Feature described here: https://markcarrington.dev/2024/06/10/sql-4-cds-v9-1-released/#sharing_&_unsharing_records seems to not work anymore (maybe regression bug ??)
Error message received:
Msg 206, Level 16, State 1, Line 1
Operand type clash: int is incompatible with uniqueidentifier
To Reproduce
Just try to share any record by inserting into POA table (see sql below)
Expected behavior
Sharing / Unsharing records work as in version 9.1
Screenshots
Environment (please complete the following information):
SELECT @@VERSION:Microsoft Dataverse - 9.2.25042.222
SQL 4 CDS - 9.6.1.0
May 05 2025 07:25:54
Copyright © 2020 - 2025 Mark Carrington
Additional context
N/A