Re: ecpg test suite - Mailing list pgsql-hackers

I wrote:
> With "make install" before "make check", I get a
> clean pass with this morning's CVS tip (using gcc ... will try HP's
> cc in a bit).

Further results:

* The vulnerability to using a previously installed ecpglib exists in
our default Linux configuration as well as HPUX.

* Still fails with HP's cc on HPUX:

*** expected/sql-desc.stdout    Thu Aug  3 09:24:58 2006
--- results//sql-desc.stdout    Tue Aug  8 09:03:35 2006
***************
*** 1,4 **** output = 1
! val1=1 (ind1: 0) val2='one' (ind2: 0) val1=2 val2=null val1=2 val2=null
--- 1,4 ---- output = 1
! val1=654311425 (ind1: 0) val2='one' (ind2: 0) val1=2 val2=null val1=2 val2=null

* Still fails with gcc on x86_64:

*** expected/pgtypeslib-num_test2.stdout    Mon Aug  7 09:17:02 2006
--- results//pgtypeslib-num_test2.stdout    Tue Aug  8 08:51:06 2006
***************
*** 53,59 **** (no errno set) - num[4,3]: 5924900000.0 (no errno set) - num[4,4]: 5924900000.00 (no errno set) -
num[4,5]:0.00
 
! (errno == PGTYPES_NUM_OVERFLOW) - num[4,6]: 0 (r: -1) (errno == PGTYPES_NUM_OVERFLOW) - num[4,8]: 0 (r: -1) (errno ==
PGTYPES_NUM_OVERFLOW)- num[4,10]: 5924900000.0000000 (r: 0) (no errno set) - num[4,11]: 5924900000.00 (cmp: 0)
 
--- 53,60 ---- (no errno set) - num[4,3]: 5924900000.0 (no errno set) - num[4,4]: 5924900000.00 (no errno set) -
num[4,5]:0.00
 
! (no errno set) - num[4,6]: 5924900000 (r: 0)
! (no errno set) - num[4,7]: 5924900000.00 (cmp: 0) (errno == PGTYPES_NUM_OVERFLOW) - num[4,8]: 0 (r: -1) (errno ==
PGTYPES_NUM_OVERFLOW)- num[4,10]: 5924900000.0000000 (r: 0) (no errno set) - num[4,11]: 5924900000.00 (cmp: 0)
 
*** expected/sql-dynalloc.stderr    Tue Aug  8 08:43:33 2006
--- results//sql-dynalloc.stderr    Tue Aug  8 08:51:06 2006
***************
*** 34,75 **** [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 3 [NO_PID]:
sqlca:code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 43: allocating 21 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 43: RESULT: varchar offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]:ECPGget_data line 43: RESULT:  offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_desc:reading items for tuple 4 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 44: allocating 16 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 44: RESULT: v offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_dataline 44: RESULT: v offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc:
readingitems for tuple 5 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 45: allocating 22 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 45: RESULT: c    offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]:ECPGget_data line 45: RESULT: c    offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_desc:reading items for tuple 6 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 46: allocating 70 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 46: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes [NO_PID]: sqlca: code:
0,state: 00000 [NO_PID]: ECPGget_data line 46: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes [NO_PID]:
sqlca:code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 7 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 47: allocating 16 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 47: RESULT: t offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_dataline 47: RESULT: f offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc:
readingitems for tuple 9 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 50: allocating 46 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 50: RESULT: 2001:4f8:3:ba:2e0:81ff:fe22:d1f1 offset: -1 array: Yes [NO_PID]: sqlca:
code:0, state: 00000 [NO_PID]: ECPGget_data line 50: RESULT:  offset: -1 array: Yes
 
--- 34,75 ---- [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 3 [NO_PID]:
sqlca:code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 43: allocating 33 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 43: RESULT: varchar offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]:ECPGget_data line 43: RESULT:  offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_desc:reading items for tuple 4 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 44: allocating 28 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 44: RESULT: v offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_dataline 44: RESULT: v offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc:
readingitems for tuple 5 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 45: allocating 34 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 45: RESULT: c    offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]:ECPGget_data line 45: RESULT: c    offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_desc:reading items for tuple 6 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 46: allocating 82 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 46: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes [NO_PID]: sqlca: code:
0,state: 00000 [NO_PID]: ECPGget_data line 46: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1 array: Yes [NO_PID]:
sqlca:code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 7 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 47: allocating 28 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 47: RESULT: t offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_dataline 47: RESULT: f offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc:
readingitems for tuple 9 [NO_PID]: sqlca: code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 50: allocating 58 bytes for 2 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 50: RESULT: 2001:4f8:3:ba:2e0:81ff:fe22:d1f1 offset: -1 array: Yes [NO_PID]: sqlca:
code:0, state: 00000 [NO_PID]: ECPGget_data line 50: RESULT:  offset: -1 array: Yes
 
*** expected/sql-dynalloc2.stderr    Tue Aug  8 08:43:33 2006
--- results//sql-dynalloc2.stderr    Tue Aug  8 08:51:06 2006
***************
*** 54,60 **** [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 2 [NO_PID]:
sqlca:code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 34: allocating 49 bytes for 6 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 34: RESULT: one offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_dataline 34: RESULT: two offset: -1 array: Yes
 
--- 54,60 ---- [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_desc: reading items for tuple 2 [NO_PID]:
sqlca:code: 0, state: 00000
 
! [NO_PID]: ECPGstore_result: line 34: allocating 77 bytes for 6 tuples (char**=0)[NO_PID]: sqlca: code: 0, state:
00000[NO_PID]: ECPGget_data line 34: RESULT: one offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]:
ECPGget_dataline 34: RESULT: two offset: -1 array: Yes
 
        regards, tom lane