Thread
-
int8 beta5 broken?
ohp@pyrenet.fr — 2001-02-28T16:04:51Z
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) -
Re: int8 beta5 broken?
ohp@pyrenet.fr — 2001-02-28T16:44:48Z
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) -
Re: [HACKERS] int8 beta5 broken?
Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-28T16:53:55Z
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
-
Re: Re: int8 beta5 broken?
Tom Lane <tgl@sss.pgh.pa.us> — 2001-02-28T17:04:10Z
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
-
RE: Re: int8 beta5 broken?
Larry Rosenman <ler@lerctr.org> — 2001-02-28T17:12:48Z
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
-
Re: [HACKERS] int8 beta5 broken?
Peter Eisentraut <peter_e@gmx.net> — 2001-02-28T17:19:53Z
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/
-
Re: Re: int8 beta5 broken?
Larry Rosenman <ler@lerctr.org> — 2001-02-28T17:26:59Z
* 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 -
Re: Re: int8 beta5 broken?
ohp@pyrenet.fr — 2001-03-01T12:00:57Z
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)