-
-
Notifications
You must be signed in to change notification settings - Fork 24
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
JOIN with 2 conditions no longer works 9.1.0 #486
Comments
Thanks for the details. I can't reproduce this error at the moment, but it looks like the server is having problems evaluating the cross-table column comparison condition. Could you please post the FetchXML that this query generates, along with the results of |
I'm gonna be off for a week so will post a week after.
I'm on-prem v9.1, perhaps that is the issue.
Mark Carrington ***@***.***> (šajā datumā: Pk, 2024. g. 14.
jūn. 21:36) rakstīja:
… Thanks for the details. I can't reproduce this error at the moment, but it
looks like the server is having problems evaluating the cross-table
column comparison
<https://learn.microsoft.com/en-us/power-apps/developer/data-platform/fetchxml/filter-rows?tabs=fetchxml&WT.mc_id=DX-MVP-5004203#cross-table-column-comparisons>
condition.
Could you please post the FetchXML that this query generates, along with
the results of SELECT @@Version?
—
Reply to this email directly, view it on GitHub
<#486 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAFOPK7BJM5NYVG4I4QYPE3ZHMZ33AVCNFSM6AAAAABJIR2NSKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNRYGU3DGOBUGU>
.
You are receiving this because you authored the thread.Message ID:
***@***.***>
|
That is almost certainly the issue - if you can get me the version number details I can build in an extra check so it doesn't attempt to use this feature in the on-prem version. |
Experiencing a similar issue (online): select account.accountid
from account
inner join inf_place ON account.inf_placevisitaddressid = inf_place.inf_placeid
inner join inf_stateprovincecountydepartement ON inf_place.inf_stateprovincecountydepartementid = inf_stateprovincecountydepartement.inf_stateprovincecountydepartementid
where account.address1_stateorprovince is null or account.address1_stateorprovince != inf_stateprovincecountydepartement.inf_name Giving me fetchxml: <fetch xmlns:generator='MarkMpn.SQL4CDS'>
<entity name='account'>
<attribute name='accountid' />
<link-entity name='inf_place' to='inf_placevisitaddressid' from='inf_placeid' alias='inf_place' link-type='inner'>
<link-entity name='inf_stateprovincecountydepartement' to='inf_stateprovincecountydepartementid' from='inf_stateprovincecountydepartementid' alias='inf_stateprovincecountydepartement' link-type='inner' />
</link-entity>
<filter type='or'>
<condition attribute='address1_stateorprovince' operator='null' />
<filter>
<condition valueof='inf_stateprovincecountydepartement.inf_name' attribute='address1_stateorprovince' operator='ne' />
<condition attribute='address1_stateorprovince' operator='not-null' />
<condition attribute='inf_name' operator='not-null' />
</filter>
</filter>
</entity>
</fetch> Last condition breaks the query. Creating a calculated condition fixes the issue:
|
So as I was writing my query and got it working... I updated XTB SQL4CDS to 9.1.0 and suddenly cannot run the query and am greeted with error:
Query that worked and now errors out:
conn.record2id = sc.prefix_servicecontractid
to WHERE clause spits same errorI may have had 9.0.1 before or maybe earlyer.
This refactor works:
But if I add
WHERE sc.prefix_accountid = a.accountid
to be more correct, I get:The text was updated successfully, but these errors were encountered: