Skip to content

Commit 27ac183

Browse files
knizhnikknizhnik
committed
Add empty mask to tile
1 parent d4256bd commit 27ac183

File tree

4 files changed

+279
-276
lines changed

4 files changed

+279
-276
lines changed

‎Makefile

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@ OBJS = vops.o
66
EXTENSION = vops
77
DATA = vops--1.0.sql
88
PGFILEDESC = "vops - vectorized operations"
9-
CUSTOM_COPT = -O0 -g
9+
CUSTOM_COPT = -O3
1010

1111
REGRESS = test
1212

‎expected/test.out

Lines changed: 7 additions & 93 deletions
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,7 @@ select countall(*) from v where x is not null;
2525
select count(*) from v where x is null;
2626
count
2727
-------
28-
60
28+
2
2929
(1 row)
3030

3131
select count(*) from v where x is not null;
@@ -61,83 +61,25 @@ select count(*),count(x),sum(x),avg(x),min(x),max(x),variance(x),var_pop(x),var_
6161
select count(*) from v where ifnull(x, 0) >= 0;
6262
count
6363
-------
64-
64
64+
6
6565
(1 row)
6666

6767
select count(*) from v where coalesce(x, 0.0::float8::vops_float4) >= 0;
6868
count
6969
-------
70-
64
70+
6
7171
(1 row)
7272

7373
select unnest(t.*) from (select mcount(*) over w,mcount(x) over w,msum(x) over w,mavg(x) over w,mmin(x) over w,mmax(x) over w,x - lag(x) over w from v window w as (rows between unbounded preceding and current row)) t;
74-
unnest
75-
--------------------
74+
unnest
75+
-------------------
7676
(1,1,1,1,1,1,)
7777
(2,2,3,1.5,1,2,1)
7878
(3,2,3,1.5,1,2,)
7979
(4,3,6,2,1,3,)
8080
(5,3,6,2,1,3,)
8181
(6,4,10,2.5,1,4,)
82-
(7,4,10,2.5,1,4,)
83-
(8,4,10,2.5,1,4,)
84-
(9,4,10,2.5,1,4,)
85-
(10,4,10,2.5,1,4,)
86-
(11,4,10,2.5,1,4,)
87-
(12,4,10,2.5,1,4,)
88-
(13,4,10,2.5,1,4,)
89-
(14,4,10,2.5,1,4,)
90-
(15,4,10,2.5,1,4,)
91-
(16,4,10,2.5,1,4,)
92-
(17,4,10,2.5,1,4,)
93-
(18,4,10,2.5,1,4,)
94-
(19,4,10,2.5,1,4,)
95-
(20,4,10,2.5,1,4,)
96-
(21,4,10,2.5,1,4,)
97-
(22,4,10,2.5,1,4,)
98-
(23,4,10,2.5,1,4,)
99-
(24,4,10,2.5,1,4,)
100-
(25,4,10,2.5,1,4,)
101-
(26,4,10,2.5,1,4,)
102-
(27,4,10,2.5,1,4,)
103-
(28,4,10,2.5,1,4,)
104-
(29,4,10,2.5,1,4,)
105-
(30,4,10,2.5,1,4,)
106-
(31,4,10,2.5,1,4,)
107-
(32,4,10,2.5,1,4,)
108-
(33,4,10,2.5,1,4,)
109-
(34,4,10,2.5,1,4,)
110-
(35,4,10,2.5,1,4,)
111-
(36,4,10,2.5,1,4,)
112-
(37,4,10,2.5,1,4,)
113-
(38,4,10,2.5,1,4,)
114-
(39,4,10,2.5,1,4,)
115-
(40,4,10,2.5,1,4,)
116-
(41,4,10,2.5,1,4,)
117-
(42,4,10,2.5,1,4,)
118-
(43,4,10,2.5,1,4,)
119-
(44,4,10,2.5,1,4,)
120-
(45,4,10,2.5,1,4,)
121-
(46,4,10,2.5,1,4,)
122-
(47,4,10,2.5,1,4,)
123-
(48,4,10,2.5,1,4,)
124-
(49,4,10,2.5,1,4,)
125-
(50,4,10,2.5,1,4,)
126-
(51,4,10,2.5,1,4,)
127-
(52,4,10,2.5,1,4,)
128-
(53,4,10,2.5,1,4,)
129-
(54,4,10,2.5,1,4,)
130-
(55,4,10,2.5,1,4,)
131-
(56,4,10,2.5,1,4,)
132-
(57,4,10,2.5,1,4,)
133-
(58,4,10,2.5,1,4,)
134-
(59,4,10,2.5,1,4,)
135-
(60,4,10,2.5,1,4,)
136-
(61,4,10,2.5,1,4,)
137-
(62,4,10,2.5,1,4,)
138-
(63,4,10,2.5,1,4,)
139-
(64,4,10,2.5,1,4,)
140-
(64 rows)
82+
(6 rows)
14183

14284

14385
create table s2(x float8, id serial);
@@ -252,35 +194,7 @@ select unnest(t.*) from (select msum(x,10) over (order by first(id)) from v2) t;
252194
(935)
253195
(945)
254196
(955)
255-
(864)
256-
(772)
257-
(679)
258-
(585)
259-
(490)
260-
(394)
261-
(297)
262-
(199)
263-
(100)
264-
(0)
265-
(0)
266-
(0)
267-
(0)
268-
(0)
269-
(0)
270-
(0)
271-
(0)
272-
(0)
273-
(0)
274-
(0)
275-
(0)
276-
(0)
277-
(0)
278-
(0)
279-
(0)
280-
(0)
281-
(0)
282-
(0)
283-
(128 rows)
197+
(100 rows)
284198

285199
select sum(x) over (order by id rows between 9 preceding and current row) from s2;
286200
sum

‎vops--1.0.sql

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -37,67 +37,67 @@ create type vops_bool (
3737
input = vops_bool_input,
3838
output = vops_bool_output,
3939
alignment = double,
40-
internallength = 16
40+
internallength = 24
4141
);
4242

4343
create type vops_char (
4444
input = vops_char_input,
4545
output = vops_char_output,
4646
alignment = double,
47-
internallength = 72 -- 8+64
47+
internallength = 80 -- 16+64
4848
);
4949

5050

5151
create type vops_int2 (
5252
input = vops_int2_input,
5353
output = vops_int2_output,
5454
alignment = double,
55-
internallength = 136 -- 8+64*2
55+
internallength = 144 -- 16+64*2
5656
);
5757

5858

5959
create type vops_int4 (
6060
input = vops_int4_input,
6161
output = vops_int4_output,
6262
alignment = double,
63-
internallength = 264 -- 8 + 64*4
63+
internallength = 272 -- 16 + 64*4
6464
);
6565

6666
create type vops_date (
6767
input = vops_date_input,
6868
output = vops_date_output,
6969
alignment = double,
70-
internallength = 264 -- 8 + 64*4
70+
internallength = 272 -- 16 + 64*4
7171
);
7272

7373

7474
create type vops_int8 (
7575
input = vops_int8_input,
7676
output = vops_int8_output,
7777
alignment = double,
78-
internallength = 520 -- 8 + 64*8
78+
internallength = 528 -- 16 + 64*8
7979
);
8080

8181

8282
create type vops_float4 (
8383
input = vops_float4_input,
8484
output = vops_float4_output,
8585
alignment = double,
86-
internallength = 264 -- 8 + 64*4
86+
internallength = 272 -- 16 + 64*4
8787
);
8888

8989
create type vops_float8 (
9090
input = vops_float8_input,
9191
output = vops_float8_output,
9292
alignment = double,
93-
internallength = 520 -- 8 + 64*8
93+
internallength = 528 -- 16 + 64*8
9494
);
9595

9696
create type vops_timestamp (
9797
input = vops_timestamp_input,
9898
output = vops_timestamp_output,
9999
alignment = double,
100-
internallength = 520 -- 8 + 64*8
100+
internallength = 528 -- 16 + 64*8
101101
);
102102

103103
-- char tile

0 commit comments

Comments
 (0)