diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-12-01 19:00:56 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-12-01 19:00:56 +0000 |
| commit | 5374d097de4d7321f03df7899816e61502438b32 (patch) | |
| tree | e7dae5fe8181c528568b4a8bb9ca1aa4c7261831 /src/test/regress/expected/join.out | |
| parent | b7bcea64ecca27e67dbc81525a71fcc0da396b36 (diff) | |
| download | postgresql-5374d097de4d7321f03df7899816e61502438b32.tar.gz | |
Change planner to use the current true disk file size as its estimate of
a relation's number of blocks, rather than the possibly-obsolete value
in pg_class.relpages. Scale the value in pg_class.reltuples correspondingly
to arrive at a hopefully more accurate number of rows. When pg_class
contains 0/0, estimate a tuple width from the column datatypes and divide
that into current file size to estimate number of rows. This improved
methodology allows us to jettison the ancient hacks that put bogus default
values into pg_class when a table is first created. Also, per a suggestion
from Simon, make VACUUM (but not VACUUM FULL or ANALYZE) adjust the value
it puts into pg_class.reltuples to try to represent the mean tuple density
instead of the minimal density that actually prevails just after VACUUM.
These changes alter the plans selected for certain regression tests, so
update the expected files accordingly. (I removed join_1.out because
it's not clear if it still applies; we can add back any variant versions
as they are shown to be needed.)
Diffstat (limited to 'src/test/regress/expected/join.out')
| -rw-r--r-- | src/test/regress/expected/join.out | 1640 |
1 files changed, 820 insertions, 820 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index 471e149b8c..ec708f7766 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -214,13 +214,13 @@ SELECT '' AS "xxx", t1.a, t2.e WHERE t1.a = t2.d; xxx | a | e -----+---+---- - | 0 | | 1 | -1 | 2 | 2 - | 2 | 4 | 3 | -3 + | 2 | 4 | 5 | -5 | 5 | -5 + | 0 | (7 rows) -- @@ -660,895 +660,895 @@ SELECT '' AS "xxx", * xxx | i | j | t | i | k | i | k -----+---+---+-------+---+----+---+---- | 1 | 4 | one | 1 | -1 | 1 | -1 - | 2 | 3 | two | 1 | -1 | 1 | -1 - | 3 | 2 | three | 1 | -1 | 1 | -1 - | 4 | 1 | four | 1 | -1 | 1 | -1 - | 5 | 0 | five | 1 | -1 | 1 | -1 - | 6 | 6 | six | 1 | -1 | 1 | -1 - | 7 | 7 | seven | 1 | -1 | 1 | -1 - | 8 | 8 | eight | 1 | -1 | 1 | -1 - | 0 | | zero | 1 | -1 | 1 | -1 - | | | null | 1 | -1 | 1 | -1 - | | 0 | zero | 1 | -1 | 1 | -1 | 1 | 4 | one | 1 | -1 | 2 | 2 - | 2 | 3 | two | 1 | -1 | 2 | 2 - | 3 | 2 | three | 1 | -1 | 2 | 2 - | 4 | 1 | four | 1 | -1 | 2 | 2 - | 5 | 0 | five | 1 | -1 | 2 | 2 - | 6 | 6 | six | 1 | -1 | 2 | 2 - | 7 | 7 | seven | 1 | -1 | 2 | 2 - | 8 | 8 | eight | 1 | -1 | 2 | 2 - | 0 | | zero | 1 | -1 | 2 | 2 - | | | null | 1 | -1 | 2 | 2 - | | 0 | zero | 1 | -1 | 2 | 2 | 1 | 4 | one | 1 | -1 | 3 | -3 - | 2 | 3 | two | 1 | -1 | 3 | -3 - | 3 | 2 | three | 1 | -1 | 3 | -3 - | 4 | 1 | four | 1 | -1 | 3 | -3 - | 5 | 0 | five | 1 | -1 | 3 | -3 - | 6 | 6 | six | 1 | -1 | 3 | -3 - | 7 | 7 | seven | 1 | -1 | 3 | -3 - | 8 | 8 | eight | 1 | -1 | 3 | -3 - | 0 | | zero | 1 | -1 | 3 | -3 - | | | null | 1 | -1 | 3 | -3 - | | 0 | zero | 1 | -1 | 3 | -3 | 1 | 4 | one | 1 | -1 | 2 | 4 - | 2 | 3 | two | 1 | -1 | 2 | 4 - | 3 | 2 | three | 1 | -1 | 2 | 4 - | 4 | 1 | four | 1 | -1 | 2 | 4 - | 5 | 0 | five | 1 | -1 | 2 | 4 - | 6 | 6 | six | 1 | -1 | 2 | 4 - | 7 | 7 | seven | 1 | -1 | 2 | 4 - | 8 | 8 | eight | 1 | -1 | 2 | 4 - | 0 | | zero | 1 | -1 | 2 | 4 - | | | null | 1 | -1 | 2 | 4 - | | 0 | zero | 1 | -1 | 2 | 4 | 1 | 4 | one | 1 | -1 | 5 | -5 - | 2 | 3 | two | 1 | -1 | 5 | -5 - | 3 | 2 | three | 1 | -1 | 5 | -5 - | 4 | 1 | four | 1 | -1 | 5 | -5 - | 5 | 0 | five | 1 | -1 | 5 | -5 - | 6 | 6 | six | 1 | -1 | 5 | -5 - | 7 | 7 | seven | 1 | -1 | 5 | -5 - | 8 | 8 | eight | 1 | -1 | 5 | -5 - | 0 | | zero | 1 | -1 | 5 | -5 - | | | null | 1 | -1 | 5 | -5 - | | 0 | zero | 1 | -1 | 5 | -5 | 1 | 4 | one | 1 | -1 | 5 | -5 - | 2 | 3 | two | 1 | -1 | 5 | -5 - | 3 | 2 | three | 1 | -1 | 5 | -5 - | 4 | 1 | four | 1 | -1 | 5 | -5 - | 5 | 0 | five | 1 | -1 | 5 | -5 - | 6 | 6 | six | 1 | -1 | 5 | -5 - | 7 | 7 | seven | 1 | -1 | 5 | -5 - | 8 | 8 | eight | 1 | -1 | 5 | -5 - | 0 | | zero | 1 | -1 | 5 | -5 - | | | null | 1 | -1 | 5 | -5 - | | 0 | zero | 1 | -1 | 5 | -5 | 1 | 4 | one | 1 | -1 | 0 | - | 2 | 3 | two | 1 | -1 | 0 | - | 3 | 2 | three | 1 | -1 | 0 | - | 4 | 1 | four | 1 | -1 | 0 | - | 5 | 0 | five | 1 | -1 | 0 | - | 6 | 6 | six | 1 | -1 | 0 | - | 7 | 7 | seven | 1 | -1 | 0 | - | 8 | 8 | eight | 1 | -1 | 0 | - | 0 | | zero | 1 | -1 | 0 | - | | | null | 1 | -1 | 0 | - | | 0 | zero | 1 | -1 | 0 | | 1 | 4 | one | 1 | -1 | | - | 2 | 3 | two | 1 | -1 | | - | 3 | 2 | three | 1 | -1 | | - | 4 | 1 | four | 1 | -1 | | - | 5 | 0 | five | 1 | -1 | | - | 6 | 6 | six | 1 | -1 | | - | 7 | 7 | seven | 1 | -1 | | - | 8 | 8 | eight | 1 | -1 | | - | 0 | | zero | 1 | -1 | | - | | | null | 1 | -1 | | - | | 0 | zero | 1 | -1 | | | 1 | 4 | one | 1 | -1 | | 0 - | 2 | 3 | two | 1 | -1 | | 0 - | 3 | 2 | three | 1 | -1 | | 0 - | 4 | 1 | four | 1 | -1 | | 0 - | 5 | 0 | five | 1 | -1 | | 0 - | 6 | 6 | six | 1 | -1 | | 0 - | 7 | 7 | seven | 1 | -1 | | 0 - | 8 | 8 | eight | 1 | -1 | | 0 - | 0 | | zero | 1 | -1 | | 0 - | | | null | 1 | -1 | | 0 - | | 0 | zero | 1 | -1 | | 0 | 1 | 4 | one | 2 | 2 | 1 | -1 - | 2 | 3 | two | 2 | 2 | 1 | -1 - | 3 | 2 | three | 2 | 2 | 1 | -1 - | 4 | 1 | four | 2 | 2 | 1 | -1 - | 5 | 0 | five | 2 | 2 | 1 | -1 - | 6 | 6 | six | 2 | 2 | 1 | -1 - | 7 | 7 | seven | 2 | 2 | 1 | -1 - | 8 | 8 | eight | 2 | 2 | 1 | -1 - | 0 | | zero | 2 | 2 | 1 | -1 - | | | null | 2 | 2 | 1 | -1 - | | 0 | zero | 2 | 2 | 1 | -1 | 1 | 4 | one | 2 | 2 | 2 | 2 - | 2 | 3 | two | 2 | 2 | 2 | 2 - | 3 | 2 | three | 2 | 2 | 2 | 2 - | 4 | 1 | four | 2 | 2 | 2 | 2 - | 5 | 0 | five | 2 | 2 | 2 | 2 - | 6 | 6 | six | 2 | 2 | 2 | 2 - | 7 | 7 | seven | 2 | 2 | 2 | 2 - | 8 | 8 | eight | 2 | 2 | 2 | 2 - | 0 | | zero | 2 | 2 | 2 | 2 - | | | null | 2 | 2 | 2 | 2 - | | 0 | zero | 2 | 2 | 2 | 2 | 1 | 4 | one | 2 | 2 | 3 | -3 - | 2 | 3 | two | 2 | 2 | 3 | -3 - | 3 | 2 | three | 2 | 2 | 3 | -3 - | 4 | 1 | four | 2 | 2 | 3 | -3 - | 5 | 0 | five | 2 | 2 | 3 | -3 - | 6 | 6 | six | 2 | 2 | 3 | -3 - | 7 | 7 | seven | 2 | 2 | 3 | -3 - | 8 | 8 | eight | 2 | 2 | 3 | -3 - | 0 | | zero | 2 | 2 | 3 | -3 - | | | null | 2 | 2 | 3 | -3 - | | 0 | zero | 2 | 2 | 3 | -3 | 1 | 4 | one | 2 | 2 | 2 | 4 - | 2 | 3 | two | 2 | 2 | 2 | 4 - | 3 | 2 | three | 2 | 2 | 2 | 4 - | 4 | 1 | four | 2 | 2 | 2 | 4 - | 5 | 0 | five | 2 | 2 | 2 | 4 - | 6 | 6 | six | 2 | 2 | 2 | 4 - | 7 | 7 | seven | 2 | 2 | 2 | 4 - | 8 | 8 | eight | 2 | 2 | 2 | 4 - | 0 | | zero | 2 | 2 | 2 | 4 - | | | null | 2 | 2 | 2 | 4 - | | 0 | zero | 2 | 2 | 2 | 4 | 1 | 4 | one | 2 | 2 | 5 | -5 - | 2 | 3 | two | 2 | 2 | 5 | -5 - | 3 | 2 | three | 2 | 2 | 5 | -5 - | 4 | 1 | four | 2 | 2 | 5 | -5 - | 5 | 0 | five | 2 | 2 | 5 | -5 - | 6 | 6 | six | 2 | 2 | 5 | -5 - | 7 | 7 | seven | 2 | 2 | 5 | -5 - | 8 | 8 | eight | 2 | 2 | 5 | -5 - | 0 | | zero | 2 | 2 | 5 | -5 - | | | null | 2 | 2 | 5 | -5 - | | 0 | zero | 2 | 2 | 5 | -5 | 1 | 4 | one | 2 | 2 | 5 | -5 - | 2 | 3 | two | 2 | 2 | 5 | -5 - | 3 | 2 | three | 2 | 2 | 5 | -5 - | 4 | 1 | four | 2 | 2 | 5 | -5 - | 5 | 0 | five | 2 | 2 | 5 | -5 - | 6 | 6 | six | 2 | 2 | 5 | -5 - | 7 | 7 | seven | 2 | 2 | 5 | -5 - | 8 | 8 | eight | 2 | 2 | 5 | -5 - | 0 | | zero | 2 | 2 | 5 | -5 - | | | null | 2 | 2 | 5 | -5 - | | 0 | zero | 2 | 2 | 5 | -5 | 1 | 4 | one | 2 | 2 | 0 | - | 2 | 3 | two | 2 | 2 | 0 | - | 3 | 2 | three | 2 | 2 | 0 | - | 4 | 1 | four | 2 | 2 | 0 | - | 5 | 0 | five | 2 | 2 | 0 | - | 6 | 6 | six | 2 | 2 | 0 | - | 7 | 7 | seven | 2 | 2 | 0 | - | 8 | 8 | eight | 2 | 2 | 0 | - | 0 | | zero | 2 | 2 | 0 | - | | | null | 2 | 2 | 0 | - | | 0 | zero | 2 | 2 | 0 | | 1 | 4 | one | 2 | 2 | | - | 2 | 3 | two | 2 | 2 | | - | 3 | 2 | three | 2 | 2 | | - | 4 | 1 | four | 2 | 2 | | - | 5 | 0 | five | 2 | 2 | | - | 6 | 6 | six | 2 | 2 | | - | 7 | 7 | seven | 2 | 2 | | - | 8 | 8 | eight | 2 | 2 | | - | 0 | | zero | 2 | 2 | | - | | | null | 2 | 2 | | - | | 0 | zero | 2 | 2 | | | 1 | 4 | one | 2 | 2 | | 0 - | 2 | 3 | two | 2 | 2 | | 0 - | 3 | 2 | three | 2 | 2 | | 0 - | 4 | 1 | four | 2 | 2 | | 0 - | 5 | 0 | five | 2 | 2 | | 0 - | 6 | 6 | six | 2 | 2 | | 0 - | 7 | 7 | seven | 2 | 2 | | 0 - | 8 | 8 | eight | 2 | 2 | | 0 - | 0 | | zero | 2 | 2 | | 0 - | | | null | 2 | 2 | | 0 - | | 0 | zero | 2 | 2 | | 0 | 1 | 4 | one | 3 | -3 | 1 | -1 - | 2 | 3 | two | 3 | -3 | 1 | -1 - | 3 | 2 | three | 3 | -3 | 1 | -1 - | 4 | 1 | four | 3 | -3 | 1 | -1 - | 5 | 0 | five | 3 | -3 | 1 | -1 - | 6 | 6 | six | 3 | -3 | 1 | -1 - | 7 | 7 | seven | 3 | -3 | 1 | -1 - | 8 | 8 | eight | 3 | -3 | 1 | -1 - | 0 | | zero | 3 | -3 | 1 | -1 - | | | null | 3 | -3 | 1 | -1 - | | 0 | zero | 3 | -3 | 1 | -1 | 1 | 4 | one | 3 | -3 | 2 | 2 - | 2 | 3 | two | 3 | -3 | 2 | 2 - | 3 | 2 | three | 3 | -3 | 2 | 2 - | 4 | 1 | four | 3 | -3 | 2 | 2 - | 5 | 0 | five | 3 | -3 | 2 | 2 - | 6 | 6 | six | 3 | -3 | 2 | 2 - | 7 | 7 | seven | 3 | -3 | 2 | 2 - | 8 | 8 | eight | 3 | -3 | 2 | 2 - | 0 | | zero | 3 | -3 | 2 | 2 - | | | null | 3 | -3 | 2 | 2 - | | 0 | zero | 3 | -3 | 2 | 2 | 1 | 4 | one | 3 | -3 | 3 | -3 - | 2 | 3 | two | 3 | -3 | 3 | -3 - | 3 | 2 | three | 3 | -3 | 3 | -3 - | 4 | 1 | four | 3 | -3 | 3 | -3 - | 5 | 0 | five | 3 | -3 | 3 | -3 - | 6 | 6 | six | 3 | -3 | 3 | -3 - | 7 | 7 | seven | 3 | -3 | 3 | -3 - | 8 | 8 | eight | 3 | -3 | 3 | -3 - | 0 | | zero | 3 | -3 | 3 | -3 - | | | null | 3 | -3 | 3 | -3 - | | 0 | zero | 3 | -3 | 3 | -3 | 1 | 4 | one | 3 | -3 | 2 | 4 - | 2 | 3 | two | 3 | -3 | 2 | 4 - | 3 | 2 | three | 3 | -3 | 2 | 4 - | 4 | 1 | four | 3 | -3 | 2 | 4 - | 5 | 0 | five | 3 | -3 | 2 | 4 - | 6 | 6 | six | 3 | -3 | 2 | 4 - | 7 | 7 | seven | 3 | -3 | 2 | 4 - | 8 | 8 | eight | 3 | -3 | 2 | 4 - | 0 | | zero | 3 | -3 | 2 | 4 - | | | null | 3 | -3 | 2 | 4 - | | 0 | zero | 3 | -3 | 2 | 4 | 1 | 4 | one | 3 | -3 | 5 | -5 - | 2 | 3 | two | 3 | -3 | 5 | -5 - | 3 | 2 | three | 3 | -3 | 5 | -5 - | 4 | 1 | four | 3 | -3 | 5 | -5 - | 5 | 0 | five | 3 | -3 | 5 | -5 - | 6 | 6 | six | 3 | -3 | 5 | -5 - | 7 | 7 | seven | 3 | -3 | 5 | -5 - | 8 | 8 | eight | 3 | -3 | 5 | -5 - | 0 | | zero | 3 | -3 | 5 | -5 - | | | null | 3 | -3 | 5 | -5 - | | 0 | zero | 3 | -3 | 5 | -5 | 1 | 4 | one | 3 | -3 | 5 | -5 - | 2 | 3 | two | 3 | -3 | 5 | -5 - | 3 | 2 | three | 3 | -3 | 5 | -5 - | 4 | 1 | four | 3 | -3 | 5 | -5 - | 5 | 0 | five | 3 | -3 | 5 | -5 - | 6 | 6 | six | 3 | -3 | 5 | -5 - | 7 | 7 | seven | 3 | -3 | 5 | -5 - | 8 | 8 | eight | 3 | -3 | 5 | -5 - | 0 | | zero | 3 | -3 | 5 | -5 - | | | null | 3 | -3 | 5 | -5 - | | 0 | zero | 3 | -3 | 5 | -5 | 1 | 4 | one | 3 | -3 | 0 | - | 2 | 3 | two | 3 | -3 | 0 | - | 3 | 2 | three | 3 | -3 | 0 | - | 4 | 1 | four | 3 | -3 | 0 | - | 5 | 0 | five | 3 | -3 | 0 | - | 6 | 6 | six | 3 | -3 | 0 | - | 7 | 7 | seven | 3 | -3 | 0 | - | 8 | 8 | eight | 3 | -3 | 0 | - | 0 | | zero | 3 | -3 | 0 | - | | | null | 3 | -3 | 0 | - | | 0 | zero | 3 | -3 | 0 | | 1 | 4 | one | 3 | -3 | | - | 2 | 3 | two | 3 | -3 | | - | 3 | 2 | three | 3 | -3 | | - | 4 | 1 | four | 3 | -3 | | - | 5 | 0 | five | 3 | -3 | | - | 6 | 6 | six | 3 | -3 | | - | 7 | 7 | seven | 3 | -3 | | - | 8 | 8 | eight | 3 | -3 | | - | 0 | | zero | 3 | -3 | | - | | | null | 3 | -3 | | - | | 0 | zero | 3 | -3 | | | 1 | 4 | one | 3 | -3 | | 0 - | 2 | 3 | two | 3 | -3 | | 0 - | 3 | 2 | three | 3 | -3 | | 0 - | 4 | 1 | four | 3 | -3 | | 0 - | 5 | 0 | five | 3 | -3 | | 0 - | 6 | 6 | six | 3 | -3 | | 0 - | 7 | 7 | seven | 3 | -3 | | 0 - | 8 | 8 | eight | 3 | -3 | | 0 - | 0 | | zero | 3 | -3 | | 0 - | | | null | 3 | -3 | | 0 - | | 0 | zero | 3 | -3 | | 0 | 1 | 4 | one | 2 | 4 | 1 | -1 - | 2 | 3 | two | 2 | 4 | 1 | -1 - | 3 | 2 | three | 2 | 4 | 1 | -1 - | 4 | 1 | four | 2 | 4 | 1 | -1 - | 5 | 0 | five | 2 | 4 | 1 | -1 - | 6 | 6 | six | 2 | 4 | 1 | -1 - | 7 | 7 | seven | 2 | 4 | 1 | -1 - | 8 | 8 | eight | 2 | 4 | 1 | -1 - | 0 | | zero | 2 | 4 | 1 | -1 - | | | null | 2 | 4 | 1 | -1 - | | 0 | zero | 2 | 4 | 1 | -1 | 1 | 4 | one | 2 | 4 | 2 | 2 - | 2 | 3 | two | 2 | 4 | 2 | 2 - | 3 | 2 | three | 2 | 4 | 2 | 2 - | 4 | 1 | four | 2 | 4 | 2 | 2 - | 5 | 0 | five | 2 | 4 | 2 | 2 - | 6 | 6 | six | 2 | 4 | 2 | 2 - | 7 | 7 | seven | 2 | 4 | 2 | 2 - | 8 | 8 | eight | 2 | 4 | 2 | 2 - | 0 | | zero | 2 | 4 | 2 | 2 - | | | null | 2 | 4 | 2 | 2 - | | 0 | zero | 2 | 4 | 2 | 2 | 1 | 4 | one | 2 | 4 | 3 | -3 - | 2 | 3 | two | 2 | 4 | 3 | -3 - | 3 | 2 | three | 2 | 4 | 3 | -3 - | 4 | 1 | four | 2 | 4 | 3 | -3 - | 5 | 0 | five | 2 | 4 | 3 | -3 - | 6 | 6 | six | 2 | 4 | 3 | -3 - | 7 | 7 | seven | 2 | 4 | 3 | -3 - | 8 | 8 | eight | 2 | 4 | 3 | -3 - | 0 | | zero | 2 | 4 | 3 | -3 - | | | null | 2 | 4 | 3 | -3 - | | 0 | zero | 2 | 4 | 3 | -3 | 1 | 4 | one | 2 | 4 | 2 | 4 - | 2 | 3 | two | 2 | 4 | 2 | 4 - | 3 | 2 | three | 2 | 4 | 2 | 4 - | 4 | 1 | four | 2 | 4 | 2 | 4 - | 5 | 0 | five | 2 | 4 | 2 | 4 - | 6 | 6 | six | 2 | 4 | 2 | 4 - | 7 | 7 | seven | 2 | 4 | 2 | 4 - | 8 | 8 | eight | 2 | 4 | 2 | 4 - | 0 | | zero | 2 | 4 | 2 | 4 - | | | null | 2 | 4 | 2 | 4 - | | 0 | zero | 2 | 4 | 2 | 4 | 1 | 4 | one | 2 | 4 | 5 | -5 - | 2 | 3 | two | 2 | 4 | 5 | -5 - | 3 | 2 | three | 2 | 4 | 5 | -5 - | 4 | 1 | four | 2 | 4 | 5 | -5 - | 5 | 0 | five | 2 | 4 | 5 | -5 - | 6 | 6 | six | 2 | 4 | 5 | -5 - | 7 | 7 | seven | 2 | 4 | 5 | -5 - | 8 | 8 | eight | 2 | 4 | 5 | -5 - | 0 | | zero | 2 | 4 | 5 | -5 - | | | null | 2 | 4 | 5 | -5 - | | 0 | zero | 2 | 4 | 5 | -5 | 1 | 4 | one | 2 | 4 | 5 | -5 - | 2 | 3 | two | 2 | 4 | 5 | -5 - | 3 | 2 | three | 2 | 4 | 5 | -5 - | 4 | 1 | four | 2 | 4 | 5 | -5 - | 5 | 0 | five | 2 | 4 | 5 | -5 - | 6 | 6 | six | 2 | 4 | 5 | -5 - | 7 | 7 | seven | 2 | 4 | 5 | -5 - | 8 | 8 | eight | 2 | 4 | 5 | -5 - | 0 | | zero | 2 | 4 | 5 | -5 - | | | null | 2 | 4 | 5 | -5 - | | 0 | zero | 2 | 4 | 5 | -5 | 1 | 4 | one | 2 | 4 | 0 | - | 2 | 3 | two | 2 | 4 | 0 | - | 3 | 2 | three | 2 | 4 | 0 | - | 4 | 1 | four | 2 | 4 | 0 | - | 5 | 0 | five | 2 | 4 | 0 | - | 6 | 6 | six | 2 | 4 | 0 | - | 7 | 7 | seven | 2 | 4 | 0 | - | 8 | 8 | eight | 2 | 4 | 0 | - | 0 | | zero | 2 | 4 | 0 | - | | | null | 2 | 4 | 0 | - | | 0 | zero | 2 | 4 | 0 | | 1 | 4 | one | 2 | 4 | | - | 2 | 3 | two | 2 | 4 | | - | 3 | 2 | three | 2 | 4 | | - | 4 | 1 | four | 2 | 4 | | - | 5 | 0 | five | 2 | 4 | | - | 6 | 6 | six | 2 | 4 | | - | 7 | 7 | seven | 2 | 4 | | - | 8 | 8 | eight | 2 | 4 | | - | 0 | | zero | 2 | 4 | | - | | | null | 2 | 4 | | - | | 0 | zero | 2 | 4 | | | 1 | 4 | one | 2 | 4 | | 0 - | 2 | 3 | two | 2 | 4 | | 0 - | 3 | 2 | three | 2 | 4 | | 0 - | 4 | 1 | four | 2 | 4 | | 0 - | 5 | 0 | five | 2 | 4 | | 0 - | 6 | 6 | six | 2 | 4 | | 0 - | 7 | 7 | seven | 2 | 4 | | 0 - | 8 | 8 | eight | 2 | 4 | | 0 - | 0 | | zero | 2 | 4 | | 0 - | | | null | 2 | 4 | | 0 - | | 0 | zero | 2 | 4 | | 0 | 1 | 4 | one | 5 | -5 | 1 | -1 - | 2 | 3 | two | 5 | -5 | 1 | -1 - | 3 | 2 | three | 5 | -5 | 1 | -1 - | 4 | 1 | four | 5 | -5 | 1 | -1 - | 5 | 0 | five | 5 | -5 | 1 | -1 - | 6 | 6 | six | 5 | -5 | 1 | -1 - | 7 | 7 | seven | 5 | -5 | 1 | -1 - | 8 | 8 | eight | 5 | -5 | 1 | -1 - | 0 | | zero | 5 | -5 | 1 | -1 - | | | null | 5 | -5 | 1 | -1 - | | 0 | zero | 5 | -5 | 1 | -1 | 1 | 4 | one | 5 | -5 | 2 | 2 - | 2 | 3 | two | 5 | -5 | 2 | 2 - | 3 | 2 | three | 5 | -5 | 2 | 2 - | 4 | 1 | four | 5 | -5 | 2 | 2 - | 5 | 0 | five | 5 | -5 | 2 | 2 - | 6 | 6 | six | 5 | -5 | 2 | 2 - | 7 | 7 | seven | 5 | -5 | 2 | 2 - | 8 | 8 | eight | 5 | -5 | 2 | 2 - | 0 | | zero | 5 | -5 | 2 | 2 - | | | null | 5 | -5 | 2 | 2 - | | 0 | zero | 5 | -5 | 2 | 2 | 1 | 4 | one | 5 | -5 | 3 | -3 - | 2 | 3 | two | 5 | -5 | 3 | -3 - | 3 | 2 | three | 5 | -5 | 3 | -3 - | 4 | 1 | four | 5 | -5 | 3 | -3 - | 5 | 0 | five | 5 | -5 | 3 | -3 - | 6 | 6 | six | 5 | -5 | 3 | -3 - | 7 | 7 | seven | 5 | -5 | 3 | -3 - | 8 | 8 | eight | 5 | -5 | 3 | -3 - | 0 | | zero | 5 | -5 | 3 | -3 - | | | null | 5 | -5 | 3 | -3 - | | 0 | zero | 5 | -5 | 3 | -3 | 1 | 4 | one | 5 | -5 | 2 | 4 - | 2 | 3 | two | 5 | -5 | 2 | 4 - | 3 | 2 | three | 5 | -5 | 2 | 4 - | 4 | 1 | four | 5 | -5 | 2 | 4 - | 5 | 0 | five | 5 | -5 | 2 | 4 - | 6 | 6 | six | 5 | -5 | 2 | 4 - | 7 | 7 | seven | 5 | -5 | 2 | 4 - | 8 | 8 | eight | 5 | -5 | 2 | 4 - | 0 | | zero | 5 | -5 | 2 | 4 - | | | null | 5 | -5 | 2 | 4 - | | 0 | zero | 5 | -5 | 2 | 4 | 1 | 4 | one | 5 | -5 | 5 | -5 - | 2 | 3 | two | 5 | -5 | 5 | -5 - | 3 | 2 | three | 5 | -5 | 5 | -5 - | 4 | 1 | four | 5 | -5 | 5 | -5 - | 5 | 0 | five | 5 | -5 | 5 | -5 - | 6 | 6 | six | 5 | -5 | 5 | -5 - | 7 | 7 | seven | 5 | -5 | 5 | -5 - | 8 | 8 | eight | 5 | -5 | 5 | -5 - | 0 | | zero | 5 | -5 | 5 | -5 - | | | null | 5 | -5 | 5 | -5 - | | 0 | zero | 5 | -5 | 5 | -5 | 1 | 4 | one | 5 | -5 | 5 | -5 - | 2 | 3 | two | 5 | -5 | 5 | -5 - | 3 | 2 | three | 5 | -5 | 5 | -5 - | 4 | 1 | four | 5 | -5 | 5 | -5 - | 5 | 0 | five | 5 | -5 | 5 | -5 - | 6 | 6 | six | 5 | -5 | 5 | -5 - | 7 | 7 | seven | 5 | -5 | 5 | -5 - | 8 | 8 | eight | 5 | -5 | 5 | -5 - | 0 | | zero | 5 | -5 | 5 | -5 - | | | null | 5 | -5 | 5 | -5 - | | 0 | zero | 5 | -5 | 5 | -5 | 1 | 4 | one | 5 | -5 | 0 | - | 2 | 3 | two | 5 | -5 | 0 | - | 3 | 2 | three | 5 | -5 | 0 | - | 4 | 1 | four | 5 | -5 | 0 | - | 5 | 0 | five | 5 | -5 | 0 | - | 6 | 6 | six | 5 | -5 | 0 | - | 7 | 7 | seven | 5 | -5 | 0 | - | 8 | 8 | eight | 5 | -5 | 0 | - | 0 | | zero | 5 | -5 | 0 | - | | | null | 5 | -5 | 0 | - | | 0 | zero | 5 | -5 | 0 | | 1 | 4 | one | 5 | -5 | | - | 2 | 3 | two | 5 | -5 | | - | 3 | 2 | three | 5 | -5 | | - | 4 | 1 | four | 5 | -5 | | - | 5 | 0 | five | 5 | -5 | | - | 6 | 6 | six | 5 | -5 | | - | 7 | 7 | seven | 5 | -5 | | - | 8 | 8 | eight | 5 | -5 | | - | 0 | | zero | 5 | -5 | | - | | | null | 5 | -5 | | - | | 0 | zero | 5 | -5 | | | 1 | 4 | one | 5 | -5 | | 0 - | 2 | 3 | two | 5 | -5 | | 0 - | 3 | 2 | three | 5 | -5 | | 0 - | 4 | 1 | four | 5 | -5 | | 0 - | 5 | 0 | five | 5 | -5 | | 0 - | 6 | 6 | six | 5 | -5 | | 0 - | 7 | 7 | seven | 5 | -5 | | 0 - | 8 | 8 | eight | 5 | -5 | | 0 - | 0 | | zero | 5 | -5 | | 0 - | | | null | 5 | -5 | | 0 - | | 0 | zero | 5 | -5 | | 0 | 1 | 4 | one | 5 | -5 | 1 | -1 - | 2 | 3 | two | 5 | -5 | 1 | -1 - | 3 | 2 | three | 5 | -5 | 1 | -1 - | 4 | 1 | four | 5 | -5 | 1 | -1 - | 5 | 0 | five | 5 | -5 | 1 | -1 - | 6 | 6 | six | 5 | -5 | 1 | -1 - | 7 | 7 | seven | 5 | -5 | 1 | -1 - | 8 | 8 | eight | 5 | -5 | 1 | -1 - | 0 | | zero | 5 | -5 | 1 | -1 - | | | null | 5 | -5 | 1 | -1 - | | 0 | zero | 5 | -5 | 1 | -1 | 1 | 4 | one | 5 | -5 | 2 | 2 - | 2 | 3 | two | 5 | -5 | 2 | 2 - | 3 | 2 | three | 5 | -5 | 2 | 2 - | 4 | 1 | four | 5 | -5 | 2 | 2 - | 5 | 0 | five | 5 | -5 | 2 | 2 - | 6 | 6 | six | 5 | -5 | 2 | 2 - | 7 | 7 | seven | 5 | -5 | 2 | 2 - | 8 | 8 | eight | 5 | -5 | 2 | 2 - | 0 | | zero | 5 | -5 | 2 | 2 - | | | null | 5 | -5 | 2 | 2 - | | 0 | zero | 5 | -5 | 2 | 2 | 1 | 4 | one | 5 | -5 | 3 | -3 - | 2 | 3 | two | 5 | -5 | 3 | -3 - | 3 | 2 | three | 5 | -5 | 3 | -3 - | 4 | 1 | four | 5 | -5 | 3 | -3 - | 5 | 0 | five | 5 | -5 | 3 | -3 - | 6 | 6 | six | 5 | -5 | 3 | -3 - | 7 | 7 | seven | 5 | -5 | 3 | -3 - | 8 | 8 | eight | 5 | -5 | 3 | -3 - | 0 | | zero | 5 | -5 | 3 | -3 - | | | null | 5 | -5 | 3 | -3 - | | 0 | zero | 5 | -5 | 3 | -3 | 1 | 4 | one | 5 | -5 | 2 | 4 - | 2 | 3 | two | 5 | -5 | 2 | 4 - | 3 | 2 | three | 5 | -5 | 2 | 4 - | 4 | 1 | four | 5 | -5 | 2 | 4 - | 5 | 0 | five | 5 | -5 | 2 | 4 - | 6 | 6 | six | 5 | -5 | 2 | 4 - | 7 | 7 | seven | 5 | -5 | 2 | 4 - | 8 | 8 | eight | 5 | -5 | 2 | 4 - | 0 | | zero | 5 | -5 | 2 | 4 - | | | null | 5 | -5 | 2 | 4 - | | 0 | zero | 5 | -5 | 2 | 4 | 1 | 4 | one | 5 | -5 | 5 | -5 - | 2 | 3 | two | 5 | -5 | 5 | -5 - | 3 | 2 | three | 5 | -5 | 5 | -5 - | 4 | 1 | four | 5 | -5 | 5 | -5 - | 5 | 0 | five | 5 | -5 | 5 | -5 - | 6 | 6 | six | 5 | -5 | 5 | -5 - | 7 | 7 | seven | 5 | -5 | 5 | -5 - | 8 | 8 | eight | 5 | -5 | 5 | -5 - | 0 | | zero | 5 | -5 | 5 | -5 - | | | null | 5 | -5 | 5 | -5 - | | 0 | zero | 5 | -5 | 5 | -5 | 1 | 4 | one | 5 | -5 | 5 | -5 - | 2 | 3 | two | 5 | -5 | 5 | -5 - | 3 | 2 | three | 5 | -5 | 5 | -5 - | 4 | 1 | four | 5 | -5 | 5 | -5 - | 5 | 0 | five | 5 | -5 | 5 | -5 - | 6 | 6 | six | 5 | -5 | 5 | -5 - | 7 | 7 | seven | 5 | -5 | 5 | -5 - | 8 | 8 | eight | 5 | -5 | 5 | -5 - | 0 | | zero | 5 | -5 | 5 | -5 - | | | null | 5 | -5 | 5 | -5 - | | 0 | zero | 5 | -5 | 5 | -5 | 1 | 4 | one | 5 | -5 | 0 | - | 2 | 3 | two | 5 | -5 | 0 | - | 3 | 2 | three | 5 | -5 | 0 | - | 4 | 1 | four | 5 | -5 | 0 | - | 5 | 0 | five | 5 | -5 | 0 | - | 6 | 6 | six | 5 | -5 | 0 | - | 7 | 7 | seven | 5 | -5 | 0 | - | 8 | 8 | eight | 5 | -5 | 0 | - | 0 | | zero | 5 | -5 | 0 | - | | | null | 5 | -5 | 0 | - | | 0 | zero | 5 | -5 | 0 | | 1 | 4 | one | 5 | -5 | | - | 2 | 3 | two | 5 | -5 | | - | 3 | 2 | three | 5 | -5 | | - | 4 | 1 | four | 5 | -5 | | - | 5 | 0 | five | 5 | -5 | | - | 6 | 6 | six | 5 | -5 | | - | 7 | 7 | seven | 5 | -5 | | - | 8 | 8 | eight | 5 | -5 | | - | 0 | | zero | 5 | -5 | | - | | | null | 5 | -5 | | - | | 0 | zero | 5 | -5 | | | 1 | 4 | one | 5 | -5 | | 0 - | 2 | 3 | two | 5 | -5 | | 0 - | 3 | 2 | three | 5 | -5 | | 0 - | 4 | 1 | four | 5 | -5 | | 0 - | 5 | 0 | five | 5 | -5 | | 0 - | 6 | 6 | six | 5 | -5 | | 0 - | 7 | 7 | seven | 5 | -5 | | 0 - | 8 | 8 | eight | 5 | -5 | | 0 - | 0 | | zero | 5 | -5 | | 0 - | | | null | 5 | -5 | | 0 - | | 0 | zero | 5 | -5 | | 0 | 1 | 4 | one | 0 | | 1 | -1 - | 2 | 3 | two | 0 | | 1 | -1 - | 3 | 2 | three | 0 | | 1 | -1 - | 4 | 1 | four | 0 | | 1 | -1 - | 5 | 0 | five | 0 | | 1 | -1 - | 6 | 6 | six | 0 | | 1 | -1 - | 7 | 7 | seven | 0 | | 1 | -1 - | 8 | 8 | eight | 0 | | 1 | -1 - | 0 | | zero | 0 | | 1 | -1 - | | | null | 0 | | 1 | -1 - | | 0 | zero | 0 | | 1 | -1 | 1 | 4 | one | 0 | | 2 | 2 - | 2 | 3 | two | 0 | | 2 | 2 - | 3 | 2 | three | 0 | | 2 | 2 - | 4 | 1 | four | 0 | | 2 | 2 - | 5 | 0 | five | 0 | | 2 | 2 - | 6 | 6 | six | 0 | | 2 | 2 - | 7 | 7 | seven | 0 | | 2 | 2 - | 8 | 8 | eight | 0 | | 2 | 2 - | 0 | | zero | 0 | | 2 | 2 - | | | null | 0 | | 2 | 2 - | | 0 | zero | 0 | | 2 | 2 | 1 | 4 | one | 0 | | 3 | -3 - | 2 | 3 | two | 0 | | 3 | -3 - | 3 | 2 | three | 0 | | 3 | -3 - | 4 | 1 | four | 0 | | 3 | -3 - | 5 | 0 | five | 0 | | 3 | -3 - | 6 | 6 | six | 0 | | 3 | -3 - | 7 | 7 | seven | 0 | | 3 | -3 - | 8 | 8 | eight | 0 | | 3 | -3 - | 0 | | zero | 0 | | 3 | -3 - | | | null | 0 | | 3 | -3 - | | 0 | zero | 0 | | 3 | -3 | 1 | 4 | one | 0 | | 2 | 4 - | 2 | 3 | two | 0 | | 2 | 4 - | 3 | 2 | three | 0 | | 2 | 4 - | 4 | 1 | four | 0 | | 2 | 4 - | 5 | 0 | five | 0 | | 2 | 4 - | 6 | 6 | six | 0 | | 2 | 4 - | 7 | 7 | seven | 0 | | 2 | 4 - | 8 | 8 | eight | 0 | | 2 | 4 - | 0 | | zero | 0 | | 2 | 4 - | | | null | 0 | | 2 | 4 - | | 0 | zero | 0 | | 2 | 4 | 1 | 4 | one | 0 | | 5 | -5 - | 2 | 3 | two | 0 | | 5 | -5 - | 3 | 2 | three | 0 | | 5 | -5 - | 4 | 1 | four | 0 | | 5 | -5 - | 5 | 0 | five | 0 | | 5 | -5 - | 6 | 6 | six | 0 | | 5 | -5 - | 7 | 7 | seven | 0 | | 5 | -5 - | 8 | 8 | eight | 0 | | 5 | -5 - | 0 | | zero | 0 | | 5 | -5 - | | | null | 0 | | 5 | -5 - | | 0 | zero | 0 | | 5 | -5 | 1 | 4 | one | 0 | | 5 | -5 - | 2 | 3 | two | 0 | | 5 | -5 - | 3 | 2 | three | 0 | | 5 | -5 - | 4 | 1 | four | 0 | | 5 | -5 - | 5 | 0 | five | 0 | | 5 | -5 - | 6 | 6 | six | 0 | | 5 | -5 - | 7 | 7 | seven | 0 | | 5 | -5 - | 8 | 8 | eight | 0 | | 5 | -5 - | 0 | | zero | 0 | | 5 | -5 - | | | null | 0 | | 5 | -5 - | | 0 | zero | 0 | | 5 | -5 | 1 | 4 | one | 0 | | 0 | - | 2 | 3 | two | 0 | | 0 | - | 3 | 2 | three | 0 | | 0 | - | 4 | 1 | four | 0 | | 0 | - | 5 | 0 | five | 0 | | 0 | - | 6 | 6 | six | 0 | | 0 | - | 7 | 7 | seven | 0 | | 0 | - | 8 | 8 | eight | 0 | | 0 | - | 0 | | zero | 0 | | 0 | - | | | null | 0 | | 0 | - | | 0 | zero | 0 | | 0 | | 1 | 4 | one | 0 | | | - | 2 | 3 | two | 0 | | | - | 3 | 2 | three | 0 | | | - | 4 | 1 | four | 0 | | | - | 5 | 0 | five | 0 | | | - | 6 | 6 | six | 0 | | | - | 7 | 7 | seven | 0 | | | - | 8 | 8 | eight | 0 | | | - | 0 | | zero | 0 | | | - | | | null | 0 | | | - | | 0 | zero | 0 | | | | 1 | 4 | one | 0 | | | 0 - | 2 | 3 | two | 0 | | | 0 - | 3 | 2 | three | 0 | | | 0 - | 4 | 1 | four | 0 | | | 0 - | 5 | 0 | five | 0 | | | 0 - | 6 | 6 | six | 0 | | | 0 - | 7 | 7 | seven | 0 | | | 0 - | 8 | 8 | eight | 0 | | | 0 - | 0 | | zero | 0 | | | 0 - | | | null | 0 | | | 0 - | | 0 | zero | 0 | | | 0 | 1 | 4 | one | | | 1 | -1 - | 2 | 3 | two | | | 1 | -1 - | 3 | 2 | three | | | 1 | -1 - | 4 | 1 | four | | | 1 | -1 - | 5 | 0 | five | | | 1 | -1 - | 6 | 6 | six | | | 1 | -1 - | 7 | 7 | seven | | | 1 | -1 - | 8 | 8 | eight | | | 1 | -1 - | 0 | | zero | | | 1 | -1 - | | | null | | | 1 | -1 - | | 0 | zero | | | 1 | -1 | 1 | 4 | one | | | 2 | 2 - | 2 | 3 | two | | | 2 | 2 - | 3 | 2 | three | | | 2 | 2 - | 4 | 1 | four | | | 2 | 2 - | 5 | 0 | five | | | 2 | 2 - | 6 | 6 | six | | | 2 | 2 - | 7 | 7 | seven | | | 2 | 2 - | 8 | 8 | eight | | | 2 | 2 - | 0 | | zero | | | 2 | 2 - | | | null | | | 2 | 2 - | | 0 | zero | | | 2 | 2 | 1 | 4 | one | | | 3 | -3 - | 2 | 3 | two | | | 3 | -3 - | 3 | 2 | three | | | 3 | -3 - | 4 | 1 | four | | | 3 | -3 - | 5 | 0 | five | | | 3 | -3 - | 6 | 6 | six | | | 3 | -3 - | 7 | 7 | seven | | | 3 | -3 - | 8 | 8 | eight | | | 3 | -3 - | 0 | | zero | | | 3 | -3 - | | | null | | | 3 | -3 - | | 0 | zero | | | 3 | -3 | 1 | 4 | one | | | 2 | 4 - | 2 | 3 | two | | | 2 | 4 - | 3 | 2 | three | | | 2 | 4 - | 4 | 1 | four | | | 2 | 4 - | 5 | 0 | five | | | 2 | 4 - | 6 | 6 | six | | | 2 | 4 - | 7 | 7 | seven | | | 2 | 4 - | 8 | 8 | eight | | | 2 | 4 - | 0 | | zero | | | 2 | 4 - | | | null | | | 2 | 4 - | | 0 | zero | | | 2 | 4 | 1 | 4 | one | | | 5 | -5 - | 2 | 3 | two | | | 5 | -5 - | 3 | 2 | three | | | 5 | -5 - | 4 | 1 | four | | | 5 | -5 - | 5 | 0 | five | | | 5 | -5 - | 6 | 6 | six | | | 5 | -5 - | 7 | 7 | seven | | | 5 | -5 - | 8 | 8 | eight | | | 5 | -5 - | 0 | | zero | | | 5 | -5 - | | | null | | | 5 | -5 - | | 0 | zero | | | 5 | -5 | 1 | 4 | one | | | 5 | -5 - | 2 | 3 | two | | | 5 | -5 - | 3 | 2 | three | | | 5 | -5 - | 4 | 1 | four | | | 5 | -5 - | 5 | 0 | five | | | 5 | -5 - | 6 | 6 | six | | | 5 | -5 - | 7 | 7 | seven | | | 5 | -5 - | 8 | 8 | eight | | | 5 | -5 - | 0 | | zero | | | 5 | -5 - | | | null | | | 5 | -5 - | | 0 | zero | | | 5 | -5 | 1 | 4 | one | | | 0 | - | 2 | 3 | two | | | 0 | - | 3 | 2 | three | | | 0 | - | 4 | 1 | four | | | 0 | - | 5 | 0 | five | | | 0 | - | 6 | 6 | six | | | 0 | - | 7 | 7 | seven | | | 0 | - | 8 | 8 | eight | | | 0 | - | 0 | | zero | | | 0 | - | | | null | | | 0 | - | | 0 | zero | | | 0 | | 1 | 4 | one | | | | - | 2 | 3 | two | | | | - | 3 | 2 | three | | | | - | 4 | 1 | four | | | | - | 5 | 0 | five | | | | - | 6 | 6 | six | | | | - | 7 | 7 | seven | | | | - | 8 | 8 | eight | | | | - | 0 | | zero | | | | - | | | null | | | | - | | 0 | zero | | | | | 1 | 4 | one | | | | 0 - | 2 | 3 | two | | | | 0 - | 3 | 2 | three | | | | 0 - | 4 | 1 | four | | | | 0 - | 5 | 0 | five | | | | 0 - | 6 | 6 | six | | | | 0 - | 7 | 7 | seven | | | | 0 - | 8 | 8 | eight | | | | 0 - | 0 | | zero | | | | 0 - | | | null | | | | 0 - | | 0 | zero | | | | 0 | 1 | 4 | one | | 0 | 1 | -1 - | 2 | 3 | two | | 0 | 1 | -1 - | 3 | 2 | three | | 0 | 1 | -1 - | 4 | 1 | four | | 0 | 1 | -1 - | 5 | 0 | five | | 0 | 1 | -1 - | 6 | 6 | six | | 0 | 1 | -1 - | 7 | 7 | seven | | 0 | 1 | -1 - | 8 | 8 | eight | | 0 | 1 | -1 - | 0 | | zero | | 0 | 1 | -1 - | | | null | | 0 | 1 | -1 - | | 0 | zero | | 0 | 1 | -1 | 1 | 4 | one | | 0 | 2 | 2 - | 2 | 3 | two | | 0 | 2 | 2 - | 3 | 2 | three | | 0 | 2 | 2 - | 4 | 1 | four | | 0 | 2 | 2 - | 5 | 0 | five | | 0 | 2 | 2 - | 6 | 6 | six | | 0 | 2 | 2 - | 7 | 7 | seven | | 0 | 2 | 2 - | 8 | 8 | eight | | 0 | 2 | 2 - | 0 | | zero | | 0 | 2 | 2 - | | | null | | 0 | 2 | 2 - | | 0 | zero | | 0 | 2 | 2 | 1 | 4 | one | | 0 | 3 | -3 - | 2 | 3 | two | | 0 | 3 | -3 - | 3 | 2 | three | | 0 | 3 | -3 - | 4 | 1 | four | | 0 | 3 | -3 - | 5 | 0 | five | | 0 | 3 | -3 - | 6 | 6 | six | | 0 | 3 | -3 - | 7 | 7 | seven | | 0 | 3 | -3 - | 8 | 8 | eight | | 0 | 3 | -3 - | 0 | | zero | | 0 | 3 | -3 - | | | null | | 0 | 3 | -3 - | | 0 | zero | | 0 | 3 | -3 | 1 | 4 | one | | 0 | 2 | 4 - | 2 | 3 | two | | 0 | 2 | 4 - | 3 | 2 | three | | 0 | 2 | 4 - | 4 | 1 | four | | 0 | 2 | 4 - | 5 | 0 | five | | 0 | 2 | 4 - | 6 | 6 | six | | 0 | 2 | 4 - | 7 | 7 | seven | | 0 | 2 | 4 - | 8 | 8 | eight | | 0 | 2 | 4 - | 0 | | zero | | 0 | 2 | 4 - | | | null | | 0 | 2 | 4 - | | 0 | zero | | 0 | 2 | 4 | 1 | 4 | one | | 0 | 5 | -5 - | 2 | 3 | two | | 0 | 5 | -5 - | 3 | 2 | three | | 0 | 5 | -5 - | 4 | 1 | four | | 0 | 5 | -5 - | 5 | 0 | five | | 0 | 5 | -5 - | 6 | 6 | six | | 0 | 5 | -5 - | 7 | 7 | seven | | 0 | 5 | -5 - | 8 | 8 | eight | | 0 | 5 | -5 - | 0 | | zero | | 0 | 5 | -5 - | | | null | | 0 | 5 | -5 - | | 0 | zero | | 0 | 5 | -5 | 1 | 4 | one | | 0 | 5 | -5 - | 2 | 3 | two | | 0 | 5 | -5 - | 3 | 2 | three | | 0 | 5 | -5 - | 4 | 1 | four | | 0 | 5 | -5 - | 5 | 0 | five | | 0 | 5 | -5 - | 6 | 6 | six | | 0 | 5 | -5 - | 7 | 7 | seven | | 0 | 5 | -5 - | 8 | 8 | eight | | 0 | 5 | -5 - | 0 | | zero | | 0 | 5 | -5 - | | | null | | 0 | 5 | -5 - | | 0 | zero | | 0 | 5 | -5 | 1 | 4 | one | | 0 | 0 | - | 2 | 3 | two | | 0 | 0 | - | 3 | 2 | three | | 0 | 0 | - | 4 | 1 | four | | 0 | 0 | - | 5 | 0 | five | | 0 | 0 | - | 6 | 6 | six | | 0 | 0 | - | 7 | 7 | seven | | 0 | 0 | - | 8 | 8 | eight | | 0 | 0 | - | 0 | | zero | | 0 | 0 | - | | | null | | 0 | 0 | - | | 0 | zero | | 0 | 0 | | 1 | 4 | one | | 0 | | - | 2 | 3 | two | | 0 | | - | 3 | 2 | three | | 0 | | - | 4 | 1 | four | | 0 | | - | 5 | 0 | five | | 0 | | - | 6 | 6 | six | | 0 | | - | 7 | 7 | seven | | 0 | | - | 8 | 8 | eight | | 0 | | - | 0 | | zero | | 0 | | - | | | null | | 0 | | - | | 0 | zero | | 0 | | | 1 | 4 | one | | 0 | | 0 + | 2 | 3 | two | 1 | -1 | 1 | -1 + | 2 | 3 | two | 1 | -1 | 2 | 2 + | 2 | 3 | two | 1 | -1 | 3 | -3 + | 2 | 3 | two | 1 | -1 | 2 | 4 + | 2 | 3 | two | 1 | -1 | 5 | -5 + | 2 | 3 | two | 1 | -1 | 5 | -5 + | 2 | 3 | two | 1 | -1 | 0 | + | 2 | 3 | two | 1 | -1 | | + | 2 | 3 | two | 1 | -1 | | 0 + | 2 | 3 | two | 2 | 2 | 1 | -1 + | 2 | 3 | two | 2 | 2 | 2 | 2 + | 2 | 3 | two | 2 | 2 | 3 | -3 + | 2 | 3 | two | 2 | 2 | 2 | 4 + | 2 | 3 | two | 2 | 2 | 5 | -5 + | 2 | 3 | two | 2 | 2 | 5 | -5 + | 2 | 3 | two | 2 | 2 | 0 | + | 2 | 3 | two | 2 | 2 | | + | 2 | 3 | two | 2 | 2 | | 0 + | 2 | 3 | two | 3 | -3 | 1 | -1 + | 2 | 3 | two | 3 | -3 | 2 | 2 + | 2 | 3 | two | 3 | -3 | 3 | -3 + | 2 | 3 | two | 3 | -3 | 2 | 4 + | 2 | 3 | two | 3 | -3 | 5 | -5 + | 2 | 3 | two | 3 | -3 | 5 | -5 + | 2 | 3 | two | 3 | -3 | 0 | + | 2 | 3 | two | 3 | -3 | | + | 2 | 3 | two | 3 | -3 | | 0 + | 2 | 3 | two | 2 | 4 | 1 | -1 + | 2 | 3 | two | 2 | 4 | 2 | 2 + | 2 | 3 | two | 2 | 4 | 3 | -3 + | 2 | 3 | two | 2 | 4 | 2 | 4 + | 2 | 3 | two | 2 | 4 | 5 | -5 + | 2 | 3 | two | 2 | 4 | 5 | -5 + | 2 | 3 | two | 2 | 4 | 0 | + | 2 | 3 | two | 2 | 4 | | + | 2 | 3 | two | 2 | 4 | | 0 + | 2 | 3 | two | 5 | -5 | 1 | -1 + | 2 | 3 | two | 5 | -5 | 2 | 2 + | 2 | 3 | two | 5 | -5 | 3 | -3 + | 2 | 3 | two | 5 | -5 | 2 | 4 + | 2 | 3 | two | 5 | -5 | 5 | -5 + | 2 | 3 | two | 5 | -5 | 5 | -5 + | 2 | 3 | two | 5 | -5 | 0 | + | 2 | 3 | two | 5 | -5 | | + | 2 | 3 | two | 5 | -5 | | 0 + | 2 | 3 | two | 5 | -5 | 1 | -1 + | 2 | 3 | two | 5 | -5 | 2 | 2 + | 2 | 3 | two | 5 | -5 | 3 | -3 + | 2 | 3 | two | 5 | -5 | 2 | 4 + | 2 | 3 | two | 5 | -5 | 5 | -5 + | 2 | 3 | two | 5 | -5 | 5 | -5 + | 2 | 3 | two | 5 | -5 | 0 | + | 2 | 3 | two | 5 | -5 | | + | 2 | 3 | two | 5 | -5 | | 0 + | 2 | 3 | two | 0 | | 1 | -1 + | 2 | 3 | two | 0 | | 2 | 2 + | 2 | 3 | two | 0 | | 3 | -3 + | 2 | 3 | two | 0 | | 2 | 4 + | 2 | 3 | two | 0 | | 5 | -5 + | 2 | 3 | two | 0 | | 5 | -5 + | 2 | 3 | two | 0 | | 0 | + | 2 | 3 | two | 0 | | | + | 2 | 3 | two | 0 | | | 0 + | 2 | 3 | two | | | 1 | -1 + | 2 | 3 | two | | | 2 | 2 + | 2 | 3 | two | | | 3 | -3 + | 2 | 3 | two | | | 2 | 4 + | 2 | 3 | two | | | 5 | -5 + | 2 | 3 | two | | | 5 | -5 + | 2 | 3 | two | | | 0 | + | 2 | 3 | two | | | | + | 2 | 3 | two | | | | 0 + | 2 | 3 | two | | 0 | 1 | -1 + | 2 | 3 | two | | 0 | 2 | 2 + | 2 | 3 | two | | 0 | 3 | -3 + | 2 | 3 | two | | 0 | 2 | 4 + | 2 | 3 | two | | 0 | 5 | -5 + | 2 | 3 | two | | 0 | 5 | -5 + | 2 | 3 | two | | 0 | 0 | + | 2 | 3 | two | | 0 | | | 2 | 3 | two | | 0 | | 0 + | 3 | 2 | three | 1 | -1 | 1 | -1 + | 3 | 2 | three | 1 | -1 | 2 | 2 + | 3 | 2 | three | 1 | -1 | 3 | -3 + | 3 | 2 | three | 1 | -1 | 2 | 4 + | 3 | 2 | three | 1 | -1 | 5 | -5 + | 3 | 2 | three | 1 | -1 | 5 | -5 + | 3 | 2 | three | 1 | -1 | 0 | + | 3 | 2 | three | 1 | -1 | | + | 3 | 2 | three | 1 | -1 | | 0 + | 3 | 2 | three | 2 | 2 | 1 | -1 + | 3 | 2 | three | 2 | 2 | 2 | 2 + | 3 | 2 | three | 2 | 2 | 3 | -3 + | 3 | 2 | three | 2 | 2 | 2 | 4 + | 3 | 2 | three | 2 | 2 | 5 | -5 + | 3 | 2 | three | 2 | 2 | 5 | -5 + | 3 | 2 | three | 2 | 2 | 0 | + | 3 | 2 | three | 2 | 2 | | + | 3 | 2 | three | 2 | 2 | | 0 + | 3 | 2 | three | 3 | -3 | 1 | -1 + | 3 | 2 | three | 3 | -3 | 2 | 2 + | 3 | 2 | three | 3 | -3 | 3 | -3 + | 3 | 2 | three | 3 | -3 | 2 | 4 + | 3 | 2 | three | 3 | -3 | 5 | -5 + | 3 | 2 | three | 3 | -3 | 5 | -5 + | 3 | 2 | three | 3 | -3 | 0 | + | 3 | 2 | three | 3 | -3 | | + | 3 | 2 | three | 3 | -3 | | 0 + | 3 | 2 | three | 2 | 4 | 1 | -1 + | 3 | 2 | three | 2 | 4 | 2 | 2 + | 3 | 2 | three | 2 | 4 | 3 | -3 + | 3 | 2 | three | 2 | 4 | 2 | 4 + | 3 | 2 | three | 2 | 4 | 5 | -5 + | 3 | 2 | three | 2 | 4 | 5 | -5 + | 3 | 2 | three | 2 | 4 | 0 | + | 3 | 2 | three | 2 | 4 | | + | 3 | 2 | three | 2 | 4 | | 0 + | 3 | 2 | three | 5 | -5 | 1 | -1 + | 3 | 2 | three | 5 | -5 | 2 | 2 + | 3 | 2 | three | 5 | -5 | 3 | -3 + | 3 | 2 | three | 5 | -5 | 2 | 4 + | 3 | 2 | three | 5 | -5 | 5 | -5 + | 3 | 2 | three | 5 | -5 | 5 | -5 + | 3 | 2 | three | 5 | -5 | 0 | + | 3 | 2 | three | 5 | -5 | | + | 3 | 2 | three | 5 | -5 | | 0 + | 3 | 2 | three | 5 | -5 | 1 | -1 + | 3 | 2 | three | 5 | -5 | 2 | 2 + | 3 | 2 | three | 5 | -5 | 3 | -3 + | 3 | 2 | three | 5 | -5 | 2 | 4 + | 3 | 2 | three | 5 | -5 | 5 | -5 + | 3 | 2 | three | 5 | -5 | 5 | -5 + | 3 | 2 | three | 5 | -5 | 0 | + | 3 | 2 | three | 5 | -5 | | + | 3 | 2 | three | 5 | -5 | | 0 + | 3 | 2 | three | 0 | | 1 | -1 + | 3 | 2 | three | 0 | | 2 | 2 + | 3 | 2 | three | 0 | | 3 | -3 + | 3 | 2 | three | 0 | | 2 | 4 + | 3 | 2 | three | 0 | | 5 | -5 + | 3 | 2 | three | 0 | | 5 | -5 + | 3 | 2 | three | 0 | | 0 | + | 3 | 2 | three | 0 | | | + | 3 | 2 | three | 0 | | | 0 + | 3 | 2 | three | | | 1 | -1 + | 3 | 2 | three | | | 2 | 2 + | 3 | 2 | three | | | 3 | -3 + | 3 | 2 | three | | | 2 | 4 + | 3 | 2 | three | | | 5 | -5 + | 3 | 2 | three | | | 5 | -5 + | 3 | 2 | three | | | 0 | + | 3 | 2 | three | | | | + | 3 | 2 | three | | | | 0 + | 3 | 2 | three | | 0 | 1 | -1 + | 3 | 2 | three | | 0 | 2 | 2 + | 3 | 2 | three | | 0 | 3 | -3 + | 3 | 2 | three | | 0 | 2 | 4 + | 3 | 2 | three | | 0 | 5 | -5 + | 3 | 2 | three | | 0 | 5 | -5 + | 3 | 2 | three | | 0 | 0 | + | 3 | 2 | three | | 0 | | | 3 | 2 | three | | 0 | | 0 + | 4 | 1 | four | 1 | -1 | 1 | -1 + | 4 | 1 | four | 1 | -1 | 2 | 2 + | 4 | 1 | four | 1 | -1 | 3 | -3 + | 4 | 1 | four | 1 | -1 | 2 | 4 + | 4 | 1 | four | 1 | -1 | 5 | -5 + | 4 | 1 | four | 1 | -1 | 5 | -5 + | 4 | 1 | four | 1 | -1 | 0 | + | 4 | 1 | four | 1 | -1 | | + | 4 | 1 | four | 1 | -1 | | 0 + | 4 | 1 | four | 2 | 2 | 1 | -1 + | 4 | 1 | four | 2 | 2 | 2 | 2 + | 4 | 1 | four | 2 | 2 | 3 | -3 + | 4 | 1 | four | 2 | 2 | 2 | 4 + | 4 | 1 | four | 2 | 2 | 5 | -5 + | 4 | 1 | four | 2 | 2 | 5 | -5 + | 4 | 1 | four | 2 | 2 | 0 | + | 4 | 1 | four | 2 | 2 | | + | 4 | 1 | four | 2 | 2 | | 0 + | 4 | 1 | four | 3 | -3 | 1 | -1 + | 4 | 1 | four | 3 | -3 | 2 | 2 + | 4 | 1 | four | 3 | -3 | 3 | -3 + | 4 | 1 | four | 3 | -3 | 2 | 4 + | 4 | 1 | four | 3 | -3 | 5 | -5 + | 4 | 1 | four | 3 | -3 | 5 | -5 + | 4 | 1 | four | 3 | -3 | 0 | + | 4 | 1 | four | 3 | -3 | | + | 4 | 1 | four | 3 | -3 | | 0 + | 4 | 1 | four | 2 | 4 | 1 | -1 + | 4 | 1 | four | 2 | 4 | 2 | 2 + | 4 | 1 | four | 2 | 4 | 3 | -3 + | 4 | 1 | four | 2 | 4 | 2 | 4 + | 4 | 1 | four | 2 | 4 | 5 | -5 + | 4 | 1 | four | 2 | 4 | 5 | -5 + | 4 | 1 | four | 2 | 4 | 0 | + | 4 | 1 | four | 2 | 4 | | + | 4 | 1 | four | 2 | 4 | | 0 + | 4 | 1 | four | 5 | -5 | 1 | -1 + | 4 | 1 | four | 5 | -5 | 2 | 2 + | 4 | 1 | four | 5 | -5 | 3 | -3 + | 4 | 1 | four | 5 | -5 | 2 | 4 + | 4 | 1 | four | 5 | -5 | 5 | -5 + | 4 | 1 | four | 5 | -5 | 5 | -5 + | 4 | 1 | four | 5 | -5 | 0 | + | 4 | 1 | four | 5 | -5 | | + | 4 | 1 | four | 5 | -5 | | 0 + | 4 | 1 | four | 5 | -5 | 1 | -1 + | 4 | 1 | four | 5 | -5 | 2 | 2 + | 4 | 1 | four | 5 | -5 | 3 | -3 + | 4 | 1 | four | 5 | -5 | 2 | 4 + | 4 | 1 | four | 5 | -5 | 5 | -5 + | 4 | 1 | four | 5 | -5 | 5 | -5 + | 4 | 1 | four | 5 | -5 | 0 | + | 4 | 1 | four | 5 | -5 | | + | 4 | 1 | four | 5 | -5 | | 0 + | 4 | 1 | four | 0 | | 1 | -1 + | 4 | 1 | four | 0 | | 2 | 2 + | 4 | 1 | four | 0 | | 3 | -3 + | 4 | 1 | four | 0 | | 2 | 4 + | 4 | 1 | four | 0 | | 5 | -5 + | 4 | 1 | four | 0 | | 5 | -5 + | 4 | 1 | four | 0 | | 0 | + | 4 | 1 | four | 0 | | | + | 4 | 1 | four | 0 | | | 0 + | 4 | 1 | four | | | 1 | -1 + | 4 | 1 | four | | | 2 | 2 + | 4 | 1 | four | | | 3 | -3 + | 4 | 1 | four | | | 2 | 4 + | 4 | 1 | four | | | 5 | -5 + | 4 | 1 | four | | | 5 | -5 + | 4 | 1 | four | | | 0 | + | 4 | 1 | four | | | | + | 4 | 1 | four | | | | 0 + | 4 | 1 | four | | 0 | 1 | -1 + | 4 | 1 | four | | 0 | 2 | 2 + | 4 | 1 | four | | 0 | 3 | -3 + | 4 | 1 | four | | 0 | 2 | 4 + | 4 | 1 | four | | 0 | 5 | -5 + | 4 | 1 | four | | 0 | 5 | -5 + | 4 | 1 | four | | 0 | 0 | + | 4 | 1 | four | | 0 | | | 4 | 1 | four | | 0 | | 0 + | 5 | 0 | five | 1 | -1 | 1 | -1 + | 5 | 0 | five | 1 | -1 | 2 | 2 + | 5 | 0 | five | 1 | -1 | 3 | -3 + | 5 | 0 | five | 1 | -1 | 2 | 4 + | 5 | 0 | five | 1 | -1 | 5 | -5 + | 5 | 0 | five | 1 | -1 | 5 | -5 + | 5 | 0 | five | 1 | -1 | 0 | + | 5 | 0 | five | 1 | -1 | | + | 5 | 0 | five | 1 | -1 | | 0 + | 5 | 0 | five | 2 | 2 | 1 | -1 + | 5 | 0 | five | 2 | 2 | 2 | 2 + | 5 | 0 | five | 2 | 2 | 3 | -3 + | 5 | 0 | five | 2 | 2 | 2 | 4 + | 5 | 0 | five | 2 | 2 | 5 | -5 + | 5 | 0 | five | 2 | 2 | 5 | -5 + | 5 | 0 | five | 2 | 2 | 0 | + | 5 | 0 | five | 2 | 2 | | + | 5 | 0 | five | 2 | 2 | | 0 + | 5 | 0 | five | 3 | -3 | 1 | -1 + | 5 | 0 | five | 3 | -3 | 2 | 2 + | 5 | 0 | five | 3 | -3 | 3 | -3 + | 5 | 0 | five | 3 | -3 | 2 | 4 + | 5 | 0 | five | 3 | -3 | 5 | -5 + | 5 | 0 | five | 3 | -3 | 5 | -5 + | 5 | 0 | five | 3 | -3 | 0 | + | 5 | 0 | five | 3 | -3 | | + | 5 | 0 | five | 3 | -3 | | 0 + | 5 | 0 | five | 2 | 4 | 1 | -1 + | 5 | 0 | five | 2 | 4 | 2 | 2 + | 5 | 0 | five | 2 | 4 | 3 | -3 + | 5 | 0 | five | 2 | 4 | 2 | 4 + | 5 | 0 | five | 2 | 4 | 5 | -5 + | 5 | 0 | five | 2 | 4 | 5 | -5 + | 5 | 0 | five | 2 | 4 | 0 | + | 5 | 0 | five | 2 | 4 | | + | 5 | 0 | five | 2 | 4 | | 0 + | 5 | 0 | five | 5 | -5 | 1 | -1 + | 5 | 0 | five | 5 | -5 | 2 | 2 + | 5 | 0 | five | 5 | -5 | 3 | -3 + | 5 | 0 | five | 5 | -5 | 2 | 4 + | 5 | 0 | five | 5 | -5 | 5 | -5 + | 5 | 0 | five | 5 | -5 | 5 | -5 + | 5 | 0 | five | 5 | -5 | 0 | + | 5 | 0 | five | 5 | -5 | | + | 5 | 0 | five | 5 | -5 | | 0 + | 5 | 0 | five | 5 | -5 | 1 | -1 + | 5 | 0 | five | 5 | -5 | 2 | 2 + | 5 | 0 | five | 5 | -5 | 3 | -3 + | 5 | 0 | five | 5 | -5 | 2 | 4 + | 5 | 0 | five | 5 | -5 | 5 | -5 + | 5 | 0 | five | 5 | -5 | 5 | -5 + | 5 | 0 | five | 5 | -5 | 0 | + | 5 | 0 | five | 5 | -5 | | + | 5 | 0 | five | 5 | -5 | | 0 + | 5 | 0 | five | 0 | | 1 | -1 + | 5 | 0 | five | 0 | | 2 | 2 + | 5 | 0 | five | 0 | | 3 | -3 + | 5 | 0 | five | 0 | | 2 | 4 + | 5 | 0 | five | 0 | | 5 | -5 + | 5 | 0 | five | 0 | | 5 | -5 + | 5 | 0 | five | 0 | | 0 | + | 5 | 0 | five | 0 | | | + | 5 | 0 | five | 0 | | | 0 + | 5 | 0 | five | | | 1 | -1 + | 5 | 0 | five | | | 2 | 2 + | 5 | 0 | five | | | 3 | -3 + | 5 | 0 | five | | | 2 | 4 + | 5 | 0 | five | | | 5 | -5 + | 5 | 0 | five | | | 5 | -5 + | 5 | 0 | five | | | 0 | + | 5 | 0 | five | | | | + | 5 | 0 | five | | | | 0 + | 5 | 0 | five | | 0 | 1 | -1 + | 5 | 0 | five | | 0 | 2 | 2 + | 5 | 0 | five | | 0 | 3 | -3 + | 5 | 0 | five | | 0 | 2 | 4 + | 5 | 0 | five | | 0 | 5 | -5 + | 5 | 0 | five | | 0 | 5 | -5 + | 5 | 0 | five | | 0 | 0 | + | 5 | 0 | five | | 0 | | | 5 | 0 | five | | 0 | | 0 + | 6 | 6 | six | 1 | -1 | 1 | -1 + | 6 | 6 | six | 1 | -1 | 2 | 2 + | 6 | 6 | six | 1 | -1 | 3 | -3 + | 6 | 6 | six | 1 | -1 | 2 | 4 + | 6 | 6 | six | 1 | -1 | 5 | -5 + | 6 | 6 | six | 1 | -1 | 5 | -5 + | 6 | 6 | six | 1 | -1 | 0 | + | 6 | 6 | six | 1 | -1 | | + | 6 | 6 | six | 1 | -1 | | 0 + | 6 | 6 | six | 2 | 2 | 1 | -1 + | 6 | 6 | six | 2 | 2 | 2 | 2 + | 6 | 6 | six | 2 | 2 | 3 | -3 + | 6 | 6 | six | 2 | 2 | 2 | 4 + | 6 | 6 | six | 2 | 2 | 5 | -5 + | 6 | 6 | six | 2 | 2 | 5 | -5 + | 6 | 6 | six | 2 | 2 | 0 | + | 6 | 6 | six | 2 | 2 | | + | 6 | 6 | six | 2 | 2 | | 0 + | 6 | 6 | six | 3 | -3 | 1 | -1 + | 6 | 6 | six | 3 | -3 | 2 | 2 + | 6 | 6 | six | 3 | -3 | 3 | -3 + | 6 | 6 | six | 3 | -3 | 2 | 4 + | 6 | 6 | six | 3 | -3 | 5 | -5 + | 6 | 6 | six | 3 | -3 | 5 | -5 + | 6 | 6 | six | 3 | -3 | 0 | + | 6 | 6 | six | 3 | -3 | | + | 6 | 6 | six | 3 | -3 | | 0 + | 6 | 6 | six | 2 | 4 | 1 | -1 + | 6 | 6 | six | 2 | 4 | 2 | 2 + | 6 | 6 | six | 2 | 4 | 3 | -3 + | 6 | 6 | six | 2 | 4 | 2 | 4 + | 6 | 6 | six | 2 | 4 | 5 | -5 + | 6 | 6 | six | 2 | 4 | 5 | -5 + | 6 | 6 | six | 2 | 4 | 0 | + | 6 | 6 | six | 2 | 4 | | + | 6 | 6 | six | 2 | 4 | | 0 + | 6 | 6 | six | 5 | -5 | 1 | -1 + | 6 | 6 | six | 5 | -5 | 2 | 2 + | 6 | 6 | six | 5 | -5 | 3 | -3 + | 6 | 6 | six | 5 | -5 | 2 | 4 + | 6 | 6 | six | 5 | -5 | 5 | -5 + | 6 | 6 | six | 5 | -5 | 5 | -5 + | 6 | 6 | six | 5 | -5 | 0 | + | 6 | 6 | six | 5 | -5 | | + | 6 | 6 | six | 5 | -5 | | 0 + | 6 | 6 | six | 5 | -5 | 1 | -1 + | 6 | 6 | six | 5 | -5 | 2 | 2 + | 6 | 6 | six | 5 | -5 | 3 | -3 + | 6 | 6 | six | 5 | -5 | 2 | 4 + | 6 | 6 | six | 5 | -5 | 5 | -5 + | 6 | 6 | six | 5 | -5 | 5 | -5 + | 6 | 6 | six | 5 | -5 | 0 | + | 6 | 6 | six | 5 | -5 | | + | 6 | 6 | six | 5 | -5 | | 0 + | 6 | 6 | six | 0 | | 1 | -1 + | 6 | 6 | six | 0 | | 2 | 2 + | 6 | 6 | six | 0 | | 3 | -3 + | 6 | 6 | six | 0 | | 2 | 4 + | 6 | 6 | six | 0 | | 5 | -5 + | 6 | 6 | six | 0 | | 5 | -5 + | 6 | 6 | six | 0 | | 0 | + | 6 | 6 | six | 0 | | | + | 6 | 6 | six | 0 | | | 0 + | 6 | 6 | six | | | 1 | -1 + | 6 | 6 | six | | | 2 | 2 + | 6 | 6 | six | | | 3 | -3 + | 6 | 6 | six | | | 2 | 4 + | 6 | 6 | six | | | 5 | -5 + | 6 | 6 | six | | | 5 | -5 + | 6 | 6 | six | | | 0 | + | 6 | 6 | six | | | | + | 6 | 6 | six | | | | 0 + | 6 | 6 | six | | 0 | 1 | -1 + | 6 | 6 | six | | 0 | 2 | 2 + | 6 | 6 | six | | 0 | 3 | -3 + | 6 | 6 | six | | 0 | 2 | 4 + | 6 | 6 | six | | 0 | 5 | -5 + | 6 | 6 | six | | 0 | 5 | -5 + | 6 | 6 | six | | 0 | 0 | + | 6 | 6 | six | | 0 | | | 6 | 6 | six | | 0 | | 0 + | 7 | 7 | seven | 1 | -1 | 1 | -1 + | 7 | 7 | seven | 1 | -1 | 2 | 2 + | 7 | 7 | seven | 1 | -1 | 3 | -3 + | 7 | 7 | seven | 1 | -1 | 2 | 4 + | 7 | 7 | seven | 1 | -1 | 5 | -5 + | 7 | 7 | seven | 1 | -1 | 5 | -5 + | 7 | 7 | seven | 1 | -1 | 0 | + | 7 | 7 | seven | 1 | -1 | | + | 7 | 7 | seven | 1 | -1 | | 0 + | 7 | 7 | seven | 2 | 2 | 1 | -1 + | 7 | 7 | seven | 2 | 2 | 2 | 2 + | 7 | 7 | seven | 2 | 2 | 3 | -3 + | 7 | 7 | seven | 2 | 2 | 2 | 4 + | 7 | 7 | seven | 2 | 2 | 5 | -5 + | 7 | 7 | seven | 2 | 2 | 5 | -5 + | 7 | 7 | seven | 2 | 2 | 0 | + | 7 | 7 | seven | 2 | 2 | | + | 7 | 7 | seven | 2 | 2 | | 0 + | 7 | 7 | seven | 3 | -3 | 1 | -1 + | 7 | 7 | seven | 3 | -3 | 2 | 2 + | 7 | 7 | seven | 3 | -3 | 3 | -3 + | 7 | 7 | seven | 3 | -3 | 2 | 4 + | 7 | 7 | seven | 3 | -3 | 5 | -5 + | 7 | 7 | seven | 3 | -3 | 5 | -5 + | 7 | 7 | seven | 3 | -3 | 0 | + | 7 | 7 | seven | 3 | -3 | | + | 7 | 7 | seven | 3 | -3 | | 0 + | 7 | 7 | seven | 2 | 4 | 1 | -1 + | 7 | 7 | seven | 2 | 4 | 2 | 2 + | 7 | 7 | seven | 2 | 4 | 3 | -3 + | 7 | 7 | seven | 2 | 4 | 2 | 4 + | 7 | 7 | seven | 2 | 4 | 5 | -5 + | 7 | 7 | seven | 2 | 4 | 5 | -5 + | 7 | 7 | seven | 2 | 4 | 0 | + | 7 | 7 | seven | 2 | 4 | | + | 7 | 7 | seven | 2 | 4 | | 0 + | 7 | 7 | seven | 5 | -5 | 1 | -1 + | 7 | 7 | seven | 5 | -5 | 2 | 2 + | 7 | 7 | seven | 5 | -5 | 3 | -3 + | 7 | 7 | seven | 5 | -5 | 2 | 4 + | 7 | 7 | seven | 5 | -5 | 5 | -5 + | 7 | 7 | seven | 5 | -5 | 5 | -5 + | 7 | 7 | seven | 5 | -5 | 0 | + | 7 | 7 | seven | 5 | -5 | | + | 7 | 7 | seven | 5 | -5 | | 0 + | 7 | 7 | seven | 5 | -5 | 1 | -1 + | 7 | 7 | seven | 5 | -5 | 2 | 2 + | 7 | 7 | seven | 5 | -5 | 3 | -3 + | 7 | 7 | seven | 5 | -5 | 2 | 4 + | 7 | 7 | seven | 5 | -5 | 5 | -5 + | 7 | 7 | seven | 5 | -5 | 5 | -5 + | 7 | 7 | seven | 5 | -5 | 0 | + | 7 | 7 | seven | 5 | -5 | | + | 7 | 7 | seven | 5 | -5 | | 0 + | 7 | 7 | seven | 0 | | 1 | -1 + | 7 | 7 | seven | 0 | | 2 | 2 + | 7 | 7 | seven | 0 | | 3 | -3 + | 7 | 7 | seven | 0 | | 2 | 4 + | 7 | 7 | seven | 0 | | 5 | -5 + | 7 | 7 | seven | 0 | | 5 | -5 + | 7 | 7 | seven | 0 | | 0 | + | 7 | 7 | seven | 0 | | | + | 7 | 7 | seven | 0 | | | 0 + | 7 | 7 | seven | | | 1 | -1 + | 7 | 7 | seven | | | 2 | 2 + | 7 | 7 | seven | | | 3 | -3 + | 7 | 7 | seven | | | 2 | 4 + | 7 | 7 | seven | | | 5 | -5 + | 7 | 7 | seven | | | 5 | -5 + | 7 | 7 | seven | | | 0 | + | 7 | 7 | seven | | | | + | 7 | 7 | seven | | | | 0 + | 7 | 7 | seven | | 0 | 1 | -1 + | 7 | 7 | seven | | 0 | 2 | 2 + | 7 | 7 | seven | | 0 | 3 | -3 + | 7 | 7 | seven | | 0 | 2 | 4 + | 7 | 7 | seven | | 0 | 5 | -5 + | 7 | 7 | seven | | 0 | 5 | -5 + | 7 | 7 | seven | | 0 | 0 | + | 7 | 7 | seven | | 0 | | | 7 | 7 | seven | | 0 | | 0 + | 8 | 8 | eight | 1 | -1 | 1 | -1 + | 8 | 8 | eight | 1 | -1 | 2 | 2 + | 8 | 8 | eight | 1 | -1 | 3 | -3 + | 8 | 8 | eight | 1 | -1 | 2 | 4 + | 8 | 8 | eight | 1 | -1 | 5 | -5 + | 8 | 8 | eight | 1 | -1 | 5 | -5 + | 8 | 8 | eight | 1 | -1 | 0 | + | 8 | 8 | eight | 1 | -1 | | + | 8 | 8 | eight | 1 | -1 | | 0 + | 8 | 8 | eight | 2 | 2 | 1 | -1 + | 8 | 8 | eight | 2 | 2 | 2 | 2 + | 8 | 8 | eight | 2 | 2 | 3 | -3 + | 8 | 8 | eight | 2 | 2 | 2 | 4 + | 8 | 8 | eight | 2 | 2 | 5 | -5 + | 8 | 8 | eight | 2 | 2 | 5 | -5 + | 8 | 8 | eight | 2 | 2 | 0 | + | 8 | 8 | eight | 2 | 2 | | + | 8 | 8 | eight | 2 | 2 | | 0 + | 8 | 8 | eight | 3 | -3 | 1 | -1 + | 8 | 8 | eight | 3 | -3 | 2 | 2 + | 8 | 8 | eight | 3 | -3 | 3 | -3 + | 8 | 8 | eight | 3 | -3 | 2 | 4 + | 8 | 8 | eight | 3 | -3 | 5 | -5 + | 8 | 8 | eight | 3 | -3 | 5 | -5 + | 8 | 8 | eight | 3 | -3 | 0 | + | 8 | 8 | eight | 3 | -3 | | + | 8 | 8 | eight | 3 | -3 | | 0 + | 8 | 8 | eight | 2 | 4 | 1 | -1 + | 8 | 8 | eight | 2 | 4 | 2 | 2 + | 8 | 8 | eight | 2 | 4 | 3 | -3 + | 8 | 8 | eight | 2 | 4 | 2 | 4 + | 8 | 8 | eight | 2 | 4 | 5 | -5 + | 8 | 8 | eight | 2 | 4 | 5 | -5 + | 8 | 8 | eight | 2 | 4 | 0 | + | 8 | 8 | eight | 2 | 4 | | + | 8 | 8 | eight | 2 | 4 | | 0 + | 8 | 8 | eight | 5 | -5 | 1 | -1 + | 8 | 8 | eight | 5 | -5 | 2 | 2 + | 8 | 8 | eight | 5 | -5 | 3 | -3 + | 8 | 8 | eight | 5 | -5 | 2 | 4 + | 8 | 8 | eight | 5 | -5 | 5 | -5 + | 8 | 8 | eight | 5 | -5 | 5 | -5 + | 8 | 8 | eight | 5 | -5 | 0 | + | 8 | 8 | eight | 5 | -5 | | + | 8 | 8 | eight | 5 | -5 | | 0 + | 8 | 8 | eight | 5 | -5 | 1 | -1 + | 8 | 8 | eight | 5 | -5 | 2 | 2 + | 8 | 8 | eight | 5 | -5 | 3 | -3 + | 8 | 8 | eight | 5 | -5 | 2 | 4 + | 8 | 8 | eight | 5 | -5 | 5 | -5 + | 8 | 8 | eight | 5 | -5 | 5 | -5 + | 8 | 8 | eight | 5 | -5 | 0 | + | 8 | 8 | eight | 5 | -5 | | + | 8 | 8 | eight | 5 | -5 | | 0 + | 8 | 8 | eight | 0 | | 1 | -1 + | 8 | 8 | eight | 0 | | 2 | 2 + | 8 | 8 | eight | 0 | | 3 | -3 + | 8 | 8 | eight | 0 | | 2 | 4 + | 8 | 8 | eight | 0 | | 5 | -5 + | 8 | 8 | eight | 0 | | 5 | -5 + | 8 | 8 | eight | 0 | | 0 | + | 8 | 8 | eight | 0 | | | + | 8 | 8 | eight | 0 | | | 0 + | 8 | 8 | eight | | | 1 | -1 + | 8 | 8 | eight | | | 2 | 2 + | 8 | 8 | eight | | | 3 | -3 + | 8 | 8 | eight | | | 2 | 4 + | 8 | 8 | eight | | | 5 | -5 + | 8 | 8 | eight | | | 5 | -5 + | 8 | 8 | eight | | | 0 | + | 8 | 8 | eight | | | | + | 8 | 8 | eight | | | | 0 + | 8 | 8 | eight | | 0 | 1 | -1 + | 8 | 8 | eight | | 0 | 2 | 2 + | 8 | 8 | eight | | 0 | 3 | -3 + | 8 | 8 | eight | | 0 | 2 | 4 + | 8 | 8 | eight | | 0 | 5 | -5 + | 8 | 8 | eight | | 0 | 5 | -5 + | 8 | 8 | eight | | 0 | 0 | + | 8 | 8 | eight | | 0 | | | 8 | 8 | eight | | 0 | | 0 + | 0 | | zero | 1 | -1 | 1 | -1 + | 0 | | zero | 1 | -1 | 2 | 2 + | 0 | | zero | 1 | -1 | 3 | -3 + | 0 | | zero | 1 | -1 | 2 | 4 + | 0 | | zero | 1 | -1 | 5 | -5 + | 0 | | zero | 1 | -1 | 5 | -5 + | 0 | | zero | 1 | -1 | 0 | + | 0 | | zero | 1 | -1 | | + | 0 | | zero | 1 | -1 | | 0 + | 0 | | zero | 2 | 2 | 1 | -1 + | 0 | | zero | 2 | 2 | 2 | 2 + | 0 | | zero | 2 | 2 | 3 | -3 + | 0 | | zero | 2 | 2 | 2 | 4 + | 0 | | zero | 2 | 2 | 5 | -5 + | 0 | | zero | 2 | 2 | 5 | -5 + | 0 | | zero | 2 | 2 | 0 | + | 0 | | zero | 2 | 2 | | + | 0 | | zero | 2 | 2 | | 0 + | 0 | | zero | 3 | -3 | 1 | -1 + | 0 | | zero | 3 | -3 | 2 | 2 + | 0 | | zero | 3 | -3 | 3 | -3 + | 0 | | zero | 3 | -3 | 2 | 4 + | 0 | | zero | 3 | -3 | 5 | -5 + | 0 | | zero | 3 | -3 | 5 | -5 + | 0 | | zero | 3 | -3 | 0 | + | 0 | | zero | 3 | -3 | | + | 0 | | zero | 3 | -3 | | 0 + | 0 | | zero | 2 | 4 | 1 | -1 + | 0 | | zero | 2 | 4 | 2 | 2 + | 0 | | zero | 2 | 4 | 3 | -3 + | 0 | | zero | 2 | 4 | 2 | 4 + | 0 | | zero | 2 | 4 | 5 | -5 + | 0 | | zero | 2 | 4 | 5 | -5 + | 0 | | zero | 2 | 4 | 0 | + | 0 | | zero | 2 | 4 | | + | 0 | | zero | 2 | 4 | | 0 + | 0 | | zero | 5 | -5 | 1 | -1 + | 0 | | zero | 5 | -5 | 2 | 2 + | 0 | | zero | 5 | -5 | 3 | -3 + | 0 | | zero | 5 | -5 | 2 | 4 + | 0 | | zero | 5 | -5 | 5 | -5 + | 0 | | zero | 5 | -5 | 5 | -5 + | 0 | | zero | 5 | -5 | 0 | + | 0 | | zero | 5 | -5 | | + | 0 | | zero | 5 | -5 | | 0 + | 0 | | zero | 5 | -5 | 1 | -1 + | 0 | | zero | 5 | -5 | 2 | 2 + | 0 | | zero | 5 | -5 | 3 | -3 + | 0 | | zero | 5 | -5 | 2 | 4 + | 0 | | zero | 5 | -5 | 5 | -5 + | 0 | | zero | 5 | -5 | 5 | -5 + | 0 | | zero | 5 | -5 | 0 | + | 0 | | zero | 5 | -5 | | + | 0 | | zero | 5 | -5 | | 0 + | 0 | | zero | 0 | | 1 | -1 + | 0 | | zero | 0 | | 2 | 2 + | 0 | | zero | 0 | | 3 | -3 + | 0 | | zero | 0 | | 2 | 4 + | 0 | | zero | 0 | | 5 | -5 + | 0 | | zero | 0 | | 5 | -5 + | 0 | | zero | 0 | | 0 | + | 0 | | zero | 0 | | | + | 0 | | zero | 0 | | | 0 + | 0 | | zero | | | 1 | -1 + | 0 | | zero | | | 2 | 2 + | 0 | | zero | | | 3 | -3 + | 0 | | zero | | | 2 | 4 + | 0 | | zero | | | 5 | -5 + | 0 | | zero | | | 5 | -5 + | 0 | | zero | | | 0 | + | 0 | | zero | | | | + | 0 | | zero | | | | 0 + | 0 | | zero | | 0 | 1 | -1 + | 0 | | zero | | 0 | 2 | 2 + | 0 | | zero | | 0 | 3 | -3 + | 0 | | zero | | 0 | 2 | 4 + | 0 | | zero | | 0 | 5 | -5 + | 0 | | zero | | 0 | 5 | -5 + | 0 | | zero | | 0 | 0 | + | 0 | | zero | | 0 | | | 0 | | zero | | 0 | | 0 + | | | null | 1 | -1 | 1 | -1 + | | | null | 1 | -1 | 2 | 2 + | | | null | 1 | -1 | 3 | -3 + | | | null | 1 | -1 | 2 | 4 + | | | null | 1 | -1 | 5 | -5 + | | | null | 1 | -1 | 5 | -5 + | | | null | 1 | -1 | 0 | + | | | null | 1 | -1 | | + | | | null | 1 | -1 | | 0 + | | | null | 2 | 2 | 1 | -1 + | | | null | 2 | 2 | 2 | 2 + | | | null | 2 | 2 | 3 | -3 + | | | null | 2 | 2 | 2 | 4 + | | | null | 2 | 2 | 5 | -5 + | | | null | 2 | 2 | 5 | -5 + | | | null | 2 | 2 | 0 | + | | | null | 2 | 2 | | + | | | null | 2 | 2 | | 0 + | | | null | 3 | -3 | 1 | -1 + | | | null | 3 | -3 | 2 | 2 + | | | null | 3 | -3 | 3 | -3 + | | | null | 3 | -3 | 2 | 4 + | | | null | 3 | -3 | 5 | -5 + | | | null | 3 | -3 | 5 | -5 + | | | null | 3 | -3 | 0 | + | | | null | 3 | -3 | | + | | | null | 3 | -3 | | 0 + | | | null | 2 | 4 | 1 | -1 + | | | null | 2 | 4 | 2 | 2 + | | | null | 2 | 4 | 3 | -3 + | | | null | 2 | 4 | 2 | 4 + | | | null | 2 | 4 | 5 | -5 + | | | null | 2 | 4 | 5 | -5 + | | | null | 2 | 4 | 0 | + | | | null | 2 | 4 | | + | | | null | 2 | 4 | | 0 + | | | null | 5 | -5 | 1 | -1 + | | | null | 5 | -5 | 2 | 2 + | | | null | 5 | -5 | 3 | -3 + | | | null | 5 | -5 | 2 | 4 + | | | null | 5 | -5 | 5 | -5 + | | | null | 5 | -5 | 5 | -5 + | | | null | 5 | -5 | 0 | + | | | null | 5 | -5 | | + | | | null | 5 | -5 | | 0 + | | | null | 5 | -5 | 1 | -1 + | | | null | 5 | -5 | 2 | 2 + | | | null | 5 | -5 | 3 | -3 + | | | null | 5 | -5 | 2 | 4 + | | | null | 5 | -5 | 5 | -5 + | | | null | 5 | -5 | 5 | -5 + | | | null | 5 | -5 | 0 | + | | | null | 5 | -5 | | + | | | null | 5 | -5 | | 0 + | | | null | 0 | | 1 | -1 + | | | null | 0 | | 2 | 2 + | | | null | 0 | | 3 | -3 + | | | null | 0 | | 2 | 4 + | | | null | 0 | | 5 | -5 + | | | null | 0 | | 5 | -5 + | | | null | 0 | | 0 | + | | | null | 0 | | | + | | | null | 0 | | | 0 + | | | null | | | 1 | -1 + | | | null | | | 2 | 2 + | | | null | | | 3 | -3 + | | | null | | | 2 | 4 + | | | null | | | 5 | -5 + | | | null | | | 5 | -5 + | | | null | | | 0 | + | | | null | | | | + | | | null | | | | 0 + | | | null | | 0 | 1 | -1 + | | | null | | 0 | 2 | 2 + | | | null | | 0 | 3 | -3 + | | | null | | 0 | 2 | 4 + | | | null | | 0 | 5 | -5 + | | | null | | 0 | 5 | -5 + | | | null | | 0 | 0 | + | | | null | | 0 | | | | | null | | 0 | | 0 + | | 0 | zero | 1 | -1 | 1 | -1 + | | 0 | zero | 1 | -1 | 2 | 2 + | | 0 | zero | 1 | -1 | 3 | -3 + | | 0 | zero | 1 | -1 | 2 | 4 + | | 0 | zero | 1 | -1 | 5 | -5 + | | 0 | zero | 1 | -1 | 5 | -5 + | | 0 | zero | 1 | -1 | 0 | + | | 0 | zero | 1 | -1 | | + | | 0 | zero | 1 | -1 | | 0 + | | 0 | zero | 2 | 2 | 1 | -1 + | | 0 | zero | 2 | 2 | 2 | 2 + | | 0 | zero | 2 | 2 | 3 | -3 + | | 0 | zero | 2 | 2 | 2 | 4 + | | 0 | zero | 2 | 2 | 5 | -5 + | | 0 | zero | 2 | 2 | 5 | -5 + | | 0 | zero | 2 | 2 | 0 | + | | 0 | zero | 2 | 2 | | + | | 0 | zero | 2 | 2 | | 0 + | | 0 | zero | 3 | -3 | 1 | -1 + | | 0 | zero | 3 | -3 | 2 | 2 + | | 0 | zero | 3 | -3 | 3 | -3 + | | 0 | zero | 3 | -3 | 2 | 4 + | | 0 | zero | 3 | -3 | 5 | -5 + | | 0 | zero | 3 | -3 | 5 | -5 + | | 0 | zero | 3 | -3 | 0 | + | | 0 | zero | 3 | -3 | | + | | 0 | zero | 3 | -3 | | 0 + | | 0 | zero | 2 | 4 | 1 | -1 + | | 0 | zero | 2 | 4 | 2 | 2 + | | 0 | zero | 2 | 4 | 3 | -3 + | | 0 | zero | 2 | 4 | 2 | 4 + | | 0 | zero | 2 | 4 | 5 | -5 + | | 0 | zero | 2 | 4 | 5 | -5 + | | 0 | zero | 2 | 4 | 0 | + | | 0 | zero | 2 | 4 | | + | | 0 | zero | 2 | 4 | | 0 + | | 0 | zero | 5 | -5 | 1 | -1 + | | 0 | zero | 5 | -5 | 2 | 2 + | | 0 | zero | 5 | -5 | 3 | -3 + | | 0 | zero | 5 | -5 | 2 | 4 + | | 0 | zero | 5 | -5 | 5 | -5 + | | 0 | zero | 5 | -5 | 5 | -5 + | | 0 | zero | 5 | -5 | 0 | + | | 0 | zero | 5 | -5 | | + | | 0 | zero | 5 | -5 | | 0 + | | 0 | zero | 5 | -5 | 1 | -1 + | | 0 | zero | 5 | -5 | 2 | 2 + | | 0 | zero | 5 | -5 | 3 | -3 + | | 0 | zero | 5 | -5 | 2 | 4 + | | 0 | zero | 5 | -5 | 5 | -5 + | | 0 | zero | 5 | -5 | 5 | -5 + | | 0 | zero | 5 | -5 | 0 | + | | 0 | zero | 5 | -5 | | + | | 0 | zero | 5 | -5 | | 0 + | | 0 | zero | 0 | | 1 | -1 + | | 0 | zero | 0 | | 2 | 2 + | | 0 | zero | 0 | | 3 | -3 + | | 0 | zero | 0 | | 2 | 4 + | | 0 | zero | 0 | | 5 | -5 + | | 0 | zero | 0 | | 5 | -5 + | | 0 | zero | 0 | | 0 | + | | 0 | zero | 0 | | | + | | 0 | zero | 0 | | | 0 + | | 0 | zero | | | 1 | -1 + | | 0 | zero | | | 2 | 2 + | | 0 | zero | | | 3 | -3 + | | 0 | zero | | | 2 | 4 + | | 0 | zero | | | 5 | -5 + | | 0 | zero | | | 5 | -5 + | | 0 | zero | | | 0 | + | | 0 | zero | | | | + | | 0 | zero | | | | 0 + | | 0 | zero | | 0 | 1 | -1 + | | 0 | zero | | 0 | 2 | 2 + | | 0 | zero | | 0 | 3 | -3 + | | 0 | zero | | 0 | 2 | 4 + | | 0 | zero | | 0 | 5 | -5 + | | 0 | zero | | 0 | 5 | -5 + | | 0 | zero | | 0 | 0 | + | | 0 | zero | | 0 | | | | 0 | zero | | 0 | | 0 (891 rows) @@ -1567,13 +1567,13 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) -- Same as above, slightly different syntax @@ -1581,13 +1581,13 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) SELECT '' AS "xxx", * @@ -1623,35 +1623,35 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) SELECT '' AS "xxx", * 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 + | 0 | | zero | (3 rows) -- mismatch number of columns @@ -1660,13 +1660,13 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 2 | 3 | 2 | three | -3 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | (7 rows) -- @@ -1676,22 +1676,22 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 2 | 2 | 3 | 2 | three | 3 | -3 | 5 | 0 | five | 5 | -5 | 5 | 0 | five | 5 | -5 + | 0 | | zero | 0 | (7 rows) SELECT '' AS "xxx", * 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 + | 0 | | zero | | 0 (3 rows) -- @@ -1760,13 +1760,13 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | | | | | | | | | 0 (9 rows) @@ -1775,13 +1775,13 @@ SELECT '' AS "xxx", * 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 + | 2 | 3 | two | 4 | 5 | 0 | five | -5 | 5 | 0 | five | -5 + | 0 | | zero | | | | | | | | | 0 (9 rows) |
