Fix #1425

sqlc-dev · kyleconroy · Oct 16, 2023 · Oct 13, 2023 · Oct 13, 2023 · Oct 13, 2023
commit 191cf0d6f78cf9df74a5cea67123f5bb05686bb6
diff --git a/internal/endtoend/testdata/join_using/issue.md b/internal/endtoend/testdata/join_using/issue.md
@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/1425
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/exec.json b/internal/endtoend/testdata/join_using/postgresql/pgx/exec.json
@@ -0,0 +1,3 @@
+{
+  "contexts": ["managed-db"]
+}
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/go/db.go b/internal/endtoend/testdata/join_using/postgresql/pgx/go/db.go
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/go/models.go b/internal/endtoend/testdata/join_using/postgresql/pgx/go/models.go
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/go/query.sql.go b/internal/endtoend/testdata/join_using/postgresql/pgx/go/query.sql.go
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/query.sql b/internal/endtoend/testdata/join_using/postgresql/pgx/query.sql
@@ -0,0 +1,2 @@
+-- name: SelectJoinUsing :many
+select t1.fk, sum(t2.fk) from t1 join t2 using (fk) group by fk;
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/schema.sql b/internal/endtoend/testdata/join_using/postgresql/pgx/schema.sql
@@ -0,0 +1,6 @@
+create table t1 (
+        fk integer not null unique
+);
+create table t2 (
+        fk integer not null references t1(fk)
+);
diff --git a/internal/endtoend/testdata/join_using/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/join_using/postgresql/pgx/sqlc.yaml
@@ -0,0 +1,10 @@
+version: "2"
+sql:
+  - engine: "postgresql"
+    schema: "schema.sql"
+    queries: "query.sql"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+        sql_package: "pgx/v5"
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: SelectJoinUsing :many
		select t1.fk, sum(t2.fk) from t1 join t2 using (fk) group by fk;