Changeset: 00a2d1d1215b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=00a2d1d1215b Modified Files: sql/test/Tests/systemfunctions.stable.out Branch: sciql Log Message:
systemfunctions: approved new output after changeset 2de73dc7cea2 diffs (213 lines): diff --git a/sql/test/Tests/systemfunctions.stable.out b/sql/test/Tests/systemfunctions.stable.out --- a/sql/test/Tests/systemfunctions.stable.out +++ b/sql/test/Tests/systemfunctions.stable.out @@ -67,7 +67,7 @@ Ready. [ "sys", "alpha", 2, "double", "" ] [ "sys", "area", 0, "double", "-- ogc Spatial Analysis methods\n\ncreate function area(g geometry) returns float external name geom.\"Area\";" ] [ "sys", "area", 1, "geometry", "" ] -[ "sys", "array_avg", 0, "double", "--create function array_avg(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns table (a double) external name \"array\".avg;\n--create function array_avg(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns table (a real) external name \"array\".avg;\n--create function array_avg(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns table (a double) external name \"array\".avg;\n\n--create function array_sum(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns table (s bigint) external name \"array\".sum;\n--create function array_sum(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns table (s double) external name \"array\".sum;\n--create function array_sum(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns table (s double) external name \"array\".sum;\n\ncreate function array_avg(val tinyint, dim1 int, offsets1 int, size1 int) returns double external name \"array\".avg;" ] +[ "sys", "array_avg", 0, "double", "create function array_avg(val tinyint, dim1 int, offsets1 int, size1 int) returns double external name \"array\".avg;" ] [ "sys", "array_avg", 1, "tinyint", "" ] [ "sys", "array_avg", 2, "int", "" ] [ "sys", "array_avg", 3, "int", "" ] @@ -211,43 +211,187 @@ Ready. [ "sys", "array_avg", 8, "int", "" ] [ "sys", "array_avg", 9, "int", "" ] [ "sys", "array_avg", 10, "int", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val tinyint) returns table (id bigint, cellval tinyint) external name \"array\".filler_;" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val tinyint, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "tinyint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val smallint, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "smallint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val int, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "int", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val bigint, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "bigint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val real, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "real", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val double, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "double", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val tinyint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "tinyint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val smallint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "smallint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "int", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val bigint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "bigint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "real", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "double", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val tinyint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "tinyint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 8, "int", "" ] +[ "sys", "array_count", 9, "int", "" ] +[ "sys", "array_count", 10, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val smallint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "smallint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 8, "int", "" ] +[ "sys", "array_count", 9, "int", "" ] +[ "sys", "array_count", 10, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "int", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 8, "int", "" ] +[ "sys", "array_count", 9, "int", "" ] +[ "sys", "array_count", 10, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val bigint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "bigint", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 8, "int", "" ] +[ "sys", "array_count", 9, "int", "" ] +[ "sys", "array_count", 10, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "real", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 8, "int", "" ] +[ "sys", "array_count", 9, "int", "" ] +[ "sys", "array_count", 10, "int", "" ] +[ "sys", "array_count", 0, "bigint", "create function array_count(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns bigint external name \"array\".cnt;" ] +[ "sys", "array_count", 1, "double", "" ] +[ "sys", "array_count", 2, "int", "" ] +[ "sys", "array_count", 3, "int", "" ] +[ "sys", "array_count", 4, "int", "" ] +[ "sys", "array_count", 5, "int", "" ] +[ "sys", "array_count", 6, "int", "" ] +[ "sys", "array_count", 7, "int", "" ] +[ "sys", "array_count", 8, "int", "" ] +[ "sys", "array_count", 9, "int", "" ] +[ "sys", "array_count", 10, "int", "" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val tinyint) returns table (id bigint, cellval tinyint) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "tinyint", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val smallint) returns table (id bigint, cellval smallint) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val smallint) returns table (id bigint, cellval smallint) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "smallint", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val integer) returns table (id bigint, cellval integer) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val integer) returns table (id bigint, cellval integer) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "int", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val bigint) returns table (id bigint, cellval bigint) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val bigint) returns table (id bigint, cellval bigint) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "bigint", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val real) returns table (id bigint, cellval real) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val real) returns table (id bigint, cellval real) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "real", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val double) returns table (id bigint, cellval double) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val double) returns table (id bigint, cellval double) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "double", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val date) returns table (id bigint, vals date) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val date) returns table (id bigint, vals date) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "date", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val time) returns table (id bigint, vals time) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val time) returns table (id bigint, vals time) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "time", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val timestamp) returns table (id bigint, vals timestamp) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val timestamp) returns table (id bigint, vals timestamp) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "timestamp", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val char(2048)) returns table (id bigint, vals char(2048)) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val char(2048)) returns table (id bigint, vals char(2048)) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "char", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val varchar(2048)) returns table (id bigint, vals varchar(2048)) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val varchar(2048)) returns table (id bigint, vals varchar(2048)) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "varchar", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val blob) returns table (id bigint, vals blob) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val blob) returns table (id bigint, vals blob) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "blob", "" ] -[ "sys", "array_filler", 0, "table", "create function array_filler(cnt bigint, val clob) returns table (id bigint, vals clob) external name \"array\".filler_;" ] +[ "sys", "array_filler", 0, "table", "create function array_filler(count bigint, val clob) returns table (id bigint, vals clob) external name \"array\".filler_;" ] [ "sys", "array_filler", 1, "bigint", "" ] [ "sys", "array_filler", 2, "clob", "" ] [ "sys", "array_max", 0, "tinyint", "create function array_max(val tinyint, dim1 int, offsets1 int, size1 int) returns tinyint external name \"array\".max;" ] _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
