Changeset: eafafbcdc5f7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eafafbcdc5f7 Modified Files: sql/test/Tests/systemfunctions_nogeom.stable.out Branch: default Log Message:
Approved. diffs (62 lines): diff --git a/sql/test/Tests/systemfunctions_nogeom.stable.out b/sql/test/Tests/systemfunctions_nogeom.stable.out --- a/sql/test/Tests/systemfunctions_nogeom.stable.out +++ b/sql/test/Tests/systemfunctions_nogeom.stable.out @@ -229,6 +229,8 @@ Ready. [ "sys", "median", 1, "wrd", "" ] [ "sys", "median", 0, "bigint", "create aggregate median(val bigint) returns bigint\n\texternal name \"aggr\".\"median\";" ] [ "sys", "median", 1, "bigint", "" ] +[ "sys", "median", 0, "decimal", "create aggregate median(val decimal) returns decimal\n \texternal name \"aggr\".\"median\";" ] +[ "sys", "median", 1, "decimal", "" ] [ "sys", "median", 0, "real", "create aggregate median(val real) returns real\n\texternal name \"aggr\".\"median\";" ] [ "sys", "median", 1, "real", "" ] [ "sys", "median", 0, "double", "create aggregate median(val double) returns double\n\texternal name \"aggr\".\"median\";" ] @@ -276,6 +278,39 @@ Ready. [ "sys", "password_hash", 1, "clob", "" ] [ "sys", "pause", 0, "int", "-- operations to manipulate the state of havoc queries\ncreate procedure sys.pause(tag int)\nexternal name sql.sysmon_pause;" ] [ "sys", "pause", 0, "bigint", "create procedure sys.pause(tag bigint)\nexternal name sql.sysmon_pause;" ] +[ "sys", "quantile", 0, "tinyint", "create aggregate quantile(val tinyint, q double) returns tinyint\n \texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "tinyint", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "smallint", "create aggregate quantile(val smallint, q double) returns smallint\n \texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "smallint", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "int", "create aggregate quantile(val integer, q double) returns integer\n \texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "int", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "wrd", "create aggregate quantile(val wrd, q double) returns wrd\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "wrd", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "bigint", "create aggregate quantile(val bigint, q double) returns bigint\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "bigint", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "decimal", "create aggregate quantile(val decimal, q double) returns decimal\n \texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "decimal", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "real", "create aggregate quantile(val real, q double) returns real\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "real", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "double", "create aggregate quantile(val double, q double) returns double\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "double", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "date", "create aggregate quantile(val date, q double) returns date\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "date", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "time", "create aggregate quantile(val time, q double) returns time\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "time", "" ] +[ "sys", "quantile", 2, "double", "" ] +[ "sys", "quantile", 0, "timestamp", "create aggregate quantile(val timestamp, q double) returns timestamp\n\texternal name \"aggr\".\"quantile\";" ] +[ "sys", "quantile", 1, "timestamp", "" ] +[ "sys", "quantile", 2, "double", "" ] [ "sys", "querycache", 0, "table", "-- SQL QUERY CACHE\n-- The SQL query cache returns a table with the query plans kept\n\ncreate function sys.querycache() \n\treturns table (query string, count int) \n\texternal name sql.dump_cache;" ] [ "sys", "querylog", 0, "clob", "-- Trace the SQL input\ncreate procedure sys.querylog(filename string) \n\texternal name sql.logfile;" ] [ "sys", "querylog_calls", 0, "table", "-- Each query call is stored in the table calls\n-- At regular intervals the query history table should be cleaned.\n-- This can be done manually on the SQL console, or be integrated\n-- in the keepQuery and keepCall upon need.\n-- The parameters are geared at understanding the resource claims\n-- They reflect the effect of the total workload mix during execution.\n-- The 'cpu' gives the average cpu load percentage over all cores on the \n-- server during execution phase. \n-- increasing cpu load indicates better use of multi-cores.\n-- The 'io' indicate IOs during complete query run.\n-- The 'space' is the total amount of intermediates created in MB.\n-- Reducing the space component improves performance/\n-- All timing in usec and all storage in bytes.\n\ncreate function sys.querylog_calls()\nreturns table(\n\tid oid,\t\t\t\t -- references query plan\n\t\"start\" timestamp,\t-- time the statement was started\n\t\"stop\" timestamp,\t-- time th e statement was completely finished\n\targuments string,\t-- actual call structure\n\ttuples wrd,\t\t\t-- number of tuples in the result set\n\trun bigint,\t\t-- time spent (in usec) until the result export\n\tship bigint,\t\t-- time spent (in usec) to ship the result set\n\tcpu int, \t\t-- average cpu load percentage during execution\n\tio int,\t\t\t-- percentage time waiting for IO to finish \n\tspace bigint\t\t-- total storage size of intermediates created (in MB)\n)\nexternal name sql.querylog_calls;" ] @@ -300,6 +335,9 @@ Ready. [ "sys", "settimeout", 1, "bigint", "" ] [ "sys", "shrink", 0, "clob", "-- 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-2013 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 after the cluste r operation.\n\ncreate procedure shrink(sys string, tab string)\n\texternal name sql.shrink;" ] [ "sys", "shrink", 1, "clob", "" ] +[ "sys", "shutdown", 0, "tinyint", "create procedure sys.shutdown(delay tinyint) \nexternal name sql.shutdown;" ] +[ "sys", "shutdown", 0, "tinyint", "create procedure sys.shutdown(delay tinyint, force bool) \nexternal name sql.shutdown;" ] +[ "sys", "shutdown", 1, "boolean", "" ] [ "sys", "stddev_pop", 0, "double", "create aggregate stddev_pop(val tinyint) returns double\n\texternal name \"aggr\".\"stdevp\";" ] [ "sys", "stddev_pop", 1, "tinyint", "" ] [ "sys", "stddev_pop", 0, "double", "create aggregate stddev_pop(val smallint) returns double\n\texternal name \"aggr\".\"stdevp\";" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
