Skip to content

[pg] Fix commit insert into two tables #2915

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

Closed
Tracked by #2914
rekby opened this issue Mar 18, 2024 · 1 comment
Closed
Tracked by #2914

[pg] Fix commit insert into two tables #2915

rekby opened this issue Mar 18, 2024 · 1 comment
Assignees
Labels
area/pg bug Something isn't working

Comments

@rekby
Copy link
Member

rekby commented Mar 18, 2024

Run local ydb

echo "
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1 (id INT NOT NULL, PRIMARY KEY (id)); 
CREATE TABLE t2 (id INT NOT NULL, PRIMARY KEY (id)); 

BEGIN; 
INSERT INTO t1 (id) VALUES (1); 
INSERT INTO t2 (id) VALUES (2); 
COMMIT;
" | psql postgres://root:1234@localhost:5432/local

Error:

Status: INTERNAL_ERROR
Issues:
<main>: Error: ydb/core/kqp/executer_actor/kqp_executer_impl.cpp:98  CreateKqpExecuter(): requirement *txsType == NKqpProto::TKqpPhyTx::TYPE_DATA failed, message: Cannot execute multiple non-data physical txs.```


Expected behaviour: insert two values into tables
@rekby rekby mentioned this issue Mar 18, 2024
6 tasks
@rekby rekby added bug Something isn't working area/pg labels Mar 18, 2024
@rekby rekby changed the title Fix commit insert into two tables [pg] Fix commit insert into two tables Mar 18, 2024
@rekby rekby assigned gridnevvvit and unassigned qrort Mar 18, 2024
@gridnevvvit
Copy link
Member

issue was fixed in #2919

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/pg bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants