--- src/test/regress/expected/boolean.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/boolean.out 2018-03-03 09:18:15.000000000 -0500 @@ -295,41 +295,11 @@ SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.* FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 <> BOOLTBL1.f1; - tf_12 | f1 | f1 --------+----+---- - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f -(12 rows) - +ERROR: failed to JIT: evalexpr.0.3 SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.* FROM BOOLTBL1, BOOLTBL2 WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1); - tf_12 | f1 | f1 --------+----+---- - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f -(12 rows) - +ERROR: failed to JIT: evalexpr.1.3 SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.* FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 = BOOLTBL1.f1 and BOOLTBL1.f1 = bool 'false'; @@ -345,26 +315,7 @@ FROM BOOLTBL1, BOOLTBL2 WHERE BOOLTBL2.f1 = BOOLTBL1.f1 or BOOLTBL1.f1 = bool 'true' ORDER BY BOOLTBL1.f1, BOOLTBL2.f1; - tf_12_ff_4 | f1 | f1 -------------+----+---- - | f | f - | f | f - | f | f - | f | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f - | t | f -(16 rows) - +ERROR: failed to JIT: evalexpr.2.3 -- -- SQL syntax -- Try all combinations to ensure that we get nothing when we expect nothing ====================================================================== --- src/test/regress/expected/bit.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/bit.out 2018-03-03 09:18:16.000000000 -0500 @@ -44,22 +44,7 @@ SELECT v, b, (v || b) AS concat FROM BIT_TABLE, VARBIT_TABLE ORDER BY 3; - v | b | concat --------------+-------------+------------------------ - | 00000000000 | 00000000000 - 0 | 00000000000 | 000000000000 - 0 | 01010101010 | 001010101010 - 010101 | 00000000000 | 01010100000000000 - | 01010101010 | 01010101010 - 01010101010 | 00000000000 | 0101010101000000000000 - 01010101010 | 01010101010 | 0101010101001010101010 - 010101 | 01010101010 | 01010101010101010 - 01010101010 | 11011000000 | 0101010101011011000000 - 010101 | 11011000000 | 01010111011000000 - 0 | 11011000000 | 011011000000 - | 11011000000 | 11011000000 -(12 rows) - +ERROR: failed to JIT: evalexpr.0.0 -- Length SELECT b, length(b) AS lb FROM BIT_TABLE; ====================================================================== --- src/test/regress/expected/rangetypes.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/rangetypes.out 2018-03-03 09:18:17.000000000 -0500 @@ -1359,11 +1359,7 @@ create type cashrange as range (subtype = money); set enable_sort = off; -- try to make it pick a hash setop implementation select '(2,5)'::cashrange except select '(5,6)'::cashrange; - cashrange ---------------- - ($2.00,$5.00) -(1 row) - +ERROR: failed to JIT: evalexpr.0.0 reset enable_sort; -- -- OUT/INOUT/TABLE functions ====================================================================== --- src/test/regress/expected/numerology.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/numerology.out 2018-03-03 09:18:17.000000000 -0500 @@ -76,25 +76,24 @@ INSERT INTO TEMP_GROUP SELECT 1, (- i.f1), (- f.f1) FROM INT4_TBL i, FLOAT8_TBL f; +ERROR: failed to JIT: evalexpr.0.0 INSERT INTO TEMP_GROUP SELECT 2, i.f1, f.f1 FROM INT4_TBL i, FLOAT8_TBL f; SELECT DISTINCT f1 AS two FROM TEMP_GROUP ORDER BY 1; two ----- - 1 2 -(2 rows) +(1 row) SELECT f1 AS two, max(f3) AS max_float, min(f3) as min_float FROM TEMP_GROUP GROUP BY f1 ORDER BY two, max_float, min_float; - two | max_float | min_float ------+----------------------+----------------------- - 1 | 1.2345678901234e+200 | -0 - 2 | 0 | -1.2345678901234e+200 -(2 rows) + two | max_float | min_float +-----+-----------+----------------------- + 2 | 0 | -1.2345678901234e+200 +(1 row) -- GROUP BY a result column name is not legal per SQL92, but we accept it -- anyway (if the name is not the name of any column exposed by FROM). @@ -102,21 +101,19 @@ FROM TEMP_GROUP GROUP BY two ORDER BY two, max_float, min_float; - two | max_float | min_float ------+----------------------+----------------------- - 1 | 1.2345678901234e+200 | -0 - 2 | 0 | -1.2345678901234e+200 -(2 rows) + two | max_float | min_float +-----+-----------+----------------------- + 2 | 0 | -1.2345678901234e+200 +(1 row) SELECT f1 AS two, (max(f3) + 1) AS max_plus_1, (min(f3) - 1) AS min_minus_1 FROM TEMP_GROUP GROUP BY f1 ORDER BY two, min_minus_1; - two | max_plus_1 | min_minus_1 ------+----------------------+----------------------- - 1 | 1.2345678901234e+200 | -1 - 2 | 1 | -1.2345678901234e+200 -(2 rows) + two | max_plus_1 | min_minus_1 +-----+------------+----------------------- + 2 | 1 | -1.2345678901234e+200 +(1 row) SELECT f1 AS two, max(f2) + min(f2) AS max_plus_min, @@ -126,9 +123,8 @@ ORDER BY two, min_minus_1; two | max_plus_min | min_minus_1 -----+--------------+----------------------- - 1 | 0 | -1 2 | 0 | -1.2345678901234e+200 -(2 rows) +(1 row) DROP TABLE TEMP_INT2; DROP TABLE TEMP_INT4; ====================================================================== --- src/test/regress/expected/point.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/point.out 2018-03-03 09:18:17.000000000 -0500 @@ -132,46 +132,7 @@ SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist FROM POINT_TBL p1, POINT_TBL p2 ORDER BY dist, p1.f1[0], p2.f1[0]; - thirtysix | point1 | point2 | dist ------------+------------+------------+------------------ - | (-10,0) | (-10,0) | 0 - | (-5,-12) | (-5,-12) | 0 - | (-3,4) | (-3,4) | 0 - | (0,0) | (0,0) | 0 - | (5.1,34.5) | (5.1,34.5) | 0 - | (10,10) | (10,10) | 0 - | (-3,4) | (0,0) | 5 - | (0,0) | (-3,4) | 5 - | (-10,0) | (-3,4) | 8.06225774829855 - | (-3,4) | (-10,0) | 8.06225774829855 - | (-10,0) | (0,0) | 10 - | (0,0) | (-10,0) | 10 - | (-10,0) | (-5,-12) | 13 - | (-5,-12) | (-10,0) | 13 - | (-5,-12) | (0,0) | 13 - | (0,0) | (-5,-12) | 13 - | (0,0) | (10,10) | 14.142135623731 - | (10,10) | (0,0) | 14.142135623731 - | (-3,4) | (10,10) | 14.3178210632764 - | (10,10) | (-3,4) | 14.3178210632764 - | (-5,-12) | (-3,4) | 16.1245154965971 - | (-3,4) | (-5,-12) | 16.1245154965971 - | (-10,0) | (10,10) | 22.3606797749979 - | (10,10) | (-10,0) | 22.3606797749979 - | (5.1,34.5) | (10,10) | 24.9851956166046 - | (10,10) | (5.1,34.5) | 24.9851956166046 - | (-5,-12) | (10,10) | 26.6270539113887 - | (10,10) | (-5,-12) | 26.6270539113887 - | (-3,4) | (5.1,34.5) | 31.5572495632937 - | (5.1,34.5) | (-3,4) | 31.5572495632937 - | (0,0) | (5.1,34.5) | 34.8749193547455 - | (5.1,34.5) | (0,0) | 34.8749193547455 - | (-10,0) | (5.1,34.5) | 37.6597928831267 - | (5.1,34.5) | (-10,0) | 37.6597928831267 - | (-5,-12) | (5.1,34.5) | 47.5842410888311 - | (5.1,34.5) | (-5,-12) | 47.5842410888311 -(36 rows) - +ERROR: failed to JIT: evalexpr.0.0 SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2 FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3; ====================================================================== --- src/test/regress/expected/interval.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/interval.out 2018-03-03 09:18:19.000000000 -0500 @@ -158,55 +158,7 @@ FROM INTERVAL_TBL r1, INTERVAL_TBL r2 WHERE r1.f1 > r2.f1 ORDER BY r1.f1, r2.f1; - fortyfive | f1 | f1 ------------+-----------------+----------------- - | 00:01:00 | -00:00:14 - | 05:00:00 | -00:00:14 - | 05:00:00 | 00:01:00 - | 1 day 02:03:04 | -00:00:14 - | 1 day 02:03:04 | 00:01:00 - | 1 day 02:03:04 | 05:00:00 - | 10 days | -00:00:14 - | 10 days | 00:01:00 - | 10 days | 05:00:00 - | 10 days | 1 day 02:03:04 - | 3 mons | -00:00:14 - | 3 mons | 00:01:00 - | 3 mons | 05:00:00 - | 3 mons | 1 day 02:03:04 - | 3 mons | 10 days - | 5 mons | -00:00:14 - | 5 mons | 00:01:00 - | 5 mons | 05:00:00 - | 5 mons | 1 day 02:03:04 - | 5 mons | 10 days - | 5 mons | 3 mons - | 5 mons 12:00:00 | -00:00:14 - | 5 mons 12:00:00 | 00:01:00 - | 5 mons 12:00:00 | 05:00:00 - | 5 mons 12:00:00 | 1 day 02:03:04 - | 5 mons 12:00:00 | 10 days - | 5 mons 12:00:00 | 3 mons - | 5 mons 12:00:00 | 5 mons - | 6 years | -00:00:14 - | 6 years | 00:01:00 - | 6 years | 05:00:00 - | 6 years | 1 day 02:03:04 - | 6 years | 10 days - | 6 years | 3 mons - | 6 years | 5 mons - | 6 years | 5 mons 12:00:00 - | 34 years | -00:00:14 - | 34 years | 00:01:00 - | 34 years | 05:00:00 - | 34 years | 1 day 02:03:04 - | 34 years | 10 days - | 34 years | 3 mons - | 34 years | 5 mons - | 34 years | 5 mons 12:00:00 - | 34 years | 6 years -(45 rows) - +ERROR: failed to JIT: evalexpr.0.3 -- Test intervals that are large enough to overflow 64 bits in comparisons CREATE TEMP TABLE INTERVAL_TBL_OF (f1 interval); INSERT INTO INTERVAL_TBL_OF (f1) VALUES @@ -236,20 +188,7 @@ FROM INTERVAL_TBL_OF r1, INTERVAL_TBL_OF r2 WHERE r1.f1 > r2.f1 ORDER BY r1.f1, r2.f1; - f1 | f1 --------------------------------------------+------------------------------------------- - -178956970 years -8 mons +2147483647 days | -178956970 years -8 mons -2147483648 days - 1 year | -178956970 years -8 mons -2147483648 days - 1 year | -178956970 years -8 mons +2147483647 days - 178956970 years 7 mons -2147483648 days | -178956970 years -8 mons -2147483648 days - 178956970 years 7 mons -2147483648 days | -178956970 years -8 mons +2147483647 days - 178956970 years 7 mons -2147483648 days | 1 year - 178956970 years 7 mons 2147483647 days | -178956970 years -8 mons -2147483648 days - 178956970 years 7 mons 2147483647 days | -178956970 years -8 mons +2147483647 days - 178956970 years 7 mons 2147483647 days | 1 year - 178956970 years 7 mons 2147483647 days | 178956970 years 7 mons -2147483648 days -(10 rows) - +ERROR: failed to JIT: evalexpr.1.3 CREATE INDEX ON INTERVAL_TBL_OF USING btree (f1); SET enable_seqscan TO false; EXPLAIN (COSTS OFF) ====================================================================== --- src/test/regress/expected/reltime.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/reltime.out 2018-03-03 09:18:19.000000000 -0500 @@ -88,22 +88,4 @@ FROM RELTIME_TBL r1, RELTIME_TBL r2 WHERE r1.f1 > r2.f1 ORDER BY r1.f1, r2.f1; - fifteen | f1 | f1 ----------+------------+--------------- - | @ 1 min | @ 14 secs ago - | @ 5 hours | @ 14 secs ago - | @ 5 hours | @ 1 min - | @ 10 days | @ 14 secs ago - | @ 10 days | @ 1 min - | @ 10 days | @ 5 hours - | @ 3 mons | @ 14 secs ago - | @ 3 mons | @ 1 min - | @ 3 mons | @ 5 hours - | @ 3 mons | @ 10 days - | @ 34 years | @ 14 secs ago - | @ 34 years | @ 1 min - | @ 34 years | @ 5 hours - | @ 34 years | @ 10 days - | @ 34 years | @ 3 mons -(15 rows) - +ERROR: failed to JIT: evalexpr.0.3 ====================================================================== --- src/test/regress/expected/tinterval.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/tinterval.out 2018-03-03 09:18:19.000000000 -0500 @@ -125,24 +125,7 @@ FROM TINTERVAL_TBL t1, TINTERVAL_TBL t2 WHERE t1.f1 && t2.f1 and not t1.f1 = t2.f1 ORDER BY interval1, interval2; - fourteen | interval1 | interval2 -----------+-----------------------------------------------------------------+----------------------------------------------------------------- - | ["-infinity" "infinity"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] - | ["-infinity" "infinity"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] - | ["-infinity" "infinity"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] - | ["-infinity" "infinity"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] - | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["-infinity" "infinity"] - | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] - | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["-infinity" "infinity"] - | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] - | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["-infinity" "infinity"] - | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] - | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Thu Feb 15 12:15:03 1990 PST" "Sun Sep 23 11:12:13 2001 PDT"] - | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] - | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["-infinity" "infinity"] - | ["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"] -(14 rows) - +ERROR: failed to JIT: evalexpr.0.3 -- contains SELECT '' AS five, t1.f1 FROM TINTERVAL_TBL t1 ====================================================================== --- src/test/regress/expected/geometry.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/geometry.out 2018-03-03 09:18:19.000000000 -0500 @@ -536,28 +536,4 @@ FROM CIRCLE_TBL c1, POINT_TBL p1 WHERE (p1.f1 <-> c1.f1) > 0 ORDER BY distance, area(c1.f1), p1.f1[0]; - twentyfour | circle | point | distance -------------+----------------+------------+--------------- - | <(1,2),3> | (-3,4) | 1.472135955 - | <(5,1),3> | (0,0) | 2.09901951359 - | <(5,1),3> | (-3,4) | 5.54400374532 - | <(1,3),5> | (-10,0) | 6.40175425099 - | <(1,3),5> | (10,10) | 6.40175425099 - | <(5,1),3> | (10,10) | 7.29563014099 - | <(1,2),3> | (-10,0) | 8.1803398875 - | <(1,2),3> | (10,10) | 9.04159457879 - | <(1,3),5> | (-5,-12) | 11.1554944214 - | <(5,1),3> | (-10,0) | 12.0332963784 - | <(1,2),3> | (-5,-12) | 12.2315462117 - | <(5,1),3> | (-5,-12) | 13.4012194669 - | <(1,3),5> | (5.1,34.5) | 26.7657047773 - | <(1,2),3> | (5.1,34.5) | 29.7575945393 - | <(5,1),3> | (5.1,34.5) | 30.5001492534 - | <(100,200),10> | (5.1,34.5) | 180.778038568 - | <(100,200),10> | (10,10) | 200.237960416 - | <(100,200),10> | (-3,4) | 211.415898255 - | <(100,200),10> | (0,0) | 213.60679775 - | <(100,200),10> | (-10,0) | 218.25424421 - | <(100,200),10> | (-5,-12) | 226.577682802 -(21 rows) - +ERROR: failed to JIT: evalexpr.0.3 ====================================================================== --- src/test/regress/expected/horology.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/horology.out 2018-03-03 09:18:20.000000000 -0500 @@ -1044,237 +1044,11 @@ SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract" FROM TIME_TBL t, INTERVAL_TBL i ORDER BY 1,2; - t | i | add | subtract --------------+-------------------------------+-------------+------------- - 00:00:00 | @ 14 secs ago | 23:59:46 | 00:00:14 - 00:00:00 | @ 1 min | 00:01:00 | 23:59:00 - 00:00:00 | @ 5 hours | 05:00:00 | 19:00:00 - 00:00:00 | @ 1 day 2 hours 3 mins 4 secs | 02:03:04 | 21:56:56 - 00:00:00 | @ 10 days | 00:00:00 | 00:00:00 - 00:00:00 | @ 3 mons | 00:00:00 | 00:00:00 - 00:00:00 | @ 5 mons | 00:00:00 | 00:00:00 - 00:00:00 | @ 5 mons 12 hours | 12:00:00 | 12:00:00 - 00:00:00 | @ 6 years | 00:00:00 | 00:00:00 - 00:00:00 | @ 34 years | 00:00:00 | 00:00:00 - 01:00:00 | @ 14 secs ago | 00:59:46 | 01:00:14 - 01:00:00 | @ 1 min | 01:01:00 | 00:59:00 - 01:00:00 | @ 5 hours | 06:00:00 | 20:00:00 - 01:00:00 | @ 1 day 2 hours 3 mins 4 secs | 03:03:04 | 22:56:56 - 01:00:00 | @ 10 days | 01:00:00 | 01:00:00 - 01:00:00 | @ 3 mons | 01:00:00 | 01:00:00 - 01:00:00 | @ 5 mons | 01:00:00 | 01:00:00 - 01:00:00 | @ 5 mons 12 hours | 13:00:00 | 13:00:00 - 01:00:00 | @ 6 years | 01:00:00 | 01:00:00 - 01:00:00 | @ 34 years | 01:00:00 | 01:00:00 - 02:03:00 | @ 14 secs ago | 02:02:46 | 02:03:14 - 02:03:00 | @ 1 min | 02:04:00 | 02:02:00 - 02:03:00 | @ 5 hours | 07:03:00 | 21:03:00 - 02:03:00 | @ 1 day 2 hours 3 mins 4 secs | 04:06:04 | 23:59:56 - 02:03:00 | @ 10 days | 02:03:00 | 02:03:00 - 02:03:00 | @ 3 mons | 02:03:00 | 02:03:00 - 02:03:00 | @ 5 mons | 02:03:00 | 02:03:00 - 02:03:00 | @ 5 mons 12 hours | 14:03:00 | 14:03:00 - 02:03:00 | @ 6 years | 02:03:00 | 02:03:00 - 02:03:00 | @ 34 years | 02:03:00 | 02:03:00 - 11:59:00 | @ 14 secs ago | 11:58:46 | 11:59:14 - 11:59:00 | @ 1 min | 12:00:00 | 11:58:00 - 11:59:00 | @ 5 hours | 16:59:00 | 06:59:00 - 11:59:00 | @ 1 day 2 hours 3 mins 4 secs | 14:02:04 | 09:55:56 - 11:59:00 | @ 10 days | 11:59:00 | 11:59:00 - 11:59:00 | @ 3 mons | 11:59:00 | 11:59:00 - 11:59:00 | @ 5 mons | 11:59:00 | 11:59:00 - 11:59:00 | @ 5 mons 12 hours | 23:59:00 | 23:59:00 - 11:59:00 | @ 6 years | 11:59:00 | 11:59:00 - 11:59:00 | @ 34 years | 11:59:00 | 11:59:00 - 12:00:00 | @ 14 secs ago | 11:59:46 | 12:00:14 - 12:00:00 | @ 1 min | 12:01:00 | 11:59:00 - 12:00:00 | @ 5 hours | 17:00:00 | 07:00:00 - 12:00:00 | @ 1 day 2 hours 3 mins 4 secs | 14:03:04 | 09:56:56 - 12:00:00 | @ 10 days | 12:00:00 | 12:00:00 - 12:00:00 | @ 3 mons | 12:00:00 | 12:00:00 - 12:00:00 | @ 5 mons | 12:00:00 | 12:00:00 - 12:00:00 | @ 5 mons 12 hours | 00:00:00 | 00:00:00 - 12:00:00 | @ 6 years | 12:00:00 | 12:00:00 - 12:00:00 | @ 34 years | 12:00:00 | 12:00:00 - 12:01:00 | @ 14 secs ago | 12:00:46 | 12:01:14 - 12:01:00 | @ 1 min | 12:02:00 | 12:00:00 - 12:01:00 | @ 5 hours | 17:01:00 | 07:01:00 - 12:01:00 | @ 1 day 2 hours 3 mins 4 secs | 14:04:04 | 09:57:56 - 12:01:00 | @ 10 days | 12:01:00 | 12:01:00 - 12:01:00 | @ 3 mons | 12:01:00 | 12:01:00 - 12:01:00 | @ 5 mons | 12:01:00 | 12:01:00 - 12:01:00 | @ 5 mons 12 hours | 00:01:00 | 00:01:00 - 12:01:00 | @ 6 years | 12:01:00 | 12:01:00 - 12:01:00 | @ 34 years | 12:01:00 | 12:01:00 - 15:36:39 | @ 14 secs ago | 15:36:25 | 15:36:53 - 15:36:39 | @ 14 secs ago | 15:36:25 | 15:36:53 - 15:36:39 | @ 1 min | 15:37:39 | 15:35:39 - 15:36:39 | @ 1 min | 15:37:39 | 15:35:39 - 15:36:39 | @ 5 hours | 20:36:39 | 10:36:39 - 15:36:39 | @ 5 hours | 20:36:39 | 10:36:39 - 15:36:39 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43 | 13:33:35 - 15:36:39 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43 | 13:33:35 - 15:36:39 | @ 10 days | 15:36:39 | 15:36:39 - 15:36:39 | @ 10 days | 15:36:39 | 15:36:39 - 15:36:39 | @ 3 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 3 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 5 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 5 mons | 15:36:39 | 15:36:39 - 15:36:39 | @ 5 mons 12 hours | 03:36:39 | 03:36:39 - 15:36:39 | @ 5 mons 12 hours | 03:36:39 | 03:36:39 - 15:36:39 | @ 6 years | 15:36:39 | 15:36:39 - 15:36:39 | @ 6 years | 15:36:39 | 15:36:39 - 15:36:39 | @ 34 years | 15:36:39 | 15:36:39 - 15:36:39 | @ 34 years | 15:36:39 | 15:36:39 - 23:59:00 | @ 14 secs ago | 23:58:46 | 23:59:14 - 23:59:00 | @ 1 min | 00:00:00 | 23:58:00 - 23:59:00 | @ 5 hours | 04:59:00 | 18:59:00 - 23:59:00 | @ 1 day 2 hours 3 mins 4 secs | 02:02:04 | 21:55:56 - 23:59:00 | @ 10 days | 23:59:00 | 23:59:00 - 23:59:00 | @ 3 mons | 23:59:00 | 23:59:00 - 23:59:00 | @ 5 mons | 23:59:00 | 23:59:00 - 23:59:00 | @ 5 mons 12 hours | 11:59:00 | 11:59:00 - 23:59:00 | @ 6 years | 23:59:00 | 23:59:00 - 23:59:00 | @ 34 years | 23:59:00 | 23:59:00 - 23:59:59.99 | @ 14 secs ago | 23:59:45.99 | 00:00:13.99 - 23:59:59.99 | @ 1 min | 00:00:59.99 | 23:58:59.99 - 23:59:59.99 | @ 5 hours | 04:59:59.99 | 18:59:59.99 - 23:59:59.99 | @ 1 day 2 hours 3 mins 4 secs | 02:03:03.99 | 21:56:55.99 - 23:59:59.99 | @ 10 days | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 3 mons | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 5 mons | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 5 mons 12 hours | 11:59:59.99 | 11:59:59.99 - 23:59:59.99 | @ 6 years | 23:59:59.99 | 23:59:59.99 - 23:59:59.99 | @ 34 years | 23:59:59.99 | 23:59:59.99 -(100 rows) - +ERROR: failed to JIT: evalexpr.0.0 SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract" FROM TIMETZ_TBL t, INTERVAL_TBL i ORDER BY 1,2; - t | i | add | subtract -----------------+-------------------------------+----------------+---------------- - 00:01:00-07 | @ 14 secs ago | 00:00:46-07 | 00:01:14-07 - 00:01:00-07 | @ 1 min | 00:02:00-07 | 00:00:00-07 - 00:01:00-07 | @ 5 hours | 05:01:00-07 | 19:01:00-07 - 00:01:00-07 | @ 1 day 2 hours 3 mins 4 secs | 02:04:04-07 | 21:57:56-07 - 00:01:00-07 | @ 10 days | 00:01:00-07 | 00:01:00-07 - 00:01:00-07 | @ 3 mons | 00:01:00-07 | 00:01:00-07 - 00:01:00-07 | @ 5 mons | 00:01:00-07 | 00:01:00-07 - 00:01:00-07 | @ 5 mons 12 hours | 12:01:00-07 | 12:01:00-07 - 00:01:00-07 | @ 6 years | 00:01:00-07 | 00:01:00-07 - 00:01:00-07 | @ 34 years | 00:01:00-07 | 00:01:00-07 - 01:00:00-07 | @ 14 secs ago | 00:59:46-07 | 01:00:14-07 - 01:00:00-07 | @ 1 min | 01:01:00-07 | 00:59:00-07 - 01:00:00-07 | @ 5 hours | 06:00:00-07 | 20:00:00-07 - 01:00:00-07 | @ 1 day 2 hours 3 mins 4 secs | 03:03:04-07 | 22:56:56-07 - 01:00:00-07 | @ 10 days | 01:00:00-07 | 01:00:00-07 - 01:00:00-07 | @ 3 mons | 01:00:00-07 | 01:00:00-07 - 01:00:00-07 | @ 5 mons | 01:00:00-07 | 01:00:00-07 - 01:00:00-07 | @ 5 mons 12 hours | 13:00:00-07 | 13:00:00-07 - 01:00:00-07 | @ 6 years | 01:00:00-07 | 01:00:00-07 - 01:00:00-07 | @ 34 years | 01:00:00-07 | 01:00:00-07 - 02:03:00-07 | @ 14 secs ago | 02:02:46-07 | 02:03:14-07 - 02:03:00-07 | @ 1 min | 02:04:00-07 | 02:02:00-07 - 02:03:00-07 | @ 5 hours | 07:03:00-07 | 21:03:00-07 - 02:03:00-07 | @ 1 day 2 hours 3 mins 4 secs | 04:06:04-07 | 23:59:56-07 - 02:03:00-07 | @ 10 days | 02:03:00-07 | 02:03:00-07 - 02:03:00-07 | @ 3 mons | 02:03:00-07 | 02:03:00-07 - 02:03:00-07 | @ 5 mons | 02:03:00-07 | 02:03:00-07 - 02:03:00-07 | @ 5 mons 12 hours | 14:03:00-07 | 14:03:00-07 - 02:03:00-07 | @ 6 years | 02:03:00-07 | 02:03:00-07 - 02:03:00-07 | @ 34 years | 02:03:00-07 | 02:03:00-07 - 08:08:00-04 | @ 14 secs ago | 08:07:46-04 | 08:08:14-04 - 08:08:00-04 | @ 1 min | 08:09:00-04 | 08:07:00-04 - 08:08:00-04 | @ 5 hours | 13:08:00-04 | 03:08:00-04 - 08:08:00-04 | @ 1 day 2 hours 3 mins 4 secs | 10:11:04-04 | 06:04:56-04 - 08:08:00-04 | @ 10 days | 08:08:00-04 | 08:08:00-04 - 08:08:00-04 | @ 3 mons | 08:08:00-04 | 08:08:00-04 - 08:08:00-04 | @ 5 mons | 08:08:00-04 | 08:08:00-04 - 08:08:00-04 | @ 5 mons 12 hours | 20:08:00-04 | 20:08:00-04 - 08:08:00-04 | @ 6 years | 08:08:00-04 | 08:08:00-04 - 08:08:00-04 | @ 34 years | 08:08:00-04 | 08:08:00-04 - 07:07:00-08 | @ 14 secs ago | 07:06:46-08 | 07:07:14-08 - 07:07:00-08 | @ 1 min | 07:08:00-08 | 07:06:00-08 - 07:07:00-08 | @ 5 hours | 12:07:00-08 | 02:07:00-08 - 07:07:00-08 | @ 1 day 2 hours 3 mins 4 secs | 09:10:04-08 | 05:03:56-08 - 07:07:00-08 | @ 10 days | 07:07:00-08 | 07:07:00-08 - 07:07:00-08 | @ 3 mons | 07:07:00-08 | 07:07:00-08 - 07:07:00-08 | @ 5 mons | 07:07:00-08 | 07:07:00-08 - 07:07:00-08 | @ 5 mons 12 hours | 19:07:00-08 | 19:07:00-08 - 07:07:00-08 | @ 6 years | 07:07:00-08 | 07:07:00-08 - 07:07:00-08 | @ 34 years | 07:07:00-08 | 07:07:00-08 - 11:59:00-07 | @ 14 secs ago | 11:58:46-07 | 11:59:14-07 - 11:59:00-07 | @ 1 min | 12:00:00-07 | 11:58:00-07 - 11:59:00-07 | @ 5 hours | 16:59:00-07 | 06:59:00-07 - 11:59:00-07 | @ 1 day 2 hours 3 mins 4 secs | 14:02:04-07 | 09:55:56-07 - 11:59:00-07 | @ 10 days | 11:59:00-07 | 11:59:00-07 - 11:59:00-07 | @ 3 mons | 11:59:00-07 | 11:59:00-07 - 11:59:00-07 | @ 5 mons | 11:59:00-07 | 11:59:00-07 - 11:59:00-07 | @ 5 mons 12 hours | 23:59:00-07 | 23:59:00-07 - 11:59:00-07 | @ 6 years | 11:59:00-07 | 11:59:00-07 - 11:59:00-07 | @ 34 years | 11:59:00-07 | 11:59:00-07 - 12:00:00-07 | @ 14 secs ago | 11:59:46-07 | 12:00:14-07 - 12:00:00-07 | @ 1 min | 12:01:00-07 | 11:59:00-07 - 12:00:00-07 | @ 5 hours | 17:00:00-07 | 07:00:00-07 - 12:00:00-07 | @ 1 day 2 hours 3 mins 4 secs | 14:03:04-07 | 09:56:56-07 - 12:00:00-07 | @ 10 days | 12:00:00-07 | 12:00:00-07 - 12:00:00-07 | @ 3 mons | 12:00:00-07 | 12:00:00-07 - 12:00:00-07 | @ 5 mons | 12:00:00-07 | 12:00:00-07 - 12:00:00-07 | @ 5 mons 12 hours | 00:00:00-07 | 00:00:00-07 - 12:00:00-07 | @ 6 years | 12:00:00-07 | 12:00:00-07 - 12:00:00-07 | @ 34 years | 12:00:00-07 | 12:00:00-07 - 12:01:00-07 | @ 14 secs ago | 12:00:46-07 | 12:01:14-07 - 12:01:00-07 | @ 1 min | 12:02:00-07 | 12:00:00-07 - 12:01:00-07 | @ 5 hours | 17:01:00-07 | 07:01:00-07 - 12:01:00-07 | @ 1 day 2 hours 3 mins 4 secs | 14:04:04-07 | 09:57:56-07 - 12:01:00-07 | @ 10 days | 12:01:00-07 | 12:01:00-07 - 12:01:00-07 | @ 3 mons | 12:01:00-07 | 12:01:00-07 - 12:01:00-07 | @ 5 mons | 12:01:00-07 | 12:01:00-07 - 12:01:00-07 | @ 5 mons 12 hours | 00:01:00-07 | 00:01:00-07 - 12:01:00-07 | @ 6 years | 12:01:00-07 | 12:01:00-07 - 12:01:00-07 | @ 34 years | 12:01:00-07 | 12:01:00-07 - 15:36:39-04 | @ 14 secs ago | 15:36:25-04 | 15:36:53-04 - 15:36:39-04 | @ 1 min | 15:37:39-04 | 15:35:39-04 - 15:36:39-04 | @ 5 hours | 20:36:39-04 | 10:36:39-04 - 15:36:39-04 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43-04 | 13:33:35-04 - 15:36:39-04 | @ 10 days | 15:36:39-04 | 15:36:39-04 - 15:36:39-04 | @ 3 mons | 15:36:39-04 | 15:36:39-04 - 15:36:39-04 | @ 5 mons | 15:36:39-04 | 15:36:39-04 - 15:36:39-04 | @ 5 mons 12 hours | 03:36:39-04 | 03:36:39-04 - 15:36:39-04 | @ 6 years | 15:36:39-04 | 15:36:39-04 - 15:36:39-04 | @ 34 years | 15:36:39-04 | 15:36:39-04 - 15:36:39-05 | @ 14 secs ago | 15:36:25-05 | 15:36:53-05 - 15:36:39-05 | @ 1 min | 15:37:39-05 | 15:35:39-05 - 15:36:39-05 | @ 5 hours | 20:36:39-05 | 10:36:39-05 - 15:36:39-05 | @ 1 day 2 hours 3 mins 4 secs | 17:39:43-05 | 13:33:35-05 - 15:36:39-05 | @ 10 days | 15:36:39-05 | 15:36:39-05 - 15:36:39-05 | @ 3 mons | 15:36:39-05 | 15:36:39-05 - 15:36:39-05 | @ 5 mons | 15:36:39-05 | 15:36:39-05 - 15:36:39-05 | @ 5 mons 12 hours | 03:36:39-05 | 03:36:39-05 - 15:36:39-05 | @ 6 years | 15:36:39-05 | 15:36:39-05 - 15:36:39-05 | @ 34 years | 15:36:39-05 | 15:36:39-05 - 23:59:00-07 | @ 14 secs ago | 23:58:46-07 | 23:59:14-07 - 23:59:00-07 | @ 1 min | 00:00:00-07 | 23:58:00-07 - 23:59:00-07 | @ 5 hours | 04:59:00-07 | 18:59:00-07 - 23:59:00-07 | @ 1 day 2 hours 3 mins 4 secs | 02:02:04-07 | 21:55:56-07 - 23:59:00-07 | @ 10 days | 23:59:00-07 | 23:59:00-07 - 23:59:00-07 | @ 3 mons | 23:59:00-07 | 23:59:00-07 - 23:59:00-07 | @ 5 mons | 23:59:00-07 | 23:59:00-07 - 23:59:00-07 | @ 5 mons 12 hours | 11:59:00-07 | 11:59:00-07 - 23:59:00-07 | @ 6 years | 23:59:00-07 | 23:59:00-07 - 23:59:00-07 | @ 34 years | 23:59:00-07 | 23:59:00-07 - 23:59:59.99-07 | @ 14 secs ago | 23:59:45.99-07 | 00:00:13.99-07 - 23:59:59.99-07 | @ 1 min | 00:00:59.99-07 | 23:58:59.99-07 - 23:59:59.99-07 | @ 5 hours | 04:59:59.99-07 | 18:59:59.99-07 - 23:59:59.99-07 | @ 1 day 2 hours 3 mins 4 secs | 02:03:03.99-07 | 21:56:55.99-07 - 23:59:59.99-07 | @ 10 days | 23:59:59.99-07 | 23:59:59.99-07 - 23:59:59.99-07 | @ 3 mons | 23:59:59.99-07 | 23:59:59.99-07 - 23:59:59.99-07 | @ 5 mons | 23:59:59.99-07 | 23:59:59.99-07 - 23:59:59.99-07 | @ 5 mons 12 hours | 11:59:59.99-07 | 11:59:59.99-07 - 23:59:59.99-07 | @ 6 years | 23:59:59.99-07 | 23:59:59.99-07 - 23:59:59.99-07 | @ 34 years | 23:59:59.99-07 | 23:59:59.99-07 -(120 rows) - +ERROR: failed to JIT: evalexpr.1.0 -- SQL9x OVERLAPS operator -- test with time zone SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28') @@ -1426,338 +1200,12 @@ SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 + t.f1 AS plus FROM TEMP_TIMESTAMP d, INTERVAL_TBL t ORDER BY plus, "timestamp", "interval"; - 160 | timestamp | interval | plus ------+------------------------------+-------------------------------+------------------------------ - | Thu Jan 01 00:00:00 1970 PST | @ 14 secs ago | Wed Dec 31 23:59:46 1969 PST - | Thu Jan 01 00:00:00 1970 PST | @ 1 min | Thu Jan 01 00:01:00 1970 PST - | Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Thu Jan 01 05:00:00 1970 PST - | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Jan 02 02:03:04 1970 PST - | Thu Jan 01 00:00:00 1970 PST | @ 10 days | Sun Jan 11 00:00:00 1970 PST - | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Apr 01 00:00:00 1970 PST - | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Mon Jun 01 00:00:00 1970 PDT - | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Mon Jun 01 12:00:00 1970 PDT - | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Thu Jan 01 00:00:00 1976 PST - | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago | Wed Feb 28 17:31:47 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 1 min | Wed Feb 28 17:33:01 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 5 hours | Wed Feb 28 22:32:01 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago | Thu Feb 29 17:31:47 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 1 min | Thu Feb 29 17:33:01 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 19:35:05 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 5 hours | Thu Feb 29 22:32:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago | Fri Mar 01 17:31:47 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 1 min | Fri Mar 01 17:33:01 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Mar 01 19:35:05 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 5 hours | Fri Mar 01 22:32:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Mar 02 19:35:05 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 10 days | Sat Mar 09 17:32:01 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 10 days | Sun Mar 10 17:32:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 10 days | Mon Mar 11 17:32:01 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 3 mons | Tue May 28 17:32:01 1996 PDT - | Thu Feb 29 17:32:01 1996 PST | @ 3 mons | Wed May 29 17:32:01 1996 PDT - | Fri Mar 01 17:32:01 1996 PST | @ 3 mons | Sat Jun 01 17:32:01 1996 PDT - | Wed Feb 28 17:32:01 1996 PST | @ 5 mons | Sun Jul 28 17:32:01 1996 PDT - | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours | Mon Jul 29 05:32:01 1996 PDT - | Thu Feb 29 17:32:01 1996 PST | @ 5 mons | Mon Jul 29 17:32:01 1996 PDT - | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours | Tue Jul 30 05:32:01 1996 PDT - | Fri Mar 01 17:32:01 1996 PST | @ 5 mons | Thu Aug 01 17:32:01 1996 PDT - | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours | Fri Aug 02 05:32:01 1996 PDT - | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago | Mon Dec 30 17:31:47 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 1 min | Mon Dec 30 17:33:01 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 5 hours | Mon Dec 30 22:32:01 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago | Tue Dec 31 17:31:47 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 1 min | Tue Dec 31 17:33:01 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 31 19:35:05 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 5 hours | Tue Dec 31 22:32:01 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Jan 01 19:35:05 1997 PST - | Mon Dec 30 17:32:01 1996 PST | @ 10 days | Thu Jan 09 17:32:01 1997 PST - | Tue Dec 31 17:32:01 1996 PST | @ 10 days | Fri Jan 10 17:32:01 1997 PST - | Mon Dec 30 17:32:01 1996 PST | @ 3 mons | Sun Mar 30 17:32:01 1997 PST - | Tue Dec 31 17:32:01 1996 PST | @ 3 mons | Mon Mar 31 17:32:01 1997 PST - | Mon Dec 30 17:32:01 1996 PST | @ 5 mons | Fri May 30 17:32:01 1997 PDT - | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours | Sat May 31 05:32:01 1997 PDT - | Tue Dec 31 17:32:01 1996 PST | @ 5 mons | Sat May 31 17:32:01 1997 PDT - | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours | Sun Jun 01 05:32:01 1997 PDT - | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago | Fri Dec 31 17:31:47 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 1 min | Fri Dec 31 17:33:01 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 5 hours | Fri Dec 31 22:32:01 1999 PST - | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago | Sat Jan 01 17:31:47 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 1 min | Sat Jan 01 17:33:01 2000 PST - | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Jan 01 19:35:05 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 5 hours | Sat Jan 01 22:32:01 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Jan 02 19:35:05 2000 PST - | Fri Dec 31 17:32:01 1999 PST | @ 10 days | Mon Jan 10 17:32:01 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 10 days | Tue Jan 11 17:32:01 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 14 secs ago | Wed Mar 15 02:13:51 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 1 min | Wed Mar 15 02:15:05 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago | Wed Mar 15 03:13:50 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 1 min | Wed Mar 15 03:15:04 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 5 hours | Wed Mar 15 07:14:05 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago | Wed Mar 15 08:13:47 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 5 hours | Wed Mar 15 08:14:04 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 1 min | Wed Mar 15 08:15:01 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 14 secs ago | Wed Mar 15 12:13:49 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 1 min | Wed Mar 15 12:15:03 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 14 secs ago | Wed Mar 15 13:13:48 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 5 hours | Wed Mar 15 13:14:01 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 1 min | Wed Mar 15 13:15:02 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 5 hours | Wed Mar 15 17:14:03 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 5 hours | Wed Mar 15 18:14:02 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 04:17:09 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 05:17:08 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 10:17:05 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 14:17:07 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 15:17:06 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 10 days | Sat Mar 25 02:14:05 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 10 days | Sat Mar 25 03:14:04 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 10 days | Sat Mar 25 08:14:01 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 10 days | Sat Mar 25 12:14:03 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 10 days | Sat Mar 25 13:14:02 2000 PST - | Fri Dec 31 17:32:01 1999 PST | @ 3 mons | Fri Mar 31 17:32:01 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 3 mons | Sat Apr 01 17:32:01 2000 PST - | Fri Dec 31 17:32:01 1999 PST | @ 5 mons | Wed May 31 17:32:01 2000 PDT - | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours | Thu Jun 01 05:32:01 2000 PDT - | Sat Jan 01 17:32:01 2000 PST | @ 5 mons | Thu Jun 01 17:32:01 2000 PDT - | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours | Fri Jun 02 05:32:01 2000 PDT - | Wed Mar 15 02:14:05 2000 PST | @ 3 mons | Thu Jun 15 02:14:05 2000 PDT - | Wed Mar 15 03:14:04 2000 PST | @ 3 mons | Thu Jun 15 03:14:04 2000 PDT - | Wed Mar 15 08:14:01 2000 PST | @ 3 mons | Thu Jun 15 08:14:01 2000 PDT - | Wed Mar 15 12:14:03 2000 PST | @ 3 mons | Thu Jun 15 12:14:03 2000 PDT - | Wed Mar 15 13:14:02 2000 PST | @ 3 mons | Thu Jun 15 13:14:02 2000 PDT - | Wed Mar 15 02:14:05 2000 PST | @ 5 mons | Tue Aug 15 02:14:05 2000 PDT - | Wed Mar 15 03:14:04 2000 PST | @ 5 mons | Tue Aug 15 03:14:04 2000 PDT - | Wed Mar 15 08:14:01 2000 PST | @ 5 mons | Tue Aug 15 08:14:01 2000 PDT - | Wed Mar 15 12:14:03 2000 PST | @ 5 mons | Tue Aug 15 12:14:03 2000 PDT - | Wed Mar 15 13:14:02 2000 PST | @ 5 mons | Tue Aug 15 13:14:02 2000 PDT - | Wed Mar 15 02:14:05 2000 PST | @ 5 mons 12 hours | Tue Aug 15 14:14:05 2000 PDT - | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours | Tue Aug 15 15:14:04 2000 PDT - | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours | Tue Aug 15 20:14:01 2000 PDT - | Wed Mar 15 12:14:03 2000 PST | @ 5 mons 12 hours | Wed Aug 16 00:14:03 2000 PDT - | Wed Mar 15 13:14:02 2000 PST | @ 5 mons 12 hours | Wed Aug 16 01:14:02 2000 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago | Sun Dec 31 17:31:47 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 1 min | Sun Dec 31 17:33:01 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 5 hours | Sun Dec 31 22:32:01 2000 PST - | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago | Mon Jan 01 17:31:47 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 1 min | Mon Jan 01 17:33:01 2001 PST - | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Jan 01 19:35:05 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 5 hours | Mon Jan 01 22:32:01 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Jan 02 19:35:05 2001 PST - | Sun Dec 31 17:32:01 2000 PST | @ 10 days | Wed Jan 10 17:32:01 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 10 days | Thu Jan 11 17:32:01 2001 PST - | Sun Dec 31 17:32:01 2000 PST | @ 3 mons | Sat Mar 31 17:32:01 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 3 mons | Sun Apr 01 17:32:01 2001 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 5 mons | Thu May 31 17:32:01 2001 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours | Fri Jun 01 05:32:01 2001 PDT - | Mon Jan 01 17:32:01 2001 PST | @ 5 mons | Fri Jun 01 17:32:01 2001 PDT - | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours | Sat Jun 02 05:32:01 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago | Sat Sep 22 18:19:06 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 1 min | Sat Sep 22 18:20:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 5 hours | Sat Sep 22 23:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 1 day 2 hours 3 mins 4 secs | Sun Sep 23 20:22:24 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 10 days | Tue Oct 02 18:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 3 mons | Sat Dec 22 18:19:20 2001 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons | Fri Feb 22 18:19:20 2002 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons 12 hours | Sat Feb 23 06:19:20 2002 PST - | Wed Feb 28 17:32:01 1996 PST | @ 6 years | Thu Feb 28 17:32:01 2002 PST - | Thu Feb 29 17:32:01 1996 PST | @ 6 years | Thu Feb 28 17:32:01 2002 PST - | Fri Mar 01 17:32:01 1996 PST | @ 6 years | Fri Mar 01 17:32:01 2002 PST - | Mon Dec 30 17:32:01 1996 PST | @ 6 years | Mon Dec 30 17:32:01 2002 PST - | Tue Dec 31 17:32:01 1996 PST | @ 6 years | Tue Dec 31 17:32:01 2002 PST - | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Thu Jan 01 00:00:00 2004 PST - | Fri Dec 31 17:32:01 1999 PST | @ 6 years | Sat Dec 31 17:32:01 2005 PST - | Sat Jan 01 17:32:01 2000 PST | @ 6 years | Sun Jan 01 17:32:01 2006 PST - | Wed Mar 15 02:14:05 2000 PST | @ 6 years | Wed Mar 15 02:14:05 2006 PST - | Wed Mar 15 03:14:04 2000 PST | @ 6 years | Wed Mar 15 03:14:04 2006 PST - | Wed Mar 15 08:14:01 2000 PST | @ 6 years | Wed Mar 15 08:14:01 2006 PST - | Wed Mar 15 12:14:03 2000 PST | @ 6 years | Wed Mar 15 12:14:03 2006 PST - | Wed Mar 15 13:14:02 2000 PST | @ 6 years | Wed Mar 15 13:14:02 2006 PST - | Sun Dec 31 17:32:01 2000 PST | @ 6 years | Sun Dec 31 17:32:01 2006 PST - | Mon Jan 01 17:32:01 2001 PST | @ 6 years | Mon Jan 01 17:32:01 2007 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 6 years | Sat Sep 22 18:19:20 2007 PDT - | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Thu Feb 28 17:32:01 2030 PST - | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Thu Feb 28 17:32:01 2030 PST - | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Fri Mar 01 17:32:01 2030 PST - | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Mon Dec 30 17:32:01 2030 PST - | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Tue Dec 31 17:32:01 2030 PST - | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Sat Dec 31 17:32:01 2033 PST - | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sun Jan 01 17:32:01 2034 PST - | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Wed Mar 15 02:14:05 2034 PDT - | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Wed Mar 15 03:14:04 2034 PDT - | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Wed Mar 15 08:14:01 2034 PDT - | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Wed Mar 15 12:14:03 2034 PDT - | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Wed Mar 15 13:14:02 2034 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sun Dec 31 17:32:01 2034 PST - | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Mon Jan 01 17:32:01 2035 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Sat Sep 22 18:19:20 2035 PDT -(160 rows) - +ERROR: failed to JIT: evalexpr.2.0 SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 - t.f1 AS minus FROM TEMP_TIMESTAMP d, INTERVAL_TBL t WHERE isfinite(d.f1) ORDER BY minus, "timestamp", "interval"; - 160 | timestamp | interval | minus ------+------------------------------+-------------------------------+------------------------------ - | Thu Jan 01 00:00:00 1970 PST | @ 34 years | Wed Jan 01 00:00:00 1936 PST - | Wed Feb 28 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST - | Thu Feb 29 17:32:01 1996 PST | @ 34 years | Wed Feb 28 17:32:01 1962 PST - | Fri Mar 01 17:32:01 1996 PST | @ 34 years | Thu Mar 01 17:32:01 1962 PST - | Mon Dec 30 17:32:01 1996 PST | @ 34 years | Sun Dec 30 17:32:01 1962 PST - | Tue Dec 31 17:32:01 1996 PST | @ 34 years | Mon Dec 31 17:32:01 1962 PST - | Thu Jan 01 00:00:00 1970 PST | @ 6 years | Wed Jan 01 00:00:00 1964 PST - | Fri Dec 31 17:32:01 1999 PST | @ 34 years | Fri Dec 31 17:32:01 1965 PST - | Sat Jan 01 17:32:01 2000 PST | @ 34 years | Sat Jan 01 17:32:01 1966 PST - | Wed Mar 15 02:14:05 2000 PST | @ 34 years | Tue Mar 15 02:14:05 1966 PST - | Wed Mar 15 03:14:04 2000 PST | @ 34 years | Tue Mar 15 03:14:04 1966 PST - | Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15 08:14:01 1966 PST - | Wed Mar 15 12:14:03 2000 PST | @ 34 years | Tue Mar 15 12:14:03 1966 PST - | Wed Mar 15 13:14:02 2000 PST | @ 34 years | Tue Mar 15 13:14:02 1966 PST - | Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31 17:32:01 1966 PST - | Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01 17:32:01 1967 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 34 years | Fri Sep 22 18:19:20 1967 PDT - | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours | Thu Jul 31 12:00:00 1969 PDT - | Thu Jan 01 00:00:00 1970 PST | @ 5 mons | Fri Aug 01 00:00:00 1969 PDT - | Thu Jan 01 00:00:00 1970 PST | @ 3 mons | Wed Oct 01 00:00:00 1969 PDT - | Thu Jan 01 00:00:00 1970 PST | @ 10 days | Mon Dec 22 00:00:00 1969 PST - | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST - | Thu Jan 01 00:00:00 1970 PST | @ 5 hours | Wed Dec 31 19:00:00 1969 PST - | Thu Jan 01 00:00:00 1970 PST | @ 1 min | Wed Dec 31 23:59:00 1969 PST - | Thu Jan 01 00:00:00 1970 PST | @ 14 secs ago | Thu Jan 01 00:00:14 1970 PST - | Wed Feb 28 17:32:01 1996 PST | @ 6 years | Wed Feb 28 17:32:01 1990 PST - | Thu Feb 29 17:32:01 1996 PST | @ 6 years | Wed Feb 28 17:32:01 1990 PST - | Fri Mar 01 17:32:01 1996 PST | @ 6 years | Thu Mar 01 17:32:01 1990 PST - | Mon Dec 30 17:32:01 1996 PST | @ 6 years | Sun Dec 30 17:32:01 1990 PST - | Tue Dec 31 17:32:01 1996 PST | @ 6 years | Mon Dec 31 17:32:01 1990 PST - | Fri Dec 31 17:32:01 1999 PST | @ 6 years | Fri Dec 31 17:32:01 1993 PST - | Sat Jan 01 17:32:01 2000 PST | @ 6 years | Sat Jan 01 17:32:01 1994 PST - | Wed Mar 15 02:14:05 2000 PST | @ 6 years | Tue Mar 15 02:14:05 1994 PST - | Wed Mar 15 03:14:04 2000 PST | @ 6 years | Tue Mar 15 03:14:04 1994 PST - | Wed Mar 15 08:14:01 2000 PST | @ 6 years | Tue Mar 15 08:14:01 1994 PST - | Wed Mar 15 12:14:03 2000 PST | @ 6 years | Tue Mar 15 12:14:03 1994 PST - | Wed Mar 15 13:14:02 2000 PST | @ 6 years | Tue Mar 15 13:14:02 1994 PST - | Sun Dec 31 17:32:01 2000 PST | @ 6 years | Sat Dec 31 17:32:01 1994 PST - | Mon Jan 01 17:32:01 2001 PST | @ 6 years | Sun Jan 01 17:32:01 1995 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 6 years | Fri Sep 22 18:19:20 1995 PDT - | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours | Thu Sep 28 05:32:01 1995 PDT - | Wed Feb 28 17:32:01 1996 PST | @ 5 mons | Thu Sep 28 17:32:01 1995 PDT - | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours | Fri Sep 29 05:32:01 1995 PDT - | Thu Feb 29 17:32:01 1996 PST | @ 5 mons | Fri Sep 29 17:32:01 1995 PDT - | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours | Sun Oct 01 05:32:01 1995 PDT - | Fri Mar 01 17:32:01 1996 PST | @ 5 mons | Sun Oct 01 17:32:01 1995 PDT - | Wed Feb 28 17:32:01 1996 PST | @ 3 mons | Tue Nov 28 17:32:01 1995 PST - | Thu Feb 29 17:32:01 1996 PST | @ 3 mons | Wed Nov 29 17:32:01 1995 PST - | Fri Mar 01 17:32:01 1996 PST | @ 3 mons | Fri Dec 01 17:32:01 1995 PST - | Wed Feb 28 17:32:01 1996 PST | @ 10 days | Sun Feb 18 17:32:01 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 10 days | Mon Feb 19 17:32:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 10 days | Tue Feb 20 17:32:01 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Feb 27 15:28:57 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 5 hours | Wed Feb 28 12:32:01 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Feb 28 15:28:57 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 1 min | Wed Feb 28 17:31:01 1996 PST - | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago | Wed Feb 28 17:32:15 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 5 hours | Thu Feb 29 12:32:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 15:28:57 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 1 min | Thu Feb 29 17:31:01 1996 PST - | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago | Thu Feb 29 17:32:15 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 5 hours | Fri Mar 01 12:32:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 1 min | Fri Mar 01 17:31:01 1996 PST - | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago | Fri Mar 01 17:32:15 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours | Tue Jul 30 05:32:01 1996 PDT - | Mon Dec 30 17:32:01 1996 PST | @ 5 mons | Tue Jul 30 17:32:01 1996 PDT - | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours | Wed Jul 31 05:32:01 1996 PDT - | Tue Dec 31 17:32:01 1996 PST | @ 5 mons | Wed Jul 31 17:32:01 1996 PDT - | Mon Dec 30 17:32:01 1996 PST | @ 3 mons | Mon Sep 30 17:32:01 1996 PDT - | Tue Dec 31 17:32:01 1996 PST | @ 3 mons | Mon Sep 30 17:32:01 1996 PDT - | Mon Dec 30 17:32:01 1996 PST | @ 10 days | Fri Dec 20 17:32:01 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 10 days | Sat Dec 21 17:32:01 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 29 15:28:57 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 5 hours | Mon Dec 30 12:32:01 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Dec 30 15:28:57 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 1 min | Mon Dec 30 17:31:01 1996 PST - | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago | Mon Dec 30 17:32:15 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 5 hours | Tue Dec 31 12:32:01 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 1 min | Tue Dec 31 17:31:01 1996 PST - | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago | Tue Dec 31 17:32:15 1996 PST - | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours | Sat Jul 31 05:32:01 1999 PDT - | Fri Dec 31 17:32:01 1999 PST | @ 5 mons | Sat Jul 31 17:32:01 1999 PDT - | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours | Sun Aug 01 05:32:01 1999 PDT - | Sat Jan 01 17:32:01 2000 PST | @ 5 mons | Sun Aug 01 17:32:01 1999 PDT - | Fri Dec 31 17:32:01 1999 PST | @ 3 mons | Thu Sep 30 17:32:01 1999 PDT - | Sat Jan 01 17:32:01 2000 PST | @ 3 mons | Fri Oct 01 17:32:01 1999 PDT - | Wed Mar 15 02:14:05 2000 PST | @ 5 mons 12 hours | Thu Oct 14 14:14:05 1999 PDT - | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours | Thu Oct 14 15:14:04 1999 PDT - | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours | Thu Oct 14 20:14:01 1999 PDT - | Wed Mar 15 12:14:03 2000 PST | @ 5 mons 12 hours | Fri Oct 15 00:14:03 1999 PDT - | Wed Mar 15 13:14:02 2000 PST | @ 5 mons 12 hours | Fri Oct 15 01:14:02 1999 PDT - | Wed Mar 15 02:14:05 2000 PST | @ 5 mons | Fri Oct 15 02:14:05 1999 PDT - | Wed Mar 15 03:14:04 2000 PST | @ 5 mons | Fri Oct 15 03:14:04 1999 PDT - | Wed Mar 15 08:14:01 2000 PST | @ 5 mons | Fri Oct 15 08:14:01 1999 PDT - | Wed Mar 15 12:14:03 2000 PST | @ 5 mons | Fri Oct 15 12:14:03 1999 PDT - | Wed Mar 15 13:14:02 2000 PST | @ 5 mons | Fri Oct 15 13:14:02 1999 PDT - | Wed Mar 15 02:14:05 2000 PST | @ 3 mons | Wed Dec 15 02:14:05 1999 PST - | Wed Mar 15 03:14:04 2000 PST | @ 3 mons | Wed Dec 15 03:14:04 1999 PST - | Wed Mar 15 08:14:01 2000 PST | @ 3 mons | Wed Dec 15 08:14:01 1999 PST - | Wed Mar 15 12:14:03 2000 PST | @ 3 mons | Wed Dec 15 12:14:03 1999 PST - | Wed Mar 15 13:14:02 2000 PST | @ 3 mons | Wed Dec 15 13:14:02 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 10 days | Tue Dec 21 17:32:01 1999 PST - | Sat Jan 01 17:32:01 2000 PST | @ 10 days | Wed Dec 22 17:32:01 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Dec 30 15:28:57 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 5 hours | Fri Dec 31 12:32:01 1999 PST - | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Dec 31 15:28:57 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 1 min | Fri Dec 31 17:31:01 1999 PST - | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago | Fri Dec 31 17:32:15 1999 PST - | Sat Jan 01 17:32:01 2000 PST | @ 5 hours | Sat Jan 01 12:32:01 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 1 min | Sat Jan 01 17:31:01 2000 PST - | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago | Sat Jan 01 17:32:15 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 10 days | Sun Mar 05 02:14:05 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 10 days | Sun Mar 05 03:14:04 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 10 days | Sun Mar 05 08:14:01 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 10 days | Sun Mar 05 12:14:03 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 10 days | Sun Mar 05 13:14:02 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 00:11:01 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 01:11:00 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 06:10:57 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 10:10:59 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 11:10:58 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 5 hours | Tue Mar 14 21:14:05 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 5 hours | Tue Mar 14 22:14:04 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 1 min | Wed Mar 15 02:13:05 2000 PST - | Wed Mar 15 02:14:05 2000 PST | @ 14 secs ago | Wed Mar 15 02:14:19 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 1 min | Wed Mar 15 03:13:04 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 5 hours | Wed Mar 15 03:14:01 2000 PST - | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago | Wed Mar 15 03:14:18 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 5 hours | Wed Mar 15 07:14:03 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 1 min | Wed Mar 15 08:13:01 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 5 hours | Wed Mar 15 08:14:02 2000 PST - | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago | Wed Mar 15 08:14:15 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 1 min | Wed Mar 15 12:13:03 2000 PST - | Wed Mar 15 12:14:03 2000 PST | @ 14 secs ago | Wed Mar 15 12:14:17 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 1 min | Wed Mar 15 13:13:02 2000 PST - | Wed Mar 15 13:14:02 2000 PST | @ 14 secs ago | Wed Mar 15 13:14:16 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours | Mon Jul 31 05:32:01 2000 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 5 mons | Mon Jul 31 17:32:01 2000 PDT - | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours | Tue Aug 01 05:32:01 2000 PDT - | Mon Jan 01 17:32:01 2001 PST | @ 5 mons | Tue Aug 01 17:32:01 2000 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 3 mons | Sat Sep 30 17:32:01 2000 PDT - | Mon Jan 01 17:32:01 2001 PST | @ 3 mons | Sun Oct 01 17:32:01 2000 PDT - | Sun Dec 31 17:32:01 2000 PST | @ 10 days | Thu Dec 21 17:32:01 2000 PST - | Mon Jan 01 17:32:01 2001 PST | @ 10 days | Fri Dec 22 17:32:01 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Dec 30 15:28:57 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 5 hours | Sun Dec 31 12:32:01 2000 PST - | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 31 15:28:57 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 1 min | Sun Dec 31 17:31:01 2000 PST - | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago | Sun Dec 31 17:32:15 2000 PST - | Mon Jan 01 17:32:01 2001 PST | @ 5 hours | Mon Jan 01 12:32:01 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 1 min | Mon Jan 01 17:31:01 2001 PST - | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago | Mon Jan 01 17:32:15 2001 PST - | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons 12 hours | Sun Apr 22 06:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons | Sun Apr 22 18:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 3 mons | Fri Jun 22 18:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 10 days | Wed Sep 12 18:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 1 day 2 hours 3 mins 4 secs | Fri Sep 21 16:16:16 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 5 hours | Sat Sep 22 13:19:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 1 min | Sat Sep 22 18:18:20 2001 PDT - | Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago | Sat Sep 22 18:19:34 2001 PDT -(160 rows) - +ERROR: failed to JIT: evalexpr.3.0 SELECT '' AS "16", d.f1 AS "timestamp", timestamp with time zone '1980-01-06 00:00 GMT' AS gpstime_zero, d.f1 - timestamp with time zone '1980-01-06 00:00 GMT' AS difference @@ -1786,266 +1234,7 @@ SELECT '' AS "226", d1.f1 AS timestamp1, d2.f1 AS timestamp2, d1.f1 - d2.f1 AS difference FROM TEMP_TIMESTAMP d1, TEMP_TIMESTAMP d2 ORDER BY timestamp1, timestamp2, difference; - 226 | timestamp1 | timestamp2 | difference ------+------------------------------+------------------------------+------------------------------------------- - | Thu Jan 01 00:00:00 1970 PST | Thu Jan 01 00:00:00 1970 PST | @ 0 - | Thu Jan 01 00:00:00 1970 PST | Wed Feb 28 17:32:01 1996 PST | @ 9554 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Thu Feb 29 17:32:01 1996 PST | @ 9555 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Fri Mar 01 17:32:01 1996 PST | @ 9556 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Mon Dec 30 17:32:01 1996 PST | @ 9860 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Tue Dec 31 17:32:01 1996 PST | @ 9861 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Fri Dec 31 17:32:01 1999 PST | @ 10956 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Sat Jan 01 17:32:01 2000 PST | @ 10957 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 02:14:05 2000 PST | @ 11031 days 2 hours 14 mins 5 secs ago - | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 03:14:04 2000 PST | @ 11031 days 3 hours 14 mins 4 secs ago - | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 08:14:01 2000 PST | @ 11031 days 8 hours 14 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 12:14:03 2000 PST | @ 11031 days 12 hours 14 mins 3 secs ago - | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 13:14:02 2000 PST | @ 11031 days 13 hours 14 mins 2 secs ago - | Thu Jan 01 00:00:00 1970 PST | Sun Dec 31 17:32:01 2000 PST | @ 11322 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Mon Jan 01 17:32:01 2001 PST | @ 11323 days 17 hours 32 mins 1 sec ago - | Thu Jan 01 00:00:00 1970 PST | Sat Sep 22 18:19:20 2001 PDT | @ 11587 days 17 hours 19 mins 20 secs ago - | Wed Feb 28 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9554 days 17 hours 32 mins 1 sec - | Wed Feb 28 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 0 - | Wed Feb 28 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 1 day ago - | Wed Feb 28 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 2 days ago - | Wed Feb 28 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 306 days ago - | Wed Feb 28 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 307 days ago - | Wed Feb 28 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1402 days ago - | Wed Feb 28 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1403 days ago - | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1476 days 8 hours 42 mins 4 secs ago - | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1476 days 9 hours 42 mins 3 secs ago - | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1476 days 14 hours 42 mins ago - | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1476 days 18 hours 42 mins 2 secs ago - | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1476 days 19 hours 42 mins 1 sec ago - | Wed Feb 28 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1768 days ago - | Wed Feb 28 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1769 days ago - | Wed Feb 28 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2032 days 23 hours 47 mins 19 secs ago - | Thu Feb 29 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9555 days 17 hours 32 mins 1 sec - | Thu Feb 29 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 1 day - | Thu Feb 29 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 0 - | Thu Feb 29 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 1 day ago - | Thu Feb 29 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 305 days ago - | Thu Feb 29 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 306 days ago - | Thu Feb 29 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1401 days ago - | Thu Feb 29 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1402 days ago - | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1475 days 8 hours 42 mins 4 secs ago - | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1475 days 9 hours 42 mins 3 secs ago - | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1475 days 14 hours 42 mins ago - | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1475 days 18 hours 42 mins 2 secs ago - | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1475 days 19 hours 42 mins 1 sec ago - | Thu Feb 29 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1767 days ago - | Thu Feb 29 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1768 days ago - | Thu Feb 29 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2031 days 23 hours 47 mins 19 secs ago - | Fri Mar 01 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9556 days 17 hours 32 mins 1 sec - | Fri Mar 01 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 2 days - | Fri Mar 01 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 1 day - | Fri Mar 01 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 0 - | Fri Mar 01 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 304 days ago - | Fri Mar 01 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 305 days ago - | Fri Mar 01 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1400 days ago - | Fri Mar 01 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1401 days ago - | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1474 days 8 hours 42 mins 4 secs ago - | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1474 days 9 hours 42 mins 3 secs ago - | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1474 days 14 hours 42 mins ago - | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1474 days 18 hours 42 mins 2 secs ago - | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1474 days 19 hours 42 mins 1 sec ago - | Fri Mar 01 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1766 days ago - | Fri Mar 01 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1767 days ago - | Fri Mar 01 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2030 days 23 hours 47 mins 19 secs ago - | Mon Dec 30 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9860 days 17 hours 32 mins 1 sec - | Mon Dec 30 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 306 days - | Mon Dec 30 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 305 days - | Mon Dec 30 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 304 days - | Mon Dec 30 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 0 - | Mon Dec 30 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 1 day ago - | Mon Dec 30 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1096 days ago - | Mon Dec 30 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1097 days ago - | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1170 days 8 hours 42 mins 4 secs ago - | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1170 days 9 hours 42 mins 3 secs ago - | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1170 days 14 hours 42 mins ago - | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1170 days 18 hours 42 mins 2 secs ago - | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1170 days 19 hours 42 mins 1 sec ago - | Mon Dec 30 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1462 days ago - | Mon Dec 30 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1463 days ago - | Mon Dec 30 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 1726 days 23 hours 47 mins 19 secs ago - | Tue Dec 31 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9861 days 17 hours 32 mins 1 sec - | Tue Dec 31 17:32:01 1996 PST | Wed Feb 28 17:32:01 1996 PST | @ 307 days - | Tue Dec 31 17:32:01 1996 PST | Thu Feb 29 17:32:01 1996 PST | @ 306 days - | Tue Dec 31 17:32:01 1996 PST | Fri Mar 01 17:32:01 1996 PST | @ 305 days - | Tue Dec 31 17:32:01 1996 PST | Mon Dec 30 17:32:01 1996 PST | @ 1 day - | Tue Dec 31 17:32:01 1996 PST | Tue Dec 31 17:32:01 1996 PST | @ 0 - | Tue Dec 31 17:32:01 1996 PST | Fri Dec 31 17:32:01 1999 PST | @ 1095 days ago - | Tue Dec 31 17:32:01 1996 PST | Sat Jan 01 17:32:01 2000 PST | @ 1096 days ago - | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1169 days 8 hours 42 mins 4 secs ago - | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1169 days 9 hours 42 mins 3 secs ago - | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1169 days 14 hours 42 mins ago - | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1169 days 18 hours 42 mins 2 secs ago - | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1169 days 19 hours 42 mins 1 sec ago - | Tue Dec 31 17:32:01 1996 PST | Sun Dec 31 17:32:01 2000 PST | @ 1461 days ago - | Tue Dec 31 17:32:01 1996 PST | Mon Jan 01 17:32:01 2001 PST | @ 1462 days ago - | Tue Dec 31 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 1725 days 23 hours 47 mins 19 secs ago - | Fri Dec 31 17:32:01 1999 PST | Thu Jan 01 00:00:00 1970 PST | @ 10956 days 17 hours 32 mins 1 sec - | Fri Dec 31 17:32:01 1999 PST | Wed Feb 28 17:32:01 1996 PST | @ 1402 days - | Fri Dec 31 17:32:01 1999 PST | Thu Feb 29 17:32:01 1996 PST | @ 1401 days - | Fri Dec 31 17:32:01 1999 PST | Fri Mar 01 17:32:01 1996 PST | @ 1400 days - | Fri Dec 31 17:32:01 1999 PST | Mon Dec 30 17:32:01 1996 PST | @ 1096 days - | Fri Dec 31 17:32:01 1999 PST | Tue Dec 31 17:32:01 1996 PST | @ 1095 days - | Fri Dec 31 17:32:01 1999 PST | Fri Dec 31 17:32:01 1999 PST | @ 0 - | Fri Dec 31 17:32:01 1999 PST | Sat Jan 01 17:32:01 2000 PST | @ 1 day ago - | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 02:14:05 2000 PST | @ 74 days 8 hours 42 mins 4 secs ago - | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 03:14:04 2000 PST | @ 74 days 9 hours 42 mins 3 secs ago - | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 08:14:01 2000 PST | @ 74 days 14 hours 42 mins ago - | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 12:14:03 2000 PST | @ 74 days 18 hours 42 mins 2 secs ago - | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 13:14:02 2000 PST | @ 74 days 19 hours 42 mins 1 sec ago - | Fri Dec 31 17:32:01 1999 PST | Sun Dec 31 17:32:01 2000 PST | @ 366 days ago - | Fri Dec 31 17:32:01 1999 PST | Mon Jan 01 17:32:01 2001 PST | @ 367 days ago - | Fri Dec 31 17:32:01 1999 PST | Sat Sep 22 18:19:20 2001 PDT | @ 630 days 23 hours 47 mins 19 secs ago - | Sat Jan 01 17:32:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 10957 days 17 hours 32 mins 1 sec - | Sat Jan 01 17:32:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1403 days - | Sat Jan 01 17:32:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1402 days - | Sat Jan 01 17:32:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1401 days - | Sat Jan 01 17:32:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1097 days - | Sat Jan 01 17:32:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1096 days - | Sat Jan 01 17:32:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 1 day - | Sat Jan 01 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 0 - | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 73 days 8 hours 42 mins 4 secs ago - | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 73 days 9 hours 42 mins 3 secs ago - | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 73 days 14 hours 42 mins ago - | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 73 days 18 hours 42 mins 2 secs ago - | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 73 days 19 hours 42 mins 1 sec ago - | Sat Jan 01 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 365 days ago - | Sat Jan 01 17:32:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 366 days ago - | Sat Jan 01 17:32:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 629 days 23 hours 47 mins 19 secs ago - | Wed Mar 15 02:14:05 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 2 hours 14 mins 5 secs - | Wed Mar 15 02:14:05 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 8 hours 42 mins 4 secs - | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 0 - | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 59 mins 59 secs ago - | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 59 mins 56 secs ago - | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 9 hours 59 mins 58 secs ago - | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 10 hours 59 mins 57 secs ago - | Wed Mar 15 02:14:05 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 15 hours 17 mins 56 secs ago - | Wed Mar 15 02:14:05 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 15 hours 17 mins 56 secs ago - | Wed Mar 15 02:14:05 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 15 hours 5 mins 15 secs ago - | Wed Mar 15 03:14:04 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 3 hours 14 mins 4 secs - | Wed Mar 15 03:14:04 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 9 hours 42 mins 3 secs - | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 59 mins 59 secs - | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 0 - | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 59 mins 57 secs ago - | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 8 hours 59 mins 59 secs ago - | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 9 hours 59 mins 58 secs ago - | Wed Mar 15 03:14:04 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 14 hours 17 mins 57 secs ago - | Wed Mar 15 03:14:04 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 14 hours 17 mins 57 secs ago - | Wed Mar 15 03:14:04 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 14 hours 5 mins 16 secs ago - | Wed Mar 15 08:14:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 8 hours 14 mins 1 sec - | Wed Mar 15 08:14:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 14 hours 42 mins - | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 5 hours 59 mins 56 secs - | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 4 hours 59 mins 57 secs - | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 0 - | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 4 hours 2 secs ago - | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 5 hours 1 sec ago - | Wed Mar 15 08:14:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 9 hours 18 mins ago - | Wed Mar 15 08:14:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 9 hours 18 mins ago - | Wed Mar 15 08:14:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 9 hours 5 mins 19 secs ago - | Wed Mar 15 12:14:03 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 12 hours 14 mins 3 secs - | Wed Mar 15 12:14:03 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 18 hours 42 mins 2 secs - | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 9 hours 59 mins 58 secs - | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 8 hours 59 mins 59 secs - | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 2 secs - | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 0 - | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 59 mins 59 secs ago - | Wed Mar 15 12:14:03 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 5 hours 17 mins 58 secs ago - | Wed Mar 15 12:14:03 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 5 hours 17 mins 58 secs ago - | Wed Mar 15 12:14:03 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 5 hours 5 mins 17 secs ago - | Wed Mar 15 13:14:02 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 13 hours 14 mins 2 secs - | Wed Mar 15 13:14:02 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 19 hours 42 mins 1 sec - | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 10 hours 59 mins 57 secs - | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 9 hours 59 mins 58 secs - | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 1 sec - | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 59 mins 59 secs - | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 0 - | Wed Mar 15 13:14:02 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 4 hours 17 mins 59 secs ago - | Wed Mar 15 13:14:02 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 4 hours 17 mins 59 secs ago - | Wed Mar 15 13:14:02 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 4 hours 5 mins 18 secs ago - | Sun Dec 31 17:32:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11322 days 17 hours 32 mins 1 sec - | Sun Dec 31 17:32:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1768 days - | Sun Dec 31 17:32:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1767 days - | Sun Dec 31 17:32:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1766 days - | Sun Dec 31 17:32:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1462 days - | Sun Dec 31 17:32:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1461 days - | Sun Dec 31 17:32:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 366 days - | Sun Dec 31 17:32:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 365 days - | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 291 days 15 hours 17 mins 56 secs - | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 291 days 14 hours 17 mins 57 secs - | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 291 days 9 hours 18 mins - | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 291 days 5 hours 17 mins 58 secs - | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 291 days 4 hours 17 mins 59 secs - | Sun Dec 31 17:32:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 0 - | Sun Dec 31 17:32:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 1 day ago - | Sun Dec 31 17:32:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 264 days 23 hours 47 mins 19 secs ago - | Mon Jan 01 17:32:01 2001 PST | Thu Jan 01 00:00:00 1970 PST | @ 11323 days 17 hours 32 mins 1 sec - | Mon Jan 01 17:32:01 2001 PST | Wed Feb 28 17:32:01 1996 PST | @ 1769 days - | Mon Jan 01 17:32:01 2001 PST | Thu Feb 29 17:32:01 1996 PST | @ 1768 days - | Mon Jan 01 17:32:01 2001 PST | Fri Mar 01 17:32:01 1996 PST | @ 1767 days - | Mon Jan 01 17:32:01 2001 PST | Mon Dec 30 17:32:01 1996 PST | @ 1463 days - | Mon Jan 01 17:32:01 2001 PST | Tue Dec 31 17:32:01 1996 PST | @ 1462 days - | Mon Jan 01 17:32:01 2001 PST | Fri Dec 31 17:32:01 1999 PST | @ 367 days - | Mon Jan 01 17:32:01 2001 PST | Sat Jan 01 17:32:01 2000 PST | @ 366 days - | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 02:14:05 2000 PST | @ 292 days 15 hours 17 mins 56 secs - | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 03:14:04 2000 PST | @ 292 days 14 hours 17 mins 57 secs - | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 08:14:01 2000 PST | @ 292 days 9 hours 18 mins - | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 12:14:03 2000 PST | @ 292 days 5 hours 17 mins 58 secs - | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 13:14:02 2000 PST | @ 292 days 4 hours 17 mins 59 secs - | Mon Jan 01 17:32:01 2001 PST | Sun Dec 31 17:32:01 2000 PST | @ 1 day - | Mon Jan 01 17:32:01 2001 PST | Mon Jan 01 17:32:01 2001 PST | @ 0 - | Mon Jan 01 17:32:01 2001 PST | Sat Sep 22 18:19:20 2001 PDT | @ 263 days 23 hours 47 mins 19 secs ago - | Sat Sep 22 18:19:20 2001 PDT | Thu Jan 01 00:00:00 1970 PST | @ 11587 days 17 hours 19 mins 20 secs - | Sat Sep 22 18:19:20 2001 PDT | Wed Feb 28 17:32:01 1996 PST | @ 2032 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Thu Feb 29 17:32:01 1996 PST | @ 2031 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Fri Mar 01 17:32:01 1996 PST | @ 2030 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Mon Dec 30 17:32:01 1996 PST | @ 1726 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Tue Dec 31 17:32:01 1996 PST | @ 1725 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Fri Dec 31 17:32:01 1999 PST | @ 630 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Sat Jan 01 17:32:01 2000 PST | @ 629 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 02:14:05 2000 PST | @ 556 days 15 hours 5 mins 15 secs - | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 03:14:04 2000 PST | @ 556 days 14 hours 5 mins 16 secs - | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 08:14:01 2000 PST | @ 556 days 9 hours 5 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 12:14:03 2000 PST | @ 556 days 5 hours 5 mins 17 secs - | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 13:14:02 2000 PST | @ 556 days 4 hours 5 mins 18 secs - | Sat Sep 22 18:19:20 2001 PDT | Sun Dec 31 17:32:01 2000 PST | @ 264 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Mon Jan 01 17:32:01 2001 PST | @ 263 days 23 hours 47 mins 19 secs - | Sat Sep 22 18:19:20 2001 PDT | Sat Sep 22 18:19:20 2001 PDT | @ 0 -(256 rows) - +ERROR: failed to JIT: evalexpr.4.0 -- -- abstime, reltime arithmetic -- @@ -2053,20 +1242,7 @@ FROM ABSTIME_TBL, RELTIME_TBL WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1) < abstime 'Jan 14 14:00:00 1971' ORDER BY abstime, reltime; - ten | abstime | reltime ------+------------------------------+--------------- - | Sat May 10 23:59:12 1947 PST | @ 14 secs ago - | Sat May 10 23:59:12 1947 PST | @ 1 min - | Sat May 10 23:59:12 1947 PST | @ 5 hours - | Sat May 10 23:59:12 1947 PST | @ 10 days - | Sat May 10 23:59:12 1947 PST | @ 3 mons - | Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago - | Wed Dec 31 16:00:00 1969 PST | @ 1 min - | Wed Dec 31 16:00:00 1969 PST | @ 5 hours - | Wed Dec 31 16:00:00 1969 PST | @ 10 days - | Wed Dec 31 16:00:00 1969 PST | @ 3 mons -(10 rows) - +ERROR: failed to JIT: evalexpr.5.3 -- these four queries should return the same answer -- the "infinity" and "-infinity" tuples in ABSTIME_TBL cannot be added and -- therefore, should not show up in the results. ====================================================================== --- src/test/regress/expected/create_index.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/create_index.out 2018-03-03 09:18:25.000000000 -0500 @@ -1999,27 +1999,13 @@ (1 row) SELECT * FROM array_op_test WHERE i = '{NULL}' ORDER BY seqno; - seqno | i | t --------+--------+-------- - 102 | {NULL} | {NULL} -(1 row) - +ERROR: failed to JIT: evalexpr.0.0 SELECT * FROM array_op_test WHERE i @> '{NULL}' ORDER BY seqno; - seqno | i | t --------+---+--- -(0 rows) - +ERROR: failed to JIT: evalexpr.1.0 SELECT * FROM array_op_test WHERE i && '{NULL}' ORDER BY seqno; - seqno | i | t --------+---+--- -(0 rows) - +ERROR: failed to JIT: evalexpr.2.0 SELECT * FROM array_op_test WHERE i <@ '{NULL}' ORDER BY seqno; - seqno | i | t --------+----+---- - 101 | {} | {} -(1 row) - +ERROR: failed to JIT: evalexpr.3.0 CREATE INDEX textarrayidx ON array_index_op_test USING gin (t); explain (costs off) SELECT * FROM array_index_op_test WHERE t @> '{AAAAAAAA72908}' ORDER BY seqno; @@ -2290,17 +2276,9 @@ (1 row) SELECT * FROM array_op_test WHERE i = '{NULL}' ORDER BY seqno; - seqno | i | t --------+--------+-------- - 102 | {NULL} | {NULL} -(1 row) - +ERROR: failed to JIT: evalexpr.4.0 SELECT * FROM array_op_test WHERE i <@ '{NULL}' ORDER BY seqno; - seqno | i | t --------+----+---- - 101 | {} | {} -(1 row) - +ERROR: failed to JIT: evalexpr.5.0 RESET enable_seqscan; RESET enable_indexscan; RESET enable_bitmapscan; ====================================================================== --- src/test/regress/expected/inherit.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/inherit.out 2018-03-03 09:18:27.000000000 -0500 @@ -1424,16 +1424,7 @@ (13 rows) select * from matest0 order by 1-id; - id | name -----+-------- - 6 | Test 6 - 5 | Test 5 - 4 | Test 4 - 3 | Test 3 - 2 | Test 2 - 1 | Test 1 -(6 rows) - +ERROR: failed to JIT: evalexpr.1.2 explain (verbose, costs off) select min(1-id) from matest0; QUERY PLAN -------------------------------------------------------------------------- @@ -1650,13 +1641,7 @@ ) f(i) ORDER BY f.i LIMIT 10) FROM generate_series(1, 3) g(i); - array ------------------------------- - {1,5,6,8,11,11,14,16,17,20} - {2,6,7,9,12,12,15,17,18,21} - {3,7,8,10,13,13,16,18,19,22} -(3 rows) - +ERROR: failed to JIT: evalexpr.3.11 reset enable_seqscan; reset enable_indexscan; reset enable_bitmapscan; ====================================================================== --- src/test/regress/expected/select.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/select.out 2018-03-03 09:18:29.000000000 -0500 @@ -926,24 +926,12 @@ (4 rows) select sillysrf(-1) order by 1; - sillysrf ----------- - -1 - 1 - 2 - 10 -(4 rows) - +ERROR: failed to JIT: evalexpr.0.0 drop function sillysrf(int); -- X = X isn't a no-op, it's effectively X IS NOT NULL assuming = is strict -- (see bug #5084) select * from (values (2),(null),(1)) v(k) where k = k order by k; - k ---- - 1 - 2 -(2 rows) - +ERROR: failed to JIT: evalexpr.1.0 select * from (values (2),(null),(1)) v(k) where k = k; k --- ====================================================================== --- src/test/regress/expected/join.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/join.out 2018-03-03 09:18:32.000000000 -0500 @@ -659,901 +659,7 @@ SELECT '' AS "xxx", * FROM J1_TBL CROSS JOIN J2_TBL a CROSS JOIN J2_TBL b; - xxx | i | j | t | i | k | i | k ------+---+---+-------+---+----+---+---- - | 1 | 4 | one | 1 | -1 | 1 | -1 - | 1 | 4 | one | 1 | -1 | 2 | 2 - | 1 | 4 | one | 1 | -1 | 3 | -3 - | 1 | 4 | one | 1 | -1 | 2 | 4 - | 1 | 4 | one | 1 | -1 | 5 | -5 - | 1 | 4 | one | 1 | -1 | 5 | -5 - | 1 | 4 | one | 1 | -1 | 0 | - | 1 | 4 | one | 1 | -1 | | - | 1 | 4 | one | 1 | -1 | | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | 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 - | | 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 - | 1 | 4 | one | 2 | 2 | 1 | -1 - | 1 | 4 | one | 2 | 2 | 2 | 2 - | 1 | 4 | one | 2 | 2 | 3 | -3 - | 1 | 4 | one | 2 | 2 | 2 | 4 - | 1 | 4 | one | 2 | 2 | 5 | -5 - | 1 | 4 | one | 2 | 2 | 5 | -5 - | 1 | 4 | one | 2 | 2 | 0 | - | 1 | 4 | one | 2 | 2 | | - | 1 | 4 | one | 2 | 2 | | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | 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 - | | 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 - | 1 | 4 | one | 3 | -3 | 1 | -1 - | 1 | 4 | one | 3 | -3 | 2 | 2 - | 1 | 4 | one | 3 | -3 | 3 | -3 - | 1 | 4 | one | 3 | -3 | 2 | 4 - | 1 | 4 | one | 3 | -3 | 5 | -5 - | 1 | 4 | one | 3 | -3 | 5 | -5 - | 1 | 4 | one | 3 | -3 | 0 | - | 1 | 4 | one | 3 | -3 | | - | 1 | 4 | one | 3 | -3 | | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | 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 - | | 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 - | 1 | 4 | one | 2 | 4 | 1 | -1 - | 1 | 4 | one | 2 | 4 | 2 | 2 - | 1 | 4 | one | 2 | 4 | 3 | -3 - | 1 | 4 | one | 2 | 4 | 2 | 4 - | 1 | 4 | one | 2 | 4 | 5 | -5 - | 1 | 4 | one | 2 | 4 | 5 | -5 - | 1 | 4 | one | 2 | 4 | 0 | - | 1 | 4 | one | 2 | 4 | | - | 1 | 4 | one | 2 | 4 | | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | 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 - | | 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 - | 1 | 4 | one | 5 | -5 | 1 | -1 - | 1 | 4 | one | 5 | -5 | 2 | 2 - | 1 | 4 | one | 5 | -5 | 3 | -3 - | 1 | 4 | one | 5 | -5 | 2 | 4 - | 1 | 4 | one | 5 | -5 | 5 | -5 - | 1 | 4 | one | 5 | -5 | 5 | -5 - | 1 | 4 | one | 5 | -5 | 0 | - | 1 | 4 | one | 5 | -5 | | - | 1 | 4 | one | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | 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 - | | 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 - | 1 | 4 | one | 5 | -5 | 1 | -1 - | 1 | 4 | one | 5 | -5 | 2 | 2 - | 1 | 4 | one | 5 | -5 | 3 | -3 - | 1 | 4 | one | 5 | -5 | 2 | 4 - | 1 | 4 | one | 5 | -5 | 5 | -5 - | 1 | 4 | one | 5 | -5 | 5 | -5 - | 1 | 4 | one | 5 | -5 | 0 | - | 1 | 4 | one | 5 | -5 | | - | 1 | 4 | one | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | 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 - | | 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 - | 1 | 4 | one | 0 | | 1 | -1 - | 1 | 4 | one | 0 | | 2 | 2 - | 1 | 4 | one | 0 | | 3 | -3 - | 1 | 4 | one | 0 | | 2 | 4 - | 1 | 4 | one | 0 | | 5 | -5 - | 1 | 4 | one | 0 | | 5 | -5 - | 1 | 4 | one | 0 | | 0 | - | 1 | 4 | one | 0 | | | - | 1 | 4 | one | 0 | | | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 - | 1 | 4 | one | | | 1 | -1 - | 1 | 4 | one | | | 2 | 2 - | 1 | 4 | one | | | 3 | -3 - | 1 | 4 | one | | | 2 | 4 - | 1 | 4 | one | | | 5 | -5 - | 1 | 4 | one | | | 5 | -5 - | 1 | 4 | one | | | 0 | - | 1 | 4 | one | | | | - | 1 | 4 | one | | | | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | 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 - | | | null | | | 1 | -1 - | | | null | | | 2 | 2 - | | | null | | | 3 | -3 - | | | null | | | 2 | 4 - | | | null | | | 5 | -5 - | | | null | | | 5 | -5 - | | | null | | | 0 | - | | | null | | | | - | | | null | | | | 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 - | 1 | 4 | one | | 0 | 1 | -1 - | 1 | 4 | one | | 0 | 2 | 2 - | 1 | 4 | one | | 0 | 3 | -3 - | 1 | 4 | one | | 0 | 2 | 4 - | 1 | 4 | one | | 0 | 5 | -5 - | 1 | 4 | one | | 0 | 5 | -5 - | 1 | 4 | one | | 0 | 0 | - | 1 | 4 | one | | 0 | | - | 1 | 4 | one | | 0 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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 | | 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) - +ERROR: failed to JIT: evalexpr.0.0 -- -- -- Inner joins (equi-joins) @@ -2402,12 +1508,14 @@ (3 rows) DELETE FROM t3 USING t1 JOIN t2 USING (a) WHERE t3.x > t1.a; +ERROR: failed to JIT: evalexpr.1.0 SELECT * FROM t3; - x | y ----+--- - 6 | 7 - 7 | 8 -(2 rows) + x | y +-----+----- + 6 | 7 + 7 | 8 + 500 | 100 +(3 rows) DELETE FROM t3 USING t3 t3_other WHERE t3.x = t3_other.x AND t3.y = t3_other.y; SELECT * FROM t3; @@ -4498,11 +3606,7 @@ -- lateral with function in FROM select count(*) from tenk1 a, lateral generate_series(1,two) g; - count -------- - 5000 -(1 row) - +ERROR: failed to JIT: evalexpr.2.0 explain (costs off) select count(*) from tenk1 a, lateral generate_series(1,two) g; QUERY PLAN @@ -6480,11 +5584,8 @@ select count(*) from foo left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; - count -------- - 3 -(1 row) - +ERROR: failed to JIT: evalexpr.0.0 +CONTEXT: parallel worker select final > 1 as multibatch from hash_join_batches( $$ @@ -6492,11 +5593,7 @@ left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; $$); - multibatch ------------- - t -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- single-batch with rescan, parallel-oblivious savepoint settings; @@ -6531,11 +5628,8 @@ select count(*) from foo left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; - count -------- - 3 -(1 row) - +ERROR: failed to JIT: evalexpr.0.0 +CONTEXT: parallel worker select final > 1 as multibatch from hash_join_batches( $$ @@ -6543,11 +5637,7 @@ left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; $$); - multibatch ------------- - f -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- multi-batch with rescan, parallel-aware savepoint settings; @@ -6582,11 +5672,8 @@ select count(*) from foo left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; - count -------- - 3 -(1 row) - +ERROR: failed to JIT: evalexpr.0.2 +CONTEXT: parallel worker select final > 1 as multibatch from hash_join_batches( $$ @@ -6594,11 +5681,7 @@ left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; $$); - multibatch ------------- - t -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- single-batch with rescan, parallel-aware savepoint settings; @@ -6633,11 +5716,8 @@ select count(*) from foo left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; - count -------- - 3 -(1 row) - +ERROR: failed to JIT: evalexpr.0.0 +CONTEXT: parallel worker select final > 1 as multibatch from hash_join_batches( $$ @@ -6645,11 +5725,7 @@ left join (select b1.id, b1.t from bar b1 join bar b2 using (id)) ss on foo.id < ss.id + 1 and foo.id > ss.id - 1; $$); - multibatch ------------- - f -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block rollback to settings; -- A full outer join where every record is matched. -- non-parallel ====================================================================== --- src/test/regress/expected/collate.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/collate.out 2018-03-03 09:18:36.000000000 -0500 @@ -599,7 +599,10 @@ ERROR: insert or update on table "collate_test22" violates foreign key constraint "collate_test22_f2_fkey" DETAIL: Key (f2)=(baz) is not present in table "collate_test20". DELETE FROM collate_test22 WHERE f2 = 'baz'; +ERROR: failed to JIT: evalexpr.0.1 ALTER TABLE collate_test22 ADD FOREIGN KEY (f2) REFERENCES collate_test20; +ERROR: insert or update on table "collate_test22" violates foreign key constraint "collate_test22_f2_fkey" +DETAIL: Key (f2)=(baz) is not present in table "collate_test20". RESET enable_seqscan; RESET enable_hashjoin; RESET enable_nestloop; ====================================================================== --- src/test/regress/expected/groupingsets.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/groupingsets.out 2018-03-03 09:18:37.000000000 -0500 @@ -305,11 +305,7 @@ -- empty input with joins tests some important code paths select t1.a, t2.b, sum(t1.v), count(*) from gstest_empty t1, gstest_empty t2 group by grouping sets ((t1.a,t2.b),()); - a | b | sum | count ----+---+-----+------- - | | | 0 -(1 row) - +ERROR: failed to JIT: evalexpr.0.5 -- simple joins, var resolution, GROUPING on join vars select t1.a, t2.b, grouping(t1.a, t2.b), sum(t1.v), max(t2.a) from gstest1 t1, gstest2 t2 ====================================================================== --- src/test/regress/expected/misc.out 2018-03-03 09:18:14.000000000 -0500 +++ src/test/regress/results/misc.out 2018-03-03 09:18:38.000000000 -0500 @@ -508,72 +508,24 @@ -- everyone else is fine. -- SELECT p.name, name(p.hobbies), name(equipment(p.hobbies)) FROM ONLY person p; - name | name | name --------+-------------+--------------- - mike | posthacking | advil - mike | posthacking | peet's coffee - joe | basketball | hightops - sally | basketball | hightops -(4 rows) - +ERROR: failed to JIT: evalexpr.0.0 -- -- as above, but jeff needs advil and peet's coffee as well. -- SELECT p.name, name(p.hobbies), name(equipment(p.hobbies)) FROM person* p; - name | name | name --------+-------------+--------------- - mike | posthacking | advil - mike | posthacking | peet's coffee - joe | basketball | hightops - sally | basketball | hightops - jeff | posthacking | advil - jeff | posthacking | peet's coffee -(6 rows) - +ERROR: failed to JIT: evalexpr.1.0 -- -- just like the last two, but make sure that the target list fixup and -- unflattening is being done correctly. -- SELECT name(equipment(p.hobbies)), p.name, name(p.hobbies) FROM ONLY person p; - name | name | name ----------------+-------+------------- - advil | mike | posthacking - peet's coffee | mike | posthacking - hightops | joe | basketball - hightops | sally | basketball -(4 rows) - +ERROR: failed to JIT: evalexpr.2.0 SELECT (p.hobbies).equipment.name, p.name, name(p.hobbies) FROM person* p; - name | name | name ----------------+-------+------------- - advil | mike | posthacking - peet's coffee | mike | posthacking - hightops | joe | basketball - hightops | sally | basketball - advil | jeff | posthacking - peet's coffee | jeff | posthacking -(6 rows) - +ERROR: failed to JIT: evalexpr.3.0 SELECT (p.hobbies).equipment.name, name(p.hobbies), p.name FROM ONLY person p; - name | name | name ----------------+-------------+------- - advil | posthacking | mike - peet's coffee | posthacking | mike - hightops | basketball | joe - hightops | basketball | sally -(4 rows) - +ERROR: failed to JIT: evalexpr.4.0 SELECT name(equipment(p.hobbies)), name(p.hobbies), p.name FROM person* p; - name | name | name ----------------+-------------+------- - advil | posthacking | mike - peet's coffee | posthacking | mike - hightops | basketball | joe - hightops | basketball | sally - advil | posthacking | jeff - peet's coffee | posthacking | jeff -(6 rows) - +ERROR: failed to JIT: evalexpr.5.0 SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))); name ------ ====================================================================== --- src/test/regress/expected/tsrf.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/tsrf.out 2018-03-03 09:18:39.000000000 -0500 @@ -100,48 +100,12 @@ -- but SRFs can be referenced in sort SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; - id | g -----+--- - 1 | 3 - 1 | 2 - 1 | 1 - 2 | 3 - 2 | 2 - 2 | 1 - 3 | 3 - 3 | 2 - 3 | 1 -(9 rows) - +ERROR: failed to JIT: evalexpr.0.0 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, generate_series(1,3) DESC; - id | g -----+--- - 1 | 3 - 1 | 2 - 1 | 1 - 2 | 3 - 2 | 2 - 2 | 1 - 3 | 3 - 3 | 2 - 3 | 1 -(9 rows) - +ERROR: failed to JIT: evalexpr.1.0 -- it's weird to have ORDER BYs that increase the number of results SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; - id ----- - 1 - 1 - 1 - 2 - 2 - 2 - 3 - 3 - 3 -(9 rows) - +ERROR: failed to JIT: evalexpr.2.0 -- SRFs are computed after aggregation SET enable_hashagg TO 0; -- stable output order SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GROUP BY few.dataa; @@ -176,11 +140,7 @@ (1 row) SELECT dataa, generate_series(1,1), count(*) FROM few GROUP BY 1, 2 HAVING count(*) > 1; - dataa | generate_series | count --------+-----------------+------- - a | 1 | 2 -(1 row) - +ERROR: failed to JIT: evalexpr.3.0 -- it's weird to have GROUP BYs that increase the number of results SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; dataa | count @@ -334,92 +294,11 @@ (16 rows) SELECT dataa, datab b, generate_series(1,2) g, count(*) FROM few GROUP BY CUBE(dataa, datab, g); - dataa | b | g | count --------+-----+---+------- - a | bar | 1 | 1 - a | bar | 2 | 1 - a | bar | | 2 - a | foo | 1 | 1 - a | foo | 2 | 1 - a | foo | | 2 - a | | | 4 - b | bar | 1 | 1 - b | bar | 2 | 1 - b | bar | | 2 - b | | | 2 - | | | 6 - | bar | 1 | 2 - | bar | 2 | 2 - | bar | | 4 - | foo | 1 | 1 - | foo | 2 | 1 - | foo | | 2 - a | | 1 | 2 - b | | 1 | 1 - | | 1 | 3 - a | | 2 | 2 - b | | 2 | 1 - | | 2 | 3 -(24 rows) - +ERROR: failed to JIT: evalexpr.4.0 SELECT dataa, datab b, generate_series(1,2) g, count(*) FROM few GROUP BY CUBE(dataa, datab, g) ORDER BY dataa; - dataa | b | g | count --------+-----+---+------- - a | foo | | 2 - a | | | 4 - a | | 2 | 2 - a | bar | 1 | 1 - a | bar | 2 | 1 - a | bar | | 2 - a | foo | 1 | 1 - a | foo | 2 | 1 - a | | 1 | 2 - b | bar | 1 | 1 - b | | | 2 - b | | 1 | 1 - b | bar | 2 | 1 - b | bar | | 2 - b | | 2 | 1 - | | 2 | 3 - | | | 6 - | bar | 1 | 2 - | bar | 2 | 2 - | bar | | 4 - | foo | 1 | 1 - | foo | 2 | 1 - | foo | | 2 - | | 1 | 3 -(24 rows) - +ERROR: failed to JIT: evalexpr.5.0 SELECT dataa, datab b, generate_series(1,2) g, count(*) FROM few GROUP BY CUBE(dataa, datab, g) ORDER BY g; - dataa | b | g | count --------+-----+---+------- - a | bar | 1 | 1 - a | foo | 1 | 1 - b | bar | 1 | 1 - | bar | 1 | 2 - | foo | 1 | 1 - a | | 1 | 2 - b | | 1 | 1 - | | 1 | 3 - a | | 2 | 2 - b | | 2 | 1 - | bar | 2 | 2 - | | 2 | 3 - | foo | 2 | 1 - a | bar | 2 | 1 - a | foo | 2 | 1 - b | bar | 2 | 1 - a | | | 4 - b | bar | | 2 - b | | | 2 - | | | 6 - a | foo | | 2 - a | bar | | 2 - | bar | | 4 - | foo | | 2 -(24 rows) - +ERROR: failed to JIT: evalexpr.6.0 reset enable_hashagg; -- data modification CREATE TABLE fewmore AS SELECT generate_series(1,3) AS data; ====================================================================== --- src/test/regress/expected/select_parallel.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/select_parallel.out 2018-03-03 09:18:42.000000000 -0500 @@ -462,43 +462,28 @@ (10 rows) select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0; - count -------- - 98000 -(1 row) - +ERROR: failed to JIT: evalexpr.1.0 create table bmscantest (a int, t text); +ERROR: current transaction is aborted, commands ignored until end of transaction block insert into bmscantest select r, 'fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo' FROM generate_series(1,100000) r; +ERROR: current transaction is aborted, commands ignored until end of transaction block create index i_bmtest ON bmscantest(a); +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from bmscantest where a>1; - count -------- - 99999 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test accumulation of stats for parallel nodes reset enable_seqscan; +ERROR: current transaction is aborted, commands ignored until end of transaction block alter table tenk2 set (parallel_workers = 0); +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (analyze, timing off, summary off, costs off) select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0; - QUERY PLAN --------------------------------------------------------------------------- - Aggregate (actual rows=1 loops=1) - -> Nested Loop (actual rows=98000 loops=1) - -> Seq Scan on tenk2 (actual rows=10 loops=1) - Filter: (thousand = 0) - Rows Removed by Filter: 9990 - -> Gather (actual rows=9800 loops=10) - Workers Planned: 4 - Workers Launched: 4 - -> Parallel Seq Scan on tenk1 (actual rows=1960 loops=50) - Filter: (hundred > 1) - Rows Removed by Filter: 40 -(11 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block alter table tenk2 reset (parallel_workers); +ERROR: current transaction is aborted, commands ignored until end of transaction block reset work_mem; +ERROR: current transaction is aborted, commands ignored until end of transaction block create function explain_parallel_sort_stats() returns setof text language plpgsql as $$ @@ -515,99 +500,45 @@ end loop; end; $$; +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from explain_parallel_sort_stats(); - explain_parallel_sort_stats --------------------------------------------------------------------------- - Nested Loop Left Join (actual rows=30000 loops=1) - -> Values Scan on "*VALUES*" (actual rows=3 loops=1) - -> Gather Merge (actual rows=10000 loops=3) - Workers Planned: 4 - Workers Launched: 4 - -> Sort (actual rows=2000 loops=15) - Sort Key: tenk1.ten - Sort Method: quicksort Memory: xxx - Worker 0: Sort Method: quicksort Memory: xxx - Worker 1: Sort Method: quicksort Memory: xxx - Worker 2: Sort Method: quicksort Memory: xxx - Worker 3: Sort Method: quicksort Memory: xxx - -> Parallel Seq Scan on tenk1 (actual rows=2000 loops=15) - Filter: (ten < 100) -(14 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_indexscan; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_hashjoin; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_mergejoin; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_material; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset effective_io_concurrency; +ERROR: current transaction is aborted, commands ignored until end of transaction block drop table bmscantest; +ERROR: current transaction is aborted, commands ignored until end of transaction block drop function explain_parallel_sort_stats(); +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test parallel merge join path. set enable_hashjoin to off; +ERROR: current transaction is aborted, commands ignored until end of transaction block set enable_nestloop to off; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select count(*) from tenk1, tenk2 where tenk1.unique1 = tenk2.unique1; - QUERY PLAN -------------------------------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Merge Join - Merge Cond: (tenk1.unique1 = tenk2.unique1) - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 - -> Index Only Scan using tenk2_unique1 on tenk2 -(8 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1, tenk2 where tenk1.unique1 = tenk2.unique1; - count -------- - 10000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_hashjoin; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_nestloop; +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test gather merge set enable_hashagg = false; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select count(*) from tenk1 group by twenty; - QUERY PLAN ----------------------------------------------------- - Finalize GroupAggregate - Group Key: twenty - -> Gather Merge - Workers Planned: 4 - -> Partial GroupAggregate - Group Key: twenty - -> Sort - Sort Key: twenty - -> Parallel Seq Scan on tenk1 -(9 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 group by twenty; - count -------- - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 -(20 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block --test expressions in targetlist are pushed down for gather merge create or replace function simple_func(var1 integer) returns integer as $$ @@ -615,217 +546,83 @@ return var1 + 10; end; $$ language plpgsql PARALLEL SAFE; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off, verbose) select ten, simple_func(ten) from tenk1 where ten < 100 order by ten; - QUERY PLAN ------------------------------------------------------ - Gather Merge - Output: ten, (simple_func(ten)) - Workers Planned: 4 - -> Result - Output: ten, simple_func(ten) - -> Sort - Output: ten - Sort Key: tenk1.ten - -> Parallel Seq Scan on public.tenk1 - Output: ten - Filter: (tenk1.ten < 100) -(11 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block drop function simple_func(integer); +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test gather merge with parallel leader participation disabled set parallel_leader_participation = off; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select count(*) from tenk1 group by twenty; - QUERY PLAN ----------------------------------------------------- - Finalize GroupAggregate - Group Key: twenty - -> Gather Merge - Workers Planned: 4 - -> Partial GroupAggregate - Group Key: twenty - -> Sort - Sort Key: twenty - -> Parallel Seq Scan on tenk1 -(9 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1 group by twenty; - count -------- - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 - 500 -(20 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block reset parallel_leader_participation; +ERROR: current transaction is aborted, commands ignored until end of transaction block --test rescan behavior of gather merge set enable_material = false; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select * from (select string4, count(unique2) from tenk1 group by string4 order by string4) ss right join (values (1),(2),(3)) v(x) on true; - QUERY PLAN ----------------------------------------------------------- - Nested Loop Left Join - -> Values Scan on "*VALUES*" - -> Finalize GroupAggregate - Group Key: tenk1.string4 - -> Gather Merge - Workers Planned: 4 - -> Partial GroupAggregate - Group Key: tenk1.string4 - -> Sort - Sort Key: tenk1.string4 - -> Parallel Seq Scan on tenk1 -(11 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select * from (select string4, count(unique2) from tenk1 group by string4 order by string4) ss right join (values (1),(2),(3)) v(x) on true; - string4 | count | x ----------+-------+--- - AAAAxx | 2500 | 1 - HHHHxx | 2500 | 1 - OOOOxx | 2500 | 1 - VVVVxx | 2500 | 1 - AAAAxx | 2500 | 2 - HHHHxx | 2500 | 2 - OOOOxx | 2500 | 2 - VVVVxx | 2500 | 2 - AAAAxx | 2500 | 3 - HHHHxx | 2500 | 3 - OOOOxx | 2500 | 3 - VVVVxx | 2500 | 3 -(12 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_material; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset enable_hashagg; +ERROR: current transaction is aborted, commands ignored until end of transaction block -- check parallelized int8 aggregate (bug #14897) explain (costs off) select avg(unique1::int8) from tenk1; - QUERY PLAN -------------------------------------------------------------------------- - Finalize Aggregate - -> Gather - Workers Planned: 4 - -> Partial Aggregate - -> Parallel Index Only Scan using tenk1_unique1 on tenk1 -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select avg(unique1::int8) from tenk1; - avg ------------------------ - 4999.5000000000000000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- gather merge test with a LIMIT explain (costs off) select fivethous from tenk1 order by fivethous limit 4; - QUERY PLAN ----------------------------------------------- - Limit - -> Gather Merge - Workers Planned: 4 - -> Sort - Sort Key: fivethous - -> Parallel Seq Scan on tenk1 -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select fivethous from tenk1 order by fivethous limit 4; - fivethous ------------ - 0 - 0 - 1 - 1 -(4 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- gather merge test with 0 worker set max_parallel_workers = 0; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select string4 from tenk1 order by string4 limit 5; - QUERY PLAN ----------------------------------------------- - Limit - -> Gather Merge - Workers Planned: 4 - -> Sort - Sort Key: string4 - -> Parallel Seq Scan on tenk1 -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select string4 from tenk1 order by string4 limit 5; - string4 ---------- - AAAAxx - AAAAxx - AAAAxx - AAAAxx - AAAAxx -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block -- gather merge test with 0 workers, with parallel leader -- participation disabled (the leader will have to run the plan -- despite the setting) set parallel_leader_participation = off; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select string4 from tenk1 order by string4 limit 5; - QUERY PLAN ----------------------------------------------- - Limit - -> Gather Merge - Workers Planned: 4 - -> Sort - Sort Key: string4 - -> Parallel Seq Scan on tenk1 -(6 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block select string4 from tenk1 order by string4 limit 5; - string4 ---------- - AAAAxx - AAAAxx - AAAAxx - AAAAxx - AAAAxx -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block reset parallel_leader_participation; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset max_parallel_workers; +ERROR: current transaction is aborted, commands ignored until end of transaction block SAVEPOINT settings; +ERROR: current transaction is aborted, commands ignored until end of transaction block SET LOCAL force_parallel_mode = 1; +ERROR: current transaction is aborted, commands ignored until end of transaction block explain (costs off) select stringu1::int2 from tenk1 where unique1 = 1; - QUERY PLAN ------------------------------------------------ - Gather - Workers Planned: 1 - Single Copy: true - -> Index Scan using tenk1_unique1 on tenk1 - Index Cond: (unique1 = 1) -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK TO SAVEPOINT settings; +ERROR: no such savepoint -- exercise record typmod remapping between backends CREATE OR REPLACE FUNCTION make_record(n int) RETURNS RECORD LANGUAGE plpgsql PARALLEL SAFE AS @@ -840,54 +637,52 @@ END; END; $$; +ERROR: current transaction is aborted, commands ignored until end of transaction block SAVEPOINT settings; +ERROR: current transaction is aborted, commands ignored until end of transaction block SET LOCAL force_parallel_mode = 1; +ERROR: current transaction is aborted, commands ignored until end of transaction block SELECT make_record(x) FROM (SELECT generate_series(1, 5) x) ss ORDER BY x; - make_record -------------- - (1) - (1,2) - (1,2,3) - (1,2,3,4) - (1,2,3,4,5) -(5 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK TO SAVEPOINT settings; +ERROR: no such savepoint DROP function make_record(n int); +ERROR: current transaction is aborted, commands ignored until end of transaction block -- test the sanity of parallel query after the active role is dropped. drop role if exists regress_parallel_worker; -NOTICE: role "regress_parallel_worker" does not exist, skipping +ERROR: current transaction is aborted, commands ignored until end of transaction block create role regress_parallel_worker; +ERROR: current transaction is aborted, commands ignored until end of transaction block set role regress_parallel_worker; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset session authorization; +ERROR: current transaction is aborted, commands ignored until end of transaction block drop role regress_parallel_worker; +ERROR: current transaction is aborted, commands ignored until end of transaction block set force_parallel_mode = 1; +ERROR: current transaction is aborted, commands ignored until end of transaction block select count(*) from tenk1; - count -------- - 10000 -(1 row) - +ERROR: current transaction is aborted, commands ignored until end of transaction block reset force_parallel_mode; +ERROR: current transaction is aborted, commands ignored until end of transaction block reset role; +ERROR: current transaction is aborted, commands ignored until end of transaction block -- to increase the parallel query test coverage SAVEPOINT settings; +ERROR: current transaction is aborted, commands ignored until end of transaction block SET LOCAL force_parallel_mode = 1; +ERROR: current transaction is aborted, commands ignored until end of transaction block EXPLAIN (analyze, timing off, summary off, costs off) SELECT * FROM tenk1; - QUERY PLAN -------------------------------------------------------------- - Gather (actual rows=10000 loops=1) - Workers Planned: 4 - Workers Launched: 4 - -> Parallel Seq Scan on tenk1 (actual rows=2000 loops=5) -(4 rows) - +ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK TO SAVEPOINT settings; +ERROR: no such savepoint -- provoke error in worker SAVEPOINT settings; +ERROR: current transaction is aborted, commands ignored until end of transaction block SET LOCAL force_parallel_mode = 1; +ERROR: current transaction is aborted, commands ignored until end of transaction block select stringu1::int2 from tenk1 where unique1 = 1; -ERROR: invalid input syntax for integer: "BAAAAA" -CONTEXT: parallel worker +ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK TO SAVEPOINT settings; +ERROR: no such savepoint rollback; ====================================================================== --- src/test/regress/expected/tsearch.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/tsearch.out 2018-03-03 09:18:44.000000000 -0500 @@ -171,11 +171,7 @@ (1 row) SELECT count(*) FROM test_tsvector WHERE a @@ any ('{wr,qh}'); - count -------- - 158 -(1 row) - +ERROR: failed to JIT: evalexpr.0.0 SELECT count(*) FROM test_tsvector WHERE a @@ 'no_such_lexeme'; count ------- ====================================================================== --- src/test/regress/expected/rangefuncs.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/rangefuncs.out 2018-03-03 09:18:50.000000000 -0500 @@ -1139,23 +1139,7 @@ (1 row) SELECT * FROM generate_series(1,2) r1, generate_series(r1,3) r2, ROWS FROM( foo_sql(10+r1,13), foo_mat(10+r2,13) ); - r1 | r2 | i | s | i | s -----+----+----+----+----+--- - 1 | 1 | 11 | 1 | 11 | 1 - 1 | 1 | 12 | 2 | 12 | 2 - 1 | 1 | 13 | 3 | 13 | 3 - 1 | 2 | 11 | 4 | 12 | 4 - 1 | 2 | 12 | 5 | 13 | 5 - 1 | 2 | 13 | 6 | | - 1 | 3 | 11 | 7 | 13 | 6 - 1 | 3 | 12 | 8 | | - 1 | 3 | 13 | 9 | | - 2 | 2 | 12 | 10 | 12 | 7 - 2 | 2 | 13 | 11 | 13 | 8 - 2 | 3 | 12 | 12 | 13 | 9 - 2 | 3 | 13 | 13 | | -(13 rows) - +ERROR: failed to JIT: evalexpr.0.0 SELECT * FROM (VALUES (1),(2),(3)) v(r), generate_series(10+r,20-r) f(i); r | i ---+---- ====================================================================== --- src/test/regress/expected/with.out 2018-03-02 18:38:36.000000000 -0500 +++ src/test/regress/results/with.out 2018-03-03 09:18:52.000000000 -0500 @@ -428,42 +428,7 @@ select * from x) ) select * from q limit 32; - id | parent_department | name -----+-------------------+------ - 0 | | ROOT - 1 | 0 | A - 2 | 1 | B - 3 | 2 | C - 4 | 2 | D - 5 | 0 | E - 6 | 4 | F - 7 | 5 | G - 0 | | ROOT - 1 | 0 | A - 2 | 1 | B - 3 | 2 | C - 4 | 2 | D - 5 | 0 | E - 6 | 4 | F - 7 | 5 | G - 0 | | ROOT - 1 | 0 | A - 2 | 1 | B - 3 | 2 | C - 4 | 2 | D - 5 | 0 | E - 6 | 4 | F - 7 | 5 | G - 0 | | ROOT - 1 | 0 | A - 2 | 1 | B - 3 | 2 | C - 4 | 2 | D - 5 | 0 | E - 6 | 4 | F - 7 | 5 | G -(32 rows) - +ERROR: failed to JIT: evalexpr.0.0 -- recursive term has sub-UNION WITH RECURSIVE t(i,j) AS ( VALUES (1,2) ======================================================================