Hi all...
In my organisation we build PG from source on SLES11.2 using GCC 4.3.
Versions 9.1.x of Postgresql and earlier always passed all of the regression
tests but 9.2.3 and .4 fail on the following :
Union
Join
Select views
Polymorphism
With
This happens when using gmake check & gmake MAX_CONNECTIONS=10 installcheck
Mostly the fails are because the returned data order doesn't match the expected
results. Another significant example is this output from the 'union' test :
***
/data/vdrive/Workspaces/jsm/apx/apx_system_fix_S4/ds_pgres/source/postgresql-9.2.4/src/test/regress/expected/union.out
Mon Apr 1 19:20:36 2013
---
/data/vdrive/Workspaces/jsm/apx/apx_system_fix_S4/ds_pgres/source/postgresql-9.2.4/src/test/regress/results/union.out
Fri Apr 19 15:21:59 2013
***************
*** 490,504 ****
UNION
SELECT * FROM t2) t
WHERE ab = 'ab';
! QUERY PLAN
! ---------------------------------------------------
! HashAggregate
! -> Append
! -> Index Scan using t1_ab_idx on t1
! Index Cond: ((a || b) = 'ab'::text)
! -> Index Only Scan using t2_pkey on t2
! Index Cond: (ab = 'ab'::text)
! (6 rows)
reset enable_seqscan;
reset enable_indexscan;
--- 490,506 ----
UNION
SELECT * FROM t2) t
WHERE ab = 'ab';
! QUERY PLAN
! ---------------------------------------------------------
! Unique
! -> Sort
! Sort Key: ((t1.a || t1.b))
! -> Append
! -> Index Scan using t1_ab_idx on t1
! Index Cond: ((a || b) = 'ab'::text)
! -> Index Only Scan using t2_pkey on t2
! Index Cond: (ab = 'ab'::text)
! (8 rows)
reset enable_seqscan;
reset enable_indexscan;
Sorry for the rambling question : is this problem common, i.e. the expected
results files need to be changed or... is it just me? :)
Regards,
John Manning
Business & Application Services
Fujitsu
Central Park, Northampton Road, Manchester, M40 5BP
Unless otherwise stated, this email has been sent from Fujitsu Services
Limited, from Fujitsu (FTS) Limited, or from Fujitsu Telecommunications Europe
Limited, together "Fujitsu".
This email is only for the use of its intended recipient. Its contents are
subject to a duty of confidence and may be privileged. Fujitsu does not
guarantee that this email has not been intercepted and amended or that it is
virus-free.
Fujitsu Services Limited, registered in England No 96056, registered office 22
Baker Street, London W1U 3BW.
Fujitsu (FTS) Limited, registered in England No 03808613, registered office 22
Baker Street, London W1U 3BW.
PFU Imaging Solutions Europe Limited, registered in England No 1578652,
registered office Hayes Park Central, Hayes End Road, Hayes, Middlesex, UB4 8FE.
Fujitsu Telecommunications Europe Limited, registered in England No 2548187,
registered office Solihull Parkway, Birmingham Business Park, Birmingham, B37
7YU.
