René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Multiple CTE Update","articleBody":"### Version\r\n\r\n1.15.0\r\n\r\n### What happened?\r\n\r\nHi \r\n\r\ni Have This issue with the following query, i tested the query itself, and it works fine, but sqlc is giving me the below error.\r\n\r\n### Relevant log output\r\n\r\n```shell\r\n# package db\r\ndb/query/user_address.sql:88:5: column \"default_address\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE \"user\" (\r\n  \"id\" bigserial PRIMARY KEY NOT NULL,\r\n  \"username\" varchar NOT NULL,\r\n  \"email\" varchar UNIQUE NOT NULL,\r\n  \"password\" varchar NOT NULL,\r\n  \"telephone\" int NOT NULL DEFAULT 0,\r\n  \"default_payment\" bigint,\r\n  \"created_at\" timestamptz NOT NULL DEFAULT (now()),\r\n  \"updated_at\" timestamptz NOT NULL DEFAULT '0001-01-01 00:00:00Z'\r\n);\r\n\r\nCREATE TABLE \"address\" (\r\n  \"id\" bigserial PRIMARY KEY NOT NULL,\r\n  \"address_line\" varchar NOT NULL,\r\n  \"region\" varchar NOT NULL,\r\n  \"city\" varchar NOT NULL,\r\n  \"created_at\" timestamptz NOT NULL DEFAULT (now()),\r\n  \"updated_at\" timestamptz NOT NULL DEFAULT '0001-01-01 00:00:00Z'\r\n);\r\n\r\nCREATE TABLE \"user_address\" (\r\n  \"user_id\" bigint NOT NULL,\r\n  \"address_id\" bigint UNIQUE NOT NULL,\r\n  \"default_address\" bigint,\r\n  \"created_at\" timestamptz NOT NULL DEFAULT (now()),\r\n  \"updated_at\" timestamptz NOT NULL DEFAULT '0001-01-01 00:00:00Z'\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: UpdateUserAddressWithAddress :one\r\nWITH t1 AS (\r\n    UPDATE \"address\" as a\r\n    SET\r\n    address_line = COALESCE(sqlc.narg(address_line),address_line), \r\n    region = COALESCE(sqlc.narg(region),region), \r\n    city= COALESCE(sqlc.narg(city),city)\r\n    WHERE id = COALESCE(sqlc.arg(id),id)\r\n    RETURNING a.id, a.address_line, a.region, a.city\r\n   ),\r\n   \r\n    t2 AS (\r\n    UPDATE \"user_address\"\r\n    SET\r\n    default_address = COALESCE(sqlc.narg(default_address),default_address)\r\n    WHERE\r\n    user_id = COALESCE(sqlc.arg(user_id),user_id)\r\n    AND address_id = COALESCE(sqlc.arg(address_id),address_id)\r\n    RETURNING user_id, address_id, default_address\r\n\t)\r\n\t\r\nSELECT \r\nuser_id,\r\naddress_id,\r\ndefault_address,\r\naddress_line,\r\nregion,\r\ncity From t1,t2;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: 1\r\npackages:\r\n  - name: \"db\"\r\n    path: \"./db/sqlc\"\r\n    queries: \"./db/query/\"\r\n    schema: \"./db/migration/\"\r\n    engine: \"postgresql\"\r\n    emit_json_tags: true\r\n    emit_prepared_queries: false\r\n    emit_interface: true\r\n    emit_exact_table_names: false\r\n    emit_empty_slices: true\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/17faf82c923406a0c8272595305c3262ea1e0e74c744a0d3744e3ebb23554cc9\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/DarkHeros09","@type":"Person","name":"DarkHeros09"},"datePublished":"2022-10-27T21:44:32.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/1916/sqlc/issues/1916"}