sqlite generate error #4648
Description
Version
1.31.1
What happened?
CREATE TABLE IF NOT EXISTS id3_meta_times (
day TEXT NOT NULL,
times INT NOT NULL,
CONSTRAINT "pk:id3_meta_times" PRIMARY KEY(day)
);
-- name: UpdateId3MetaTimes :exec
INSERT INTO id3_meta_times
( day, times)
VALUES(strftime('%Y%d','now'), 1)
ON CONFLICT(day)
DO UPDATE SET times = times + 1;generate error code
// - ON CONFLICT(day) DO UPDATE SET tim - > MISSING ENDING
const updateId3MetaTimes = `-- name: UpdateId3MetaTimes :exec
INSERT INTO id3_meta_times
( day, times)
VALUES(strftime('%Y%d','now'), 1)
ON CONFLICT(day)
DO UPDATE SET tim
`
//
// INSERT INTO id3_meta_times
// ( day, times)
// VALUES(strftime('%Y%d','now'), 1)
// ON CONFLICT(day)
// DO UPDATE SET tim <- HERE
func (q *Queries) UpdateId3MetaTimes(ctx context.Context) error {
_, err := q.db.ExecContext(ctx, updateId3MetaTimes)
return err
}Relevant log output
Database schema
SQL queries
Configuration
Playground URL
No response
What operating system are you using?
No response
What database engines are you using?
No response
What type of code are you generating?
No response
Reacted by Kyle Gray
Activity
kyleconroy commentedon Oct 19, 2026
This was fixed in github.com//pull/4535, which will be included in the next release.