*** ./expected/join.out Thu Sep 25 16:58:06 2003 --- ./results/join.out Tue Feb 24 21:39:26 2004 *************** *** 216,223 **** -----+---+---- | 0 | | 1 | -1 - | 2 | 2 | 2 | 4 | 3 | -3 | 5 | -5 | 5 | -5 --- 216,223 ---- -----+---+---- | 0 | | 1 | -1 | 2 | 4 + | 2 | 2 | 3 | -3 | 5 | -5 | 5 | -5 *************** *** 1569,1576 **** -----+---+---+-------+---- | 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 --- 1569,1576 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 *************** *** 1583,1590 **** -----+---+---+-------+---- | 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 --- 1583,1590 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 *************** *** 1625,1632 **** -----+---+---+-------+---- | 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 --- 1625,1632 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 *************** *** 1638,1645 **** -----+---+---+-------+---- | 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 --- 1638,1645 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 *************** *** 1662,1669 **** -----+---+---+-------+---- | 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 --- 1662,1669 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 *************** *** 1678,1685 **** -----+---+---+-------+---+---- | 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 --- 1678,1685 ---- -----+---+---+-------+---+---- | 0 | | zero | 0 | | 1 | 4 | one | 1 | -1 | 2 | 3 | two | 2 | 4 + | 2 | 3 | two | 2 | 2 | 3 | 2 | three | 3 | -3 | 5 | 0 | five | 5 | -5 | 5 | 0 | five | 5 | -5 *************** *** 1723,1730 **** -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 - | 2 | 3 | two | 2 | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 4 | 1 | four | | 5 | 0 | five | -5 --- 1723,1730 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 4 | 1 | four | | 5 | 0 | five | -5 *************** *** 1732,1739 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | (13 rows) SELECT '' AS "xxx", * --- 1732,1739 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | (13 rows) SELECT '' AS "xxx", * *************** *** 1743,1750 **** -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 - | 2 | 3 | two | 2 | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 4 | 1 | four | | 5 | 0 | five | -5 --- 1743,1750 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 4 | 1 | four | | 5 | 0 | five | -5 *************** *** 1752,1759 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | (13 rows) SELECT '' AS "xxx", * --- 1752,1759 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | (13 rows) SELECT '' AS "xxx", * *************** *** 1762,1774 **** -----+---+---+-------+---- | 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) SELECT '' AS "xxx", * --- 1762,1774 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 | | | | 0 + | | | | (9 rows) SELECT '' AS "xxx", * *************** *** 1777,1789 **** -----+---+---+-------+---- | 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) SELECT '' AS "xxx", * --- 1777,1789 ---- -----+---+---+-------+---- | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 4 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 | | | | 0 + | | | | (9 rows) SELECT '' AS "xxx", * ====================================================================== *** ./expected/rules.out Thu Dec 18 19:09:14 2003 --- ./results/rules.out Tue Feb 24 21:39:41 2004 *************** *** 1124,1131 **** SELECT * FROM shoelace_obsolete; sl_name | sl_avail | sl_color | sl_len | sl_unit | sl_len_cm ------------+----------+------------+--------+----------+----------- - sl9 | 0 | pink | 35 | inch | 88.9 sl10 | 1000 | magenta | 40 | inch | 101.6 (2 rows) SELECT * FROM shoelace_candelete; --- 1124,1131 ---- SELECT * FROM shoelace_obsolete; sl_name | sl_avail | sl_color | sl_len | sl_unit | sl_len_cm ------------+----------+------------+--------+----------+----------- sl10 | 1000 | magenta | 40 | inch | 101.6 + sl9 | 0 | pink | 35 | inch | 88.9 (2 rows) SELECT * FROM shoelace_candelete; ====================================================================== *** ./expected/stats.out Sat Nov 1 14:18:20 2003 --- ./results/stats.out Tue Feb 24 21:42:09 2004 *************** *** 62,68 **** WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column? ----------+----------+----------+---------- ! t | t | t | t (1 row) SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages, --- 62,68 ---- WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? | ?column? | ?column? ----------+----------+----------+---------- ! f | f | f | f (1 row) SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages, *************** *** 71,77 **** WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? ----------+---------- ! t | t (1 row) -- clean up --- 71,77 ---- WHERE st.relname='tenk2' AND cl.relname='tenk2'; ?column? | ?column? ----------+---------- ! f | f (1 row) -- clean up ======================================================================