Changeset: 613bca9e263b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=613bca9e263b
Modified Files:
sql/backends/monet5/iot/Tests/iot10.sql
sql/backends/monet5/iot/Tests/iot10.stable.err
sql/backends/monet5/iot/Tests/iot10.stable.out
Branch: iot
Log Message:
Approve extended test
diffs (73 lines):
diff --git a/sql/backends/monet5/iot/Tests/iot10.sql
b/sql/backends/monet5/iot/Tests/iot10.sql
--- a/sql/backends/monet5/iot/Tests/iot10.sql
+++ b/sql/backends/monet5/iot/Tests/iot10.sql
@@ -3,6 +3,8 @@ set schema iot;
set optimizer='iot_pipe';
create stream table stmp10 (t timestamp, sensor integer, val decimal(8,2)) ;
+iot.window('iot','stmp10',2);
+
create table tmp_aggregate(tmp_total decimal(8,2), tmp_count decimal(8,2));
insert into tmp_aggregate values(0.0,0.0);
@@ -14,7 +16,10 @@ begin
delete from iot.stmp10;
end;
-insert into stmp10 values('2005-09-23 12:34:26.736',1,12.34);
+insert into stmp10 values('2005-09-23 12:34:26.000',1,9.0);
+insert into stmp10 values('2005-09-23 12:34:27.000',1,11.0);
+insert into stmp10 values('2005-09-23 12:34:28.000',1,13.0);
+insert into stmp10 values('2005-09-23 12:34:28.000',1,15.0);
select * from stmp10;
call iot.query('iot','collector');
diff --git a/sql/backends/monet5/iot/Tests/iot10.stable.err
b/sql/backends/monet5/iot/Tests/iot10.stable.err
--- a/sql/backends/monet5/iot/Tests/iot10.stable.err
+++ b/sql/backends/monet5/iot/Tests/iot10.stable.err
@@ -27,6 +27,9 @@ stderr of test 'iot10` in directory 'sql
# 23:37:15 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-25798" "--port=38558"
# 23:37:15 >
+MAPI = (monetdb) /var/tmp/mtest-12072/.s.monetdb.32469
+QUERY = iot.window('iot','stmp10',2);
+
# 23:37:15 >
# 23:37:15 > "Done."
diff --git a/sql/backends/monet5/iot/Tests/iot10.stable.out
b/sql/backends/monet5/iot/Tests/iot10.stable.out
--- a/sql/backends/monet5/iot/Tests/iot10.stable.out
+++ b/sql/backends/monet5/iot/Tests/iot10.stable.out
@@ -38,20 +38,29 @@ Ready.
# tmp_count = tmp_count + (select count(*) from
iot.stmp10);
# delete from iot.stmp10;
#end;
-#insert into stmp10 values('2005-09-23 12:34:26.736',1,12.34);
+#insert into stmp10 values('2005-09-23 12:34:26.000',1,9.0);
+[ 1 ]
+#insert into stmp10 values('2005-09-23 12:34:27.000',1,11.0);
+[ 1 ]
+#insert into stmp10 values('2005-09-23 12:34:28.000',1,13.0);
+[ 1 ]
+#insert into stmp10 values('2005-09-23 12:34:28.000',1,15.0);
[ 1 ]
#select * from stmp10;
% iot.stmp10, iot.stmp10, iot.stmp10 # table_name
% t, sensor, val # name
% timestamp, int, decimal # type
% 26, 1, 10 # length
-[ 2005-09-23 12:34:26.736000, 1, 12.34 ]
+[ 2005-09-23 12:34:26.000000, 1, 9.00 ]
+[ 2005-09-23 12:34:27.000000, 1, 11.00 ]
+[ 2005-09-23 12:34:28.000000, 1, 13.00 ]
+[ 2005-09-23 12:34:28.000000, 1, 15.00 ]
#select * from tmp_aggregate;
% iot.tmp_aggregate, iot.tmp_aggregate # table_name
% tmp_total, tmp_count # name
% decimal, decimal # type
% 10, 10 # length
-[ 12.34, 1.00 ]
+[ 48.00, 4.00 ]
#select * from iot.errors();
% ., . # table_name
% table, error # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
