| /dports/databases/timescaledb/timescaledb-2.5.1/tsl/test/sql/ |
| H A D | continuous_aggs_query.sql.in | 102 select * from mat_m1 where timec > '2018-10-01' order by timec desc;
108 select * from mat_m2 where timec > '2018-10-01' order by timec desc;
124 …ect * from mat_m1, mat_m2 where mat_m1.timec > '2018-10-01' and mat_m1.timec = mat_m2.timec order …
127 …ct * from mat_m1, regview where mat_m1.timec > '2018-10-01' and mat_m1.timec = regview.timec order…
137 select * from mat_m1 where timec > '2018-10-01' order by timec desc;
170 where timec > '2018-10-01' order by timec desc;
173 select location, time_bucket('1day', timec) as timec, first(humidity, timec) firsth, last(humidity,…
176 where timec > '2018-10-01' order by timec desc limit 10;
237 AND m1.timec = m2.timec)
284 AND m1.timec = m2.timec)
[all …]
|
| H A D | continuous_aggs_errors.sql | 12 timec TIMESTAMPTZ NOT NULL, field
87 Select time_bucket('1week', timec),
94 Select time_bucket('1week', timec),
125 group by time_bucket('1week', timec) , time_bucket('1month', timec), location WITH NO DATA;
303 group by time_bucket('1week', timec)
320 SELECT time_bucket('1 week', timec)
322 GROUP BY time_bucket('1 week', timec);
342 timec TIMESTAMPTZ NOT NULL, field
380 timec SMALLINT NOT NULL, field
408 ALTER TABLE conditions ALTER timec type int;
[all …]
|
| H A D | continuous_aggs.sql | 139 select timec, minl, sumt, sumh
141 order by timec;
145 group by time_bucket('1day', timec)
203 select timec, minl, sumth, stddevh
205 order by timec;
251 select timec, minl, sumth, stddevh
254 order by timec;
445 order by timec, minl;
849 select time_bucket(100, timec), aggregate_to_test_ffunc_extra(timec, 1, 3, 'test'::text)
851 group by time_bucket(100, timec);
[all …]
|
| H A D | continuous_aggs_permissions.sql | 36 timec INT NOT NULL, field
46 …ger_now_test1() returns int LANGUAGE SQL STABLE as $$ SELECT coalesce(max(timec), 0) FROM conditio…
55 group by time_bucket(100, timec), location WITH NO DATA;
78 timec INT NOT NULL, field
88 …ger_now_test2() returns int LANGUAGE SQL STABLE as $$ SELECT coalesce(max(timec), 0) FROM conditio…
92 timec INT NOT NULL, field
102 …ger_now_test3() returns int LANGUAGE SQL STABLE as $$ SELECT coalesce(max(timec), 0) FROM conditio…
144 group by time_bucket(100, timec), location WITH NO DATA;
152 group by time_bucket(100, timec), location WITH NO DATA;
161 group by time_bucket(100, timec), location WITH NO DATA;
[all …]
|
| H A D | compression_permissions.sql | 36 timec TIMESTAMPTZ NOT NULL, field
93 where timec = '2019-04-01 00:00+0'::timestamp with time zone;
99 select location from conditions where timec = '2019-04-01 00:00+0';
104 where timec = '2019-04-01 00:00+0'::timestamp with time zone;
105 select location from conditions where timec = '2019-04-01 00:00+0';
112 where timec = '2019-04-01 00:00+0'::timestamp with time zone;
113 select location from conditions where timec = '2019-04-01 00:00+0';
131 timec TIMESTAMPTZ NOT NULL, field
|
| H A D | transparent_decompression_ordered_index.sql.in | 151 timec timestamp with time zone NOT NULL, field
161 SELECT create_hypertable('entity_m2', 'timec', chunk_time_interval=>'30 days'::interval);
170 timescaledb.compress_orderby = 'type, timec');
176 timec timestamp with time zone , field
185 SELECT create_hypertable('entity_m1', 'timec', chunk_time_interval=>'30 days'::interval);
191 SELECT m2.timec,
201 SELECT m1.timec,
214 SELECT m.timec, avg(m.utilization) AS avg_util
217 …AND m.timec BETWEEN '2020-12-21T00:00:00'::timestamptz - interval '7 day' AND date_trunc('day', '2…
224 timescaledb.compress_orderby = 'type, timec');
[all …]
|
| H A D | continuous_aggs_dump.sql | 8 timec TIMESTAMPTZ NOT NULL, field
35 SELECT time_bucket('1week', timec) as bucket,
68 last(temperature, timec) as last_temp,
69 last(highlow, timec) as last_hl,
70 first(highlow, timec) as first_hl,
|
| H A D | compression_insert.sql.in | 6 CREATE TABLE test1 (timec timestamptz , i integer , field
13 timescaledb.compress_orderby = 'timec DESC');
55 -- insert nulls except for timec
156 CREATE TABLE test2 (timec timestamptz , field
167 timescaledb.compress_orderby = 'timec DESC');
175 COPY test2(timec,i,t) FROM STDIN DELIMITER ',';
211 CREATE TABLE vessels (timec timestamptz , field
223 timescaledb.compress_orderby = 'timec DESC');
235 SELECT timec, id, b from vessels order by 2, 1;
556 timec TIMESTAMPTZ NOT NULL, field
[all …]
|
| H A D | compression_errors.sql | 153 timec integer , field
157 primary key ( device_id, timec)
162 alter table table_constr add constraint table_constr_uk unique (location, timec, device_id);
167 alter table table_constr add constraint table_constr_exclu exclude using btree (timec with = );
222 timec integer , field
225 primary key ( device_id, timec)
|
| /dports/databases/timescaledb/timescaledb-2.5.1/tsl/test/expected/ |
| H A D | continuous_aggs_query-13.out | 63 select location, time_bucket('1day', timec), first(humidity, timec), last(humidity, timec), max(tem…
276 select * from mat_m1 where timec > '2018-10-01' order by timec desc;
364 select * from mat_m2 where timec > '2018-10-01' order by timec desc;
404 select * from (select * from mat_m2 where timec > '2018-10-01' order by timec desc ) as q limit 1;
490 Select * from mat_m2 where timec > '2018-10-01' order by timec desc )
532 …ect * from mat_m1, mat_m2 where mat_m1.timec > '2018-10-01' and mat_m1.timec = mat_m2.timec order …
540 Hash Cond: (_materialized_hypertable_3.timec = _materialized_hypertable_2.timec)
610 …ct * from mat_m1, regview where mat_m1.timec > '2018-10-01' and mat_m1.timec = regview.timec order…
781 AND m1.timec = m2.timec)
876 AND m1.timec = m2.timec)
[all …]
|
| H A D | continuous_aggs_query-14.out | 63 select location, time_bucket('1day', timec), first(humidity, timec), last(humidity, timec), max(tem…
276 select * from mat_m1 where timec > '2018-10-01' order by timec desc;
364 select * from mat_m2 where timec > '2018-10-01' order by timec desc;
404 select * from (select * from mat_m2 where timec > '2018-10-01' order by timec desc ) as q limit 1;
490 Select * from mat_m2 where timec > '2018-10-01' order by timec desc )
532 …ect * from mat_m1, mat_m2 where mat_m1.timec > '2018-10-01' and mat_m1.timec = mat_m2.timec order …
540 Hash Cond: (_materialized_hypertable_3.timec = _materialized_hypertable_2.timec)
610 …ct * from mat_m1, regview where mat_m1.timec > '2018-10-01' and mat_m1.timec = regview.timec order…
781 AND m1.timec = m2.timec)
876 AND m1.timec = m2.timec)
[all …]
|
| H A D | continuous_aggs_query-12.out | 63 select location, time_bucket('1day', timec), first(humidity, timec), last(humidity, timec), max(tem…
276 select * from mat_m1 where timec > '2018-10-01' order by timec desc;
362 select * from mat_m2 where timec > '2018-10-01' order by timec desc;
401 select * from (select * from mat_m2 where timec > '2018-10-01' order by timec desc ) as q limit 1;
485 Select * from mat_m2 where timec > '2018-10-01' order by timec desc )
526 …ect * from mat_m1, mat_m2 where mat_m1.timec > '2018-10-01' and mat_m1.timec = mat_m2.timec order …
534 Hash Cond: (_materialized_hypertable_3.timec = _materialized_hypertable_2.timec)
603 …ct * from mat_m1, regview where mat_m1.timec > '2018-10-01' and mat_m1.timec = regview.timec order…
773 AND m1.timec = m2.timec)
868 AND m1.timec = m2.timec)
[all …]
|
| H A D | dist_partial_agg.out | 172 GROUP BY :GROUPING, timec
173 ORDER BY :GROUPING, timec;
205 GROUP BY :GROUPING, timec
206 ORDER BY :GROUPING, timec;
212 …tion, last(conditions.highlow, conditions.timec), first(conditions.highlow, conditions.timec), con…
251 GROUP BY :GROUPING, timec
287 GROUP BY :GROUPING, timec
318 GROUP BY :GROUPING, timec
324 Output: location, timec
391 GROUP BY :GROUPING, timec
[all …]
|
| H A D | continuous_aggs.out | 163 select timec, minl, sumt, sumh
165 order by timec;
176 group by time_bucket('1day', timec)
238 select timec, minl, sumth, stddevh
240 order by timec;
295 select timec, minl, sumth, stddevh
298 order by timec;
519 1 | timec
540 order by timec, minl;
1144 select time_bucket(100, timec), aggregate_to_test_ffunc_extra(timec, 1, 3, 'test'::text)
[all …]
|
| H A D | continuous_aggs_errors.out | 9 timec TIMESTAMPTZ NOT NULL,
91 Select time_bucket('1week', timec),
98 Select time_bucket('1week', timec),
129 group by time_bucket('1week', timec) , time_bucket('1month', timec), location WITH NO DATA;
321 group by time_bucket('1week', timec)
341 SELECT time_bucket('1 week', timec)
343 GROUP BY time_bucket('1 week', timec);
374 timec TIMESTAMPTZ NOT NULL,
415 timec SMALLINT NOT NULL,
451 ALTER TABLE conditions ALTER timec type int;
[all …]
|
| H A D | continuous_aggs_permissions.out | 31 timec INT NOT NULL,
39 select table_name from create_hypertable( 'conditions', 'timec', chunk_time_interval=> 100);
57 group by time_bucket(100, timec), location WITH NO DATA;
78 timec INT NOT NULL,
86 select table_name from create_hypertable('conditions_for_perm_check', 'timec', chunk_time_interval=…
100 timec INT NOT NULL,
108 select table_name from create_hypertable('conditions_for_perm_check_w_grant', 'timec', chunk_time_i…
156 group by time_bucket(100, timec), location WITH NO DATA;
164 group by time_bucket(100, timec), location WITH NO DATA;
173 group by time_bucket(100, timec), location WITH NO DATA;
[all …]
|
| H A D | compression_insert-14.out | 5 CREATE TABLE test1 (timec timestamptz , i integer ,
8 NOTICE: adding not-null constraint to column "timec"
17 timescaledb.compress_orderby = 'timec DESC');
85 timec | i | b | t
123 -- insert nulls except for timec
142 timec | i | b | t
294 CREATE TABLE test2 (timec timestamptz ,
309 timescaledb.compress_orderby = 'timec DESC');
361 CREATE TABLE vessels (timec timestamptz ,
390 timec | id | b
[all …]
|
| H A D | compression_insert-13.out | 5 CREATE TABLE test1 (timec timestamptz , i integer ,
8 NOTICE: adding not-null constraint to column "timec"
17 timescaledb.compress_orderby = 'timec DESC');
85 timec | i | b | t
123 -- insert nulls except for timec
142 timec | i | b | t
294 CREATE TABLE test2 (timec timestamptz ,
309 timescaledb.compress_orderby = 'timec DESC');
361 CREATE TABLE vessels (timec timestamptz ,
390 timec | id | b
[all …]
|
| H A D | compression_insert-12.out | 5 CREATE TABLE test1 (timec timestamptz , i integer ,
8 NOTICE: adding not-null constraint to column "timec"
17 timescaledb.compress_orderby = 'timec DESC');
85 timec | i | b | t
123 -- insert nulls except for timec
142 timec | i | b | t
294 CREATE TABLE test2 (timec timestamptz ,
309 timescaledb.compress_orderby = 'timec DESC');
361 CREATE TABLE vessels (timec timestamptz ,
390 timec | id | b
[all …]
|
| H A D | compression_permissions.out | 32 timec TIMESTAMPTZ NOT NULL,
38 select table_name from create_hypertable( 'conditions', 'timec', chunk_time_interval=>'1month'::int…
112 where timec = '2019-04-01 00:00+0'::timestamp with time zone;
117 select location from conditions where timec = '2019-04-01 00:00+0';
127 where timec = '2019-04-01 00:00+0'::timestamp with time zone;
128 select location from conditions where timec = '2019-04-01 00:00+0';
140 where timec = '2019-04-01 00:00+0'::timestamp with time zone;
141 select location from conditions where timec = '2019-04-01 00:00+0';
167 timec TIMESTAMPTZ NOT NULL,
172 SELECT table_name FROM create_hypertable( 'conditions', 'timec',
[all …]
|
| H A D | continuous_aggs_dump.out | 6 timec TIMESTAMPTZ NOT NULL,
17 SELECT table_name FROM create_hypertable( 'conditions_before', 'timec');
30 SELECT table_name FROM create_hypertable( 'conditions_after', 'timec');
39 SELECT time_bucket('1week', timec) as bucket,
72 last(temperature, timec) as last_temp,
73 last(highlow, timec) as last_hl,
74 first(highlow, timec) as first_hl,
|
| /dports/databases/timescaledb/timescaledb-2.5.1/tsl/test/sql/include/ |
| H A D | aggregate_queries.sql | 43 GROUP BY :GROUPING, timec
44 ORDER BY :GROUPING, timec;
48 last(highlow, timec) as last_hl,
51 GROUP BY :GROUPING, timec
52 ORDER BY :GROUPING, timec;
68 GROUP BY :GROUPING, timec
69 ORDER BY :GROUPING, timec;
75 GROUP BY :GROUPING, timec
76 ORDER BY :GROUPING, timec;
81 GROUP BY :GROUPING, timec
[all …]
|
| H A D | recompress_basic.sql | 21 CREATE TABLE test2 (timec timestamptz NOT NULL, i integer , field
40 SELECT time_bucket(INTERVAL '2 hour', timec), b, count(*)
42 GROUP BY time_bucket(INTERVAL '2 hour', timec), b
71 SELECT time_bucket(INTERVAL '2 hour', timec), b, count(*)
73 GROUP BY time_bucket(INTERVAL '2 hour', timec), b
|
| /dports/databases/timescaledb/timescaledb-2.5.1/test/sql/updates/ |
| H A D | setup.continuous_aggs.v2.sql | 95 last(temperature, timec) as last_temp,
96 last(highlow, timec) as last_hl,
97 first(highlow, timec) as first_hl,
151 last(temperature, timec) as last_temp,
152 last(highlow, timec) as last_hl,
153 first(highlow, timec) as first_hl,
223 last(temperature, timec) as last_temp,
224 last(highlow, timec) as last_hl,
225 first(highlow, timec) as first_hl,
268 last(highlow, timec) as last_hl,
[all …]
|
| H A D | setup.continuous_aggs.sql | 8 timec TIMESTAMPTZ NOT NULL, field
38 SELECT time_bucket('1week', timec) as bucket,
71 last(temperature, timec) as last_temp,
72 last(highlow, timec) as last_hl,
73 first(highlow, timec) as first_hl,
82 SELECT time_bucket('1week', timec) as bucket,
115 last(temperature, timec) as last_temp,
116 last(highlow, timec) as last_hl,
117 first(highlow, timec) as first_hl,
|