test(sqlite): add repro and reuse cases for sqlc.slice positional ind…

…exing
sqlc-dev · noxymon · Mar 7, 2026 · Mar 7, 2026 · Mar 7, 2026 · 953e0e33b840a2cd1418de26b3f7d0f235556579
commit 953e0e33b840a2cd1418de26b3f7d0f235556579
diff --git a/internal/endtoend/testdata/issue_4213_repro/sqlite/go/db.go b/internal/endtoend/testdata/issue_4213_repro/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/issue_4213_repro/sqlite/go/models.go b/internal/endtoend/testdata/issue_4213_repro/sqlite/go/models.go
diff --git a/internal/endtoend/testdata/issue_4213_repro/sqlite/go/query.sql.go b/internal/endtoend/testdata/issue_4213_repro/sqlite/go/query.sql.go
diff --git a/internal/endtoend/testdata/issue_4213_repro/sqlite/query.sql b/internal/endtoend/testdata/issue_4213_repro/sqlite/query.sql
@@ -0,0 +1,6 @@
+-- name: BrokenQuery :many
+SELECT *
+FROM mytable
+WHERE
+    typ IN (sqlc.slice(types))
+    AND (sqlc.arg(allnames) OR (name IN (sqlc.slice(names))));
diff --git a/internal/endtoend/testdata/issue_4213_repro/sqlite/schema.sql b/internal/endtoend/testdata/issue_4213_repro/sqlite/schema.sql
@@ -0,0 +1,6 @@
+CREATE TABLE mytable (
+    id INTEGER PRIMARY KEY,
+    typ INTEGER NOT NULL,
+    name TEXT NOT NULL,
+    val TEXT NOT NULL
+);
diff --git a/internal/endtoend/testdata/issue_4213_repro/sqlite/sqlc.json b/internal/endtoend/testdata/issue_4213_repro/sqlite/sqlc.json
@@ -0,0 +1,16 @@
+{
+  "version": "2",
+  "sql": [
+    {
+      "engine": "sqlite",
+      "queries": "query.sql",
+      "schema": "schema.sql",
+      "gen": {
+        "go": {
+          "package": "querytest",
+          "out": "go"
+        }
+      }
+    }
+  ]
+}
diff --git a/internal/endtoend/testdata/mysql_reuse_test/mysql/go/db.go b/internal/endtoend/testdata/mysql_reuse_test/mysql/go/db.go
diff --git a/internal/endtoend/testdata/mysql_reuse_test/mysql/go/models.go b/internal/endtoend/testdata/mysql_reuse_test/mysql/go/models.go
diff --git a/internal/endtoend/testdata/mysql_reuse_test/mysql/go/query.sql.go b/internal/endtoend/testdata/mysql_reuse_test/mysql/go/query.sql.go
diff --git a/internal/endtoend/testdata/mysql_reuse_test/mysql/query.sql b/internal/endtoend/testdata/mysql_reuse_test/mysql/query.sql
@@ -0,0 +1,2 @@
+-- name: ReuseParam :exec
+UPDATE foo SET name = sqlc.arg(name) WHERE id = sqlc.arg(id) OR name = sqlc.arg(name);
diff --git a/internal/endtoend/testdata/mysql_reuse_test/mysql/schema.sql b/internal/endtoend/testdata/mysql_reuse_test/mysql/schema.sql
@@ -0,0 +1,4 @@
+CREATE TABLE foo (
+    id SERIAL PRIMARY KEY,
+    name TEXT NOT NULL
+);
diff --git a/internal/endtoend/testdata/mysql_reuse_test/mysql/sqlc.json b/internal/endtoend/testdata/mysql_reuse_test/mysql/sqlc.json
@@ -0,0 +1,16 @@
+{
+  "version": "2",
+  "sql": [
+    {
+      "engine": "mysql",
+      "queries": "query.sql",
+      "schema": "schema.sql",
+      "gen": {
+        "go": {
+          "package": "querytest",
+          "out": "go"
+        }
+      }
+    }
+  ]
+}
diff --git a/internal/endtoend/testdata/sqlite_reuse_test/sqlite/go/db.go b/internal/endtoend/testdata/sqlite_reuse_test/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/sqlite_reuse_test/sqlite/go/models.go b/internal/endtoend/testdata/sqlite_reuse_test/sqlite/go/models.go
diff --git a/internal/endtoend/testdata/sqlite_reuse_test/sqlite/go/query.sql.go b/internal/endtoend/testdata/sqlite_reuse_test/sqlite/go/query.sql.go
diff --git a/internal/endtoend/testdata/sqlite_reuse_test/sqlite/query.sql b/internal/endtoend/testdata/sqlite_reuse_test/sqlite/query.sql
@@ -0,0 +1,2 @@
+-- name: ReuseParam :exec
+UPDATE foo SET name = @name WHERE id = @id OR name = @name;
diff --git a/internal/endtoend/testdata/sqlite_reuse_test/sqlite/schema.sql b/internal/endtoend/testdata/sqlite_reuse_test/sqlite/schema.sql
@@ -0,0 +1,4 @@
+CREATE TABLE foo (
+    id INTEGER PRIMARY KEY,
+    name TEXT NOT NULL
+);
diff --git a/internal/endtoend/testdata/sqlite_reuse_test/sqlite/sqlc.json b/internal/endtoend/testdata/sqlite_reuse_test/sqlite/sqlc.json
@@ -0,0 +1,16 @@
+{
+  "version": "2",
+  "sql": [
+    {
+      "engine": "sqlite",
+      "queries": "query.sql",
+      "schema": "schema.sql",
+      "gen": {
+        "go": {
+          "package": "querytest",
+          "out": "go"
+        }
+      }
+    }
+  ]
+}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: ReuseParam :exec
		UPDATE foo SET name = sqlc.arg(name) WHERE id = sqlc.arg(id) OR name = sqlc.arg(name);
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: ReuseParam :exec
		UPDATE foo SET name = @name WHERE id = @id OR name = @name;