You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
mysql reuse model(with ... as ...) generated failed! #3216
sqlc generate failed.
# package
query.sql:12:24: table alias"b" does not exist
Database schema
CREATETABLEauthors (
`id`intNOT NULL AUTO_INCREMENT COMMENT 'id',
`name`varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'name',
`status`varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'status'
);
SQL queries
-- name: TestReuseModel :many
WITH filtered_data AS (
SELECT*FROM authors where id in (sqlc.slice("id"))
)
SELECTa.idFROM filtered_data AS a
LEFT JOIN filtered_data AS b
ONa.id=b.idANDb.name!= ?
WHEREb.name IS NULL;
Activity
Jille commentedon Feb 27, 2024
I expect #3220 to fix this