BUG #1429: stats tests fails
От | Hendrik Mueller |
---|---|
Тема | BUG #1429: stats tests fails |
Дата | |
Msg-id | 200501211143.j0LBhQ0x003842@developer.pgadmin.org обсуждение исходный текст |
Ответы |
Re: BUG #1429: stats tests fails
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1429 Logged by: Hendrik Mueller Email address: acone@gmx.de PostgreSQL version: 8.0.0.0 Operating system: Windows 2000 SP4 Description: stats tests fails Details: The stats-test execute after make (with make check) fails. ################# regression.diffs: ################# *** ./expected/stats.out Sat Nov 1 03:18:20 2003 --- ./results/stats.out Fri Jan 21 11:12:54 2005 *************** *** 62,68 **** WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column? ----------+----------+----------+---------- ! t | t | t | t (1 row) SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages, --- 62,68 ---- WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column? ----------+----------+----------+---------- ! f | f | f | f (1 row) SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages, *************** *** 71,77 **** WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? ----------+---------- ! t | t (1 row) -- clean up --- 71,77 ---- WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? ----------+---------- ! f | f (1 row) -- clean up ====================================================================== ############### regression.out: ############### parallel group (13 tests): text varchar oid char name float4 int2 boolean int8 int4 float8 bit numeric boolean ... ok char ... ok name ... ok varchar ... ok text ... ok int2 ... ok int4 ... ok int8 ... ok oid ... ok float4 ... ok float8 ... ok bit ... ok numeric ... ok test strings ... ok test numerology ... ok parallel group (20 tests): lseg path time timetz circle comments reltime abstime polygon point tinterval box inet interval timestamp timestamptz date type_sanity oidjoins opr_sanity point ... ok lseg ... ok box ... ok path ... ok polygon ... ok circle ... ok date ... ok time ... ok timetz ... ok timestamp ... ok timestamptz ... ok interval ... ok abstime ... ok reltime ... ok tinterval ... ok inet ... ok comments ... ok oidjoins ... ok type_sanity ... ok opr_sanity ... ok test geometry ... ok test horology ... ok test insert ... ok test create_function_1 ... ok test create_type ... ok test create_table ... ok test create_function_2 ... ok test copy ... ok parallel group (7 tests): create_operator create_aggregate triggers constraints vacuum create_misc inherit constraints ... ok triggers ... ok create_misc ... ok create_aggregate ... ok create_operator ... ok inherit ... ok vacuum ... ok parallel group (2 tests): create_view create_index create_index ... ok create_view ... ok test sanity_check ... ok test errors ... ok test select ... ok parallel group (18 tests): select_into select_having update namespace select_distinct_on case select_implicit transactions random select_distinct union arrays aggregates hash_index join portals btree_index subselect select_into ... ok select_distinct ... ok select_distinct_on ... ok select_implicit ... ok select_having ... ok subselect ... ok union ... ok case ... ok join ... ok aggregates ... ok transactions ... ok random ... ok portals ... ok arrays ... ok btree_index ... ok hash_index ... ok update ... ok namespace ... ok test privileges ... ok test misc ... ok parallel group (5 tests): portals_p2 cluster foreign_key rules select_views select_views ... ok portals_p2 ... ok rules ... ok foreign_key ... ok cluster ... ok parallel group (14 tests): copy2 truncate temp sequence rowtypes domain polymorphism limit rangefuncs prepare conversion plpgsql alter_table without_oid limit ... ok plpgsql ... ok copy2 ... ok temp ... ok domain ... ok rangefuncs ... ok prepare ... ok without_oid ... ok conversion ... ok truncate ... ok alter_table ... ok sequence ... ok polymorphism ... ok rowtypes ... ok test stats ... FAILED test tablespace ... ok ########## configure: ########## checking build system type... i686-pc-mingw32 checking host system type... i686-pc-mingw32 checking which template to use... win32 checking whether to build with 64-bit integer date/time support... no checking whether NLS is wanted... no checking for default port number... 5432 checking for gcc... gcc checking for C compiler default output... a.exe checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... .exe checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking if gcc supports -Wdeclaration-after-statement... no checking if gcc supports -Wold-style-definition... no checking if gcc supports -Wendif-labels... no checking if gcc supports -fno-strict-aliasing... yes configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing checking whether the C compiler still works... yes checking how to run the C preprocessor... gcc -E checking allow thread-safe client libraries... no checking whether to build with Tcl... no checking whether to build Perl modules... no checking whether to build Python modules... no checking whether to build with Kerberos 4 support... no checking whether to build with Kerberos 5 support... no checking whether to build with PAM support... no checking whether to build with Rendezvous support... no checking whether to build with OpenSSL support... no configure: using CPPFLAGS= -I./src/include/port/win32 -DEXEC_BACKEND configure: using LDFLAGS=-Wl,--allow-multiple-definition checking for gawk... gawk checking for flex... no checking whether ln -s works... yes checking for ld used by GCC... C:/MinGW/mingw32/bin/ld.exe checking if the linker (C:/MinGW/mingw32/bin/ld.exe) is GNU ld... yes checking for ranlib... ranlib checking for lorder... no checking for tar... /bin/tar checking for strip... strip checking whether it is possible to strip libraries... yes checking for bison... no checking for perl... no checking for main in -lbsd... no checking for setproctitle in -lutil... no checking for main in -lm... yes checking for main in -ldl... no checking for main in -lnsl... no checking for main in -lsocket... no checking for main in -lipc... no checking for main in -lIPC... no checking for main in -llc... no checking for main in -ldld... no checking for main in -lld... no checking for main in -lcompat... no checking for main in -lBSD... no checking for main in -lgen... no checking for main in -lPW... no checking for main in -lresolv... no checking for library containing getopt_long... none required checking for main in -lunix... no checking for library containing crypt... no checking for library containing fdatasync... no checking for shmget in -lcygipc... no checking for main in -lwsock32... yes checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking crypt.h usability... no checking crypt.h presence... no checking for crypt.h... no checking dld.h usability... no checking dld.h presence... no checking for dld.h... no checking endian.h usability... no checking endian.h presence... no checking for endian.h... no checking fp_class.h usability... no checking fp_class.h presence... no checking for fp_class.h... no checking getopt.h usability... yes checking getopt.h presence... yes checking for getopt.h... yes checking ieeefp.h usability... no checking ieeefp.h presence... no checking for ieeefp.h... no checking langinfo.h usability... no checking langinfo.h presence... no checking for langinfo.h... no checking poll.h usability... no checking poll.h presence... no checking for poll.h... no checking pwd.h usability... yes checking pwd.h presence... yes checking for pwd.h... yes checking sys/ipc.h usability... no checking sys/ipc.h presence... no checking for sys/ipc.h... no checking sys/poll.h usability... no checking sys/poll.h presence... no checking for sys/poll.h... no checking sys/pstat.h usability... no checking sys/pstat.h presence... no checking for sys/pstat.h... no checking sys/select.h usability... no checking sys/select.h presence... no checking for sys/select.h... no checking sys/sem.h usability... no checking sys/sem.h presence... no checking for sys/sem.h... no checking sys/socket.h usability... yes checking sys/socket.h presence... yes checking for sys/socket.h... yes checking sys/shm.h usability... no checking sys/shm.h presence... no checking for sys/shm.h... no checking sys/time.h usability... yes checking sys/time.h presence... yes checking for sys/time.h... yes checking sys/un.h usability... no checking sys/un.h presence... no checking for sys/un.h... no checking termios.h usability... no checking termios.h presence... no checking for termios.h... no checking utime.h usability... yes checking utime.h presence... yes checking for utime.h... yes checking wchar.h usability... yes checking wchar.h presence... yes checking for wchar.h... yes checking wctype.h usability... yes checking wctype.h presence... yes checking for wctype.h... yes checking kernel/OS.h usability... no checking kernel/OS.h presence... no checking for kernel/OS.h... no checking kernel/image.h usability... no checking kernel/image.h presence... no checking for kernel/image.h... no checking SupportDefs.h usability... no checking SupportDefs.h presence... no checking for SupportDefs.h... no checking netinet/in.h usability... yes checking netinet/in.h presence... yes checking for netinet/in.h... yes checking for netinet/tcp.h... no checking for an ANSI C-conforming const... yes checking for inline... inline checking for preprocessor stringizing operator... yes checking for signed types... yes checking for working volatile... yes checking for __func__... yes checking whether struct tm is in sys/time.h or time.h... time.h checking for struct tm.tm_zone... no checking for tzname... no checking for union semun... no checking for struct sockaddr_un... no checking for struct sockaddr_storage... yes checking for struct sockaddr_storage.ss_family... yes checking for struct sockaddr_storage.__ss_family... no checking for struct sockaddr_storage.ss_len... no checking for struct sockaddr_storage.__ss_len... no checking for struct sockaddr.sa_len... no checking for struct addrinfo... no checking for struct cmsgcred... no checking for struct fcred... no checking for struct sockcred... no checking for struct option... yes checking for int timezone... yes checking types of arguments for accept()... unsigned int PASCAL, unsigned int, struct sockaddr *, int * checking whether gettimeofday takes only one argument... no checking for working memcmp... yes checking for cbrt... yes checking for dlopen... no checking for fcvt... yes checking for fdatasync... no checking for getpeereid... no checking for memmove... yes checking for poll... no checking for pstat... no checking for readlink... no checking for setproctitle... no checking for setsid... no checking for sigprocmask... no checking for symlink... no checking for sysconf... no checking for towlower... yes checking for utime... yes checking for utimes... no checking for waitpid... no checking for wcstombs... yes checking whether fdatasync is declared... no checking for struct sockaddr_in6... no checking for PS_STRINGS... no checking for snprintf... yes checking for vsnprintf... yes checking whether snprintf is declared... yes checking whether vsnprintf is declared... yes checking for isinf... yes checking for crypt... no checking for fseeko... no checking for getopt... yes checking for getrusage... no checking for inet_aton... no checking for random... no checking for rint... yes checking for srandom... no checking for strdup... yes checking for strerror... yes checking for strtol... yes checking for strtoul... yes checking for unsetenv... no checking for getopt_long... yes checking for finite... yes checking for sigsetjmp... no checking for syslog... no checking for optreset... yes checking for strtoll... yes checking for strtoull... yes checking for atexit... yes checking for _LARGEFILE_SOURCE value needed for large files... no checking for fseeko... (cached) no checking test program... ok checking whether long int is 64 bits... no checking whether long long int is 64 bits... yes checking snprintf format for long long int... %I64d checking for unsigned long... yes checking size of unsigned long... 4 checking for short... yes checking alignment of short... 2 checking for int... yes checking alignment of int... 4 checking for long... yes checking alignment of long... 4 checking for long long int... yes checking alignment of long long int... 8 checking for double... yes checking alignment of double... 8 checking for int8... no checking for uint8... no checking for int64... no checking for uint64... no checking for sig_atomic_t... yes checking for POSIX signal interface... no checking for onsgmls... no checking for nsgmls... no checking for openjade... no checking for jade... no checking for DocBook V4.2... no checking for DocBook stylesheets... no checking for collateindex.pl... no checking for sgmlspl... no configure: creating ./config.status config.status: creating GNUmakefile config.status: creating src/Makefile.global config.status: creating src/include/pg_config.h config.status: src/include/pg_config.h is unchanged config.status: linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s config.status: linking ./src/backend/port/dynloader/win32.c to src/backend/port/dynloader.c config.status: linking ./src/backend/port/sysv_sema.c to src/backend/port/pg_sema.c config.status: linking ./src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c config.status: linking ./src/backend/port/dynloader/win32.h to src/include/dynloader.h config.status: linking ./src/include/port/win32.h to src/include/pg_config_os.h config.status: linking ./src/makefiles/Makefile.win32 to src/Makefile.port config.status: executing check_win32_symlinks commands
В списке pgsql-bugs по дате отправления: