Failed regression tests

From: b(dot)saunders(at)mindspring(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Failed regression tests
Date: 2000-05-26 18:53:44
Message-ID: 20000526145344.A13456@biologos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I recently compiled and installed PostgreSQL 7.0 on a P-III workstation
running SuSE Linux 6.2 (2.2.10 kernel, gcc ver. 2.7.2.3). The compilation
completed with some non-fatal warnings, but when I ran the sequential
regression tests, five failures occurred.

The first two failures may reflect a 'formating' problem:

1. int8, test 13: a "$" appears left-justified in all entries in 2nd col
2. numeric, test 13: a "$" appears left-justified in all entries in 2nd col

I am using an international code page (LANG=en_US.iso88591), and perhaps the
$ appears because I used /.configure --enable-locale?

The next two failures may reflect a 'sorting' problem:

3. select_implicit: output lines sorted A,B,b,C,c,X instead of A,B,C,X,b,c
4. select_having: output lines sorted b,X instead of X,b

The final "select_view" failure is rather messy:

*** expected/select_views.out Sat Jan 8 22:48:37 2000
--- results/select_views.out Fri May 26 13:25:43 2000
***************
*** 415,420 ****
--- 415,434 ----
I- 580 | 21
I- 580 | 22
I- 580 | 22
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 5
+ I- 580/I-680 Ramp | 6
+ I- 580/I-680 Ramp | 6
+ I- 580/I-680 Ramp | 6
I- 580 Ramp | 2
I- 580 Ramp | 2
I- 580 Ramp | 2
***************
*** 665,684 ****
I- 580 Ramp | 8
I- 580 Ramp | 8
I- 580 Ramp | 8
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 5
- I- 580/I-680 Ramp | 6
- I- 580/I-680 Ramp | 6
- I- 580/I-680 Ramp | 6
I- 680 | 2
I- 680 | 2
I- 680 | 2
--- 679,684 ----

My config.log reports 3 problems which may have caused the failures:

-----
configure: In function `main':
configure:4885: storage size of `semun' isn't known
configure: failed program was:
#line 4880 "configure"
#include "confdefs.h"
#include <sys/types.h>
#include <sys/ipc.h>
#include <sys/sem.h>
int main() {
union semun semun;
; return 0; }
-----
configure:4904: checking for fcntl(F_SETLK)
configure:4916: gcc -o conftest -O2 conftest.c -lcrypt -lnsl -ldl -lm -lreadconfigure: In function `main':
configure:4910: `SEEK_SET' undeclared (first use in this function)
configure:4910: (Each undeclared identifier is reported only once
configure:4910: for each function it appears in.)
configure: failed program was:
#line 4906 "configure"
#include "confdefs.h"
#include <fcntl.h>
int main() {
struct flock lck;
lck.l_whence = SEEK_SET; lck.l_start = lck.l_len = 0;
lck.l_type = F_WRLCK;
fcntl(0, F_SETLK, &lck);
; return 0; }
------
configure:6446: gcc -o conftest -O2 conftest.c -lcrypt -lnsl -ldl -lm -lread
cconfigure: failed program was:
#line 6418 "configure"
#include "confdefs.h"
typedef long int int64;

/* These are globals to discourage the compiler from folding all the
* arithmetic tests down to compile-time constants.
*/
int64 a = 20000001;
int64 b = 40000005;

int does_int64_work()
{
int64 c,d;

if (sizeof(int64) != 8)
return 0; /* doesn't look like the right size */

/* Do perfunctory checks to see if 64-bit arithmetic seems to work */
c = a * b;
d = (c + b) / b;
if (d != a+1)
return 0;
return 1;
}
main() {
exit(! does_int64_work());
}

Finally, the /.configure output included a dozen or so check ... (no)
entries (including some header files), which may contribute to the failures.

Have I banged into configure bugs, missing or misplaced Linux libraries, or
my own stupidity?

Thanks for any pointers,
--
Bruce Saunders

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryan White 2000-05-26 19:12:09 Update Performance from 6.5.0 to 6.5.3 to 7.0
Previous Message Mike Mascari 2000-05-26 18:33:44 Re: SPI & file locations