BUG #7581: changing blocksize makes tests fail

From: wdauchy(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7581: changing blocksize makes tests fail
Date: 2012-10-03 13:06:19
Message-ID: E1TJOeZ-000717-Lg@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7581
Logged by: William Dauchy
Email address: wdauchy(at)gmail(dot)com
PostgreSQL version: 9.2.1
Operating system: Linux
Description:

I tried to compile pgsql9.2 with the following options: --with-blocksize=16
and --with-wal-blocksize=16.

Some tests failed. I didn't have the issue with pgsql9.1.

Could someone confirm the issue?

select_views ... FAILED
========================
1 of 132 tests failed.
========================

The differences that caused some tests to fail can be viewed in the
file
"/tmp/tmp.9mUS6kM8sm/postgresql-9.2-9.2.1/build/src/test/regress/regression.diffs".
A copy of the test summary that you see
above is saved in the file
"/tmp/tmp.9mUS6kM8sm/postgresql-9.2-9.2.1/build/src/test/regress/regression.out".

make[2]: *** [bigcheck] Error 1
make[2]: Leaving directory
`/tmp/tmp.9mUS6kM8sm/postgresql-9.2-9.2.1/build/src/test/regress'
patching file src/test/regress/pg_regress.c
Hunk #1 succeeded at 898 (offset -8 lines).
Hunk #2 succeeded at 2201 (offset -6 lines).
Hunk #3 succeeded at 2233 (offset -6 lines).
patching file src/test/regress/pg_regress_main.c
patching file src/backend/main/main.c
patching file src/bin/initdb/initdb.c
patching file src/bin/pg_ctl/pg_ctl.c
Hunk #1 succeeded at 2006 (offset 9 lines).
********* regression.diffs *******
***
/tmp/tmp.9mUS6kM8sm/postgresql-9.2-9.2.1/build/../src/test/regress/expected/select_views.out
Wed Sep 19 23:47:58 2012
---
/tmp/tmp.9mUS6kM8sm/postgresql-9.2-9.2.1/build/src/test/regress/results/select_views.out
Wed Oct 3 11:25:45 2012
***************
*** 1447,1457 ****

------------------------------------------------------------------------------------
Subquery Scan on my_credit_card_usage_secure
Filter: f_leak(my_credit_card_usage_secure.cnum)
! -> Nested Loop
! Join Filter: (l.cid = r.cid)
-> Seq Scan on credit_usage r
Filter: ((ymd >= '10-01-2011'::date) AND (ymd <
'11-01-2011'::date))
! -> Materialize
-> Hash Join
Hash Cond: (r.cid = l.cid)
-> Seq Scan on credit_card r
--- 1447,1457 ----

------------------------------------------------------------------------------------
Subquery Scan on my_credit_card_usage_secure
Filter: f_leak(my_credit_card_usage_secure.cnum)
! -> Hash Join
! Hash Cond: (r.cid = l.cid)
-> Seq Scan on credit_usage r
Filter: ((ymd >= '10-01-2011'::date) AND (ymd <
'11-01-2011'::date))
! -> Hash
-> Hash Join
Hash Cond: (r.cid = l.cid)
-> Seq Scan on credit_card r

======================================================================

--
William

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-10-03 14:07:08 Re: BUG #7581: changing blocksize makes tests fail
Previous Message maxim.boguk 2012-10-03 10:32:19 BUG #7580: repeatable test case for the BUG #7579