File: histogram-test

package info (click to toggle)
timescaledb 2.19.3%2Bdfsg-1%2Bdeb13u1
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 13,692 kB
  • sloc: ansic: 55,798; sql: 23,722; sh: 1,756; python: 1,080; perl: 105; makefile: 14
file content (72 lines) | stat: -rw-r--r-- 3,125 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
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