oguimbal / pg-mem

An in memory postgres DB instance for your unit tests
MIT License
1.95k stars 94 forks source link

INSERT w/ ON CONFLICT DO NOTHING RETURNING * is returning rows for ignored conflicts #353

Open will-path opened 1 year ago

will-path commented 1 year ago

Describe the bug

In Postgres, when you combine ON CONFLICT DO NOTHING with RETURNING, the conflicting rows are not returned.

To Reproduce

CREATE TABLE example (id bigint PRIMARY KEY);
INSERT INTO example (id) VALUES (1) RETURNING *;
-- id: 1
INSERT INTO example (id) VALUES (1) ON CONFLICT DO NOTHING RETURNING *;
-- id: 1 (WRONG)

pg-mem version

2.6.13