Hi,

Testing beta5 on unixware7 gives an error on int8 test while beta4 (I've
just retested it) works ok regressions.diff follows:

Also, compiling with openssl give a compile error on
src/backend/libpq/crypt.c; this error CAN be avoided by commenting out the
definition of des_encrypt in /ur/local/ssl/include/openssl/des.h

I'm not sure this is good practice though.

Anyway, even after that, there are linking errors on libecpg.so and perl
because of a lack of -L/usr/local/ssl/lib

Easyly avoid by setting ad hoc LD_LIBRARY_PATH.

 *** ./expected/int8.out	Mon Jan 29 03:53:58 2001
--- ./results/int8.out	Wed Feb 28 16:29:40 2001
***************
*** 5,111 ****
  CREATE TABLE INT8_TBL(q1 int8, q2 int8);
  INSERT INTO INT8_TBL VALUES('123','456');
  INSERT INTO INT8_TBL VALUES('123','4567890123456789');
  INSERT INTO INT8_TBL VALUES('4567890123456789','123');
  INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
  INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
  SELECT * FROM INT8_TBL;
          q1        |        q2         
! ------------------+-------------------
                123 |               456
!               123 |  4567890123456789
!  4567890123456789 |               123
!  4567890123456789 |  4567890123456789
!  4567890123456789 | -4567890123456789
! (5 rows)
  
  SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
   five |       plus       |       minus       
! ------+------------------+-------------------
        |              123 |              -123
!       |              123 |              -123
!       | 4567890123456789 | -4567890123456789
!       | 4567890123456789 | -4567890123456789
!       | 4567890123456789 | -4567890123456789
! (5 rows)
  
  SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
   five |        q1        |        q2         |       plus       
! ------+------------------+-------------------+------------------
        |              123 |               456 |              579
!       |              123 |  4567890123456789 | 4567890123456912
!       | 4567890123456789 |               123 | 4567890123456912
!       | 4567890123456789 |  4567890123456789 | 9135780246913578
!       | 4567890123456789 | -4567890123456789 |                0
! (5 rows)
  
  SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
   five |        q1        |        q2         |       minus       
! ------+------------------+-------------------+-------------------
        |              123 |               456 |              -333
!       |              123 |  4567890123456789 | -4567890123456666
!       | 4567890123456789 |               123 |  4567890123456666
!       | 4567890123456789 |  4567890123456789 |                 0
!       | 4567890123456789 | -4567890123456789 |  9135780246913578
! (5 rows)
  
  SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL
   WHERE q1 < 1000 or (q2 > 0 and q2 < 1000);
   three |        q1        |        q2        |      multiply      
! -------+------------------+------------------+--------------------
         |              123 |              456 |              56088
!        |              123 | 4567890123456789 | 561850485185185047
!        | 4567890123456789 |              123 | 561850485185185047
! (3 rows)
  
  SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL;
   five |        q1        |        q2         |     divide     
! ------+------------------+-------------------+----------------
        |              123 |               456 |              0
!       |              123 |  4567890123456789 |              0
!       | 4567890123456789 |               123 | 37137318076884
!       | 4567890123456789 |  4567890123456789 |              1
!       | 4567890123456789 | -4567890123456789 |             -1
! (5 rows)
  
  SELECT '' AS five, q1, float8(q1) FROM INT8_TBL;
   five |        q1        |        float8        
! ------+------------------+----------------------
        |              123 |                  123
!       |              123 |                  123
!       | 4567890123456789 | 4.56789012345679e+15
!       | 4567890123456789 | 4.56789012345679e+15
!       | 4567890123456789 | 4.56789012345679e+15
! (5 rows)
  
  SELECT '' AS five, q2, float8(q2) FROM INT8_TBL;
   five |        q2         |        float8         
! ------+-------------------+-----------------------
        |               456 |                   456
!       |  4567890123456789 |  4.56789012345679e+15
!       |               123 |                   123
!       |  4567890123456789 |  4.56789012345679e+15
!       | -4567890123456789 | -4.56789012345679e+15
! (5 rows)
  
  SELECT '' AS five, 2 * q1 AS "twice int4" FROM INT8_TBL;
   five |    twice int4    
! ------+------------------
        |              246
!       |              246
!       | 9135780246913578
!       | 9135780246913578
!       | 9135780246913578
! (5 rows)
  
  SELECT '' AS five, q1 * 2 AS "twice int4" FROM INT8_TBL;
   five |    twice int4    
! ------+------------------
        |              246
!       |              246
!       | 9135780246913578
!       | 9135780246913578
!       | 9135780246913578
! (5 rows)
  
  -- TO_CHAR()
  --
--- 5,77 ----
  CREATE TABLE INT8_TBL(q1 int8, q2 int8);
  INSERT INTO INT8_TBL VALUES('123','456');
  INSERT INTO INT8_TBL VALUES('123','4567890123456789');
+ ERROR:  int8 value out of range: "4567890123456789"
  INSERT INTO INT8_TBL VALUES('4567890123456789','123');
+ ERROR:  int8 value out of range: "4567890123456789"
  INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
+ ERROR:  int8 value out of range: "4567890123456789"
  INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
+ ERROR:  int8 value out of range: "4567890123456789"
  SELECT * FROM INT8_TBL;
   q1  | q2  
! -----+-----
   123 | 456
! (1 row)
  
  SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
   five | plus | minus 
! ------+------+-------
        |  123 |  -123
! (1 row)
  
  SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
   five | q1  | q2  | plus 
! ------+-----+-----+------
        | 123 | 456 |  579
! (1 row)
  
  SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
   five | q1  | q2  | minus 
! ------+-----+-----+-------
        | 123 | 456 |  -333
! (1 row)
  
  SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL
   WHERE q1 < 1000 or (q2 > 0 and q2 < 1000);
   three | q1  | q2  | multiply 
! -------+-----+-----+----------
         | 123 | 456 |    56088
! (1 row)
  
  SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL;
   five | q1  | q2  | divide 
! ------+-----+-----+--------
        | 123 | 456 |      0
! (1 row)
  
  SELECT '' AS five, q1, float8(q1) FROM INT8_TBL;
   five | q1  | float8 
! ------+-----+--------
        | 123 |    123
! (1 row)
  
  SELECT '' AS five, q2, float8(q2) FROM INT8_TBL;
   five | q2  | float8 
! ------+-----+--------
        | 456 |    456
! (1 row)
  
  SELECT '' AS five, 2 * q1 AS "twice int4" FROM INT8_TBL;
   five | twice int4 
! ------+------------
        |        246
! (1 row)
  
  SELECT '' AS five, q1 * 2 AS "twice int4" FROM INT8_TBL;
   five | twice int4 
! ------+------------
        |        246
! (1 row)
  
  -- TO_CHAR()
  --
***************
*** 114,124 ****
   to_char_1 |        to_char         |        to_char         
  -----------+------------------------+------------------------
             |                    123 |                    456
!            |                    123 |  4,567,890,123,456,789
!            |  4,567,890,123,456,789 |                    123
!            |  4,567,890,123,456,789 |  4,567,890,123,456,789
!            |  4,567,890,123,456,789 | -4,567,890,123,456,789
! (5 rows)
  
  SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'), to_char(q2, '9,999,999,999,999,999.999,999') 
  	FROM INT8_TBL;	
--- 80,86 ----
   to_char_1 |        to_char         |        to_char         
  -----------+------------------------+------------------------
             |                    123 |                    456
! (1 row)
  
  SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'), to_char(q2, '9,999,999,999,999,999.999,999') 
  	FROM INT8_TBL;	
***************
*** 125,135 ****
   to_char_2 |            to_char             |            to_char             
  -----------+--------------------------------+--------------------------------
             |                    123.000,000 |                    456.000,000
!            |                    123.000,000 |  4,567,890,123,456,789.000,000
!            |  4,567,890,123,456,789.000,000 |                    123.000,000
!            |  4,567,890,123,456,789.000,000 |  4,567,890,123,456,789.000,000
!            |  4,567,890,123,456,789.000,000 | -4,567,890,123,456,789.000,000
! (5 rows)
  
  SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char( (q2 * -1), '9999999999999999.999PR') 
  	FROM INT8_TBL;
--- 87,93 ----
   to_char_2 |            to_char             |            to_char             
  -----------+--------------------------------+--------------------------------
             |                    123.000,000 |                    456.000,000
! (1 row)
  
  SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char( (q2 * -1), '9999999999999999.999PR') 
  	FROM INT8_TBL;
***************
*** 136,146 ****
   to_char_3 |      to_char       |        to_char         
  -----------+--------------------+------------------------
             |              <123> |              <456.000>
!            |              <123> | <4567890123456789.000>
!            | <4567890123456789> |              <123.000>
!            | <4567890123456789> | <4567890123456789.000>
!            | <4567890123456789> |  4567890123456789.000
! (5 rows)
  
  SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2 * -1), 'S9999999999999999') 
  	FROM INT8_TBL;
--- 94,100 ----
   to_char_3 |      to_char       |        to_char         
  -----------+--------------------+------------------------
             |              <123> |              <456.000>
! (1 row)
  
  SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2 * -1), 'S9999999999999999') 
  	FROM INT8_TBL;
***************
*** 147,285 ****
   to_char_4 |      to_char      |      to_char      
  -----------+-------------------+-------------------
             |              123- |              -456
!            |              123- | -4567890123456789
!            | 4567890123456789- |              -123
!            | 4567890123456789- | -4567890123456789
!            | 4567890123456789- | +4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_5,  to_char(q2, 'MI9999999999999999')     FROM INT8_TBL;	
   to_char_5 |      to_char       
  -----------+--------------------
             |                456
!            |   4567890123456789
!            |                123
!            |   4567890123456789
!            | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_6,  to_char(q2, 'FMS9999999999999999')    FROM INT8_TBL;
   to_char_6 |      to_char      
! -----------+-------------------
             | +456
!            | +4567890123456789
!            | +123
!            | +4567890123456789
!            | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_7,  to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL;
   to_char_7 |      to_char       
! -----------+--------------------
             | 456TH
!            | 4567890123456789TH
!            | 123RD
!            | 4567890123456789TH
!            | <4567890123456789>
! (5 rows)
  
  SELECT '' AS to_char_8,  to_char(q2, 'SG9999999999999999th')   FROM INT8_TBL;	
   to_char_8 |       to_char       
  -----------+---------------------
             | +             456th
!            | +4567890123456789th
!            | +             123rd
!            | +4567890123456789th
!            | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_9,  to_char(q2, '0999999999999999')       FROM INT8_TBL;	
   to_char_9 |      to_char      
  -----------+-------------------
             |  0000000000000456
!            |  4567890123456789
!            |  0000000000000123
!            |  4567890123456789
!            | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999')      FROM INT8_TBL;	
   to_char_10 |      to_char      
  ------------+-------------------
              | +0000000000000456
!             | +4567890123456789
!             | +0000000000000123
!             | +4567890123456789
!             | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999')     FROM INT8_TBL;	
   to_char_11 |      to_char      
! ------------+-------------------
              | 0000000000000456
!             | 4567890123456789
!             | 0000000000000123
!             | 4567890123456789
!             | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL;
   to_char_12 |        to_char        
! ------------+-----------------------
              | 456.000
!             | 4567890123456789.000
!             | 123.000
!             | 4567890123456789.000
!             | -4567890123456789.000
! (5 rows)
  
  SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000')  FROM INT8_TBL;	
   to_char_13 |        to_char         
  ------------+------------------------
              |                456.000
!             |   4567890123456789.000
!             |                123.000
!             |   4567890123456789.000
!             |  -4567890123456789.000
! (5 rows)
  
  SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
   to_char_14 |      to_char      
! ------------+-------------------
              | 456
!             | 4567890123456789
!             | 123
!             | 4567890123456789
!             | -4567890123456789
! (5 rows)
  
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
   to_char_15 |                  to_char                  
  ------------+-------------------------------------------
              |                           +4 5 6 . 0 0 0 
!             | + 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
!             |                           +1 2 3 . 0 0 0 
!             | + 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
!             | - 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
! (5 rows)
  
  SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM INT8_TBL;
   to_char_16 |                          to_char                          
  ------------+-----------------------------------------------------------
              |       text      9999     "text between quote marks"   456
!             |  45678 text 9012 9999 345 "text between quote marks" 6789
!             |       text      9999     "text between quote marks"   123
!             |  45678 text 9012 9999 345 "text between quote marks" 6789
!             | -45678 text 9012 9999 345 "text between quote marks" 6789
! (5 rows)
  
  SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999')     FROM INT8_TBL;
   to_char_17 |      to_char      
  ------------+-------------------
              |       +       456
!             | 456789+0123456789
!             |       +       123
!             | 456789+0123456789
!             | 456789-0123456789
! (5 rows)
  
--- 101,183 ----
   to_char_4 |      to_char      |      to_char      
  -----------+-------------------+-------------------
             |              123- |              -456
! (1 row)
  
  SELECT '' AS to_char_5,  to_char(q2, 'MI9999999999999999')     FROM INT8_TBL;	
   to_char_5 |      to_char       
  -----------+--------------------
             |                456
! (1 row)
  
  SELECT '' AS to_char_6,  to_char(q2, 'FMS9999999999999999')    FROM INT8_TBL;
   to_char_6 | to_char 
! -----------+---------
             | +456
! (1 row)
  
  SELECT '' AS to_char_7,  to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL;
   to_char_7 | to_char 
! -----------+---------
             | 456TH
! (1 row)
  
  SELECT '' AS to_char_8,  to_char(q2, 'SG9999999999999999th')   FROM INT8_TBL;	
   to_char_8 |       to_char       
  -----------+---------------------
             | +             456th
! (1 row)
  
  SELECT '' AS to_char_9,  to_char(q2, '0999999999999999')       FROM INT8_TBL;	
   to_char_9 |      to_char      
  -----------+-------------------
             |  0000000000000456
! (1 row)
  
  SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999')      FROM INT8_TBL;	
   to_char_10 |      to_char      
  ------------+-------------------
              | +0000000000000456
! (1 row)
  
  SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999')     FROM INT8_TBL;	
   to_char_11 |     to_char      
! ------------+------------------
              | 0000000000000456
! (1 row)
  
  SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL;
   to_char_12 | to_char 
! ------------+---------
              | 456.000
! (1 row)
  
  SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000')  FROM INT8_TBL;	
   to_char_13 |        to_char         
  ------------+------------------------
              |                456.000
! (1 row)
  
  SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
   to_char_14 | to_char 
! ------------+---------
              | 456
! (1 row)
  
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
   to_char_15 |                  to_char                  
  ------------+-------------------------------------------
              |                           +4 5 6 . 0 0 0 
! (1 row)
  
  SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM INT8_TBL;
   to_char_16 |                          to_char                          
  ------------+-----------------------------------------------------------
              |       text      9999     "text between quote marks"   456
! (1 row)
  
  SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999')     FROM INT8_TBL;
   to_char_17 |      to_char      
  ------------+-------------------
              |       +       456
! (1 row)
  

======================================================================

*** ./expected/subselect.out	Thu Mar 23 08:42:13 2000
--- ./results/subselect.out	Wed Feb 28 16:35:21 2001
***************
*** 160,167 ****
  select q1, float8(count(*)) / (select count(*) from int8_tbl)
  from int8_tbl group by q1;
          q1        | ?column? 
! ------------------+----------
!               123 |      0.4
!  4567890123456789 |      0.6
! (2 rows)
  
--- 160,166 ----
  select q1, float8(count(*)) / (select count(*) from int8_tbl)
  from int8_tbl group by q1;
   q1  | ?column? 
! -----+----------
!  123 |        1
! (1 row)
  

======================================================================

*** ./expected/union.out	Thu Nov  9 03:47:49 2000
--- ./results/union.out	Wed Feb 28 16:35:22 2001
***************
*** 259,318 ****
  --
  SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
          q2        
! ------------------
!               123
!  4567890123456789
! (2 rows)
  
  SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
          q2        
! ------------------
!               123
!  4567890123456789
!  4567890123456789
! (3 rows)
  
  SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
          q2         
! -------------------
!  -4567890123456789
                 456
! (2 rows)
  
  SELECT q2 FROM int8_tbl EXCEPT ALL SELECT q1 FROM int8_tbl;
          q2         
! -------------------
!  -4567890123456789
                 456
! (2 rows)
  
  SELECT q2 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q1 FROM int8_tbl;
          q2         
! -------------------
!  -4567890123456789
                 456
!   4567890123456789
! (3 rows)
  
  SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl;
   q1 
! ----
! (0 rows)
  
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
          q1        
! ------------------
                123
!  4567890123456789
! (2 rows)
  
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
          q1        
! ------------------
                123
!  4567890123456789
!  4567890123456789
! (3 rows)
  
  --
  -- Mixed types
--- 259,307 ----
  --
  SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
   q2 
! ----
! (0 rows)
  
  SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
   q2 
! ----
! (0 rows)
  
  SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
   q2  
! -----
   456
! (1 row)
  
  SELECT q2 FROM int8_tbl EXCEPT ALL SELECT q1 FROM int8_tbl;
   q2  
! -----
   456
! (1 row)
  
  SELECT q2 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q1 FROM int8_tbl;
   q2  
! -----
   456
! (1 row)
  
  SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl;
   q1  
! -----
!  123
! (1 row)
  
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
   q1  
! -----
   123
! (1 row)
  
  SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
   q1  
! -----
   123
! (1 row)
  
  --
  -- Mixed types
***************
*** 337,396 ****
  --
  SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
          q1         
! -------------------
!                123
!   4567890123456789
                 456
!   4567890123456789
!                123
!   4567890123456789
!  -4567890123456789
! (7 rows)
  
  SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
          q1        
! ------------------
!               123
!  4567890123456789
! (2 rows)
  
  (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
          q1         
! -------------------
!                123
!   4567890123456789
                 456
!   4567890123456789
!                123
!   4567890123456789
!  -4567890123456789
! (7 rows)
  
  SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
          q1         
! -------------------
!  -4567890123456789
                 456
! (2 rows)
  
  SELECT q1 FROM int8_tbl UNION ALL (((SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl)));
          q1         
! -------------------
                 123
-                123
-   4567890123456789
-   4567890123456789
-   4567890123456789
-  -4567890123456789
                 456
! (7 rows)
  
  (((SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl))) EXCEPT SELECT q1 FROM int8_tbl;
          q1         
! -------------------
!  -4567890123456789
                 456
! (2 rows)
  
  --
  -- Subqueries with ORDER BY & LIMIT clauses
--- 326,364 ----
  --
  SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
   q1  
! -----
   456
! (1 row)
  
  SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
   q1 
! ----
! (0 rows)
  
  (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
   q1  
! -----
   456
! (1 row)
  
  SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
   q1  
! -----
   456
! (1 row)
  
  SELECT q1 FROM int8_tbl UNION ALL (((SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl)));
   q1  
! -----
   123
   456
! (2 rows)
  
  (((SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl))) EXCEPT SELECT q1 FROM int8_tbl;
   q1  
! -----
   456
! (1 row)
  
  --
  -- Subqueries with ORDER BY & LIMIT clauses
***************
*** 399,408 ****
  SELECT q1,q2 FROM int8_tbl EXCEPT SELECT q2,q1 FROM int8_tbl
  ORDER BY q2,q1;
          q1        |        q2         
! ------------------+-------------------
!  4567890123456789 | -4567890123456789
                123 |               456
! (2 rows)
  
  -- This should fail, because q2 isn't a name of an EXCEPT output column
  SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1;
--- 367,375 ----
  SELECT q1,q2 FROM int8_tbl EXCEPT SELECT q2,q1 FROM int8_tbl
  ORDER BY q2,q1;
   q1  | q2  
! -----+-----
   123 | 456
! (1 row)
  
  -- This should fail, because q2 isn't a name of an EXCEPT output column
  SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1;
***************
*** 410,419 ****
  -- But this should work:
  SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
          q1        
! ------------------
                123
!  4567890123456789
! (2 rows)
  
  --
  -- New syntaxes (7.1) permit new tests
--- 377,385 ----
  -- But this should work:
  SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
   q1  
! -----
   123
! (1 row)
  
  --
  -- New syntaxes (7.1) permit new tests
***************
*** 420,430 ****
  --
  (((((select * from int8_tbl)))));
          q1        |        q2         
! ------------------+-------------------
                123 |               456
!               123 |  4567890123456789
!  4567890123456789 |               123
!  4567890123456789 |  4567890123456789
!  4567890123456789 | -4567890123456789
! (5 rows)
  
--- 386,392 ----
  --
  (((((select * from int8_tbl)))));
   q1  | q2  
! -----+-----
   123 | 456
! (1 row)
  

======================================================================


-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Wed, 28 Feb 2001 17:04:51 +0100 (MET)
Olivier PRENANT <ohp@pyrenet.fr>
int8 beta5 broken?
Sorry to follow-up on my own post; int8 test passes if open-ssl is not
used.

weird!!

Regards,
On Wed, 28 Feb 2001, Olivier PRENANT wrote:

> Hi,
> 
> Testing beta5 on unixware7 gives an error on int8 test while beta4 (I've
> just retested it) works ok regressions.diff follows:
> 
> Also, compiling with openssl give a compile error on
> src/backend/libpq/crypt.c; this error CAN be avoided by commenting out the
> definition of des_encrypt in /ur/local/ssl/include/openssl/des.h
> 
> I'm not sure this is good practice though.
> 
> Anyway, even after that, there are linking errors on libecpg.so and perl
> because of a lack of -L/usr/local/ssl/lib
> 
> Easyly avoid by setting ad hoc LD_LIBRARY_PATH.
> 
>  *** ./expected/int8.out	Mon Jan 29 03:53:58 2001
> --- ./results/int8.out	Wed Feb 28 16:29:40 2001
> ***************
> *** 5,111 ****
>   CREATE TABLE INT8_TBL(q1 int8, q2 int8);
>   INSERT INTO INT8_TBL VALUES('123','456');
>   INSERT INTO INT8_TBL VALUES('123','4567890123456789');
>   INSERT INTO INT8_TBL VALUES('4567890123456789','123');
>   INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
>   INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
>   SELECT * FROM INT8_TBL;
>           q1        |        q2         
> ! ------------------+-------------------
>                 123 |               456
> !               123 |  4567890123456789
> !  4567890123456789 |               123
> !  4567890123456789 |  4567890123456789
> !  4567890123456789 | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
>    five |       plus       |       minus       
> ! ------+------------------+-------------------
>         |              123 |              -123
> !       |              123 |              -123
> !       | 4567890123456789 | -4567890123456789
> !       | 4567890123456789 | -4567890123456789
> !       | 4567890123456789 | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
>    five |        q1        |        q2         |       plus       
> ! ------+------------------+-------------------+------------------
>         |              123 |               456 |              579
> !       |              123 |  4567890123456789 | 4567890123456912
> !       | 4567890123456789 |               123 | 4567890123456912
> !       | 4567890123456789 |  4567890123456789 | 9135780246913578
> !       | 4567890123456789 | -4567890123456789 |                0
> ! (5 rows)
>   
>   SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
>    five |        q1        |        q2         |       minus       
> ! ------+------------------+-------------------+-------------------
>         |              123 |               456 |              -333
> !       |              123 |  4567890123456789 | -4567890123456666
> !       | 4567890123456789 |               123 |  4567890123456666
> !       | 4567890123456789 |  4567890123456789 |                 0
> !       | 4567890123456789 | -4567890123456789 |  9135780246913578
> ! (5 rows)
>   
>   SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL
>    WHERE q1 < 1000 or (q2 > 0 and q2 < 1000);
>    three |        q1        |        q2        |      multiply      
> ! -------+------------------+------------------+--------------------
>          |              123 |              456 |              56088
> !        |              123 | 4567890123456789 | 561850485185185047
> !        | 4567890123456789 |              123 | 561850485185185047
> ! (3 rows)
>   
>   SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL;
>    five |        q1        |        q2         |     divide     
> ! ------+------------------+-------------------+----------------
>         |              123 |               456 |              0
> !       |              123 |  4567890123456789 |              0
> !       | 4567890123456789 |               123 | 37137318076884
> !       | 4567890123456789 |  4567890123456789 |              1
> !       | 4567890123456789 | -4567890123456789 |             -1
> ! (5 rows)
>   
>   SELECT '' AS five, q1, float8(q1) FROM INT8_TBL;
>    five |        q1        |        float8        
> ! ------+------------------+----------------------
>         |              123 |                  123
> !       |              123 |                  123
> !       | 4567890123456789 | 4.56789012345679e+15
> !       | 4567890123456789 | 4.56789012345679e+15
> !       | 4567890123456789 | 4.56789012345679e+15
> ! (5 rows)
>   
>   SELECT '' AS five, q2, float8(q2) FROM INT8_TBL;
>    five |        q2         |        float8         
> ! ------+-------------------+-----------------------
>         |               456 |                   456
> !       |  4567890123456789 |  4.56789012345679e+15
> !       |               123 |                   123
> !       |  4567890123456789 |  4.56789012345679e+15
> !       | -4567890123456789 | -4.56789012345679e+15
> ! (5 rows)
>   
>   SELECT '' AS five, 2 * q1 AS "twice int4" FROM INT8_TBL;
>    five |    twice int4    
> ! ------+------------------
>         |              246
> !       |              246
> !       | 9135780246913578
> !       | 9135780246913578
> !       | 9135780246913578
> ! (5 rows)
>   
>   SELECT '' AS five, q1 * 2 AS "twice int4" FROM INT8_TBL;
>    five |    twice int4    
> ! ------+------------------
>         |              246
> !       |              246
> !       | 9135780246913578
> !       | 9135780246913578
> !       | 9135780246913578
> ! (5 rows)
>   
>   -- TO_CHAR()
>   --
> --- 5,77 ----
>   CREATE TABLE INT8_TBL(q1 int8, q2 int8);
>   INSERT INTO INT8_TBL VALUES('123','456');
>   INSERT INTO INT8_TBL VALUES('123','4567890123456789');
> + ERROR:  int8 value out of range: "4567890123456789"
>   INSERT INTO INT8_TBL VALUES('4567890123456789','123');
> + ERROR:  int8 value out of range: "4567890123456789"
>   INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
> + ERROR:  int8 value out of range: "4567890123456789"
>   INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
> + ERROR:  int8 value out of range: "4567890123456789"
>   SELECT * FROM INT8_TBL;
>    q1  | q2  
> ! -----+-----
>    123 | 456
> ! (1 row)
>   
>   SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
>    five | plus | minus 
> ! ------+------+-------
>         |  123 |  -123
> ! (1 row)
>   
>   SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
>    five | q1  | q2  | plus 
> ! ------+-----+-----+------
>         | 123 | 456 |  579
> ! (1 row)
>   
>   SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
>    five | q1  | q2  | minus 
> ! ------+-----+-----+-------
>         | 123 | 456 |  -333
> ! (1 row)
>   
>   SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL
>    WHERE q1 < 1000 or (q2 > 0 and q2 < 1000);
>    three | q1  | q2  | multiply 
> ! -------+-----+-----+----------
>          | 123 | 456 |    56088
> ! (1 row)
>   
>   SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL;
>    five | q1  | q2  | divide 
> ! ------+-----+-----+--------
>         | 123 | 456 |      0
> ! (1 row)
>   
>   SELECT '' AS five, q1, float8(q1) FROM INT8_TBL;
>    five | q1  | float8 
> ! ------+-----+--------
>         | 123 |    123
> ! (1 row)
>   
>   SELECT '' AS five, q2, float8(q2) FROM INT8_TBL;
>    five | q2  | float8 
> ! ------+-----+--------
>         | 456 |    456
> ! (1 row)
>   
>   SELECT '' AS five, 2 * q1 AS "twice int4" FROM INT8_TBL;
>    five | twice int4 
> ! ------+------------
>         |        246
> ! (1 row)
>   
>   SELECT '' AS five, q1 * 2 AS "twice int4" FROM INT8_TBL;
>    five | twice int4 
> ! ------+------------
>         |        246
> ! (1 row)
>   
>   -- TO_CHAR()
>   --
> ***************
> *** 114,124 ****
>    to_char_1 |        to_char         |        to_char         
>   -----------+------------------------+------------------------
>              |                    123 |                    456
> !            |                    123 |  4,567,890,123,456,789
> !            |  4,567,890,123,456,789 |                    123
> !            |  4,567,890,123,456,789 |  4,567,890,123,456,789
> !            |  4,567,890,123,456,789 | -4,567,890,123,456,789
> ! (5 rows)
>   
>   SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'), to_char(q2, '9,999,999,999,999,999.999,999') 
>   	FROM INT8_TBL;	
> --- 80,86 ----
>    to_char_1 |        to_char         |        to_char         
>   -----------+------------------------+------------------------
>              |                    123 |                    456
> ! (1 row)
>   
>   SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'), to_char(q2, '9,999,999,999,999,999.999,999') 
>   	FROM INT8_TBL;	
> ***************
> *** 125,135 ****
>    to_char_2 |            to_char             |            to_char             
>   -----------+--------------------------------+--------------------------------
>              |                    123.000,000 |                    456.000,000
> !            |                    123.000,000 |  4,567,890,123,456,789.000,000
> !            |  4,567,890,123,456,789.000,000 |                    123.000,000
> !            |  4,567,890,123,456,789.000,000 |  4,567,890,123,456,789.000,000
> !            |  4,567,890,123,456,789.000,000 | -4,567,890,123,456,789.000,000
> ! (5 rows)
>   
>   SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char( (q2 * -1), '9999999999999999.999PR') 
>   	FROM INT8_TBL;
> --- 87,93 ----
>    to_char_2 |            to_char             |            to_char             
>   -----------+--------------------------------+--------------------------------
>              |                    123.000,000 |                    456.000,000
> ! (1 row)
>   
>   SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char( (q2 * -1), '9999999999999999.999PR') 
>   	FROM INT8_TBL;
> ***************
> *** 136,146 ****
>    to_char_3 |      to_char       |        to_char         
>   -----------+--------------------+------------------------
>              |              <123> |              <456.000>
> !            |              <123> | <4567890123456789.000>
> !            | <4567890123456789> |              <123.000>
> !            | <4567890123456789> | <4567890123456789.000>
> !            | <4567890123456789> |  4567890123456789.000
> ! (5 rows)
>   
>   SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2 * -1), 'S9999999999999999') 
>   	FROM INT8_TBL;
> --- 94,100 ----
>    to_char_3 |      to_char       |        to_char         
>   -----------+--------------------+------------------------
>              |              <123> |              <456.000>
> ! (1 row)
>   
>   SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2 * -1), 'S9999999999999999') 
>   	FROM INT8_TBL;
> ***************
> *** 147,285 ****
>    to_char_4 |      to_char      |      to_char      
>   -----------+-------------------+-------------------
>              |              123- |              -456
> !            |              123- | -4567890123456789
> !            | 4567890123456789- |              -123
> !            | 4567890123456789- | -4567890123456789
> !            | 4567890123456789- | +4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_5,  to_char(q2, 'MI9999999999999999')     FROM INT8_TBL;	
>    to_char_5 |      to_char       
>   -----------+--------------------
>              |                456
> !            |   4567890123456789
> !            |                123
> !            |   4567890123456789
> !            | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_6,  to_char(q2, 'FMS9999999999999999')    FROM INT8_TBL;
>    to_char_6 |      to_char      
> ! -----------+-------------------
>              | +456
> !            | +4567890123456789
> !            | +123
> !            | +4567890123456789
> !            | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_7,  to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL;
>    to_char_7 |      to_char       
> ! -----------+--------------------
>              | 456TH
> !            | 4567890123456789TH
> !            | 123RD
> !            | 4567890123456789TH
> !            | <4567890123456789>
> ! (5 rows)
>   
>   SELECT '' AS to_char_8,  to_char(q2, 'SG9999999999999999th')   FROM INT8_TBL;	
>    to_char_8 |       to_char       
>   -----------+---------------------
>              | +             456th
> !            | +4567890123456789th
> !            | +             123rd
> !            | +4567890123456789th
> !            | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_9,  to_char(q2, '0999999999999999')       FROM INT8_TBL;	
>    to_char_9 |      to_char      
>   -----------+-------------------
>              |  0000000000000456
> !            |  4567890123456789
> !            |  0000000000000123
> !            |  4567890123456789
> !            | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999')      FROM INT8_TBL;	
>    to_char_10 |      to_char      
>   ------------+-------------------
>               | +0000000000000456
> !             | +4567890123456789
> !             | +0000000000000123
> !             | +4567890123456789
> !             | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999')     FROM INT8_TBL;	
>    to_char_11 |      to_char      
> ! ------------+-------------------
>               | 0000000000000456
> !             | 4567890123456789
> !             | 0000000000000123
> !             | 4567890123456789
> !             | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL;
>    to_char_12 |        to_char        
> ! ------------+-----------------------
>               | 456.000
> !             | 4567890123456789.000
> !             | 123.000
> !             | 4567890123456789.000
> !             | -4567890123456789.000
> ! (5 rows)
>   
>   SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000')  FROM INT8_TBL;	
>    to_char_13 |        to_char         
>   ------------+------------------------
>               |                456.000
> !             |   4567890123456789.000
> !             |                123.000
> !             |   4567890123456789.000
> !             |  -4567890123456789.000
> ! (5 rows)
>   
>   SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
>    to_char_14 |      to_char      
> ! ------------+-------------------
>               | 456
> !             | 4567890123456789
> !             | 123
> !             | 4567890123456789
> !             | -4567890123456789
> ! (5 rows)
>   
>   SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
>    to_char_15 |                  to_char                  
>   ------------+-------------------------------------------
>               |                           +4 5 6 . 0 0 0 
> !             | + 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
> !             |                           +1 2 3 . 0 0 0 
> !             | + 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
> !             | - 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 . 0 0 0
> ! (5 rows)
>   
>   SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM INT8_TBL;
>    to_char_16 |                          to_char                          
>   ------------+-----------------------------------------------------------
>               |       text      9999     "text between quote marks"   456
> !             |  45678 text 9012 9999 345 "text between quote marks" 6789
> !             |       text      9999     "text between quote marks"   123
> !             |  45678 text 9012 9999 345 "text between quote marks" 6789
> !             | -45678 text 9012 9999 345 "text between quote marks" 6789
> ! (5 rows)
>   
>   SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999')     FROM INT8_TBL;
>    to_char_17 |      to_char      
>   ------------+-------------------
>               |       +       456
> !             | 456789+0123456789
> !             |       +       123
> !             | 456789+0123456789
> !             | 456789-0123456789
> ! (5 rows)
>   
> --- 101,183 ----
>    to_char_4 |      to_char      |      to_char      
>   -----------+-------------------+-------------------
>              |              123- |              -456
> ! (1 row)
>   
>   SELECT '' AS to_char_5,  to_char(q2, 'MI9999999999999999')     FROM INT8_TBL;	
>    to_char_5 |      to_char       
>   -----------+--------------------
>              |                456
> ! (1 row)
>   
>   SELECT '' AS to_char_6,  to_char(q2, 'FMS9999999999999999')    FROM INT8_TBL;
>    to_char_6 | to_char 
> ! -----------+---------
>              | +456
> ! (1 row)
>   
>   SELECT '' AS to_char_7,  to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL;
>    to_char_7 | to_char 
> ! -----------+---------
>              | 456TH
> ! (1 row)
>   
>   SELECT '' AS to_char_8,  to_char(q2, 'SG9999999999999999th')   FROM INT8_TBL;	
>    to_char_8 |       to_char       
>   -----------+---------------------
>              | +             456th
> ! (1 row)
>   
>   SELECT '' AS to_char_9,  to_char(q2, '0999999999999999')       FROM INT8_TBL;	
>    to_char_9 |      to_char      
>   -----------+-------------------
>              |  0000000000000456
> ! (1 row)
>   
>   SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999')      FROM INT8_TBL;	
>    to_char_10 |      to_char      
>   ------------+-------------------
>               | +0000000000000456
> ! (1 row)
>   
>   SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999')     FROM INT8_TBL;	
>    to_char_11 |     to_char      
> ! ------------+------------------
>               | 0000000000000456
> ! (1 row)
>   
>   SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL;
>    to_char_12 | to_char 
> ! ------------+---------
>               | 456.000
> ! (1 row)
>   
>   SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000')  FROM INT8_TBL;	
>    to_char_13 |        to_char         
>   ------------+------------------------
>               |                456.000
> ! (1 row)
>   
>   SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
>    to_char_14 | to_char 
> ! ------------+---------
>               | 456
> ! (1 row)
>   
>   SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
>    to_char_15 |                  to_char                  
>   ------------+-------------------------------------------
>               |                           +4 5 6 . 0 0 0 
> ! (1 row)
>   
>   SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999 "\\"text between quote marks\\"" 9999') FROM INT8_TBL;
>    to_char_16 |                          to_char                          
>   ------------+-----------------------------------------------------------
>               |       text      9999     "text between quote marks"   456
> ! (1 row)
>   
>   SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999')     FROM INT8_TBL;
>    to_char_17 |      to_char      
>   ------------+-------------------
>               |       +       456
> ! (1 row)
>   
> 
> ======================================================================
> 
> *** ./expected/subselect.out	Thu Mar 23 08:42:13 2000
> --- ./results/subselect.out	Wed Feb 28 16:35:21 2001
> ***************
> *** 160,167 ****
>   select q1, float8(count(*)) / (select count(*) from int8_tbl)
>   from int8_tbl group by q1;
>           q1        | ?column? 
> ! ------------------+----------
> !               123 |      0.4
> !  4567890123456789 |      0.6
> ! (2 rows)
>   
> --- 160,166 ----
>   select q1, float8(count(*)) / (select count(*) from int8_tbl)
>   from int8_tbl group by q1;
>    q1  | ?column? 
> ! -----+----------
> !  123 |        1
> ! (1 row)
>   
> 
> ======================================================================
> 
> *** ./expected/union.out	Thu Nov  9 03:47:49 2000
> --- ./results/union.out	Wed Feb 28 16:35:22 2001
> ***************
> *** 259,318 ****
>   --
>   SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
>           q2        
> ! ------------------
> !               123
> !  4567890123456789
> ! (2 rows)
>   
>   SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
>           q2        
> ! ------------------
> !               123
> !  4567890123456789
> !  4567890123456789
> ! (3 rows)
>   
>   SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
>           q2         
> ! -------------------
> !  -4567890123456789
>                  456
> ! (2 rows)
>   
>   SELECT q2 FROM int8_tbl EXCEPT ALL SELECT q1 FROM int8_tbl;
>           q2         
> ! -------------------
> !  -4567890123456789
>                  456
> ! (2 rows)
>   
>   SELECT q2 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q1 FROM int8_tbl;
>           q2         
> ! -------------------
> !  -4567890123456789
>                  456
> !   4567890123456789
> ! (3 rows)
>   
>   SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl;
>    q1 
> ! ----
> ! (0 rows)
>   
>   SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
>           q1        
> ! ------------------
>                 123
> !  4567890123456789
> ! (2 rows)
>   
>   SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
>           q1        
> ! ------------------
>                 123
> !  4567890123456789
> !  4567890123456789
> ! (3 rows)
>   
>   --
>   -- Mixed types
> --- 259,307 ----
>   --
>   SELECT q2 FROM int8_tbl INTERSECT SELECT q1 FROM int8_tbl;
>    q2 
> ! ----
> ! (0 rows)
>   
>   SELECT q2 FROM int8_tbl INTERSECT ALL SELECT q1 FROM int8_tbl;
>    q2 
> ! ----
> ! (0 rows)
>   
>   SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
>    q2  
> ! -----
>    456
> ! (1 row)
>   
>   SELECT q2 FROM int8_tbl EXCEPT ALL SELECT q1 FROM int8_tbl;
>    q2  
> ! -----
>    456
> ! (1 row)
>   
>   SELECT q2 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q1 FROM int8_tbl;
>    q2  
> ! -----
>    456
> ! (1 row)
>   
>   SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl;
>    q1  
> ! -----
> !  123
> ! (1 row)
>   
>   SELECT q1 FROM int8_tbl EXCEPT ALL SELECT q2 FROM int8_tbl;
>    q1  
> ! -----
>    123
> ! (1 row)
>   
>   SELECT q1 FROM int8_tbl EXCEPT ALL SELECT DISTINCT q2 FROM int8_tbl;
>    q1  
> ! -----
>    123
> ! (1 row)
>   
>   --
>   -- Mixed types
> ***************
> *** 337,396 ****
>   --
>   SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
>           q1         
> ! -------------------
> !                123
> !   4567890123456789
>                  456
> !   4567890123456789
> !                123
> !   4567890123456789
> !  -4567890123456789
> ! (7 rows)
>   
>   SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
>           q1        
> ! ------------------
> !               123
> !  4567890123456789
> ! (2 rows)
>   
>   (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
>           q1         
> ! -------------------
> !                123
> !   4567890123456789
>                  456
> !   4567890123456789
> !                123
> !   4567890123456789
> !  -4567890123456789
> ! (7 rows)
>   
>   SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
>           q1         
> ! -------------------
> !  -4567890123456789
>                  456
> ! (2 rows)
>   
>   SELECT q1 FROM int8_tbl UNION ALL (((SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl)));
>           q1         
> ! -------------------
>                  123
> -                123
> -   4567890123456789
> -   4567890123456789
> -   4567890123456789
> -  -4567890123456789
>                  456
> ! (7 rows)
>   
>   (((SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl))) EXCEPT SELECT q1 FROM int8_tbl;
>           q1         
> ! -------------------
> !  -4567890123456789
>                  456
> ! (2 rows)
>   
>   --
>   -- Subqueries with ORDER BY & LIMIT clauses
> --- 326,364 ----
>   --
>   SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl;
>    q1  
> ! -----
>    456
> ! (1 row)
>   
>   SELECT q1 FROM int8_tbl INTERSECT (((SELECT q2 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl)));
>    q1 
> ! ----
> ! (0 rows)
>   
>   (((SELECT q1 FROM int8_tbl INTERSECT SELECT q2 FROM int8_tbl))) UNION ALL SELECT q2 FROM int8_tbl;
>    q1  
> ! -----
>    456
> ! (1 row)
>   
>   SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl;
>    q1  
> ! -----
>    456
> ! (1 row)
>   
>   SELECT q1 FROM int8_tbl UNION ALL (((SELECT q2 FROM int8_tbl EXCEPT SELECT q1 FROM int8_tbl)));
>    q1  
> ! -----
>    123
>    456
> ! (2 rows)
>   
>   (((SELECT q1 FROM int8_tbl UNION ALL SELECT q2 FROM int8_tbl))) EXCEPT SELECT q1 FROM int8_tbl;
>    q1  
> ! -----
>    456
> ! (1 row)
>   
>   --
>   -- Subqueries with ORDER BY & LIMIT clauses
> ***************
> *** 399,408 ****
>   SELECT q1,q2 FROM int8_tbl EXCEPT SELECT q2,q1 FROM int8_tbl
>   ORDER BY q2,q1;
>           q1        |        q2         
> ! ------------------+-------------------
> !  4567890123456789 | -4567890123456789
>                 123 |               456
> ! (2 rows)
>   
>   -- This should fail, because q2 isn't a name of an EXCEPT output column
>   SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1;
> --- 367,375 ----
>   SELECT q1,q2 FROM int8_tbl EXCEPT SELECT q2,q1 FROM int8_tbl
>   ORDER BY q2,q1;
>    q1  | q2  
> ! -----+-----
>    123 | 456
> ! (1 row)
>   
>   -- This should fail, because q2 isn't a name of an EXCEPT output column
>   SELECT q1 FROM int8_tbl EXCEPT SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1;
> ***************
> *** 410,419 ****
>   -- But this should work:
>   SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
>           q1        
> ! ------------------
>                 123
> !  4567890123456789
> ! (2 rows)
>   
>   --
>   -- New syntaxes (7.1) permit new tests
> --- 377,385 ----
>   -- But this should work:
>   SELECT q1 FROM int8_tbl EXCEPT (((SELECT q2 FROM int8_tbl ORDER BY q2 LIMIT 1)));
>    q1  
> ! -----
>    123
> ! (1 row)
>   
>   --
>   -- New syntaxes (7.1) permit new tests
> ***************
> *** 420,430 ****
>   --
>   (((((select * from int8_tbl)))));
>           q1        |        q2         
> ! ------------------+-------------------
>                 123 |               456
> !               123 |  4567890123456789
> !  4567890123456789 |               123
> !  4567890123456789 |  4567890123456789
> !  4567890123456789 | -4567890123456789
> ! (5 rows)
>   
> --- 386,392 ----
>   --
>   (((((select * from int8_tbl)))));
>    q1  | q2  
> ! -----+-----
>    123 | 456
> ! (1 row)
>   
> 
> ======================================================================
> 
> 
> 

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Wed, 28 Feb 2001 17:44:48 +0100 (MET)
Olivier PRENANT <ohp@pyrenet.fr>
Re: int8 beta5 broken?
Olivier PRENANT <ohp@pyrenet.fr> writes:
> Testing beta5 on unixware7 gives an error on int8 test while beta4 (I've
> just retested it) works ok.

That's odd.  int8.c hasn't changed since beta3 (except in the
float-to-int8 routine, which isn't involved here).  Is there any
difference in the src/include/config.h file generated by the two
versions?

			regards, tom lane

Wed, 28 Feb 2001 11:53:55 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] int8 beta5 broken? 
Olivier PRENANT <ohp@pyrenet.fr> writes:
> Sorry to follow-up on my own post; int8 test passes if open-ssl is not
> used.

That's difficult to believe, because int8.c doesn't include anything
that even knows SSL exists.  Larry, can you confirm this behavior?

			regards, tom lane

Wed, 28 Feb 2001 12:04:10 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: int8 beta5 broken? 
Working on it.

Give me a couple of hours.

LER

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, February 28, 2001 11:04 AM
To: ohp@pyrenet.fr
Cc: pgsql-hackers@postgresql.org; Larry Rosenman
Subject: Re: [HACKERS] Re: int8 beta5 broken? 


Olivier PRENANT <ohp@pyrenet.fr> writes:
> Sorry to follow-up on my own post; int8 test passes if open-ssl is not
> used.

That's difficult to believe, because int8.c doesn't include anything
that even knows SSL exists.  Larry, can you confirm this behavior?

			regards, tom lane


Wed, 28 Feb 2001 11:12:48 -0600
"Larry Rosenman" <ler@lerctr.org>
RE: Re: int8 beta5 broken? 
Olivier PRENANT writes:

> Testing beta5 on unixware7 gives an error on int8 test while beta4 (I've
> just retested it) works ok regressions.diff follows:

This doesn't happen to be caused by the compiler bug described in
doc/FAQ_SCO?

> Anyway, even after that, there are linking errors on libecpg.so and perl
> because of a lack of -L/usr/local/ssl/lib

Can you post some screen output, so we can see what the command was that
caused the error?


-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Wed, 28 Feb 2001 18:19:53 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] int8 beta5 broken?
* Larry Rosenman <ler@lerctr.org> [010228 11:13]:
> Working on it.
> 
> Give me a couple of hours.
> 
Olivier,
    How did you build OpenSSL?  I get the following (I only have a
static lib): 


cc -O -K inline -K PIC -I. -I../../../src/include -I/usr/local/include -I/usr/local/ssl/include -DFRONTEND -DSYSCONFDIR='"/usr/local/pgsql/etc"'  -c -o wchar.o wchar.c
ar crs libpq.a `lorder fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o pqsignal.o wchar.o | tsort`
UX:tsort: WARNING: Cycle in data
UX:tsort: INFO: 	fe-connect.o
UX:tsort: INFO: 	fe-auth.o
UX:tsort: WARNING: Cycle in data
UX:tsort: INFO: 	fe-exec.o
UX:tsort: INFO: 	fe-misc.o
UX:tsort: INFO: 	fe-connect.o
: libpq.a
cc -G -Wl,-z,text -Wl,-h,libpq.so.2 fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o pqsignal.o    wchar.o -L/usr/local/lib -L/usr/local/ssl/lib -lssl -lcrypto -lresolv -lnsl -lsocket -Wl,-R/usr/local/pgsql/lib -o libpq.so.2.1
UX:ld: INFO: text relocations referenced from files:
libssl.a(s23_meth.o)
libssl.a(s23_srvr.o)
libssl.a(s23_clnt.o)
libssl.a(s23_lib.o)
libssl.a(s23_pkt.o)
libssl.a(t1_meth.o)
libssl.a(t1_srvr.o)
libssl.a(t1_clnt.o)
libssl.a(t1_lib.o)
libssl.a(t1_enc.o)
libssl.a(ssl_lib.o)
libssl.a(ssl_err2.o)
libssl.a(ssl_cert.o)
libssl.a(ssl_sess.o)
libssl.a(ssl_ciph.o)
libssl.a(ssl_algs.o)
libssl.a(ssl_err.o)
libssl.a(s2_srvr.o)
libssl.a(s2_clnt.o)
libssl.a(s2_lib.o)
libssl.a(s2_enc.o)
libssl.a(s2_pkt.o)
libssl.a(s3_meth.o)
libssl.a(s3_srvr.o)
libssl.a(s3_clnt.o)
libssl.a(s3_lib.o)
libssl.a(s3_enc.o)
libssl.a(s3_pkt.o)
libssl.a(s3_both.o)
libssl.a(ssl_rsa.o)
libcrypto.a(cryptlib.o)
libcrypto.a(mem.o)
libcrypto.a(ex_data.o)
libcrypto.a(md5_dgst.o)
libcrypto.a(sha1dgst.o)
libcrypto.a(hmac.o)
libcrypto.a(fcrypt.o)
libcrypto.a(bn_lib.o)
libcrypto.a(rsa_lib.o)
libcrypto.a(rsa_sign.o)
libcrypto.a(dsa_vrf.o)
libcrypto.a(dsa_sign.o)
libcrypto.a(dh_key.o)
libcrypto.a(dh_lib.o)
libcrypto.a(buffer.o)
libcrypto.a(bio_lib.o)
libcrypto.a(bss_file.o)
libcrypto.a(bss_sock.o)
libcrypto.a(bf_buff.o)
libcrypto.a(b_print.o)
libcrypto.a(stack.o)
libcrypto.a(lhash.o)
libcrypto.a(rand_lib.o)
libcrypto.a(err.o)
libcrypto.a(err_all.o)
libcrypto.a(o_names.o)
libcrypto.a(obj_dat.o)
libcrypto.a(obj_lib.o)
libcrypto.a(obj_err.o)
libcrypto.a(digest.o)
libcrypto.a(evp_enc.o)
libcrypto.a(e_des.o)
libcrypto.a(e_idea.o)
libcrypto.a(e_des3.o)
libcrypto.a(e_rc4.o)
libcrypto.a(names.o)
libcrypto.a(e_rc2.o)
libcrypto.a(m_md2.o)
libcrypto.a(m_md5.o)
libcrypto.a(m_sha1.o)
libcrypto.a(m_dss1.o)
libcrypto.a(p_sign.o)
libcrypto.a(p_verify.o)
libcrypto.a(p_lib.o)
libcrypto.a(evp_err.o)
libcrypto.a(e_null.o)
libcrypto.a(evp_lib.o)
libcrypto.a(evp_pbe.o)
libcrypto.a(a_object.o)
libcrypto.a(a_dup.o)
libcrypto.a(x_sig.o)
libcrypto.a(x_name.o)
libcrypto.a(x_x509.o)
libcrypto.a(x_x509a.o)
libcrypto.a(d2i_r_pr.o)
libcrypto.a(i2d_r_pr.o)
libcrypto.a(d2i_pr.o)
libcrypto.a(i2d_dhp.o)
libcrypto.a(d2i_dhp.o)
libcrypto.a(asn1_lib.o)
libcrypto.a(asn1_err.o)
libcrypto.a(evp_asn1.o)
libcrypto.a(pem_all.o)
libcrypto.a(pem_err.o)
libcrypto.a(x509_d2.o)
libcrypto.a(x509_cmp.o)
libcrypto.a(x509_obj.o)
libcrypto.a(x509_vfy.o)
libcrypto.a(x509_err.o)
libcrypto.a(x509_ext.o)
libcrypto.a(x509type.o)
libcrypto.a(x509_lu.o)
libcrypto.a(x_all.o)
libcrypto.a(x509_trs.o)
libcrypto.a(by_file.o)
libcrypto.a(by_dir.o)
libcrypto.a(v3_lib.o)
libcrypto.a(v3err.o)
libcrypto.a(v3_alt.o)
libcrypto.a(v3_skey.o)
libcrypto.a(v3_akey.o)
libcrypto.a(v3_pku.o)
libcrypto.a(v3_enum.o)
libcrypto.a(v3_sxnet.o)
libcrypto.a(v3_cpols.o)
libcrypto.a(v3_crld.o)
libcrypto.a(v3_purp.o)
libcrypto.a(v3_info.o)
libcrypto.a(conf_err.o)
libcrypto.a(pkcs7err.o)
libcrypto.a(pk12err.o)
libcrypto.a(comp_lib.o)
libcrypto.a(mem_dbg.o)
libcrypto.a(cpt_err.o)
libcrypto.a(md2_dgst.o)
libcrypto.a(md5_one.o)
libcrypto.a(set_key.o)
libcrypto.a(ecb_enc.o)
libcrypto.a(ecb3_enc.o)
libcrypto.a(cfb64enc.o)
libcrypto.a(cfb64ede.o)
libcrypto.a(ofb64ede.o)
libcrypto.a(ofb64enc.o)
libcrypto.a(des_enc.o)
libcrypto.a(fcrypt_b.o)
libcrypto.a(rc2_ecb.o)
libcrypto.a(rc2_skey.o)
libcrypto.a(rc2_cbc.o)
libcrypto.a(rc2cfb64.o)
libcrypto.a(rc2ofb64.o)
libcrypto.a(rc4_skey.o)
libcrypto.a(i_cbc.o)
libcrypto.a(i_cfb64.o)
libcrypto.a(i_ofb64.o)
libcrypto.a(i_ecb.o)
libcrypto.a(bn_exp.o)
libcrypto.a(bn_ctx.o)
libcrypto.a(bn_mul.o)
libcrypto.a(bn_rand.o)
libcrypto.a(bn_word.o)
libcrypto.a(bn_blind.o)
libcrypto.a(bn_gcd.o)
libcrypto.a(bn_err.o)
libcrypto.a(bn_sqr.o)
libcrypto.a(bn_asm.o)
libcrypto.a(bn_recp.o)
libcrypto.a(bn_mont.o)
libcrypto.a(rsa_eay.o)
libcrypto.a(rsa_err.o)
libcrypto.a(rsa_pk1.o)
libcrypto.a(rsa_ssl.o)
libcrypto.a(rsa_none.o)
libcrypto.a(rsa_oaep.o)
libcrypto.a(dsa_lib.o)
libcrypto.a(dsa_asn1.o)
libcrypto.a(dsa_err.o)
libcrypto.a(dsa_ossl.o)
libcrypto.a(dh_err.o)
libcrypto.a(dso_err.o)
libcrypto.a(buf_err.o)
libcrypto.a(bio_err.o)
libcrypto.a(md_rand.o)
libcrypto.a(rand_err.o)
libcrypto.a(rand_win.o)
libcrypto.a(evp_pkey.o)
libcrypto.a(a_bitstr.o)
libcrypto.a(a_utctm.o)
libcrypto.a(a_gentm.o)
libcrypto.a(a_time.o)
libcrypto.a(a_int.o)
libcrypto.a(a_octet.o)
libcrypto.a(a_print.o)
libcrypto.a(a_type.o)
libcrypto.a(a_set.o)
libcrypto.a(a_d2i_fp.o)
libcrypto.a(a_i2d_fp.o)
libcrypto.a(a_enum.o)
libcrypto.a(a_vis.o)
libcrypto.a(a_utf8.o)
libcrypto.a(a_sign.o)
libcrypto.a(a_digest.o)
libcrypto.a(a_verify.o)
libcrypto.a(x_algor.o)
libcrypto.a(x_pubkey.o)
libcrypto.a(x_req.o)
libcrypto.a(x_attrib.o)
libcrypto.a(x_cinf.o)
libcrypto.a(x_crl.o)
libcrypto.a(x_info.o)
libcrypto.a(x_spki.o)
libcrypto.a(nsseq.o)
libcrypto.a(d2i_r_pu.o)
libcrypto.a(i2d_r_pu.o)
libcrypto.a(d2i_s_pr.o)
libcrypto.a(i2d_s_pr.o)
libcrypto.a(d2i_pu.o)
libcrypto.a(i2d_pu.o)
libcrypto.a(i2d_pr.o)
libcrypto.a(t_x509.o)
libcrypto.a(t_x509a.o)
libcrypto.a(t_pkey.o)
libcrypto.a(p7_i_s.o)
libcrypto.a(p7_lib.o)
libcrypto.a(i2d_dsap.o)
libcrypto.a(d2i_dsap.o)
libcrypto.a(x_pkey.o)
libcrypto.a(x_exten.o)
libcrypto.a(a_bytes.o)
libcrypto.a(asn_pack.o)
libcrypto.a(p8_pkey.o)
libcrypto.a(pem_info.o)
libcrypto.a(pem_lib.o)
libcrypto.a(x509_def.o)
libcrypto.a(x509name.o)
libcrypto.a(x509_v3.o)
libcrypto.a(v3_bcons.o)
libcrypto.a(v3_bitst.o)
libcrypto.a(v3_conf.o)
libcrypto.a(v3_extku.o)
libcrypto.a(v3_ia5.o)
libcrypto.a(v3_prn.o)
libcrypto.a(v3_utl.o)
libcrypto.a(v3_genn.o)
libcrypto.a(conf_lib.o)
libcrypto.a(conf_api.o)
libcrypto.a(conf_def.o)
libcrypto.a(p12_add.o)
libcrypto.a(p12_bags.o)
libcrypto.a(p12_decr.o)
libcrypto.a(p12_sbag.o)
libcrypto.a(sha1_one.o)
libcrypto.a(bn_add.o)
libcrypto.a(bn_div.o)
libcrypto.a(bn_print.o)
libcrypto.a(bn_shift.o)
libcrypto.a(bn_exp2.o)
libcrypto.a(err_prn.o)
libcrypto.a(encode.o)
libcrypto.a(evp_key.o)
libcrypto.a(x_val.o)
libcrypto.a(d2i_s_pu.o)
libcrypto.a(i2d_s_pu.o)
libcrypto.a(p7_signd.o)
libcrypto.a(p7_evp.o)
libcrypto.a(p7_dgst.o)
libcrypto.a(p7_s_e.o)
libcrypto.a(p7_enc.o)
libcrypto.a(a_bool.o)
libcrypto.a(a_strnid.o)
libcrypto.a(p5_pbe.o)
libcrypto.a(p5_pbev2.o)
libcrypto.a(x509_req.o)
libcrypto.a(x509rset.o)
libcrypto.a(x509_att.o)
libcrypto.a(pk7_lib.o)
libcrypto.a(read_pwd.o)
libcrypto.a(a_mbstr.o)
libcrypto.a(p7_signi.o)
libcrypto.a(p7_recip.o)
libcrypto.a(p7_enc_c.o)
UX:ld: ERROR: relocations remain against non-writeable, allocatable section .text
gmake[3]: *** [libpq.so.2.1] Error 1
gmake[3]: Leaving directory `/home/ler/pg-dev/pgsql/src/interfaces/libpq'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/home/ler/pg-dev/pgsql/src/interfaces'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/home/ler/pg-dev/pgsql/src'
gmake: *** [all] Error 2
> LER
> 
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, February 28, 2001 11:04 AM
> To: ohp@pyrenet.fr
> Cc: pgsql-hackers@postgresql.org; Larry Rosenman
> Subject: Re: [HACKERS] Re: int8 beta5 broken? 
> 
> 
> Olivier PRENANT <ohp@pyrenet.fr> writes:
> > Sorry to follow-up on my own post; int8 test passes if open-ssl is not
> > used.
> 
> That's difficult to believe, because int8.c doesn't include anything
> that even knows SSL exists.  Larry, can you confirm this behavior?
> 
> 			regards, tom lane

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Wed, 28 Feb 2001 11:26:59 -0600
Larry Rosenman <ler@lerctr.org>
Re: Re: int8 beta5 broken?
On Wed, 28 Feb 2001, Tom Lane wrote:

> Olivier PRENANT <ohp@pyrenet.fr> writes:
> > Sorry to follow-up on my own post; int8 test passes if open-ssl is not
> > used.
> 
> That's difficult to believe, because int8.c doesn't include anything
> that even knows SSL exists.  Larry, can you confirm this behavior?
Hi, I've been testing a little more further and found that (with-openssl)
if initdb is done with LANG=C, int8 test succeeds
if initdb is done with LANG=fr int8 test fails.

I'll try nowwithout openssl and LANG=fr

Regards
> 
> 			regards, tom lane
> 

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Thu, 1 Mar 2001 13:00:57 +0100 (MET)
Olivier PRENANT <ohp@pyrenet.fr>
Re: Re: int8 beta5 broken? 