Changeset: 8f1dd6529b33 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8f1dd6529b33 Modified Files: sql/src/test/sciql/Tests/sciql01.sql sql/src/test/sciql/Tests/sciql03.sql sql/src/test/sciql/Tests/sciql06.sql Branch: sciql Log Message:
Modifications for sciql Minor additions for future testing. diffs (34 lines): diff -r c3bce7e7ea37 -r 8f1dd6529b33 sql/src/test/sciql/Tests/sciql01.sql --- a/sql/src/test/sciql/Tests/sciql01.sql Fri Jan 14 14:46:02 2011 +0100 +++ b/sql/src/test/sciql/Tests/sciql01.sql Fri Jan 14 14:47:37 2011 +0100 @@ -1,4 +1,9 @@ CREATE ARRAY matrix ( x integer DIMENSION[4], y integer DIMENSION[4], val float DEFAULT 0.0 ); CREATE ARRAY grid( x integer DIMENSION[4] CHECK(mod(x,2) = 0), y integer DIMENSION[4], val float DEFAULT 0.0); CREATE ARRAY diagonal( x integer DIMENSION[4], y integer DIMENSION[4] CHECK(x = y), val float ); -CREATE ARRAY sparse( x integer DIMENSION[4], y integer DIMENSION[4], val float DEFAULT 0.0 CHECK(val>0)); +CREATE ARRAY sparse( x integer DIMENSION[4], y integer DIMENSION[4], val float DEFAULT 0.0 CHECK(val>=0.0)); + + +CREATE ARRAY stripes( x integer DIMENSION[4], y integer DIMENSION[4], val float DEFAULT 0.0 ); +CREATE ARRAY stripes2( x integer DIMENSION, y integer DIMENSION, val float DEFAULT 0.0 ); +CREATE ARRAY stripes3( x integer DIMENSION[4], y integer DIMENSION, val float DEFAULT 0.0 ); diff -r c3bce7e7ea37 -r 8f1dd6529b33 sql/src/test/sciql/Tests/sciql03.sql --- a/sql/src/test/sciql/Tests/sciql03.sql Fri Jan 14 14:46:02 2011 +0100 +++ b/sql/src/test/sciql/Tests/sciql03.sql Fri Jan 14 14:47:37 2011 +0100 @@ -1,4 +1,6 @@ UPDATE stripes SET val = x + y; +UPDATE stripes SET x = x+1; -- what does it mean + -- consider stripes with free dimensions too UPDATE grid SET val = CASE WHEN x > y THEN x + y WHEN X<y THEN x - y ELSE 0 END; UPDATE diagonal SET val = x +y; UPDATE sparse SET val = mod(rand(),16); diff -r c3bce7e7ea37 -r 8f1dd6529b33 sql/src/test/sciql/Tests/sciql06.sql --- a/sql/src/test/sciql/Tests/sciql06.sql Fri Jan 14 14:46:02 2011 +0100 +++ b/sql/src/test/sciql/Tests/sciql06.sql Fri Jan 14 14:47:37 2011 +0100 @@ -1,5 +1,6 @@ SELECT ARRAY (1,2,3,4); SELECT ARRAY((1,2),(3,4)); SELECT x, y, val FROM matrix WHERE val >2; +SELECT x, y, val FROM stripes WHERE val >2; SELECT [x], [y], val FROM matrix WHERE val >2; SELECT [T.k], [y], val FROM matrix JOIN T ON matrix.x = T.i; _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
