search

ruricolist / cl-yesql

Common Lisp library for using SQL
67 stars 5 forks source link

Values are coerced into strings in "SELECT ? AS p;" #22

Open phoe opened 5 years ago

phoe commented 5 years ago 
-- name: check-selection
SELECT ? AS p;
SQL/TEST> (check-selection t)
(("true"))

Types are not preserved across SELECT queries, it seems. I think this is an issue on the Postmodern side as I have been able to reproduce it with pomo:query.

phoe commented 5 years ago

I have been able to work around this via explicit casting.

-- name: check-selection
SELECT ?::boolean AS p;
SQL/TEST> (check-selection t)
((T))