*** ./expected/join.out Wed Jan 9 21:42:28 2008 --- ./results/join.out Mon Apr 21 13:50:53 2008 *************** *** 214,226 **** WHERE t1.a = t2.d; xxx | a | e -----+---+---- - | 0 | | 1 | -1 | 2 | 2 - | 2 | 4 | 3 | -3 | 5 | -5 | 5 | -5 (7 rows) -- --- 214,226 ---- WHERE t1.a = t2.d; xxx | a | e -----+---+---- | 1 | -1 | 2 | 2 | 3 | -3 + | 2 | 4 | 5 | -5 | 5 | -5 + | 0 | (7 rows) -- *************** *** 1569,1581 **** FROM J1_TBL INNER JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 (7 rows) -- Same as above, slightly different syntax --- 1569,1581 ---- FROM J1_TBL INNER JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) -- Same as above, slightly different syntax *************** *** 1583,1595 **** FROM J1_TBL JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 (7 rows) SELECT '' AS "xxx", * --- 1583,1595 ---- FROM J1_TBL JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) SELECT '' AS "xxx", * *************** *** 1625,1637 **** FROM J1_TBL NATURAL JOIN J2_TBL; xxx | i | j | t | k -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 (7 rows) SELECT '' AS "xxx", * --- 1625,1637 ---- FROM J1_TBL NATURAL JOIN J2_TBL; xxx | i | j | t | k -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) SELECT '' AS "xxx", * *************** *** 1638,1650 **** FROM J1_TBL t1 (a, b, c) NATURAL JOIN J2_TBL t2 (a, d); xxx | a | b | c | d -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 (7 rows) SELECT '' AS "xxx", * --- 1638,1650 ---- FROM J1_TBL t1 (a, b, c) NATURAL JOIN J2_TBL t2 (a, d); xxx | a | b | c | d -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) SELECT '' AS "xxx", * *************** *** 1651,1659 **** FROM J1_TBL t1 (a, b, c) NATURAL JOIN J2_TBL t2 (d, a); xxx | a | b | c | d -----+---+---+------+--- - | 0 | | zero | | 2 | 3 | two | 2 | 4 | 1 | four | 2 (3 rows) -- mismatch number of columns --- 1651,1659 ---- FROM J1_TBL t1 (a, b, c) NATURAL JOIN J2_TBL t2 (d, a); xxx | a | b | c | d -----+---+---+------+--- | 2 | 3 | two | 2 | 4 | 1 | four | 2 + | 0 | | zero | (3 rows) -- mismatch number of columns *************** *** 1662,1674 **** FROM J1_TBL t1 (a, b) NATURAL JOIN J2_TBL t2 (a); xxx | a | b | t | k -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 (7 rows) -- --- 1662,1674 ---- FROM J1_TBL t1 (a, b) NATURAL JOIN J2_TBL t2 (a); xxx | a | b | t | k -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) -- *************** *** 1678,1690 **** FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.i); xxx | i | j | t | i | k -----+---+---+-------+---+---- - | 0 | | zero | 0 | | 1 | 4 | one | 1 | -1 | 2 | 3 | two | 2 | 2 - | 2 | 3 | two | 2 | 4 | 3 | 2 | three | 3 | -3 | 5 | 0 | five | 5 | -5 | 5 | 0 | five | 5 | -5 (7 rows) SELECT '' AS "xxx", * --- 1678,1690 ---- FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.i); xxx | i | j | t | i | k -----+---+---+-------+---+---- | 1 | 4 | one | 1 | -1 | 2 | 3 | two | 2 | 2 | 3 | 2 | three | 3 | -3 + | 2 | 3 | two | 2 | 4 | 5 | 0 | five | 5 | -5 | 5 | 0 | five | 5 | -5 + | 0 | | zero | 0 | (7 rows) SELECT '' AS "xxx", * *************** *** 1691,1699 **** FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.k); xxx | i | j | t | i | k -----+---+---+------+---+--- - | 0 | | zero | | 0 | 2 | 3 | two | 2 | 2 | 4 | 1 | four | 2 | 4 (3 rows) -- --- 1691,1699 ---- FROM J1_TBL JOIN J2_TBL ON (J1_TBL.i = J2_TBL.k); xxx | i | j | t | i | k -----+---+---+------+---+--- | 2 | 3 | two | 2 | 2 | 4 | 1 | four | 2 | 4 + | 0 | | zero | | 0 (3 rows) -- *************** *** 1762,1774 **** FROM J1_TBL RIGHT OUTER JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 | | | | | | | | 0 (9 rows) --- 1762,1774 ---- FROM J1_TBL RIGHT OUTER JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | | | | | | | | | 0 (9 rows) *************** *** 1777,1789 **** FROM J1_TBL RIGHT JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- - | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 - | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 | | | | | | | | 0 (9 rows) --- 1777,1789 ---- FROM J1_TBL RIGHT JOIN J2_TBL USING (i); xxx | i | j | t | k -----+---+---+-------+---- | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 3 | 2 | three | -3 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | | | | | | | | | 0 (9 rows) ====================================================================== *** ./expected/arrays.out Thu Mar 20 22:42:48 2008 --- ./results/arrays.out Mon Apr 21 13:50:52 2008 *************** *** 139,146 **** a | b | c ---------------+-----------------------+------------------- {16,25,3,4,5} | {{{113,142},{1,147}}} | {} - {16,25,23} | {{3,4},{4,5}} | {foobar,new_word} [4:4]={NULL} | {3,4} | {foo,new_word} (3 rows) -- --- 139,146 ---- a | b | c ---------------+-----------------------+------------------- {16,25,3,4,5} | {{{113,142},{1,147}}} | {} [4:4]={NULL} | {3,4} | {foo,new_word} + {16,25,23} | {{3,4},{4,5}} | {foobar,new_word} (3 rows) -- ====================================================================== *** ./expected/misc.out Mon Apr 21 13:50:12 2008 --- ./results/misc.out Mon Apr 21 13:50:55 2008 *************** *** 356,361 **** --- 356,362 ---- e | 18 | | | e | | hi elisa | | e | | | -4 | + f | 25 | | -9 | f | 19 | hi claire | -5 | f | 20 | hi mike | -6 | f | 21 | hi marcel | | *************** *** 362,368 **** f | 22 | | -7 | f | | hi keith | -8 | f | 24 | hi marc | | - f | 25 | | -9 | f | 26 | | | f | | hi allison | -10 | f | | hi jeff | | --- 363,368 ---- *************** *** 416,421 **** --- 416,422 ---- e | 18 | e | | e | | + f | 25 | f | 19 | f | 20 | f | 21 | *************** *** 422,428 **** f | 22 | f | | f | 24 | - f | 25 | f | 26 | f | | f | | --- 423,428 ---- ====================================================================== *** ./expected/polymorphism.out Fri Jan 11 19:39:41 2008 --- ./results/polymorphism.out Mon Apr 21 13:51:03 2008 *************** *** 355,362 **** select f3, myaggp01a(*) from t group by f3; f3 | myaggp01a ----+----------- - b | {} c | {} a | {} (3 rows) --- 355,362 ---- select f3, myaggp01a(*) from t group by f3; f3 | myaggp01a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 363,370 **** select f3, myaggp03a(*) from t group by f3; f3 | myaggp03a ----+----------- - b | {} c | {} a | {} (3 rows) --- 363,370 ---- select f3, myaggp03a(*) from t group by f3; f3 | myaggp03a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 371,378 **** select f3, myaggp03b(*) from t group by f3; f3 | myaggp03b ----+----------- - b | {} c | {} a | {} (3 rows) --- 371,378 ---- select f3, myaggp03b(*) from t group by f3; f3 | myaggp03b ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 379,386 **** select f3, myaggp05a(f1) from t group by f3; f3 | myaggp05a ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 379,386 ---- select f3, myaggp05a(f1) from t group by f3; f3 | myaggp05a ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 387,394 **** select f3, myaggp06a(f1) from t group by f3; f3 | myaggp06a ----+----------- - b | {} c | {} a | {} (3 rows) --- 387,394 ---- select f3, myaggp06a(f1) from t group by f3; f3 | myaggp06a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 395,402 **** select f3, myaggp08a(f1) from t group by f3; f3 | myaggp08a ----+----------- - b | {} c | {} a | {} (3 rows) --- 395,402 ---- select f3, myaggp08a(f1) from t group by f3; f3 | myaggp08a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 403,410 **** select f3, myaggp09a(f1) from t group by f3; f3 | myaggp09a ----+----------- - b | {} c | {} a | {} (3 rows) --- 403,410 ---- select f3, myaggp09a(f1) from t group by f3; f3 | myaggp09a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 411,418 **** select f3, myaggp09b(f1) from t group by f3; f3 | myaggp09b ----+----------- - b | {} c | {} a | {} (3 rows) --- 411,418 ---- select f3, myaggp09b(f1) from t group by f3; f3 | myaggp09b ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 419,426 **** select f3, myaggp10a(f1) from t group by f3; f3 | myaggp10a ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 419,426 ---- select f3, myaggp10a(f1) from t group by f3; f3 | myaggp10a ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 427,434 **** select f3, myaggp10b(f1) from t group by f3; f3 | myaggp10b ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 427,434 ---- select f3, myaggp10b(f1) from t group by f3; f3 | myaggp10b ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 435,442 **** select f3, myaggp20a(f1) from t group by f3; f3 | myaggp20a ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 435,442 ---- select f3, myaggp20a(f1) from t group by f3; f3 | myaggp20a ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 443,450 **** select f3, myaggp20b(f1) from t group by f3; f3 | myaggp20b ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 443,450 ---- select f3, myaggp20b(f1) from t group by f3; f3 | myaggp20b ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 451,458 **** select f3, myaggn01a(*) from t group by f3; f3 | myaggn01a ----+----------- - b | {} c | {} a | {} (3 rows) --- 451,458 ---- select f3, myaggn01a(*) from t group by f3; f3 | myaggn01a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 459,466 **** select f3, myaggn01b(*) from t group by f3; f3 | myaggn01b ----+----------- - b | {} c | {} a | {} (3 rows) --- 459,466 ---- select f3, myaggn01b(*) from t group by f3; f3 | myaggn01b ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 467,474 **** select f3, myaggn03a(*) from t group by f3; f3 | myaggn03a ----+----------- - b | {} c | {} a | {} (3 rows) --- 467,474 ---- select f3, myaggn03a(*) from t group by f3; f3 | myaggn03a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 475,482 **** select f3, myaggn05a(f1) from t group by f3; f3 | myaggn05a ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 475,482 ---- select f3, myaggn05a(f1) from t group by f3; f3 | myaggn05a ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 483,490 **** select f3, myaggn05b(f1) from t group by f3; f3 | myaggn05b ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 483,490 ---- select f3, myaggn05b(f1) from t group by f3; f3 | myaggn05b ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) *************** *** 491,498 **** select f3, myaggn06a(f1) from t group by f3; f3 | myaggn06a ----+----------- - b | {} c | {} a | {} (3 rows) --- 491,498 ---- select f3, myaggn06a(f1) from t group by f3; f3 | myaggn06a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 499,506 **** select f3, myaggn06b(f1) from t group by f3; f3 | myaggn06b ----+----------- - b | {} c | {} a | {} (3 rows) --- 499,506 ---- select f3, myaggn06b(f1) from t group by f3; f3 | myaggn06b ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 507,514 **** select f3, myaggn08a(f1) from t group by f3; f3 | myaggn08a ----+----------- - b | {} c | {} a | {} (3 rows) --- 507,514 ---- select f3, myaggn08a(f1) from t group by f3; f3 | myaggn08a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 515,522 **** select f3, myaggn08b(f1) from t group by f3; f3 | myaggn08b ----+----------- - b | {} c | {} a | {} (3 rows) --- 515,522 ---- select f3, myaggn08b(f1) from t group by f3; f3 | myaggn08b ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 523,530 **** select f3, myaggn09a(f1) from t group by f3; f3 | myaggn09a ----+----------- - b | {} c | {} a | {} (3 rows) --- 523,530 ---- select f3, myaggn09a(f1) from t group by f3; f3 | myaggn09a ----+----------- c | {} + b | {} a | {} (3 rows) *************** *** 531,538 **** select f3, myaggn10a(f1) from t group by f3; f3 | myaggn10a ----+----------- - b | {1,2,3} c | {1,2} a | {1,2,3} (3 rows) --- 531,538 ---- select f3, myaggn10a(f1) from t group by f3; f3 | myaggn10a ----+----------- c | {1,2} + b | {1,2,3} a | {1,2,3} (3 rows) ======================================================================