Thread: I seem to have failed some tests..;-(
I configured my postgresql distro using the following command:
./configure --prefix=/usr --exec-prefix=/usr --enable-locale
--enable-recode \
--enable-multibyte --with-perl --with-odbc --disable-debug
--enable-syslog --without-x --without-tcl
My system is running on a Dell power edge 2400 PIII w/ 256MB 36GB UW
SCSI, Trustix 1.2 w/ the stock 2.2.17 kernel running.
Did I do something wrong to fail these test? Or does my system have
this limitation...;-(
Thanks in advance.
Cheers,
John Clark
--
/) 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 \ \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 .. ok
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
parallel group1 (12 tests) ...
boolean name varchar int2 char int4 int8 text oid float4 float8 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) ...
point lseg box path polygon circle interval reltime tinterval inet timestamp comments 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) ...
triggers create_aggregate create_operator constraints 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_into select_distinct_on select_distinct select_having union subselect case join random portals aggregates
select_implicittransactions arrays hash_index 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 ... ok
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 foreign_key rules select_views
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
On Tue, 20 Mar 2001, John Clark L. Naldoza wrote: > I configured my postgresql distro using the following command: > ./configure --prefix=/usr --exec-prefix=/usr --enable-locale > My system is running on a Dell power edge 2400 PIII w/ 256MB 36GB UW > SCSI, Trustix 1.2 w/ the stock 2.2.17 kernel running. 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. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
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