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

reWriteBatchedInserts=true causes syntax error with on conflict #1045

Closed
koen-serry opened this Issue Dec 26, 2017 · 0 comments

Comments

Projects
None yet
2 participants
@koen-serry

koen-serry commented Dec 26, 2017

When doing a batch insert with the reWriteBatchInsert enabled, the query parser incorrectly determines the last parentheses after the 'on conflict' keywords.

eg. insert into test(id, name) values (:id,:name) on conflict (id) do nothing

Rewriting subsequently repeats the "ON conflict..." causing the query to fail on the server with a syntax error.

koen-serry added a commit to koen-serry/pgjdbc that referenced this issue Dec 26, 2017

vlsi added a commit to vlsi/pgjdbc that referenced this issue Jan 20, 2018

@vlsi vlsi closed this in #1082 Jan 23, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment