sqlboiler icon indicating copy to clipboard operation
sqlboiler copied to clipboard

Upsert with greylist in updateColumns results in invalid SQL

Open yourtallness opened this issue 2 years ago • 1 comments

What version of SQLBoiler are you using (sqlboiler --version)?

v4.14.0

What is your database and version (eg. Postgresql 10)

PG 15

Passing a greylist to the update columns in an Upsert operation results in:

sqbmodel: unable to upsert posts: ERROR: syntax error at or near "=" (SQLSTATE 42601)

The generated query is invalid, including 2 extra columns fields (I included 2 columns in the greylist):

"created_at" = EXCLUDED."created_at","updated_at" = EXCLUDED."updated_at", = EXCLUDED., = EXCLUDED

yourtallness avatar Jul 30 '23 19:07 yourtallness

Can you add an example schema and code?

stephenafamo avatar Jul 31 '23 08:07 stephenafamo