Version
1.10.0
What happened?
I wanted to make a INSERT OR IGNORE INTO query against a sqlite3 db (https://sqlite.org/lang_insert.html). When running sqlc it thinks that it is a syntax error.
Relevant log output
# package db
sql/queries.sql:1:1: syntax error at or near "OR"
Database schema
CREATE TABLE IF NOT EXISTS items (
id INTEGER PRIMARY KEY,
name varchar(256) UNIQUE NOT NULL,
unit varchar(256) NOT NULL
);SQL queries
-- name: CreateItem :exec
INSERT OR IGNORE INTO items (name, unit) VALUES ($1, $2);
Configuration
version: "1"
packages:
- path: "projectname/db"
name: "db"
schema: "sql/schema.sql"
queries: "sql/queries.sql"Playground URL
https://play.sqlc.dev/p/89430560ded19826e9822bb05d9107919f92760e28980b5bf461237a34dbc0ca
What operating system are you using?
Linux
What database engines are you using?
No response
What type of code are you generating?
Go
Version
1.10.0
What happened?
I wanted to make a
INSERT OR IGNORE INTOquery against a sqlite3 db (https://sqlite.org/lang_insert.html). When runningsqlcit thinks that it is a syntax error.Relevant log output
Database schema
SQL queries
Configuration
Playground URL
https://play.sqlc.dev/p/89430560ded19826e9822bb05d9107919f92760e28980b5bf461237a34dbc0ca
What operating system are you using?
Linux
What database engines are you using?
No response
What type of code are you generating?
Go