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
88
|
# name: test/sql/function/numeric/test_fdiv_fmod.test
# description: Test floored division and modulus
# group: [numeric]
statement ok
SET ieee_floating_point_ops=false;
statement ok
CREATE TABLE rs(x DOUBLE, y INTEGER)
statement ok
INSERT INTO rs VALUES (10, 3),(10,-3),(-10,3),(-10,-3),(0,1),(1,1),(NULL,10),(10,NULL),(NULL,NULL)
query I
SELECT fmod(x, y) FROM rs
----
1
-2
2
-1
0
0
NULL
NULL
NULL
query I
SELECT fdiv(x, y) FROM rs
----
3
-4
-4
3
0
1
NULL
NULL
NULL
# fmod by 0 results in NULL: should be NaN (if supported)
query I
SELECT fmod(42, 0)
----
NULL
# fmod 0 by 0 results in NULL: should be NaN (if supported)
query I
SELECT fmod(0, 0)
----
NULL
# fdiv by 0 results in NULL: should be Inf (if supported)
query I
SELECT fdiv(42, 0)
----
NULL
# fdiv by 0 results in NULL: should be -Inf (if supported)
query I
SELECT fdiv(-42, 0)
----
NULL
# fdiv 0 by 0 results in NULL: should be NaN (if supported)
query I
SELECT fdiv(0, 0)
----
NULL
query R
SELECT fmod(12.3456789, 5)
----
2.345679
query I
SELECT fdiv(12.3456789, 5)
----
2
query R
SELECT fmod(3, 2.1)
----
0.900000
query I
SELECT fdiv(3, 2.1)
----
1
|
