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

pg_regress failures after bitmap prefetch patch #3637

Closed
MMeent opened this issue Feb 17, 2023 · 1 comment
Closed

pg_regress failures after bitmap prefetch patch #3637

MMeent opened this issue Feb 17, 2023 · 1 comment
Assignees
Labels
c/compute Component: compute, excluding postgres itself t/bug Issue Type: Bug

Comments

@MMeent
Copy link
Contributor

MMeent commented Feb 17, 2023

Steps to reproduce

PG15 with 96126171 fails, but without it doesn't.

Expected result

pg_regress doesn't fail.

Actual result

There is an off-by-one in the bitmap scan results:

 insert into bmscantest select r, 'fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo' FROM generate_series(1,100000) r;
 create index i_bmtest ON bmscantest(a);
 select count(*) from bmscantest where a>1;
- count 
--------
- 99999
+ count  
+--------
+ 100000
 (1 row)
 
 -- test accumulation of stats for parallel nodes

Environment

Postgres 15, Postgres 14.

Logs, links

@MMeent MMeent added the t/bug Issue Type: Bug label Feb 17, 2023
@vadim2404 vadim2404 added the c/compute Component: compute, excluding postgres itself label Feb 21, 2023
@kelvich
Copy link
Contributor

kelvich commented Feb 24, 2023

@kelvich kelvich closed this as completed Feb 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c/compute Component: compute, excluding postgres itself t/bug Issue Type: Bug
Projects
None yet
Development

No branches or pull requests

4 participants