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

UPDATE doesn't work with EXPLAIN ANALYZE #85

Open
dpxcc opened this issue Jan 16, 2025 · 0 comments
Open

UPDATE doesn't work with EXPLAIN ANALYZE #85

dpxcc opened this issue Jan 16, 2025 · 0 comments
Labels
bug Something isn't working good first issue Good for newcomers

Comments

@dpxcc
Copy link
Contributor

dpxcc commented Jan 16, 2025

What happens?

UPDATE doesn't work with EXPLAIN ANALYZE

To Reproduce

postgres (pid: 97139) =# CREATE TABLE t (a int, b text) USING columnstore;
CREATE TABLE
postgres (pid: 97139) =# INSERT INTO t VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e');
INSERT 0 5
postgres (pid: 97139) =# EXPLAIN ANALYZE UPDATE t SET a = a + 1 WHERE b = 'a';
ERROR:  (PGDuckDB/Duckdb_ExplainCustomScan) Executor Error: (PGDuckDB/DataFilesDelete) attempted to delete invisible tuple

OS:

Linux

pg_mooncake Version:

v0.1.0

Postgres Version:

17.0

Are you using pg_mooncake Docker, Neon, or the extension standalone?

pg_mooncake Docker Image

@dpxcc dpxcc added bug Something isn't working good first issue Good for newcomers labels Jan 16, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

1 participant