Re: I seem to have failed some tests..;-( - Mailing list pgsql-general

Hi,

> Hmmmm.  Out of curiosity, do the following:
> Blow out the database data tree (wherever $PGDATA points to)
> When you initdb, do it as:
> LC_ALL=C initdb .......
>
> Now, when you start postmaster, start it with
> LC_ALL=C postmaster
>
> Or
> LC_ALL=C pg_ctl start -D $PGDATA -p /path/to/postmaster
>
> Then rerun regression and see if it passes.  Those test results look awfully
> familiar -- particularly select_having and select_implicit.

I already ran the tests... again...  This is what I got...;-(

It looks as if it's still the same...;-(
--
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer II                       ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3112            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: njclark@ntsp.nec.co.jp                        \   \parallel group1 (12 tests)           ...
 char name boolean varchar int2 int8 oid float4 float8 text int4 numeric
           test boolean              ... ok
           test char                 ... ok
           test name                 ... ok
           test varchar              ... ok
           test text                 ... ok
           test int2                 ... ok
           test int4                 ... ok
           test int8                 ... FAILED
           test oid                  ... ok
           test float4               ... ok
           test float8               ... ok
           test numeric              ... FAILED
sequential test strings              ... ok
sequential test numerology           ... FAILED
parallel group2 (15 tests)           ...
 lseg point box path polygon interval circle reltime comments tinterval inet timestamp type_sanity opr_sanity oidjoins
           test point                ... ok
           test lseg                 ... ok
           test box                  ... ok
           test path                 ... ok
           test polygon              ... ok
           test circle               ... ok
           test interval             ... FAILED
           test timestamp            ... FAILED
           test reltime              ... ok
           test tinterval            ... ok
           test inet                 ... ok
           test comments             ... ok
           test oidjoins             ... ok
           test type_sanity          ... ok
           test opr_sanity           ... ok
sequential test abstime              ... ok
sequential test geometry             ... ok
sequential test horology             ... FAILED
sequential test create_function_1    ... ok
sequential test create_type          ... ok
sequential test create_table         ... ok
sequential test create_function_2    ... ok
sequential test copy                 ... ok
parallel group3 (6 tests)            ...
 constraints triggers create_aggregate create_operator create_misc create_index
           test constraints          ... ok
           test triggers             ... ok
           test create_misc          ... ok
           test create_aggregate     ... ok
           test create_operator      ... ok
           test create_index         ... ok
sequential test create_view          ... ok
sequential test sanity_check         ... ok
sequential test errors               ... ok
sequential test select               ... ok
parallel group4 (16 tests)           ...
 select_distinct select_into select_distinct_on select_having union subselect join transactions aggregates random
arraysportals hash_index select_implicit case btree_index 
           test select_into          ... ok
           test select_distinct      ... ok
           test select_distinct_on   ... ok
           test select_implicit      ... FAILED
           test select_having        ... FAILED
           test subselect            ... ok
           test union                ... ok
           test case                 ... ok
           test join                 ... ok
           test aggregates           ... ok
           test transactions         ... ok
           test random               ... FAILED
           test portals              ... ok
           test arrays               ... ok
           test btree_index          ... ok
           test hash_index           ... ok
sequential test misc                 ... ok
parallel group5 (5 tests)            ...
 portals_p2 alter_table select_views foreign_key rules
           test select_views         ... FAILED
           test alter_table          ... ok
           test portals_p2           ... ok
           test rules                ... ok
           test foreign_key          ... ok
parallel group6 (3 tests)            ...
 limit temp plpgsql
           test limit                ... ok
           test plpgsql              ... ok
           test temp                 ... ok
sequential test numeric_big          ... ok
boolean .. ok
char .. ok
name .. ok
varchar .. ok
text .. ok
int2 .. ok
int4 .. ok
int8 .. failed
oid .. ok
float4 .. ok
float8 .. ok
numeric .. failed
strings .. ok
numerology .. failed
point .. ok
lseg .. ok
box .. ok
path .. ok
polygon .. ok
circle .. ok
interval .. failed
timestamp .. failed
reltime .. ok
tinterval .. ok
inet .. ok
comments .. ok
oidjoins .. ok
type_sanity .. ok
opr_sanity .. ok
abstime .. ok
geometry .. ok
horology .. failed
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok
copy .. ok
constraints .. ok
triggers .. ok
create_misc .. ok
create_aggregate .. ok
create_operator .. ok
create_index .. ok
create_view .. ok
sanity_check .. ok
errors .. ok
select .. ok
select_into .. ok
select_distinct .. ok
select_distinct_on .. ok
select_implicit .. failed
select_having .. failed
subselect .. ok
union .. ok
case .. ok
join .. ok
aggregates .. ok
transactions .. ok
random .. failed
portals .. ok
arrays .. ok
btree_index .. ok
hash_index .. ok
misc .. ok
select_views .. failed
alter_table .. ok
portals_p2 .. ok
rules .. ok
foreign_key .. ok
limit .. ok
plpgsql .. ok
temp .. ok
numeric_big .. ok