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

Query that uses skip index fails if index is not materialized #32292

Closed
CurtizJ opened this issue Dec 6, 2021 · 0 comments · Fixed by #32359
Closed

Query that uses skip index fails if index is not materialized #32292

CurtizJ opened this issue Dec 6, 2021 · 0 comments · Fixed by #32359
Assignees
Labels
bug Confirmed user-visible misbehaviour in official release comp-skipidx Data skipping indices

Comments

@CurtizJ
Copy link
Member

CurtizJ commented Dec 6, 2021

CREATE TABLE t ( a UInt32) ENGINE = MergeTree ORDER BY tuple();

INSERT INTO t VALUES (1);

ALTER TABLE t ADD INDEX ind (a) TYPE set(1) GRANULARITY 1;

SELECT count() FROM t WHERE a = 1;

Received exception from server (version 21.11.5):
Code: 1001. DB::Exception: Received from localhost:9000. DB::Exception: std::__1::__fs::filesystem::filesystem_error: filesystem error: in file_size: No such file or directory [./store/402/402d2274-1310-43f7-802d-22741310f3f7/all_1_1_0_2/skp_idx_ind.mrk3]. (STD_EXCEPTION)

Does it reproduce on recent release?

Reproduces on 21.11 and master.

Expected behavior

Index should be skipped if it doesn't exist in part.

Add any other context about the problem here.

Most likely introduced in #27250.

@CurtizJ CurtizJ added potential bug To be reviewed by developers and confirmed/rejected. bug Confirmed user-visible misbehaviour in official release comp-skipidx Data skipping indices and removed potential bug To be reviewed by developers and confirmed/rejected. labels Dec 6, 2021
@CurtizJ CurtizJ self-assigned this Dec 7, 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 comp-skipidx Data skipping indices
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant