Changeset: 1a5c0391a473 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1a5c0391a473 Modified Files: sql/test/sciql/Tests/teleios_noa_bsm.sql Branch: sciql Log Message:
teleios_noa_bsm: we should use a conjunctive HAVING clause, here, but that yields wrong results :-( diffs (28 lines): diff --git a/sql/test/sciql/Tests/teleios_noa_bsm.sql b/sql/test/sciql/Tests/teleios_noa_bsm.sql --- a/sql/test/sciql/Tests/teleios_noa_bsm.sql +++ b/sql/test/sciql/Tests/teleios_noa_bsm.sql @@ -76,6 +76,24 @@ INSERT INTO fire_2 ( ); -- BSM majority filter +---- should be: +INSERT INTO fire_1 ( + SELECT [x], [y], 1 + FROM fire_1 + GROUP BY fire_1[x-d1:x+d2][y-d1:y+d2] + HAVING f IS NULL AND SUM(f) > majority +); + +INSERT INTO fire_2 ( + SELECT [x], [y], 1 + FROM fire_2 + GROUP BY fire_2[x-d1:x+d2][y-d1:y+d2] + HAVING f IS NULL AND SUM(f) > majority +); + +---- however, the conjunctive HAVING clause yields wrong results; +---- hence: + INSERT INTO fire_1 ( SELECT [x], [y], 1 FROM [ _______________________________________________ checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
