|
| 1 | +From owner-pgsql-hackers@hub.org Fri May 14 16:00:46 1999 |
| 2 | +Received: from renoir.op.net (root@renoir.op.net [209.152.193.4]) |
| 3 | +by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id QAA02173 |
| 4 | +for <maillist@candle.pha.pa.us>; Fri, 14 May 1999 16:00:44 -0400 (EDT) |
| 5 | +Received: from hub.org (hub.org [209.167.229.1]) by renoir.op.net (o1/$Revision: 1.1 $) with ESMTP id QAA02824 for <maillist@candle.pha.pa.us>; Fri, 14 May 1999 16:00:45 -0400 (EDT) |
| 6 | +Received: from hub.org (hub.org [209.167.229.1]) |
| 7 | +by hub.org (8.9.3/8.9.3) with ESMTP id PAA47798; |
| 8 | +Fri, 14 May 1999 15:57:54 -0400 (EDT) |
| 9 | +(envelope-from owner-pgsql-hackers@hub.org) |
| 10 | +Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Fri, 14 May 1999 15:54:30 +0000 (EDT) |
| 11 | +Received: (from majordom@localhost) |
| 12 | +by hub.org (8.9.3/8.9.3) id PAA47191 |
| 13 | +for pgsql-hackers-outgoing; Fri, 14 May 1999 15:54:28 -0400 (EDT) |
| 14 | +(envelope-from owner-pgsql-hackers@postgreSQL.org) |
| 15 | +Received: from thelab.hub.org (nat194.147.mpoweredpc.net [142.177.194.147]) |
| 16 | +by hub.org (8.9.3/8.9.3) with ESMTP id PAA46457 |
| 17 | +for <pgsql-hackers@postgresql.org>; Fri, 14 May 1999 15:49:35 -0400 (EDT) |
| 18 | +(envelope-from scrappy@hub.org) |
| 19 | +Received: from localhost (scrappy@localhost) |
| 20 | +by thelab.hub.org (8.9.3/8.9.1) with ESMTP id QAA16128; |
| 21 | +Fri, 14 May 1999 16:49:44 -0300 (ADT) |
| 22 | +(envelope-from scrappy@hub.org) |
| 23 | +X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs |
| 24 | +Date: Fri, 14 May 1999 16:49:44 -0300 (ADT) |
| 25 | +From: The Hermit Hacker <scrappy@hub.org> |
| 26 | +To: pgsql-hackers@postgreSQL.org |
| 27 | +cc: Jack Howarth <howarth@nitro.med.uc.edu> |
| 28 | +Subject: [HACKERS] postgresql bug report (fwd) |
| 29 | +Message-ID: <Pine.BSF.4.05.9905141649150.47191-100000@thelab.hub.org> |
| 30 | +MIME-Version: 1.0 |
| 31 | +Content-Type: TEXT/PLAIN; charset=US-ASCII |
| 32 | +Sender: owner-pgsql-hackers@postgreSQL.org |
| 33 | +Precedence: bulk |
| 34 | +Status: ROr |
| 35 | + |
| 36 | + |
| 37 | +Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy |
| 38 | +Systems Administrator @ hub.org |
| 39 | +primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org |
| 40 | + |
| 41 | +---------- Forwarded message ---------- |
| 42 | +Date: Fri, 14 May 1999 14:50:58 -0400 |
| 43 | +From: Jack Howarth <howarth@nitro.med.uc.edu> |
| 44 | +To: scrappy@hub.org |
| 45 | +Subject: postgresql bug report |
| 46 | + |
| 47 | +Marc, |
| 48 | + In porting the RedHat 6.0 srpm set for a linuxppc release we |
| 49 | +believe a bug has been identified in |
| 50 | +the postgresql source for 6.5-0.beta1. Our development tools are as |
| 51 | +follows... |
| 52 | + |
| 53 | +glibc 2.1.1 pre 2 |
| 54 | +linux 2.2.6 |
| 55 | +egcs 1.1.2 |
| 56 | +the latest binutils snapshot |
| 57 | + |
| 58 | +The bug that we see is that when egcs compiles postgresql at -O1 or |
| 59 | +higher (-O0 is fine), |
| 60 | +postgresql creates incorrectly formed databases such that when the user |
| 61 | +does a destroydb |
| 62 | +the database can not be destroyed. Franz Sirl has identified the problem |
| 63 | +as follows... |
| 64 | + |
| 65 | + it seems that this problem is a type casting/promotion bug in the |
| 66 | +source. The |
| 67 | + routine _bt_checkkeys() in backend/access/nbtree/nbtutils.c calls |
| 68 | +int2eq() in |
| 69 | + backend/utils/adt/int.c via a function pointer |
| 70 | +*fmgr_faddr(&key[0].sk_func). As |
| 71 | + the type information for int2eq is lost via the function pointer, |
| 72 | +the compiler |
| 73 | + passes 2 ints, but int2eq expects 2 (preformatted in a 32bit reg) |
| 74 | +int16's. |
| 75 | + This particular bug goes away, if I for example change int2eq to: |
| 76 | + |
| 77 | + bool |
| 78 | + int2eq(int32 arg1, int32 arg2) |
| 79 | + { |
| 80 | + return (int16)arg1 == (int16)arg2; |
| 81 | + } |
| 82 | + |
| 83 | + This moves away the type casting/promotion "work" from caller to the |
| 84 | +callee and |
| 85 | + is probably the right thing to do for functions used via function |
| 86 | +pointers. |
| 87 | + |
| 88 | +...because of the large number of changes required to do this, Franz |
| 89 | +thought we should |
| 90 | +pass this on to the postgresql maintainers for correction. Please feel |
| 91 | +free to contact |
| 92 | +Franz Sirl (Franz.Sirl-kernel@lauterbach.com) if you have any questions |
| 93 | +on this bug |
| 94 | +report. |
| 95 | + |
| 96 | +-- |
| 97 | +------------------------------------------------------------------------------ |
| 98 | +Jack W. Howarth, Ph.D. 231 Bethesda Avenue |
| 99 | +NMR Facility Director Cincinnati, Ohio 45267-0524 |
| 100 | +Dept. of Molecular Genetics phone: (513) 558-4420 |
| 101 | +Univ. of Cincinnati College of Medicine fax: (513) 558-8474 |
| 102 | + |
| 103 | + |
| 104 | + |
| 105 | + |
| 106 | + |
| 107 | + |