missing argument in ORDER BY clause #4211
Description
Version
1.30.0
What happened?
The generated code for the following schema supplies only one of the two parameters in the query.
const getMainSequence = `-- name: GetMainSequence :one SELECT ID FROM Sequence WHERE SeriesID = ? ORDER BY Name = ? DESC, ID LIMIT 1 ` func (q *Queries) GetMainSequence(ctx context.Context, seriesid string) (string, error) { row := q.db.QueryRowContext(ctx, getMainSequence, seriesid) var id string err := row.Scan(&id) return id, err }This seems similar to #3990 and #3834.
Relevant log output
msg="missing argument with index 2"Database schema
CREATE TABLE Sequence ( ID TEXT PRIMARY KEY DEFAULT (newID()), Name TEXT NOT NULL, SeriesID TEXT NOT NULL REFERENCES Series ) STRICT;SQL queries
-- name: GetMainSequence :one SELECT ID FROM Sequence WHERE SeriesID = ? ORDER BY Name = ? DESC, ID LIMIT 1;Configuration
{ "version": "2", "sql": [ { "engine": "sqlite", "queries": "query.sql", "schema": "ddl", "gen": { "go": { "package": "schema", "out": "schema", "emit_exact_table_names": true, "emit_pointers_for_null_types": true, "rename": { "artworkkey": "ArtworkKey", "ownerid": "OwnerID", "sequenceid": "SequenceID", "seriesid": "SeriesID", "sortkey": "SortKey", "tagid": "TagID" } } } } ] }Playground URL
No response
What operating system are you using?
Linux
What database engines are you using?
SQLite
What type of code are you generating?
Go