column name escaping about hugsql HOT 5 CLOSED

Hmm. Are you saying HugSQL is not leaving your double-quotes alone? I'm not seeing that:

=> (hugsql/sqlvec "update world set \"randomNumber\" = :randomNumber where id = :id returning id" {:randomNumber 5 :id 1})
["update world set \"randomNumber\" = ? where id = ? returning id" 5 1]

Do you have an error message to look at?

from hugsql.

hmm, might have to dig into this further. I was updating Luminus framework benchmarks here, and got this error. org.postgresql.util.PSQLException: ERROR: column "randomNumber" of relation "world" does not exist. However, doing it the other way seems to work.

from hugsql.

These queries all work for me on postgresql in my test suite:

-- :name create-world :!
create table world (
 id int,
 "randomNumber" int
)

-- :name drop-world :!
drop table if exists world

-- :name insert-world<! :<!
insert into world (id, "randomNumber")
values (:id, :randomNumber)
returning id

-- :name update-world<! :<!
-- update an existing world record
UPDATE world
SET "randomNumber" = :randomNumber
WHERE id = :id
RETURNING id

(testing "possible double-quote bug"
        (when (= db-name :postgresql)
          (= [0] (drop-world db))
          (= [0] (create-world db))
          (= [{:id 1}] (insert-world<! db {:id 1 :randomNumber 5}))
          (= [{:id 1}] (update-world<! db {:id 1 :randomNumber 42}))))

from hugsql.

Hmm, yeah that's odd. I just tried this on my machine at home and it works fine. When I tried it on a different machine earlier I got the same error as travis. Perhaps it's something to do with the version PG itself.

from hugsql.

Oh I think I figured it out. The query returns a randomworld key that's lower case. However, I was looking for the randomWorld key when updating. Nothing to do with HugSQL. :)

from hugsql.