fix test

sqlc-dev · WillAbides · Nov 26, 2025 · Nov 27, 2025 · Nov 28, 2025 · Nov 27, 2025
commit 7666ff1925e45568419fde20eb665e95f4f09ad1
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/sqlc.yaml
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v4/go/db.go b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v4/go/db.go
diff --git a/...ew_column_ref/postgresql/pgx/go/models.go → ...column_ref/postgresql/pgx/v4/go/models.go b/...ew_column_ref/postgresql/pgx/go/models.go → ...column_ref/postgresql/pgx/v4/go/models.go
diff --git a/...column_ref/postgresql/pgx/go/query.sql.go → ...umn_ref/postgresql/pgx/v4/go/query.sql.go b/...column_ref/postgresql/pgx/go/query.sql.go → ...umn_ref/postgresql/pgx/v4/go/query.sql.go
diff --git a/..._view_column_ref/postgresql/pgx/query.sql → ...ew_column_ref/postgresql/pgx/v4/query.sql b/..._view_column_ref/postgresql/pgx/query.sql → ...ew_column_ref/postgresql/pgx/v4/query.sql
@@ -5,5 +5,5 @@ SELECT val, result FROM foo_lateral;
 SELECT f.id, f.val, sub.result
 FROM foo f
 CROSS JOIN LATERAL (
-  SELECT f.val || '-direct' AS result
+  SELECT (f.val || '-direct')::text AS result
 ) sub;
diff --git a/...view_column_ref/postgresql/pgx/schema.sql → ...w_column_ref/postgresql/pgx/v4/schema.sql b/...view_column_ref/postgresql/pgx/schema.sql → ...w_column_ref/postgresql/pgx/v4/schema.sql
@@ -8,6 +8,6 @@ CREATE VIEW foo_lateral AS
 SELECT t.val, sub.result
 FROM foo t
 CROSS JOIN LATERAL (
-  SELECT t.val AS result
+  SELECT t.val::text AS result
   FROM foo LIMIT 1
 ) sub;
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v4/sqlc.json b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v4/sqlc.json
@@ -0,0 +1,17 @@
+{
+  "version": "2",
+  "sql": [
+    {
+      "engine": "postgresql",
+      "schema": "schema.sql",
+      "queries": "query.sql",
+      "gen": {
+        "go": {
+          "package": "db",
+          "out": "go",
+          "sql_package": "pgx/v4"
+        }
+      }
+    }
+  ]
+}
diff --git a/...l_view_column_ref/postgresql/pgx/go/db.go → ...iew_column_ref/postgresql/pgx/v5/go/db.go b/...l_view_column_ref/postgresql/pgx/go/db.go → ...iew_column_ref/postgresql/pgx/v5/go/db.go
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/go/models.go b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/go/models.go
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/go/query.sql.go b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/go/query.sql.go
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/query.sql b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/query.sql
@@ -0,0 +1,9 @@
+-- name: GetFooLateral :many
+SELECT val, result FROM foo_lateral;
+
+-- name: GetFooLateralDirect :many
+SELECT f.id, f.val, sub.result
+FROM foo f
+CROSS JOIN LATERAL (
+  SELECT (f.val || '-direct')::text AS result
+) sub;
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/schema.sql b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/schema.sql
@@ -0,0 +1,13 @@
+CREATE TABLE foo (
+  id integer PRIMARY KEY,
+  val text NOT NULL
+);
+
+-- Reproduces issue #4182: LATERAL subquery referencing outer column
+CREATE VIEW foo_lateral AS
+SELECT t.val, sub.result
+FROM foo t
+CROSS JOIN LATERAL (
+  SELECT t.val::text AS result
+  FROM foo LIMIT 1
+) sub;
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/sqlc.json b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/pgx/v5/sqlc.json
@@ -0,0 +1,17 @@
+{
+  "version": "2",
+  "sql": [
+    {
+      "engine": "postgresql",
+      "schema": "schema.sql",
+      "queries": "query.sql",
+      "gen": {
+        "go": {
+          "package": "db",
+          "out": "go",
+          "sql_package": "pgx/v5"
+        }
+      }
+    }
+  ]
+}
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/go/db.go b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/go/db.go
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/go/models.go b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/go/models.go
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/go/query.sql.go b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/go/query.sql.go
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/query.sql b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/query.sql
@@ -0,0 +1,9 @@
+-- name: GetFooLateral :many
+SELECT val, result FROM foo_lateral;
+
+-- name: GetFooLateralDirect :many
+SELECT f.id, f.val, sub.result
+FROM foo f
+CROSS JOIN LATERAL (
+  SELECT (f.val || '-direct')::text AS result
+) sub;
diff --git a/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/schema.sql b/internal/endtoend/testdata/lateral_view_column_ref/postgresql/stdlib/schema.sql
@@ -0,0 +1,13 @@
+CREATE TABLE foo (
+  id integer PRIMARY KEY,
+  val text NOT NULL
+);
+
+-- Reproduces issue #4182: LATERAL subquery referencing outer column
+CREATE VIEW foo_lateral AS
+SELECT t.val, sub.result
+FROM foo t
+CROSS JOIN LATERAL (
+  SELECT t.val::text AS result
+  FROM foo LIMIT 1
+) sub;