Changeset: 37cb785977e0 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=37cb785977e0 Modified Files: sql/test/Tests/systemfunctions.stable.out Branch: sciql Log Message:
systemfunctions: approved stable output after changeset 8e5d8d710d5f diffs (298 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 @@ -250,6 +250,294 @@ Ready. [ "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", 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;" ] +[ "sys", "array_max", 1, "tinyint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 0, "smallint", "create function array_max(val smallint, dim1 int, offsets1 int, size1 int) returns smallint external name \"array\".max;" ] +[ "sys", "array_max", 1, "smallint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 0, "int", "create function array_max(val int, dim1 int, offsets1 int, size1 int) returns int external name \"array\".max;" ] +[ "sys", "array_max", 1, "int", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 0, "bigint", "create function array_max(val bigint, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".max;" ] +[ "sys", "array_max", 1, "bigint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 0, "real", "create function array_max(val real, dim1 int, offsets1 int, size1 int) returns real external name \"array\".max;" ] +[ "sys", "array_max", 1, "real", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 0, "double", "create function array_max(val double, dim1 int, offsets1 int, size1 int) returns double external name \"array\".max;" ] +[ "sys", "array_max", 1, "double", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 0, "tinyint", "create function array_max(val tinyint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns tinyint external name \"array\".max;" ] +[ "sys", "array_max", 1, "tinyint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 0, "smallint", "create function array_max(val smallint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns smallint external name \"array\".max;" ] +[ "sys", "array_max", 1, "smallint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 0, "int", "create function array_max(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns int external name \"array\".max;" ] +[ "sys", "array_max", 1, "int", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 0, "bigint", "create function array_max(val bigint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".max;" ] +[ "sys", "array_max", 1, "bigint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 0, "real", "create function array_max(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns real external name \"array\".max;" ] +[ "sys", "array_max", 1, "real", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 0, "double", "create function array_max(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns double external name \"array\".max;" ] +[ "sys", "array_max", 1, "double", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 0, "tinyint", "create function array_max(val tinyint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns tinyint external name \"array\".max;" ] +[ "sys", "array_max", 1, "tinyint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 8, "int", "" ] +[ "sys", "array_max", 9, "int", "" ] +[ "sys", "array_max", 10, "int", "" ] +[ "sys", "array_max", 0, "smallint", "create function array_max(val smallint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns smallint external name \"array\".max;" ] +[ "sys", "array_max", 1, "smallint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 8, "int", "" ] +[ "sys", "array_max", 9, "int", "" ] +[ "sys", "array_max", 10, "int", "" ] +[ "sys", "array_max", 0, "int", "create function array_max(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns int external name \"array\".max;" ] +[ "sys", "array_max", 1, "int", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 8, "int", "" ] +[ "sys", "array_max", 9, "int", "" ] +[ "sys", "array_max", 10, "int", "" ] +[ "sys", "array_max", 0, "bigint", "create function array_max(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\".max;" ] +[ "sys", "array_max", 1, "bigint", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 8, "int", "" ] +[ "sys", "array_max", 9, "int", "" ] +[ "sys", "array_max", 10, "int", "" ] +[ "sys", "array_max", 0, "real", "create function array_max(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns real external name \"array\".max;" ] +[ "sys", "array_max", 1, "real", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 8, "int", "" ] +[ "sys", "array_max", 9, "int", "" ] +[ "sys", "array_max", 10, "int", "" ] +[ "sys", "array_max", 0, "double", "create function array_max(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns double external name \"array\".max;" ] +[ "sys", "array_max", 1, "double", "" ] +[ "sys", "array_max", 2, "int", "" ] +[ "sys", "array_max", 3, "int", "" ] +[ "sys", "array_max", 4, "int", "" ] +[ "sys", "array_max", 5, "int", "" ] +[ "sys", "array_max", 6, "int", "" ] +[ "sys", "array_max", 7, "int", "" ] +[ "sys", "array_max", 8, "int", "" ] +[ "sys", "array_max", 9, "int", "" ] +[ "sys", "array_max", 10, "int", "" ] +[ "sys", "array_min", 0, "tinyint", "create function array_min(val tinyint, dim1 int, offsets1 int, size1 int) returns tinyint external name \"array\".min;" ] +[ "sys", "array_min", 1, "tinyint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 0, "smallint", "create function array_min(val smallint, dim1 int, offsets1 int, size1 int) returns smallint external name \"array\".min;" ] +[ "sys", "array_min", 1, "smallint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 0, "int", "create function array_min(val int, dim1 int, offsets1 int, size1 int) returns int external name \"array\".min;" ] +[ "sys", "array_min", 1, "int", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 0, "bigint", "create function array_min(val bigint, dim1 int, offsets1 int, size1 int) returns bigint external name \"array\".min;" ] +[ "sys", "array_min", 1, "bigint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 0, "real", "create function array_min(val real, dim1 int, offsets1 int, size1 int) returns real external name \"array\".min;" ] +[ "sys", "array_min", 1, "real", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 0, "double", "create function array_min(val double, dim1 int, offsets1 int, size1 int) returns double external name \"array\".min;" ] +[ "sys", "array_min", 1, "double", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 0, "tinyint", "create function array_min(val tinyint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns tinyint external name \"array\".min;" ] +[ "sys", "array_min", 1, "tinyint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 0, "smallint", "create function array_min(val smallint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns smallint external name \"array\".min;" ] +[ "sys", "array_min", 1, "smallint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 0, "int", "create function array_min(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns int external name \"array\".min;" ] +[ "sys", "array_min", 1, "int", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 0, "bigint", "create function array_min(val bigint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns bigint external name \"array\".min;" ] +[ "sys", "array_min", 1, "bigint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 0, "real", "create function array_min(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns real external name \"array\".min;" ] +[ "sys", "array_min", 1, "real", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 0, "double", "create function array_min(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int) returns double external name \"array\".min;" ] +[ "sys", "array_min", 1, "double", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 0, "tinyint", "create function array_min(val tinyint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns tinyint external name \"array\".min;" ] +[ "sys", "array_min", 1, "tinyint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 8, "int", "" ] +[ "sys", "array_min", 9, "int", "" ] +[ "sys", "array_min", 10, "int", "" ] +[ "sys", "array_min", 0, "smallint", "create function array_min(val smallint, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns smallint external name \"array\".min;" ] +[ "sys", "array_min", 1, "smallint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 8, "int", "" ] +[ "sys", "array_min", 9, "int", "" ] +[ "sys", "array_min", 10, "int", "" ] +[ "sys", "array_min", 0, "int", "create function array_min(val int, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns int external name \"array\".min;" ] +[ "sys", "array_min", 1, "int", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 8, "int", "" ] +[ "sys", "array_min", 9, "int", "" ] +[ "sys", "array_min", 10, "int", "" ] +[ "sys", "array_min", 0, "bigint", "create function array_min(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\".min;" ] +[ "sys", "array_min", 1, "bigint", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 8, "int", "" ] +[ "sys", "array_min", 9, "int", "" ] +[ "sys", "array_min", 10, "int", "" ] +[ "sys", "array_min", 0, "real", "create function array_min(val real, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns real external name \"array\".min;" ] +[ "sys", "array_min", 1, "real", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 8, "int", "" ] +[ "sys", "array_min", 9, "int", "" ] +[ "sys", "array_min", 10, "int", "" ] +[ "sys", "array_min", 0, "double", "create function array_min(val double, dim1 int, offsets1 int, size1 int, dim2 int, offsets2 int, size2 int, dim3 int, offsets3 int, size3 int) returns double external name \"array\".min;" ] +[ "sys", "array_min", 1, "double", "" ] +[ "sys", "array_min", 2, "int", "" ] +[ "sys", "array_min", 3, "int", "" ] +[ "sys", "array_min", 4, "int", "" ] +[ "sys", "array_min", 5, "int", "" ] +[ "sys", "array_min", 6, "int", "" ] +[ "sys", "array_min", 7, "int", "" ] +[ "sys", "array_min", 8, "int", "" ] +[ "sys", "array_min", 9, "int", "" ] +[ "sys", "array_min", 10, "int", "" ] [ "sys", "array_series", 0, "table", "-- The contents of this file are subject to the MonetDB Public License\n-- Version 1.1 (the \"License\"); you may not use this file except in\n-- compliance with the License. You may obtain a copy of the License at\n-- http://www.monetdb.org/Legal/MonetDBLicense\n--\n-- Software distributed under the License is distributed on an \"AS IS\"\n-- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the\n-- License for the specific language governing rights and limitations\n-- under the License.\n--\n-- The Original Code is the MonetDB Database System.\n--\n-- The Initial Developer of the Original Code is CWI.\n-- Copyright August 2008-2012 MonetDB B.V.\n-- All Rights Reserved.\n\n-- Vacuum a relational table should be done with care.\n-- For, the oid's are used in join-indices.\n\n-- Vacuum of tables may improve IO performance and disk footprint.\n-- The foreign key constraints should be dropped before\n-- and re-established a fter the cluster operation.\n\n-- TODO: DATE, TIME, TIMESTAMP, CHAR and VARCHAR not supported yet\ncreate function array_series(\"start\" tinyint, step tinyint, stop tinyint, n integer, m integer) returns table (id bigint, dimval tinyint) external name \"array\".series_;" ] [ "sys", "array_series", 1, "tinyint", "" ] [ "sys", "array_series", 2, "tinyint", "" ] _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
