Changeset: 85d704825e7e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=85d704825e7e
Modified Files:
sql/test/sciql/Tests/teleios_noa_bsm.sql
Branch: SciQL-2
Log Message:
teleios_noa_bsm.sql: save CAST(... AS DOUBLE) & FLOOR(); INTEGER arithmetics
does the same
diffs (21 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
@@ -59,7 +59,7 @@ INSERT INTO fire (
WHERE b3.x = b4.x AND b3.y = b4.y AND b3.x = b7.x AND b3.y = b7.y -- join
the images
and b3.intensity <> 0 AND b4.intensity <> 0 AND b7.intensity <> 0
AND b4.intensity <= 60 -- indexNIR
- AND FLOOR(CAST(b3.intensity+b4.intensity AS DOUBLE)/2.0) <= 50.0 --
indexALBEDO
+ AND (b3.intensity + b4.intensity) / 2 <= 50 -- indexALBEDO
AND b4.intensity + b7.intensity <> 0
AND (CAST(b4.intensity-b7.intensity AS DOUBLE)/(b4.intensity +
b7.intensity) + 1.0) * 127.5 <= 126.0 -- indexNBR, 255.0/2.0=127.5
);
@@ -74,7 +74,7 @@ INSERT INTO fire (
AND img1_b3.intensity <> 0 AND img1_b4.intensity <> 0 AND
img1_b7.intensity <> 0
AND img2_b3.intensity <> 0 AND img2_b4.intensity <> 0
AND img1_b4.intensity <= 60 -- indexNIR_img1
- AND FLOOR(CAST(img1_b3.intensity+img1_b4.intensity AS DOUBLE)/2.0) <= 50.0
-- indexALBEDO_img1
+ AND (img1_b3.intensity + img1_b4.intensity) / 2 <= 50 -- indexALBEDO_img1
AND img1_b4.intensity + img1_b7.intensity <> 0
AND (CAST(img1_b4.intensity-img1_b7.intensity AS
DOUBLE)/(img1_b4.intensity + img1_b7.intensity) + 1.0) * 127.5 <= 126.0 --
indexNBR_img1
AND img1_b4.intensity + img1_b3.intensity <> 0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list
