Complex sub-query on link-entity fails about fake-xrm-easy HOT 4 CLOSED

Bit more digging and simiplifed the tests a little.
The equivalent of this query fails:

select * from salesOrder s,
         salesorderdetail d
         where d.quantity is not null
         AND 
         (d.description = "A" OR d.productdescription = "B")

wheras the equivalent of this query works OK:

select * from salesOrder s,
         salesorderdetail d
         where d.description = "A" OR d.productdescription = "B"

So it's the nested Or within the And which seems to break things.
Issue63.zip
The attached Unit tests have the two queries, as FetchXML and as QueryExpressions - two working OK (without the nested filter) and two not.

from fake-xrm-easy.

Hi Ben,

Thank you again, that's interesting.

Maybe is behaving differently when the EntityName property is not specified in the filter (wild guess). I'll setup a unit test to reproduce

from fake-xrm-easy.

Here's a Unit Test. Don't want to commit it because it'll break the build. but here for when you have time to look at it...
Issue63.zip

from fake-xrm-easy.

Hi @bwmodular

Thanks a lot for all this info.

from fake-xrm-easy.