BUG #18885: ERROR: corrupt MVNDistinct entry - 2
От | PG Bug reporting form |
---|---|
Тема | BUG #18885: ERROR: corrupt MVNDistinct entry - 2 |
Дата | |
Msg-id | 18885-da51324078588253@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #18885: ERROR: corrupt MVNDistinct entry - 2
Re: BUG #18885: ERROR: corrupt MVNDistinct entry - 2 |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 18885 Logged by: Robins Tharakan Email address: tharakan@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Ubuntu Description: The following SQL triggers "ERROR: corrupt MVNDistinct entry", however this seems to be unrelated to a recent bugfix[1] for a similar issue (thus '2' in the $SUBJECT). The surfacing commit appears to be 6bb6a62f3cc45624c601d5270673a17447734629 [2]. SQL === $ cat ../sqith/repro.sql CREATE TABLE a(b BIT VARYING, d int4range); CREATE TABLE e(LIKE a); CREATE TABLE f(LIKE a); INSERT INTO f(d, b) VALUES('[0,0)', ''); CREATE STATISTICS ON d, b FROM f; ANALYZE; SELECT FROM f RIGHT JOIN e ON (e.d=f.d)AND(f.d=e.d); Commit ====== Testing for start crashing --- Checking (306dd6e727b~0) - 306dd6e727 - fail (1) Checking (306dd6e727b~10) - 91f1fe90c7 - fail (1) Checking (306dd6e727b~30) - 969ab9d4f5 - fail (1) Checking (306dd6e727b~70) - 1495eff7bd - fail (1) . . Checking (306dd6e727b~447) - fae535da0a - pass (0) Checking (306dd6e727b~446) - 6bb6a62f3c - fail (1) Surfacing Commit is 6bb6a62f3cc45624c601d5270673a17447734629 SQL Output ========== $ psql -p 9999 postgres -f ../sqith/repro.sql CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 1 CREATE STATISTICS ANALYZE psql:../sqith/repro.sql:7: ERROR: corrupt MVNDistinct entry Found using SQLSmith / creduce. - robins https://robins.in Reference 1. Similar bugfix: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e28033fe1af8037e0fec8bb3a32fabbe18ac06b1 2. Surfacing commit: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6bb6a62f3cc45624c601d5270673a17447734629
В списке pgsql-bugs по дате отправления: