The following bug has been logged on the website:
Bug reference: 7581
Logged by: William Dauchy
Email address: [email protected]
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
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
