1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
|
Remove test that unexpectedly does not fail on arm64
SELECT histogram(temperature, -1.79769e+308, 1.79769e+308,10) FROM weather GROUP BY city;
-ERROR: index -2147483648 from "width_bucket" out of range
+ histogram
+---------------------------
+ {8,0,0,0,0,0,0,0,0,0,0,0}
+(1 row)
--- a/test/expected/histogram_test-14.out
+++ b/test/expected/histogram_test-14.out
@@ -120,8 +120,3 @@ INSERT INTO weather VALUES
('2023-02-10 08:58:59.999999+00','city1',10.3),
('2023-03-23 06:12:02.73765+00 ','city1', 9.7),
('2023-03-23 06:12:06.990998+00','city1',11.7);
--- This will currently generate an error on PG15 and prior versions
-\set ON_ERROR_STOP 0
-SELECT histogram(temperature, -1.79769e+308, 1.79769e+308,10) FROM weather GROUP BY city;
-ERROR: index -2147483648 from "width_bucket" out of range
-\set ON_ERROR_STOP 1
--- a/test/expected/histogram_test-15.out
+++ b/test/expected/histogram_test-15.out
@@ -120,8 +120,3 @@ INSERT INTO weather VALUES
('2023-02-10 08:58:59.999999+00','city1',10.3),
('2023-03-23 06:12:02.73765+00 ','city1', 9.7),
('2023-03-23 06:12:06.990998+00','city1',11.7);
--- This will currently generate an error on PG15 and prior versions
-\set ON_ERROR_STOP 0
-SELECT histogram(temperature, -1.79769e+308, 1.79769e+308,10) FROM weather GROUP BY city;
-ERROR: index -2147483648 from "width_bucket" out of range
-\set ON_ERROR_STOP 1
--- a/test/expected/histogram_test-16.out
+++ b/test/expected/histogram_test-16.out
@@ -120,12 +120,3 @@ INSERT INTO weather VALUES
('2023-02-10 08:58:59.999999+00','city1',10.3),
('2023-03-23 06:12:02.73765+00 ','city1', 9.7),
('2023-03-23 06:12:06.990998+00','city1',11.7);
--- This will currently generate an error on PG15 and prior versions
-\set ON_ERROR_STOP 0
-SELECT histogram(temperature, -1.79769e+308, 1.79769e+308,10) FROM weather GROUP BY city;
- histogram
----------------------------
- {0,0,0,0,0,0,8,0,0,0,0,0}
-(1 row)
-
-\set ON_ERROR_STOP 1
--- a/test/sql/histogram_test.sql.in
+++ b/test/sql/histogram_test.sql.in
@@ -71,8 +71,3 @@ INSERT INTO weather VALUES
('2023-02-10 08:58:59.999999+00','city1',10.3),
('2023-03-23 06:12:02.73765+00 ','city1', 9.7),
('2023-03-23 06:12:06.990998+00','city1',11.7);
-
--- This will currently generate an error on PG15 and prior versions
-\set ON_ERROR_STOP 0
-SELECT histogram(temperature, -1.79769e+308, 1.79769e+308,10) FROM weather GROUP BY city;
-\set ON_ERROR_STOP 1
--- a/test/expected/histogram_test-17.out
+++ b/test/expected/histogram_test-17.out
@@ -120,12 +120,3 @@ INSERT INTO weather VALUES
('2023-02-10 08:58:59.999999+00','city1',10.3),
('2023-03-23 06:12:02.73765+00 ','city1', 9.7),
('2023-03-23 06:12:06.990998+00','city1',11.7);
--- This will currently generate an error on PG15 and prior versions
-\set ON_ERROR_STOP 0
-SELECT histogram(temperature, -1.79769e+308, 1.79769e+308,10) FROM weather GROUP BY city;
- histogram
----------------------------
- {0,0,0,0,0,0,8,0,0,0,0,0}
-(1 row)
-
-\set ON_ERROR_STOP 1
|