regression.diffs
text/plain
--- 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)
======================================================================