supposedly incorrect behavior of serial columns with REPLACE

[antonkovalenko]

More details are in the gist by @nikolaymatrosov https://gist.github.com/nikolaymatrosov/8a4e77af2bbb15f3e9b160c1803d22f7

[nikolaymatrosov]

Same wrong behavior could be achieved with UPSERT.

[ssmike]

I made a test to reproduce #13211. It passes in main. Am I wrong somewhere? Which server version do you use?

[nikolaymatrosov]

Serverless YDB in the Yandex Cloud.

[nikolaymatrosov]

If you sequentially send these queries, you will get result as it shown in the screenshot.

DROP table users;

CREATE TABLE users (
	id Serial,
	name Utf8,
	PRIMARY KEY (id)
);

REPLACE INTO users(id, name) VALUES (2, "z");

REPLACE INTO users(name) VALUES ("a"), ("b"), ("c") RETURNING *;

[ssmike]

Looks like an already fixed bug. You should wait for a newer release.

[ssmike]

24-3-13 should contain all the bugfixes.