Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upsert with greylist in updateColumns results in invalid SQL #1292

Open
yourtallness opened this issue Jul 30, 2023 · 1 comment
Open

Upsert with greylist in updateColumns results in invalid SQL #1292

yourtallness opened this issue Jul 30, 2023 · 1 comment
Labels

Comments

@yourtallness
Copy link

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
@stephenafamo
Copy link
Collaborator

Can you add an example schema and code?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants