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
76
77
78
79
80
81
82
83
84
85
86
87
|
# name: test/sql/overflow/test_numeric_overflow.test
# description: Test handling of overflows in float/double
# group: [overflow]
statement ok
PRAGMA enable_verification
query I
SELECT 1e1000
----
inf
# overflow on cast from double to real results in an error
statement error
SELECT 1e308::REAL
----
Conversion Error
# except we can cast inf -> inf
query I
SELECT 1e1000::REAL
----
inf
# test string casts
query I
SELECT '1e1000'::DOUBLE
----
inf
query I
SELECT '1e100'::REAL
----
inf
# overflow in SUM/AVG overflow
query I
SELECT SUM(i) FROM (VALUES (1e308), (1e308)) tbl(i)
----
inf
query I
SELECT AVG(i) FROM (VALUES (1e308), (1e308)) tbl(i)
----
inf
# overflow in arithmetic as well
query I
SELECT 1e308+1e308
----
inf
query I
SELECT 1e308*2
----
inf
query I
SELECT -1e308-1e308
----
-inf
query I
SELECT 1e308/0.1
----
inf
query I
SELECT 2e38::REAL+2e38::REAL
----
inf
query I
SELECT 2e38::REAL*2
----
inf
query I
SELECT -2e38::REAL-2e38::REAL
----
-inf
query I
SELECT 2e38::REAL/0.1::REAL
----
inf
|
