Changeset: ecf9c4639fb9 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ecf9c4639fb9 Modified Files: Branch: sciql Log Message:
merge diffs (40 lines): diff --git a/sql/test/sciql/Tests/teleios_potfire02.sql b/sql/test/sciql/Tests/teleios_potfire02.sql new file mode 100644 --- /dev/null +++ b/sql/test/sciql/Tests/teleios_potfire02.sql @@ -0,0 +1,35 @@ +CREATE ARRAY hrit_c039_image_array (x INTEGER DIMENSION[123], y INTEGER DIMENSION[123], v INTEGER DEFAULT 0); +CREATE ARRAY hrit_c108_image_array (x INTEGER DIMENSION[123], y INTEGER DIMENSION[123], v INTEGER DEFAULT 0); + +CREATE FUNCTION val ( + value FLOAT, slope FLOAT, voffset FLOAT, c1 FLOAT, c2 FLOAT, vc FLOAT, a FLOAT, b FLOAT +) RETURNS FLOAT BEGIN + RETURN ( c2 * vc / LOG( c1 * vc * vc * vc / ( slope * value + voffset ) + 1 ) - b ) / a; +END; + +SELECT [x], [y], + CASE + WHEN v039 > 310 AND v039 - v108 > 10 AND v039_std_dev > 4 AND v108_std_dev < 8 + THEN 2 + WHEN v039 > 310 AND v039 - v108 > 8 AND v039_std_dev > 2.5 AND v108_std_dev < 2 + THEN 1 + ELSE 0 + END AS confidence +FROM + SELECT [x], [y], + v039, SQRT( v039_sqr_mean - v039_mean * v039_mean ) AS v039_std_dev, + v108, SQRT( v108_sqr_mean - v108_mean * v108_mean ) AS v108_std_dev + FROM ( + SELECT [x], [y], + v039, AVG( v039 ) AS v039_mean, AVG( v039 * v039 ) AS v039_sqr_mean, + v108, AVG( v108 ) AS v018_mean, AVG( v108 * v108 ) AS v108_sqr_mean + FROM ( + SELECT [c039.x], [c039.y], + val( c039.v, 0.00365867, -0.186592, 0.0000119104, 1.43877, 2569.094, 0.9959, 3.471 ) AS v039, + val( c108.v, 0.205034, -10.4568, 0.0000119104, 1.43877, 930.659, 0.9983, 0.627 ) AS v108 + FROM + hrit_c039_image_array AS c039 JOIN hrit_c108_image_array AS c108 + ON c039.x = c108.x AND c039.y = c108.y + ) AS image_array + GROUP BY image_array[x-1:x+2][y-1:y+2] + ) AS tmp; _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
