Changeset: 37f0455f4b9b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=37f0455f4b9b
Modified Files:
sql/backends/monet5/datacell/Tests/emili.sql
Branch: default
Log Message:
add time constraint
diffs (13 lines):
diff --git a/sql/backends/monet5/datacell/Tests/emili.sql
b/sql/backends/monet5/datacell/Tests/emili.sql
--- a/sql/backends/monet5/datacell/Tests/emili.sql
+++ b/sql/backends/monet5/datacell/Tests/emili.sql
@@ -91,7 +91,8 @@ BEGIN
INSERT into datacell.states
SELECT S.location, H.time, 'confirmed'
FROM datacell.area A, datacell.states S, datacell.area B,
datacell.hotsensors2 H
- WHERE S.status ='unconfirmed' AND A.ip <> H.ip AND B.ip = H.ip AND A.ip
<> B.ip AND S.location = A.location;
+ WHERE S.status ='unconfirmed' AND A.ip <> H.ip AND B.ip = H.ip AND A.ip
<> B.ip AND S.location = A.location
+ AND (H.time - S.time) > '3' as minutes;
END;
CALL datacell.query('datacell.firespotted');
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
