Repository navigation
NULLIF returns bool instead of correct type #133
Description
Version
1.14.0
What happened?
Actually, NULLIF also smells bad. When using it in a query, the Go struct is generated with a field with a bool type, instead of a NullInt64 type.
Database schema
CREATE TABLE author (
id bigserial NOT NULL
);SQL queries
-- name: GetRestrictedId :one
SELECT
NULLIF(id, $1) restricted_id
FROM
author;Configuration
{
"version": "1",
"packages": [
{
"engine": "postgresql",
"path": "go",
"name": "querytest",
"schema": "query.sql",
"queries": "query.sql"
}
]
}Playground URL
https://play.sqlc.dev/p/321eb83b945edfab5a41d8c91feb596bcab9860ce1780639d1f9863207a20644
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
Originally posted by @euller88 in #92 (comment)
Activity
skabbes commentedon Apr 2, 2022
I think this is an endless game of whack-a-mole. I think in general type-checking is impossible, take for example:
how can sqlc know what type the first arg is? It can be anything castable to int - including a string or floating point number, numeric(10, 2), etc. I (personally) believe you need to give the developer control over this.
I think my proposal:
#1525 would at least give the developer control of this behavior, which would allow sqlc to still be usable (but less magic), and also would leave room for "adding magic" in the future. (because theoretically this individual case should be type-checkable).
kyleconroy commentedon Oct 24, 2023
This is fixed in v1.23.0 by enabling the database-backed query analyzer. We added a test case for this issue so it won’t break in the future.
You can play around with the working example on the playground
Jonathan-Landeed commentedon Feb 12, 2025
I still get this issue in views.