Describe the bug
Running the query below previously worked

To Reproduce
Query to reproduce the behavior:

insert into queuemembership (queueid, systemuserid)
select q.queueid, su.systemuserid
from queue q join systemuser su on su.fullname in ('')
left join queuemembership qm on qm.queueid = q.queueid and qm.systemuserid = su.systemuserid
where q.name in ('') and qm.queuemembershipid is null

Expected behavior
Expecting for the remaining queuemembership records to get inserted

Environment (please complete the following information):

• SQL 4 CDS edition:
  Microsoft Dataverse - 9.2.25062.212
  SQL 4 CDS - 10.0.0.0
  Jul 23 2025 09:35:44