File: histogram-test

package info (click to toggle)
timescaledb 2.23.1%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 13,448 kB
  • sloc: ansic: 57,664; sql: 24,413; sh: 1,717; python: 1,246; perl: 78; makefile: 14
file content (75 lines) | stat: -rw-r--r-- 3,167 bytes parent folder | download
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
73
74
75
Remove test that unexpectedly does not fail on arm64

Patch only required for PG15.

   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-15.out
+++ b/test/expected/histogram_test-15.out
@@ -110,8 +110,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/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-16.out
+++ b/test/expected/histogram_test-16.out
@@ -110,11 +110,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}
-
-\set ON_ERROR_STOP 1
--- a/test/expected/histogram_test-17.out
+++ b/test/expected/histogram_test-17.out
@@ -110,11 +110,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}
-
-\set ON_ERROR_STOP 1
--- a/test/expected/histogram_test-18.out
+++ b/test/expected/histogram_test-18.out
@@ -110,11 +110,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}
-
-\set ON_ERROR_STOP 1