Resolving reference to CTE column fails

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

fix(resolve): fix resolving reference to CTEs

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

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.

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.

This should be re-opened given: 3f129e7

fix(resolve): fix resolving reference to CTEs

feat(compiler): Support subqueries in the FROM clause (second coming) (…

fix(resolve): fix resolving reference to CTEs

fix(resolve): fix resolving reference to CTEs (#1)

feat(compiler): Support subqueries in the FROM clause (sqlc-dev#3227)

feat(compiler): Support subqueries in the FROM clause (second coming) (…

feat(compiler): Support subqueries in the FROM clause (sqlc-dev#3227)

feat(compiler): Support subqueries in the FROM clause (second coming) (…

Navigation Menu

Repository navigation

Resolving reference to CTE column fails #3219

Version

What happened?

Relevant log output

Database schema

SQL queries

Configuration

Playground URL

What operating system are you using?

What database engines are you using?

What type of code are you generating?

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Resolving reference to CTE column fails #3219

Description

Version

What happened?

Relevant log output

Database schema

SQL queries

Configuration

Playground URL

What operating system are you using?

What database engines are you using?

What type of code are you generating?

Activity

mbesida commented on Mar 17, 2024

simonklee commented on Mar 24, 2024

simonklee commented on Mar 24, 2024

simonklee commented on Mar 28, 2024

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions