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

Got wrong result when executing mutation on Memory table engine #24192

Closed
plugine opened this issue May 17, 2021 · 0 comments · Fixed by #24193
Closed

Got wrong result when executing mutation on Memory table engine #24192

plugine opened this issue May 17, 2021 · 0 comments · Fixed by #24193
Labels
bug Confirmed user-visible misbehaviour in official release

Comments

@plugine
Copy link

plugine commented May 17, 2021

Clickhouse version: 21.2.5.5

Got wrong result when excuting mutation on Memory table engine.

CREATE TABLE mem_test(id Int64) ENGINE=Memory();
INSERT INTO mem_test VALUES (1), (2), (3);
ALTER TABLE mem_test UPDATE id=4 WHERE id=1;
SELECT count(*) FROM mem_test;

┌─count()─┐
│      24 │
└─────────┘

SELECT * FROM mem_test;

┌─id─┐
│  4 │
│  2 │
│  3 │
└────┘

3 rows in set. Elapsed: 0.001 sec.
@plugine plugine added the bug Confirmed user-visible misbehaviour in official release label May 17, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Confirmed user-visible misbehaviour in official release
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant