Changeset: f195370ca97a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f195370ca97a
Modified Files:
sql/backends/monet5/datacell/Tests/emili.sql
Branch: default
Log Message:
Avoid primary key violations
diffs (12 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
@@ -46,7 +46,7 @@ CALL datacell.receptor('datacell.observa
CREATE PROCEDURE datacell.enrich()
BEGIN
DECLARE cnt INTEGER;
- SET cnt = (SELECT count(*) FROM datacell.area A, datacell.istream I
WHERE A.location = I.location ) ;
+ SET cnt = (SELECT count(*) FROM datacell.area A, datacell.istream I
WHERE A.location = substring(I.location,0,3) ) ;
INSERT INTO datacell.sensors(ip, location, kind,value)
SELECT ip, substring(location,0,3), kind, value FROM
datacell.istream;
IF cnt = 0
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
