Changeset: e3cf0f2ce136 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e3cf0f2ce136
Added Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
sql/test/copy/Tests/format_date.sql
sql/test/copy/Tests/format_date.stable.err
sql/test/copy/Tests/format_date.stable.out
sql/test/pg_regress/Tests/numeric_big.stable.err.int128
Modified Files:
clients/Tests/MAL-signatures_fits_geom.stable.out
clients/Tests/MAL-signatures_fits_geom.stable.out.int128
clients/Tests/MAL-signatures_geom.stable.out
clients/Tests/MAL-signatures_geom.stable.out.int128
clients/Tests/MAL-signatures_none.stable.out
clients/Tests/MAL-signatures_none.stable.out.int128
clients/Tests/SQL-dump_all.stable.out
clients/Tests/SQL-dump_all.stable.out.int128
clients/Tests/SQL-dump_all.stable.out.oid32
clients/Tests/SQL-dump_all.stable.out.oid32.int128
clients/Tests/SQL-dump_geom.stable.out
clients/Tests/SQL-dump_geom.stable.out.32bit
clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
clients/Tests/SQL-dump_geom.stable.out.int128
clients/Tests/SQL-dump_geom.stable.out.oid32.int128
clients/Tests/SQL-dump_none.stable.out
clients/Tests/SQL-dump_none.stable.out.int128
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
sql/common/sql_types.c
sql/scripts/13_date.sql
sql/server/rel_updates.c
sql/server/sql_parser.y
sql/test/copy/Tests/All
sql/test/leaks/Tests/check1_bam.stable.out.int128
sql/test/leaks/Tests/check2_bam.stable.out.int128
sql/test/leaks/Tests/check3_bam.stable.out.int128
sql/test/leaks/Tests/check4_bam.stable.out.int128
sql/test/leaks/Tests/check5_bam.stable.out.int128
sql/test/pg_regress/Tests/int8.stable.err
sql/test/pg_regress/Tests/int8.stable.out
sql/test/pg_regress/Tests/interval.sql
sql/test/pg_regress/Tests/interval.stable.err
sql/test/pg_regress/Tests/interval.stable.out
sql/test/pg_regress/Tests/numeric.sql
sql/test/pg_regress/Tests/numeric.stable.err
sql/test/pg_regress/Tests/numeric.stable.out
sql/test/pg_regress/Tests/numeric_big.stable.err
sql/test/pg_regress/Tests/oid.sql
sql/test/pg_regress/Tests/oid.stable.err
sql/test/pg_regress/Tests/oid.stable.out
sql/test/pg_regress/Tests/timestamptz.sql
sql/test/pg_regress/Tests/timestamptz.stable.err
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/pg_regress/Tests/timetz.sql
sql/test/pg_regress/Tests/timetz.stable.err
sql/test/pg_regress/Tests/timetz.stable.out
Branch: default
Log Message:
Merge with default
diffs (truncated from 14918 to 300 lines):
diff --git a/clients/Tests/MAL-signatures_fits_geom.stable.out
b/clients/Tests/MAL-signatures_fits_geom.stable.out
--- a/clients/Tests/MAL-signatures_fits_geom.stable.out
+++ b/clients/Tests/MAL-signatures_fits_geom.stable.out
@@ -2672,6 +2672,8 @@ command batgeom.point(x:bat[:oid,:dbl],y
address wkbcreatepoint_bat;
comment Construct a point-BAT from two geometry-BATs
+pattern batmal.multiplex(mod:str,fcn:str,a:any...):any...
+address MANIFOLDremapMultiplex;
command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit]
address BATPCREilike2;
command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit]
diff --git a/clients/Tests/MAL-signatures_fits_geom.stable.out.int128
b/clients/Tests/MAL-signatures_fits_geom.stable.out.int128
--- a/clients/Tests/MAL-signatures_fits_geom.stable.out.int128
+++ b/clients/Tests/MAL-signatures_fits_geom.stable.out.int128
@@ -3200,6 +3200,8 @@ command batgeom.point(x:bat[:oid,:dbl],y
address wkbcreatepoint_bat;
comment Construct a point-BAT from two geometry-BATs
+pattern batmal.multiplex(mod:str,fcn:str,a:any...):any...
+address MANIFOLDremapMultiplex;
command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit]
address BATPCREilike2;
command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit]
diff --git a/clients/Tests/MAL-signatures_geom.stable.out
b/clients/Tests/MAL-signatures_geom.stable.out
--- a/clients/Tests/MAL-signatures_geom.stable.out
+++ b/clients/Tests/MAL-signatures_geom.stable.out
@@ -2672,6 +2672,8 @@ command batgeom.point(x:bat[:oid,:dbl],y
address wkbcreatepoint_bat;
comment Construct a point-BAT from two geometry-BATs
+pattern batmal.multiplex(mod:str,fcn:str,a:any...):any...
+address MANIFOLDremapMultiplex;
command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit]
address BATPCREilike2;
command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit]
diff --git a/clients/Tests/MAL-signatures_geom.stable.out.int128
b/clients/Tests/MAL-signatures_geom.stable.out.int128
--- a/clients/Tests/MAL-signatures_geom.stable.out.int128
+++ b/clients/Tests/MAL-signatures_geom.stable.out.int128
@@ -3200,6 +3200,8 @@ command batgeom.point(x:bat[:oid,:dbl],y
address wkbcreatepoint_bat;
comment Construct a point-BAT from two geometry-BATs
+pattern batmal.multiplex(mod:str,fcn:str,a:any...):any...
+address MANIFOLDremapMultiplex;
command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit]
address BATPCREilike2;
command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit]
diff --git a/clients/Tests/MAL-signatures_none.stable.out
b/clients/Tests/MAL-signatures_none.stable.out
--- a/clients/Tests/MAL-signatures_none.stable.out
+++ b/clients/Tests/MAL-signatures_none.stable.out
@@ -2667,6 +2667,8 @@ command batsql.round(v:bat[:oid,:bte],d:
address bte_bat_round_wrap;
comment round off the decimal v(d,s) to r digits behind the dot (if r < 0,
before the dot)
+pattern batmal.multiplex(mod:str,fcn:str,a:any...):any...
+address MANIFOLDremapMultiplex;
command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit]
address BATPCREilike2;
command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit]
diff --git a/clients/Tests/MAL-signatures_none.stable.out.int128
b/clients/Tests/MAL-signatures_none.stable.out.int128
--- a/clients/Tests/MAL-signatures_none.stable.out.int128
+++ b/clients/Tests/MAL-signatures_none.stable.out.int128
@@ -3194,6 +3194,8 @@ command batsql.round(v:bat[:oid,:bte],d:
address bte_bat_round_wrap;
comment round off the decimal v(d,s) to r digits behind the dot (if r < 0,
before the dot)
+pattern batmal.multiplex(mod:str,fcn:str,a:any...):any...
+address MANIFOLDremapMultiplex;
command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit]
address BATPCREilike2;
command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit]
diff --git a/clients/Tests/SQL-dump_all.stable.out
b/clients/Tests/SQL-dump_all.stable.out
--- a/clients/Tests/SQL-dump_all.stable.out
+++ b/clients/Tests/SQL-dump_all.stable.out
@@ -106,6 +106,7 @@ SYSTEM FUNCTION sys.buffer
SYSTEM FUNCTION sys.chi2prob
SYSTEM FUNCTION sys.columnsize
SYSTEM FUNCTION sys.contains
+SYSTEM FUNCTION sys.convert
SYSTEM FUNCTION sys.convexhull
SYSTEM FUNCTION sys.corr
SYSTEM FUNCTION sys.crosses
@@ -1209,45 +1210,22 @@ begin
set "distinct" = "count" -- assume all distinct
where "type" = 'varchar' or "type"='clob';
end;
-
--- The contents of this file are subject to the MonetDB Public License
--- Version 1.1 (the "License"); you may not use this file except in
--- compliance with the License. You may obtain a copy of the License at
--- http://www.monetdb.org/Legal/MonetDBLicense
+-- This Source Code Form is subject to the terms of the Mozilla Public
+-- License, v. 2.0. If a copy of the MPL was not distributed with this
+-- file, You can obtain one at http://mozilla.org/MPL/2.0/.
--
--- Software distributed under the License is distributed on an "AS IS"
--- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
--- License for the specific language governing rights and limitations
--- under the License.
---
--- The Original Code is the MonetDB Database System.
---
--- The Initial Developer of the Original Code is CWI.
--- Portions created by CWI are Copyright (C) 1997-July 2008 CWI.
--- Copyright August 2008-2015 MonetDB B.V.
--- All Rights Reserved.
+-- Copyright 2008-2015 MonetDB B.V.
create function str_to_date(s string, format string) returns date
external name mtime."str_to_date";
create function symdifference(a geometry, b geometry) returns geometry
external name geom."SymDifference";
create function "text" (p inet) returns clob
external name inet."text";
--- The contents of this file are subject to the MonetDB Public License
--- Version 1.1 (the "License"); you may not use this file except in
--- compliance with the License. You may obtain a copy of the License at
--- http://www.monetdb.org/Legal/MonetDBLicense
+-- This Source Code Form is subject to the terms of the Mozilla Public
+-- License, v. 2.0. If a copy of the MPL was not distributed with this
+-- file, You can obtain one at http://mozilla.org/MPL/2.0/.
--
--- Software distributed under the License is distributed on an "AS IS"
--- basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
--- License for the specific language governing rights and limitations
--- under the License.
---
--- The Original Code is the MonetDB Database System.
---
--- The Initial Developer of the Original Code is CWI.
--- Portions created by CWI are Copyright (C) 1997-July 2008 CWI.
--- Copyright August 2008-2015 MonetDB B.V.
--- All Rights Reserved.
+-- Copyright 2008-2015 MonetDB B.V.
-- Provide a simple equivalent for the UNIX times command
-- times 0 ms user 0 ms system 0 ms 0 reads 0 writes
@@ -6879,13 +6857,13 @@ 86 "count" "count" "aggr" 0 3 false
fals
5222 "env" "CREATE FUNCTION env () RETURNS TABLE( name varchar(1024),
value varchar(2048)) EXTERNAL NAME sql.sql_environment;" "sql" 2 5
false false false 2000
5225 "var" "CREATE FUNCTION var() RETURNS TABLE( name varchar(1024))
EXTERNAL NAME sql.sql_variables;" "sql" 2 5 false false
false 2000
5231 "db_users" "CREATE FUNCTION db_users () RETURNS TABLE( name
varchar(2048)) EXTERNAL NAME sql.db_users;" "sql" 2 5 false
false false 2000
-5251 "like" "-- 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-- Portions created by CWI are Copyright (C) 1997-July
2008 CWI.\n-- Copyright August 2008-2015 MonetDB B.V.\n-- All Rights
Reserved.\n\ncreate filter function ""like""(val string, pat string, esc
string) external name algebra.""like"";" "algebra" 1 4
true false false 2000
+5251 "like" "-- This Source Code Form is subject to the terms of the
Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed
with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n--
Copyright 2008-2015 MonetDB B.V.\n\ncreate filter function ""like""(val string,
pat string, esc string) external name algebra.""like"";" "algebra" 1
4 true false false 2000
5256 "ilike" "create filter function ""ilike""(val string, pat string, esc
string) external name algebra.""ilike"";" "algebra" 1 4 true
false false 2000
5261 "like" "create filter function ""like""(val string, pat string)
external name algebra.""like"";" "algebra" 1 4 true
false false 2000
5265 "ilike" "create filter function ""ilike""(val string, pat string)
external name algebra.""ilike"";" "algebra" 1 4 true
false false 2000
-5269 "degrees" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\ncreate function degrees(r double) \nreturns
double\n\treturn r*180/pi();" "user" 2 1 false false
false 2000
+5269 "degrees" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate
function degrees(r double) \nreturns double\n\treturn r*180/pi();" "user"
2 1 false false false 2000
5273 "radians" "create function radians(d double) \nreturns
double\n\treturn d*pi()/180;" "user" 2 1 false false
false 2000
-5277 "times" "-- 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-- Portions created by CWI are Copyright (C) 1997-July
2008 CWI.\n-- Copyright August 2008-2015 MonetDB B.V.\n-- All Rights
Reserved.\n\n-- Provide a simple equivalent for the UNIX times command\n--
times 0 ms user 0 ms system 0 ms 0 reads 0 writes\n\ncreate procedure
times()\nexternal name sql.times;" "sql" 1 2 true false
false 2000
+5277 "times" "-- This Source Code Form is subject to the terms of the
Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed
with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n--
Copyright 2008-2015 MonetDB B.V.\n\n-- Provide a simple equivalent for the UNIX
times command\n-- times 0 ms user 0 ms system 0 ms 0 reads 0 writes\n\ncreate
procedure times()\nexternal name sql.times;" "sql" 1 2
true false false 2000
5280 "getanchor" "create function getanchor( theurl url ) returns string
\n\texternal name url.""getAnchor"";" "url" 1 1 false false
false 2000
5284 "getbasename" "create function getbasename(theurl url) returns string
\n\texternal name url.""getBasename"";" "url" 1 1 false
false false 2000
5288 "getcontent" "create function getcontent(theurl url) returns
string \n\texternal name url.""getContent"";" "url" 1 1
false false false 2000
@@ -6902,7 +6880,7 @@ 5328 "getroboturl" "create function getr
5332 "isaurl" "create function isaurl(theurl url) returns
bool\n\texternal name url.""isaURL"";" "url" 1 1 false
false false 2000
5336 "newurl" "create function newurl(protocol string, hostname
string, ""port"" int, file string) \n\treturns url \n\texternal name
url.""new"";" "url" 1 1 false false false 2000
5343 "newurl" "create function newurl(protocol string, hostname
string, file string) \n\treturns url \n\texternal name url.""new"";" "url" 1
1 false false false 2000
-5349 "str_to_date" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\ncreate function str_to_date(s string, format
string) returns date\n\texternal name mtime.""str_to_date"";" "mtime" 1
1 false false false 2000
+5349 "str_to_date" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate
function str_to_date(s string, format string) returns date\n\texternal name
mtime.""str_to_date"";" "mtime" 1 1 false false false 2000
5354 "date_to_str" "create function date_to_str(d date, format string)
returns string\n\texternal name mtime.""date_to_str"";" "mtime" 1 1
false false false 2000
5360 "broadcast" "create function ""broadcast"" (p inet) returns inet
\n\texternal name inet.""broadcast"";" "inet" 1 1 false
false false 2000
5364 "host" "create function ""host"" (p inet) returns clob\n\texternal
name inet.""host"";" "inet" 1 1 false false false 2000
@@ -6917,22 +6895,22 @@ 5397 "left_shift" "create function ""lef
5402 "right_shift" "create function ""right_shift""(i1 inet, i2 inet)
returns boolean\n\texternal name inet."">>"";" "inet" 1 1
false false false 2000
5407 "left_shift_assign" "create function ""left_shift_assign""(i1 inet,
i2 inet) returns boolean\n\texternal name inet.""<<="";" "inet" 1
1 false false false 2000
5412 "right_shift_assign" "create function ""right_shift_assign""(i1
inet, i2 inet) returns boolean\n\texternal name inet."">>="";" "inet" 1
1 false false false 2000
-5417 "querylog_catalog" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- QUERY HISTORY\n-- The query history
mechanism of MonetDB/SQL relies on a few hooks.\n-- The most important one is a
global system variable which controls\n-- monitoring of all sessions.
\n\ncreate funct
ion sys.querylog_catalog()\nreturns table(\n\tid oid,\n\towner
string,\n\tdefined timestamp,\n\tquery string,\n\tpipe string,\n\t""plan""
string,\t\t-- Name of MAL plan\n\tmal int,\t\t\t-- size of MAL plan\n\toptimize
bigint \t-- time in usec\n)\nexternal name sql.querylog_catalog;" "sql" 1
5 false false false 2000
+5417 "querylog_catalog" "-- This Source Code Form is subject to the
terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n--
QUERY HISTORY\n-- The query history mechanism of MonetDB/SQL relies on a few
hooks.\n-- The most important one is a global system variable which
controls\n-- monitoring of all sessions. \n\ncreate function
sys.querylog_catalog()\nreturns table(\n\tid oid,\n\towner string,\n\tdefined
timestamp,\n\tquery string,\n\tpipe string,\n\t""plan"" string,\t\t-- Name of
MAL plan\n\tmal int,\t\t\t-- size of MAL plan\n\toptimize bigint \t-- time in
usec\n)\nexternal name sql.querylog_catalog;" "sql" 1 5 false
false false 2000
5427 "querylog_calls" "-- 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 the statement was c
ompletely 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)\nexternal name sql.querylog_calls;" "sql" 1 5 false false
false 2000
5477 "querylog_empty" "-- reset history for a particular user\ncreate
procedure sys.querylog_empty()\nexternal name sql.querylog_empty;" "sql"
1 2 true false false 2000
5479 "querylog_enable" "-- manipulate the query logger\ncreate
procedure sys.querylog_enable()\nexternal name sql.querylog_enable;" "sql"
1 2 true false false 2000
5481 "querylog_enable" "create procedure sys.querylog_enable(threshold
smallint)\nexternal name sql.querylog_enable_threshold;" "sql" 1
2 true false false 2000
5484 "querylog_disable" "create procedure
sys.querylog_disable()\nexternal name sql.querylog_disable;" "sql" 1 2
true false false 2000
-5486 "tracelog" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- make the offline tracing table available
for inspection\ncreate function sys.tracelog() \n\treturns table (\n\t\tevent
integer,\t\t-- event counter\n\t\tclk varchar(20), \t-- wallclock, no mtime in
kernel\n\t\tp
c varchar(50), \t-- module.function[nr]\n\t\tthread int, \t\t-- thread
identifier\n\t\tticks bigint, \t\t-- time in microseconds\n\t\trrsmb bigint,
\t\t-- resident memory in MB\n\t\tvmmb bigint, \t\t-- virtual size in
MB\n\t\treads bigint, \t\t-- number of blocks read\n\t\twrites bigint, \t\t--
number of blocks written\n\t\tminflt bigint, \t\t-- minor page
faults\n\t\tmajflt bigint, \t\t-- major page faults\n\t\tnvcsw bigint, \t\t--
non-volantary conext switch\n\t\tstmt string\t\t\t-- actual statement
executed\n\t)\n\texternal name sql.dump_trace;" "sql" 1 5
false false false 2000
+5486 "tracelog" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n--
make the offline tracing table available for inspection\ncreate function
sys.tracelog() \n\treturns table (\n\t\tevent integer,\t\t-- event
counter\n\t\tclk varchar(20), \t-- wallclock, no mtime in kernel\n\t\tpc
varchar(50), \t-- module.function[nr]\n\t\tthread int, \t\t-- thread
identifier\n\t\tticks bigint, \t\t-- time in microseconds\n\t\trrsmb bigint,
\t\t-- resident memory in MB\n\t\tvmmb bigint, \t\t-- virtual size in
MB\n\t\treads bigint, \t\t-- number of blocks read\n\t\twrites bigint, \t\t--
number of blocks written\n\t\tminflt bigint, \t\t-- minor page
faults\n\t\tmajflt bigint, \t\t-- major page faults\n\t\tnvcsw bigint, \t\t--
non-volantary conext switch\n\t\tstmt string\t\t\t-- actual statement executed\n
\t)\n\texternal name sql.dump_trace;" "sql" 1 5 false false
false 2000
5516 "profiler_openstream" "create procedure profiler_openstream(host
string, port int) external name profiler.""openStream"";" "profiler" 1
2 true false false 2000
5520 "profiler_stethoscope" "create procedure profiler_stethoscope(ticks
int) external name profiler.stethoscope;" "profiler" 1 2 true
false false 2000
-5523 "epoch" "-- 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-- Portions created by CWI are Copyright (C) 1997-July
2008 CWI.\n-- Copyright August 2008-2015 MonetDB B.V.\n-- All Rights
Reserved.\n\n-- assume milliseconds when converted to TIMESTAMP\ncreate
function ""epoch""(sec bigint) returns timestamp\n external name
timestamp.""epoch"";" "timestamp" 1 1 false false false
2000
+5523 "epoch" "-- This Source Code Form is subject to the terms of the
Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed
with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n--
Copyright 2008-2015 MonetDB B.V.\n\n-- assume milliseconds when converted to
TIMESTAMP\ncreate function ""epoch""(sec bigint) returns timestamp\n
external name timestamp.""epoch"";" "timestamp" 1 1 false
false false 2000
5527 "epoch" "create function ""epoch""(sec int) returns
timestamp\n\texternal name timestamp.""epoch"";" "timestamp" 1 1
false false false 2000
5531 "epoch" "create function ""epoch""(ts timestamp) returns
int\n\texternal name timestamp.""epoch"";" "timestamp" 1 1
false false false 2000
-5535 "shrink" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 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 drop
ped before\n-- and re-established after the cluster operation.\n\ncreate
procedure shrink(sys string, tab string)\n\texternal name sql.shrink;"
"sql" 1 2 true false false 2000
+5535 "shrink" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\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 cluster operation.\n\ncreate procedure shrink(sys
string, tab string)\n\texternal name sql.shrink;" "sql" 1 2
true false false 2000
5539 "reuse" "create procedure reuse(sys string, tab string)\n\texternal
name sql.reuse;" "sql" 1 2 true false false 2000
5543 "vacuum" "create procedure vacuum(sys string, tab
string)\n\texternal name sql.vacuum;" "sql" 1 2 true false
false 2000
-5547 "dependencies_schemas_on_users" "-- 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-- Portions created by CWI are Copyright (C) 1997-July
2008 CWI.\n-- Copyright August 2008-2015 MonetDB B.V.\n-- All Rights
Reserved.\n\n--Schema s has a dependency on user u\ncreate function
dependencies_schemas_on_users()\nreturns table (sch varchar(100), usr
varchar(100), dep_type varchar(32))\nreturn table (select s.name, u.
name, 'DEP_USER' from schemas as s, users u where u.default_schema = s.id);"
"user" 2 5 false false false 2000
+5547 "dependencies_schemas_on_users" "-- This Source Code Form is subject to
the terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was
not distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB
B.V.\n\n--Schema s has a dependency on user u\ncreate function
dependencies_schemas_on_users()\nreturns table (sch varchar(100), usr
varchar(100), dep_type varchar(32))\nreturn table (select s.name, u.name,
'DEP_USER' from schemas as s, users u where u.default_schema = s.id);" "user"
2 5 false false false 2000
5552 "dependencies_owners_on_schemas" "--User (owner) has a
dependency in schema s\ncreate function
dependencies_owners_on_schemas()\nreturns table (sch varchar(100), usr
varchar(100), dep_type varchar(32))\nreturn table (select a.name, s.name,
'DEP_SCHEMA' from schemas as s, auths a where s.owner = a.id);" "user" 2
5 false false false 2000
5557 "dependencies_tables_on_views" "--Table t has a dependency on view
v\ncreate function dependencies_tables_on_views()\nreturns table (sch
varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select
t.name, v.name, 'DEP_VIEW' from tables as t, tables as v, dependencies as dep
where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);" "user" 2 5 false false false 2000
5562 "dependencies_tables_on_indexes" "--Table t has a dependency on
index i\ncreate function dependencies_tables_on_indexes()\nreturns table (sch
varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table (select
t.name, i.name, 'DEP_INDEX' from tables as t, idxs as i where i.table_id = t.id
and i.name not in (select name from keys) and t.type = 0);" "user" 2 5
false false false 2000
@@ -6949,36 +6927,36 @@ 5612 "dependencies_views_on_triggers" "-
5617 "dependencies_functions_on_functions" "--Function f1 has a dependency
on function f2\ncreate function dependencies_functions_on_functions()\nreturns
table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table
(select f1.name, f2.name, 'DEP_FUNC' from functions as f1, functions as f2,
dependencies as dep where f1.id = dep.id and f2.id = dep.depend_id and
dep.depend_type = 7);" "user" 2 5 false false false 2000
5622 "dependencies_functions_os_triggers" "--Function f1 has a dependency
on trigger tri\ncreate function dependencies_functions_os_triggers()\nreturns
table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table
(select f.name, tri.name, 'DEP_TRIGGER' from functions as f, triggers as tri,
dependencies as dep where dep.id = f.id and dep.depend_id =tri.id and
dep.depend_type = 8);" "user" 2 5 false false false 2000
5627 "dependencies_keys_on_foreignkeys" "--Key k has a dependency on
foreign key fk\ncreate function dependencies_keys_on_foreignkeys()\nreturns
table (sch varchar(100), usr varchar(100), dep_type varchar(32))\nreturn table
(select k.name, fk.name, 'DEP_FKEY' from keys as k, keys as fk where fk.rkey =
k.id);" "user" 2 5 false false false 2000
-5632 "password_hash" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\ncreate function sys.password_hash (username
string) \n\treturns string \n\texternal name sql.password;" "sql" 1 1
false false false 2000
+5632 "password_hash" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate
function sys.password_hash (username string) \n\treturns string \n\texternal
name sql.password;" "sql" 1 1 false false false 2000
5636 "sessions" "create function sys.sessions()\nreturns table(""user""
string, ""login"" timestamp, ""sessiontimeout"" bigint, ""lastcommand""
timestamp, ""querytimeout"" bigint, ""active"" bool)\nexternal name
sql.sessions;" "sql" 1 5 false false false 2000
5652 "shutdown" "create procedure sys.shutdown(delay tinyint)
\nexternal name sql.shutdown;" "sql" 1 2 true false false
2000
5655 "shutdown" "create procedure sys.shutdown(delay tinyint, force
bool) \nexternal name sql.shutdown;" "sql" 1 2 true
false false 2000
5659 "settimeout" "-- control the query and session time out \ncreate
procedure sys.settimeout(""query"" bigint)\n\texternal name sql.settimeout;"
"sql" 1 2 true false false 2000
5662 "settimeout" "create procedure sys.settimeout(""query"" bigint,
""session"" bigint)\n\texternal name sql.settimeout;" "sql" 1 2
true false false 2000
5666 "setsession" "create procedure sys.setsession(""timeout""
bigint)\n\texternal name sql.setsession;" "sql" 1 2 true
false false 2000
-5669 "ms_stuff" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\ncreate function ms_stuff( s1 varchar(32), st
int, len int, s3 varchar(32))\nreturns varchar(32)\nbegin\n\tdeclare res
varchar(32), aux varchar(32);\n\tdeclare ofset int;\n\n if ( st < 0 or st >
length(s1))\n
then return '';\n end if;\n\n set ofset = 1;\n set res =
substring(s1,ofset,st-1);\n set res = res || s3;\n set ofset = st +
len;\n set aux = substring(s1,ofset,length(s1)-ofset+1);\n\tset res = res ||
aux;\n\treturn res;\nend;" "user" 2 1 false false false
2000
+5669 "ms_stuff" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate
function ms_stuff( s1 varchar(32), st int, len int, s3 varchar(32))\nreturns
varchar(32)\nbegin\n\tdeclare res varchar(32), aux varchar(32);\n\tdeclare
ofset int;\n\n if ( st < 0 or st > length(s1))\n then return '';\n
end if;\n\n set ofset = 1;\n set res = substring(s1,ofset,st-1);\n set
res = res || s3;\n set ofset = st + len;\n set aux =
substring(s1,ofset,length(s1)-ofset+1);\n\tset res = res || aux;\n\treturn
res;\nend;" "user" 2 1 false false false 2000
5676 "ms_trunc" "create function ms_trunc(num double, prc int)\nreturns
double\nexternal name sql.ms_trunc;" "sql" 1 1 false false
false 2000
5681 "ms_round" "create function ms_round(num double, prc int, truncat
int)\nreturns double\nbegin\n\tif (truncat = 0)\n\t\tthen return round(num,
prc);\n\t\telse return ms_trunc(num, prc);\n\tend if;\nend;" "user" 2 1
false false false 2000
5687 "ms_str" "create function ms_str(num float, prc int, truncat
int)\nreturns string\nbegin\n return cast(num as string);\nend;"
"user" 2 1 false false false 2000
5693 "alpha" "create function alpha(pdec double, pradius double)\nreturns
double external name sql.alpha;" "sql" 1 1 false false
false 2000
-5698 "zorder_encode" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\ncreate function zorder_encode(x integer, y
integer) returns oid\n external name zorder.encode;" "zorder" 1
1 false false false 2000
+5698 "zorder_encode" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate
function zorder_encode(x integer, y integer) returns oid\n external name
zorder.encode;" "zorder" 1 1 false false false 2000
5703 "zorder_decode_x" "create function zorder_decode_x(z oid) returns
integer\n external name zorder.decode_x;" "zorder" 1 1
false false false 2000
5707 "zorder_decode_y" "create function zorder_decode_y(z oid) returns
integer\n external name zorder.decode_y;" "zorder" 1 1
false false false 2000
-5711 "optimizer_stats" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- show the optimizer statistics maintained by
the SQL frontend\ncreate function sys.optimizer_stats () \n\treturns table
(rewrite string, count int) \n\texternal name sql.dump_opt_stats;" "sql"
1 5 false fa
lse false 2000
+5711 "optimizer_stats" "-- This Source Code Form is subject to the
terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n--
show the optimizer statistics maintained by the SQL frontend\ncreate function
sys.optimizer_stats () \n\treturns table (rewrite string, count int)
\n\texternal name sql.dump_opt_stats;" "sql" 1 5 false false
false 2000
5715 "querycache" "-- 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;" "sql"
1 5 false false false 2000
5719 "querylog" "-- Trace the SQL input\ncreate procedure
sys.querylog(filename string) \n\texternal name sql.logfile;" "sql" 1 2
true false false 2000
5722 "optimizers" "-- MONETDB KERNEL SECTION\n-- optimizer pipe
catalog\ncreate function sys.optimizers () \n\treturns table (name string, def
string, status string)\n\texternal name sql.optimizers;" "sql" 1 5
false false false 2000
5732 "environment" "-- The environment table\ncreate function
sys.environment()\n\treturns table (""name"" string, value string)\n\texternal
name sql.sql_environment;" "sql" 1 5 false false false
2000
5740 "bbp" "-- The BAT buffer pool overview\ncreate function sys.bbp ()
\n\treturns table (id int, name string, htype string, \n\t\tttype string, count
bigint, refcnt int, lrefcnt int, \n\t\tlocation string, heat int, dirty string,
\n\t\tstatus string, kind string) \n\texternal name bbp.get;" "bbp" 1
5 false false false 2000
5754 "evalalgebra" "create procedure sys.evalalgebra( ra_stmt string, opt
bool)\n\texternal name sql.""evalAlgebra"";" "sql" 1 2 true
false false 2000
-5758 "queue" "-- 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-- Portions created by CWI are Copyright (C) 1997-July
2008 CWI.\n-- Copyright August 2008-2015 MonetDB B.V.\n-- All Rights
Reserved.\n\n-- System monitoring\n\n-- show status of all active SQL
queries.\ncreate function sys.queue()\nreturns table(\n\tqtag
bigint,\n\t""user"" string,\n\tstarted timestamp,\n\testimate
timestamp,\n\tprogress int,\n\tstatu
s string,\n\ttag oid,\n\tquery string\n)\nexternal name sql.sysmon_queue;"
"sql" 1 5 false false false 2000
+5758 "queue" "-- This Source Code Form is subject to the terms of the
Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed
with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n--
Copyright 2008-2015 MonetDB B.V.\n\n-- System monitoring\n\n-- show status of
all active SQL queries.\ncreate function sys.queue()\nreturns table(\n\tqtag
bigint,\n\t""user"" string,\n\tstarted timestamp,\n\testimate
timestamp,\n\tprogress int,\n\tstatus string,\n\ttag oid,\n\tquery
string\n)\nexternal name sql.sysmon_queue;" "sql" 1 5 false
false false 2000
5778 "pause" "-- operations to manipulate the state of havoc queries\ncreate
procedure sys.pause(tag int)\nexternal name sql.sysmon_pause;" "sql" 1
2 true false false 2000
5781 "resume" "create procedure sys.resume(tag int)\nexternal name
sql.sysmon_resume;" "sql" 1 2 true false false 2000
5784 "stop" "create procedure sys.stop(tag int)\nexternal name
sql.sysmon_stop;" "sql" 1 2 true false false 2000
5787 "pause" "create procedure sys.pause(tag bigint)\nexternal name
sql.sysmon_pause;" "sql" 1 2 true false false 2000
5790 "resume" "create procedure sys.resume(tag bigint)\nexternal name
sql.sysmon_resume;" "sql" 1 2 true false false 2000
5793 "stop" "create procedure sys.stop(tag bigint)\nexternal name
sql.sysmon_stop;" "sql" 1 2 true false false 2000
-5796 "stddev_samp" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\ncreate aggregate stddev_samp(val tinyint)
returns double\n\texternal name ""aggr"".""stdev"";" "aggr" 1 3
false false false 2000
+5796 "stddev_samp" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\ncreate
aggregate stddev_samp(val tinyint) returns double\n\texternal name
""aggr"".""stdev"";" "aggr" 1 3 false false false 2000
5800 "stddev_samp" "create aggregate stddev_samp(val smallint) returns
double\n\texternal name ""aggr"".""stdev"";" "aggr" 1 3
false false false 2000
5804 "stddev_samp" "create aggregate stddev_samp(val integer) returns
double\n\texternal name ""aggr"".""stdev"";" "aggr" 1 3 false
false false 2000
5808 "stddev_samp" "create aggregate stddev_samp(val wrd) returns
double\n\texternal name ""aggr"".""stdev"";" "aggr" 1 3 false
false false 2000
@@ -7109,16 +7087,16 @@ 6369 "text" "create function json.text(j
6373 "output" "-- The remainder awaits the implementation \n\ncreate
aggregate json.output(js json)\nreturns string external name json.output;"
"json" 1 3 false false false 6289
6377 "tojsonarray" "-- create function json.object(*) returns json
external name json.objectrender;\n\n-- create function json.array(*) returns
json external name json.arrayrender;\n\n-- unnesting the JSON structure\n\n--
create function json.unnest(js json)\n-- returns table( id integer, k string, v
string) external name json.unnest;\n\n-- create function json.unnest(js
json)\n-- returns table( k string, v string) external name json.unnest;\n\n--
create function json.unnest(js json)\n-- returns table( v string) external name
json.unnest;\n\n-- create function json.nest table( id integer, k string, v
string)\n-- returns json external name json.nest;\n\ncreate aggregate
json.tojsonarray( x string ) returns string external name aggr.jsonaggr;"
"aggr" 1 3 false false false 6289
6381 "tojsonarray" "create aggregate json.tojsonarray( x double ) returns
string external name aggr.jsonaggr;" "aggr" 1 3 false false
false 6289
-6385 "md5" "\n-- 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-2015 MonetDB B.V.\n-- All
Rights Reserved.\n\n-- (co) Arjen de Rijke\n-- Functions supporting
jsonstore\n\ncreate function sys.md5(v string)\nreturns string external name
clients.md5sum;" "clients" 1 1 false false false 2000
+6385 "md5" "-- This Source Code Form is subject to the terms of the
Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not distributed
with this\n-- file, You can obtain one at http://mozilla.org/MPL/2.0/.\n--\n--
Copyright 2008-2015 MonetDB B.V.\n\n-- (co) Arjen de Rijke\n-- Functions
supporting jsonstore\n\ncreate function sys.md5(v string)\nreturns string
external name clients.md5sum;" "clients" 1 1 false false
false 2000
6390 "uuid" "-- generate a new uuid\ncreate function sys.uuid()\nreturns
uuid external name uuid.""new"";" "uuid" 1 1 false false
false 2000
6393 "isauuid" "create function sys.isauuid(u uuid)\nreturns uuid
external name uuid.""isaUUID"";" "uuid" 1 1 false false
false 2000
6397 "isauuid" "create function sys.isauuid(u string)\nreturns uuid
external name uuid.""isaUUID"";" "uuid" 1 1 false false
false 2000
-6401 "chi2prob" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- (co) Arjen de Rijke, Bart Scheers\n-- Use
statistical functions from gsl library\n\n-- Calculate Chi squared
probability\ncreate function sys.chi2prob(chi2 double, datapoints
double)\nreturns double external nam
e gsl.""chi2prob"";" "gsl" 1 1 false false false 2000
+6401 "chi2prob" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n--
(co) Arjen de Rijke, Bart Scheers\n-- Use statistical functions from gsl
library\n\n-- Calculate Chi squared probability\ncreate function
sys.chi2prob(chi2 double, datapoints double)\nreturns double external name
gsl.""chi2prob"";" "gsl" 1 1 false false false 2000
6406 "listdir" "\n\ncreate procedure listdir(dirname string) external
name fits.listdir;" "fits" 1 2 true false false 2000
6409 "fitsattach" "create procedure fitsattach(fname string) external
name fits.attach;" "fits" 1 2 true false false 2000
6412 "fitsload" "create procedure fitsload(tname string) external name
fits.load;" "fits" 1 2 true false false 2000
6415 "listdirpat" "create procedure listdirpat(dirname string,pat string)
external name fits.listdirpattern;" "fits" 1 2 true false
false 2000
-6419 "storage" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- Author M.Kersten\n-- This script gives the
database administrator insight in the actual\n-- footprint of the persistent
tables and the maximum playground used\n-- when indices are introduced upon
them.\n-- By cha
ncing the storagemodelinput table directly, the footprint for\n-- yet to be
loaded databases can be assessed.\n\n-- The actual storage footprint of an
existing database can be\n-- obtained by the table procuding function
storage()\n-- It represents the actual state of affairs, i.e. storage on
disk\n-- of columns and foreign key indices, and possible temporary hash
indices.\n-- For strings we take a sample to determine their average
length.\n\ncreate function sys.""storage""()\nreturns table (""schema"" string,
""table"" string, ""column"" string, ""type"" string, ""mode"" string, location
string, ""count"" bigint, typewidth int, columnsize bigint, heapsize bigint,
hashes bigint, imprints bigint, sorted boolean)\nexternal name
sql.""storage"";" "sql" 1 5 false false false 2000
+6419 "storage" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n--
Author M.Kersten\n-- This script gives the database administrator insight in
the actual\n-- footprint of the persistent tables and the maximum playground
used\n-- when indices are introduced upon them.\n-- By chancing the
storagemodelinput table directly, the footprint for\n-- yet to be loaded
databases can be assessed.\n\n-- The actual storage footprint of an existing
database can be\n-- obtained by the table procuding function storage()\n-- It
represents the actual state of affairs, i.e. storage on disk\n-- of columns and
foreign key indices, and possible temporary hash indices.\n-- For strings we
take a sample to determine their average length.\n\ncreate function
sys.""storage""()\nreturns table (""schema"" string, "
"table"" string, ""column"" string, ""type"" string, ""mode"" string, location
string, ""count"" bigint, typewidth int, columnsize bigint, heapsize bigint,
hashes bigint, imprints bigint, sorted boolean)\nexternal name
sql.""storage"";" "sql" 1 5 false false false 2000
6461 "storagemodelinit" "-- this table can be adjusted to reflect the
anticipated final database size\n\n-- The model input can be derived from the
current database using\ncreate procedure
sys.storagemodelinit()\nbegin\n\tdelete from sys.storagemodelinput;\n\n\tinsert
into sys.storagemodelinput\n\tselect x.""schema"", x.""table"", x.""column"",
x.""type"", x.typewidth, x.count, 0, x.typewidth, false, x.sorted from
sys.""storage""() x;\n\n\tupdate sys.storagemodelinput\n\tset reference =
true\n\twhere concat(concat(""schema"",""table""), ""column"") in (\n\t\tselect
concat( concat(""fkschema"".""name"", ""fktable"".""name""),
""fkkeycol"".""name"" )\n\t\tfrom\t""sys"".""keys"" as
""fkkey"",\n\t\t\t\t""sys"".""objects"" as
""fkkeycol"",\n\t\t\t\t""sys"".""tables"" as
""fktable"",\n\t\t\t\t""sys"".""schemas"" as ""fkschema""\n\t\twhere
""fktable"".""id"" = ""fkkey"".""table_id""\n\t\t\tand ""fkkey"".""id"" =
""fkkeycol"".""id""\n\t\t\tand ""fkschema"".""id"" = ""fktable"".""schem
a_id""\n\t\t\tand ""fkkey"".""rkey"" > -1);\n\n\tupdate
sys.storagemodelinput\n\tset ""distinct"" = ""count"" -- assume all
distinct\n\twhere ""type"" = 'varchar' or ""type""='clob';\nend;" "user" 2
2 true false false 2000
6463 "columnsize" "-- The predicted storage footprint of the complete
database\n-- determines the amount of diskspace needed for persistent
storage\n-- and the upperbound when all possible index structures are
created.\n-- The storage requirement for foreign key joins is split amongst the
participants.\n\ncreate function sys.columnsize(nme string, i bigint, d
bigint)\nreturns bigint\nbegin\n\tcase\n\twhen nme = 'boolean' then return
i;\n\twhen nme = 'char' then return 2*i;\n\twhen nme = 'smallint' then return 2
* i;\n\twhen nme = 'int'\t then return 4 * i;\n\twhen nme = 'bigint'\t then
return 8 * i;\n\twhen nme = 'hugeint'\t then return 16 * i;\n\twhen nme =
'timestamp' then return 8 * i;\n\twhen nme = 'varchar'
then\n\t\tcase\n\t\twhen cast(d as bigint) << 8 then return i;\n\t\twhen cast(d
as bigint) << 16 then return 2 * i;\n\t\twhen cast(d as bigint) << 32 then
return 4 * i;\n\t\telse return 8 * i;\n\t\tend case;\n\telse return 8 *
i;\n\tend case;\nend;" "user" 2 1 false false f
alse 2000
6469 "heapsize" "create function sys.heapsize(tpe string, i bigint, w
int)\nreturns bigint\nbegin\n\tif tpe <> 'varchar' and tpe <>
'clob'\n\tthen\n\t\treturn 0;\n\tend if;\n\treturn 10240 + i * w;\nend;"
"user" 2 1 false false false 2000
@@ -7133,7 +7111,7 @@ 6546 "analyze" "-- control the sample si
6549 "analyze" "create procedure analyze(tbl string, ""sample""
bigint)\nexternal name sql.analyze;" "sql" 1 2 true false
false 2000
6553 "analyze" "create procedure analyze(sch string, tbl string,
""sample"" bigint)\nexternal name sql.analyze;" "sql" 1 2
true false false 2000
6558 "analyze" "create procedure analyze(sch string, tbl string, col
string, ""sample"" bigint)\nexternal name sql.analyze;" "sql" 1 2
true false false 2000
-6564 "reverse" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- add function signatures to SQL
catalog\n\n\n-- Reverse a string\ncreate function reverse(src string)\nreturns
string external name udf.reverse;" "udf" 1 1 false false
false 2000
+6564 "reverse" "-- This Source Code Form is subject to the terms of
the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n-- add
function signatures to SQL catalog\n\n\n-- Reverse a string\ncreate function
reverse(src string)\nreturns string external name udf.reverse;" "udf" 1
1 false false false 2000
6568 "fuse" "-- fuse two (1-byte) tinyint values into one (2-byte) smallint
value\ncreate function fuse(one tinyint, two tinyint)\nreturns smallint
external name udf.fuse;" "udf" 1 1 false false false
2000
6573 "fuse" "-- fuse two (2-byte) smallint values into one (4-byte) integer
value\ncreate function fuse(one smallint, two smallint)\nreturns integer
external name udf.fuse;" "udf" 1 1 false false false
2000
6578 "fuse" "-- fuse two (4-byte) integer values into one (8-byte) bigint
value\ncreate function fuse(one integer, two integer)\nreturns bigint external
name udf.fuse;" "udf" 1 1 false false false 2000
@@ -7147,7 +7125,7 @@ 6611 "reverse_qual" "create function bam
6615 "seq_length" "create function bam.seq_length(cigar string)\nreturns
int external name bam.seq_length;" "bam" 1 1 false false
false 6582
6619 "sam_export" "create procedure bam.sam_export(output_path
string)\nexternal name bam.sam_export;" "bam" 1 2 true
false false 6582
6622 "bam_export" "create procedure bam.bam_export(output_path
string)\nexternal name bam.bam_export;" "bam" 1 2 true
false false 6582
-6692 "generate_series" "-- 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-- Portions created by CWI are
Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2015 MonetDB
B.V.\n-- All Rights Reserved.\n\n-- (c) Author M.Kersten\n\ncreate function
sys.generate_series(first tinyint, last tinyint)\nreturns table (value
tinyint)\nexternal name generator.series;" "generator" 1 5
false false false 2000
+6692 "generate_series" "-- This Source Code Form is subject to the
terms of the Mozilla Public\n-- License, v. 2.0. If a copy of the MPL was not
distributed with this\n-- file, You can obtain one at
http://mozilla.org/MPL/2.0/.\n--\n-- Copyright 2008-2015 MonetDB B.V.\n\n-- (c)
Author M.Kersten\n\ncreate function sys.generate_series(first tinyint, last
tinyint)\nreturns table (value tinyint)\nexternal name generator.series;"
"generator" 1 5 false false false 2000
6697 "generate_series" "create function sys.generate_series(first
tinyint, last tinyint, stepsize tinyint)\nreturns table (value
tinyint)\nexternal name generator.series;" "generator" 1 5
false false false 2000
6703 "generate_series" "create function sys.generate_series(first
smallint, last smallint)\nreturns table (value smallint)\nexternal name
generator.series;" "generator" 1 5 false false false
2000
6708 "generate_series" "create function sys.generate_series(first
smallint, last smallint, stepsize smallint)\nreturns table (value
smallint)\nexternal name generator.series;" "generator" 1 5
false false false 2000
diff --git a/clients/Tests/SQL-dump_all.stable.out.int128
b/clients/Tests/SQL-dump_all.stable.out.int128
--- a/clients/Tests/SQL-dump_all.stable.out.int128
+++ b/clients/Tests/SQL-dump_all.stable.out.int128
@@ -102,6 +102,7 @@ SYSTEM FUNCTION sys.buffer
SYSTEM FUNCTION sys.chi2prob
SYSTEM FUNCTION sys.columnsize
SYSTEM FUNCTION sys.contains
+SYSTEM FUNCTION sys.convert
SYSTEM FUNCTION sys.convexhull
SYSTEM FUNCTION sys.corr
SYSTEM FUNCTION sys.crosses
@@ -1540,167 +1541,167 @@ 5699 "auth_id" "int" 32 0 5697
NULL true
5700 "privileges" "int" 32 0 5697 NULL true 2
NULL
5701 "grantor" "int" 32 0 5697 NULL true 3
NULL
5702 "grantable" "int" 32 0 5697 NULL true 4
NULL
-5891 "id" "oid" 63 0 5899 NULL true 0 NULL
-5892 "owner" "clob" 0 0 5899 NULL true 1 NULL
-5893 "defined" "timestamp" 7 0 5899 NULL true
2 NULL
-5894 "query" "clob" 0 0 5899 NULL true 3 NULL
-5895 "pipe" "clob" 0 0 5899 NULL true 4 NULL
-5896 "plan" "clob" 0 0 5899 NULL true 5 NULL
-5897 "mal" "int" 32 0 5899 NULL true 6 NULL
-5898 "optimize" "bigint" 64 0 5899 NULL true
7 NULL
-5901 "id" "oid" 63 0 5910 NULL true 0 NULL
-5902 "start" "timestamp" 7 0 5910 NULL true 1
NULL
-5903 "stop" "timestamp" 7 0 5910 NULL true 2
NULL
-5904 "arguments" "clob" 0 0 5910 NULL true 3
NULL
-5905 "tuples" "wrd" 64 0 5910 NULL true 4
NULL
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
