Error SQLITE_ERROR: ambiguous column name: ID

[SamueleBarzaghi]

Hi,

I have an error when two entities odata.draft.enabled and value list on a field.

Explain problem

Repository to reproduce the problem:

https://github.com/sbarzaghialteaup/cap_ambiguous_id

Thanks for support

Sam

[vitaly_kozyura · Accepted solution]

The issue is fixed. The fix to be provided with the next release. You can follow CAP releases at https://cap.cloud.sap/docs/releases/.

[SamueleBarzaghi · Accepted solution]

Hi vitaly.kozyura,

CDS-DK updated, however the problems seems there yet, should be the fix in this release?

@sap/cds: 4.5.2
@sap/cds-compiler: 1.49.2
@sap/cds-dk: 3.4.1
@sap/cds-foss: 2.2.0
@sap/cds-runtime: 2.8.6<br>

Thanks

Regard,

Sam

[vitaly_kozyura · Accepted solution]

Hi Sam, The fix to be delivered with cds-runtime 2.9.0. Best regards, Vitaly

[former_member631165]

Hi,

there seems to be an alias missing in the sql statement. we will look into it and notify you when we have a workaround / fix available.

BR

Samuel

[SamueleBarzaghi]

Hi,

Do you need me to open an incident?

Thank you

Sam

[former_member631165]

Hi,

i already added this task to our TODO list. So if this is not super urgent i guess it is fine like this. If you need to get this solved rather quickly an incident would help to speed up things a bit maybe dependiong on the priority of the incident.

Please keep the repo active so we can use your sample for reproducing. Thanks!

Samuel