You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
UPDATE statement with FROM subquery does not generate!
Relevant log output
sqlc generate failed.
# package
query.sql:23:14: column "id" does not exist
Database schema
CREATETABLEauthors (
id BIGSERIALPRIMARY KEY,
name textNOT NULL,
bio text
);
SQL queries
-- name: UpdateAuthor :execUPDATE authors SET name=subquery.name, bio=subquery.bioFROM (SELECT id, name, bio
FROM unnest($1::authors[])) AS subquery
WHEREauthors.id=subquery.id;
Version
1.25.0
What happened?
UPDATE statement with FROM subquery does not generate!
Relevant log output
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/146482ad583aa6e0a2980b0d0feb5e6c42628406a3f44b1eadfd925278b341e0
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
The text was updated successfully, but these errors were encountered: