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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
|
-- ----------------------------------------------------------------
-- Regression tests for equality operator with v1 output.
-- ----------------------------------------------------------------
SELECT hll_set_output_version(1);
hll_set_output_version
------------------------
1
(1 row)
-- Undefined sets: t
SELECT E'\\x108b7f'::hll = E'\\x108b7f'::hll;
?column?
----------
t
(1 row)
-- Undefined, different metadata: f
SELECT E'\\x108b7f'::hll = E'\\x108b49'::hll;
?column?
----------
f
(1 row)
-- Equal empty sets: t
SELECT hll_empty(11,5,256,1) = hll_empty(11,5,256,1);
?column?
----------
t
(1 row)
-- Different metadata: f
SELECT hll_empty(11,5,256,1) = hll_empty(11,5,256,0);
?column?
----------
f
(1 row)
-- Different metadata: f
SELECT hll_empty(11,5,256,1) = hll_empty(11,5,128,1);
?column?
----------
f
(1 row)
-- Different metadata: f
SELECT hll_empty(11,5,256,1) = hll_empty(11,4,256,1);
?column?
----------
f
(1 row)
-- Different metadata: f
SELECT hll_empty(11,5,256,1) = hll_empty(10,5,256,1);
?column?
----------
f
(1 row)
-- Same explicit: t
SELECT E'\\x128b7f8895a3f5af28cafe'::hll = E'\\x128b7f8895a3f5af28cafe'::hll;
?column?
----------
t
(1 row)
-- Different explicit: f
SELECT E'\\x128b7f8895a3f5af28cafe'::hll = E'\\x128b7fda0ce907e4355b60'::hll;
?column?
----------
f
(1 row)
-- Different explicit lengths: f
SELECT E'\\x128b7f8895a3f5af28cafe'::hll = E'\\x128b7f8895a3f5af28cafeda0ce907e4355b60'::hll;
?column?
----------
f
(1 row)
-- Same sparse: t
SELECT E'\\x138b7f0001'::hll = E'\\x138b7f0001'::hll;
?column?
----------
t
(1 row)
-- Different sparse: f
SELECT E'\\x138b7f0001'::hll = E'\\x138b7f0022'::hll;
?column?
----------
f
(1 row)
-- Different sparse lengths: f
SELECT E'\\x138b7f0001'::hll = E'\\x138b7f00410061'::hll;
?column?
----------
f
(1 row)
-- Same compressed: t
SELECT hll_add(hll_empty(11,5,0,0), hll_hash_integer(1,0)) =
E'\\x148b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::hll;
?column?
----------
t
(1 row)
-- Different compressed: f
SELECT hll_add(hll_empty(11,5,0,0), hll_hash_integer(2,0)) =
E'\\x148b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'::hll;
?column?
----------
f
(1 row)
-- Different types: f
SELECT E'\\x108b7f'::hll = hll_empty(11,5,256,1);
?column?
----------
f
(1 row)
SELECT E'\\x108b7f'::hll = E'\\x128b7f8895a3f5af28cafe'::hll;
?column?
----------
f
(1 row)
SELECT E'\\x108b7f'::hll = E'\\x138b7f0041'::hll;
?column?
----------
f
(1 row)
SELECT E'\\x108b7f'::hll = hll_add(hll_empty(11,5,0,0), hll_hash_integer(1,0));
?column?
----------
f
(1 row)
SELECT hll_empty(11,5,256,1) = E'\\x128b408895a3f5af28cafe'::hll;
?column?
----------
f
(1 row)
SELECT hll_empty(11,5,256,1) = E'\\x138b7f0001'::hll;
?column?
----------
f
(1 row)
SELECT hll_empty(11,5,256,1) =
hll_add(hll_empty(11,5,0,0), hll_hash_integer(1,0));
?column?
----------
f
(1 row)
SELECT E'\\x128b7f8895a3f5af28cafe'::hll = E'\\x138b7f0022'::hll;
?column?
----------
f
(1 row)
SELECT E'\\x128b7f8895a3f5af28cafe'::hll =
hll_add(hll_empty(11,5,0,0), hll_hash_integer(1,0));
?column?
----------
f
(1 row)
SELECT E'\\x138c40afe180'::hll =
hll_add(hll_empty(11,5,0,0), hll_hash_integer(1,0));
?column?
----------
f
(1 row)
|
