Resolving reference to CTE column fails

[simonklee]

Version

1.25.0

What happened?

Resolving references to multiple CTE's with arguments fails.

Relevant log output

sqlc generate failed.
# package 
query.sql:5:28: table alias "t1_ids" does not exist

Database schema

CREATE TABLE t1
(
    id SERIAL NOT NULL PRIMARY KEY
);

SQL queries

-- name: CTERef :one
WITH t1_ids AS (
    SELECT id FROM t1
)
SELECT * FROM t1_ids WHERE t1_ids.id = sqlc.arg('id');

Configuration

{
  "version": "2",
  "sql": [{
    "schema": "schema.sql",
    "queries": "query.sql",
    "engine": "postgresql",
    "gen": {
      "go": {
        "out": "db"
      }
    }
  }]
}

Playground URL

https://play.sqlc.dev/p/9048b486f822c300301650867612e42bef8f8d512dfd12d84ad3a4cd210f4ef7

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[mbesida]

Does this also relate to following problem? I'm trying to do conditional insert

WITH 
    data (id, foo, bar) AS ( VALUES ($1, $2, $3) ), 
    insert_data AS (
        SELECT 
          d.id, 
          u.id as userId, 
          d.bar
        FROM data d JOIN users u ON d.foo = u.someField
    )
INSERT INTO myTable(id, userId, bar)
SELECT * FROM insert_data
RETURNING *;

sqlc generate gives error: column "id" does not exist pointing to line d.id in insert_data's select

[simonklee]

I've been using a patched version of sqlc with my PR applied for a month and I haven't experienced any issues with it.

[simonklee]

Does this also relate to following problem? I'm trying to do conditional insert

I think this is the same issue. Should be fairly easy to add the use-case as a regression to the test suite.

[simonklee]

This should be re-opened given: 3f129e7