error: column reference "id" is ambiguous about cds-pg HOT 4 CLOSED

Hi @austinkloske22,
would be great if you can create a test case that can be replicated with our beer shop example data. For a quick start you could create a pull request with a sample REST client request added to the folder:

tests/assets/cap-proj/rest-client-test

Thanks
Gregor

from cds-pg.

Hi @austinkloske22,
please check my branch https://github.com/gregorwolf/cds-pg/tree/column-reference-ambiguous-246. I'm not able to replicate your issue. Please add your sample request that does show your issue in our data model.

from cds-pg.

@gregorwolf I apologize I've not been active on git and missed that you followed up on my issue. I will attempt to replicate the issue this week.

One challenge for me is that I froze my project(s) on older npm release because of the trouble I had building & deploying with newer cds-dbm releases. My project w/ column reference "id" is ambiguous issue is on releases:

"@sap/cds": "5.3.2",
"cds-dbm": "0.0.24",
"cds-pg": "0.0.41"

What releases should I be using and as a cds-pg community how do we know what versions match @sap/cds releases? Perhaps my issue doesn't even exists when using the latest sap/cds release.

What release levels do you want me to replicate on? pg-beershop does not deploy to docker on the current repos version levels. I see there haven't been a new cds-dbm release on npm for 6 months.

from cds-pg.

@gregorwolf - this issue has been resolved in one of the newer releases. In order to deploy pg-beershop and create the DB, I needed to lower the npm releases to:

"@sap/cds": "5.3.2",
"cds-dbm": "0.0.24",
"cds-pg": "0.0.41"

able to replicate:
http://localhost:4004/beershop/Breweries(0465e9ca-6255-4f5c-b8ba-7439531f8d28)?$expand=beers($filter=ID%20eq%2008d5b3fb-549c-4be7-9ac8-e039d75823e7)

http://localhost:4004/beershop/Breweries(0465e9ca-6255-4f5c-b8ba-7439531f8d28)?$expand=beers($filter=abv%20eq%200)

After created / deploying, I'm able to update the cds / dbm, pg releases to newer releases the error does not occur. I need to get my cds, dbm, cds-pg versions updated. I'll close this issue.

"@sap/cds": "5.7.3",
"cds-dbm": "0.0.27",
"cds-pg": "0.1.16"

http://localhost:4004/beershop/Breweries(0465e9ca-6255-4f5c-b8ba-7439531f8d28)?$expand=beers($filter=ID%20eq%2008d5b3fb-549c-4be7-9ac8-e039d75823e7)

from cds-pg.