Changeset: 9458f1ee8223 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9458f1ee8223 Modified Files: sql/test/Tests/systemfunctions.stable.out Branch: default Log Message:
some json functions were added. diffs (54 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 @@ -91,11 +91,17 @@ Ready. [ "json", "length", 1, "json", "" ] [ "json", "number", 0, "double", "create function json.number(js json)\nreturns float external name json.number;" ] [ "json", "number", 1, "json", "" ] +[ "json", "output", 0, "clob", "-- The remainder awaits the implementation \n\ncreate aggregate json.output(js json)\nreturns string external name json.output;" ] +[ "json", "output", 1, "json", "" ] [ "json", "text", 0, "clob", "create function json.text(js json, e string)\nreturns string external name json.text;" ] [ "json", "text", 1, "json", "" ] [ "json", "text", 2, "clob", "" ] [ "json", "text", 0, "clob", "create function json.text(js json)\nreturns string external name json.text;" ] [ "json", "text", 1, "json", "" ] +[ "json", "text", 0, "clob", "create function json.text(js string)\nreturns string external name json.text;" ] +[ "json", "text", 1, "clob", "" ] +[ "json", "text", 0, "clob", "create function json.text(js int)\nreturns string external name json.text;" ] +[ "json", "text", 1, "int", "" ] [ "json", "valuearray", 0, "json", "create function json.valuearray(js json)\nreturns json external name json.valuearray;" ] [ "json", "valuearray", 1, "json", "" ] [ "sys", "Intersect", 0, "boolean", "create function \"Intersect\"(a geometry, b geometry) returns boolean external name geom.\"Intersect\";" ] @@ -253,6 +259,8 @@ Ready. [ "sys", "distance", 0, "double", "create function distance(a geometry, b geometry) returns float external name geom.\"Distance\";" ] [ "sys", "distance", 1, "geometry", "" ] [ "sys", "distance", 2, "geometry", "" ] +[ "sys", "dropdictionary", 0, "clob", "create procedure dropdictionary (s string, t string)\n external name sql.dropdictionary;" ] +[ "sys", "dropdictionary", 1, "clob", "" ] [ "sys", "env", 0, "varchar", "CREATE FUNCTION env () RETURNS TABLE( name varchar(1024), value varchar(2048)) EXTERNAL NAME sql.sql_environment;" ] [ "sys", "env", 1, "varchar", "" ] [ "sys", "envelope", 0, "geometry", "create function envelope(g geometry) returns geometry external name geom.\"Envelope\";" ] @@ -307,6 +315,14 @@ Ready. [ "sys", "getroboturl", 1, "url", "" ] [ "sys", "getuser", 0, "clob", "create function getuser(theurl url) returns string \n\texternal name url.\"getUser\";" ] [ "sys", "getuser", 1, "url", "" ] +[ "sys", "gzcompress", 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-- Portions created by CWI are Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2014 MonetDB B.V.\n-- All Rights Reserved.\n\n-- Perform LZ-compression over a specific table;\ncreate procedure gzcompress (s string, t string)\n external name sql.gzcompress;" ] +[ "sys", "gzcompress", 1, "clob", "" ] +[ "sys", "gzdecompress", 0, "clob", "create procedure gzdecompress (s string, t string)\n external name sql.gzdecompress;" ] +[ "sys", "gzdecompress", 1, "clob", "" ] +[ "sys", "gzexpand", 0, "clob", "-- Remove the compressed images\ncreate procedure gzexpand (s string, t string)\n external name sql.gzexpand;" ] +[ "sys", "gzexpand", 1, "clob", "" ] +[ "sys", "gztruncate", 0, "clob", "-- Truncate the storage for columns with a compressed image\ncreate procedure gztruncate (s string, t string)\n external name sql.gztruncate;" ] +[ "sys", "gztruncate", 1, "clob", "" ] [ "sys", "hashsize", 0, "bigint", "create function sys.hashsize(b boolean, i bigint)\nreturns bigint\nbegin\n\t-- assume non-compound keys\n\tif b = true\n\tthen\n\t\treturn 8 * i;\n\tend if;\n\treturn 0;\nend;" ] [ "sys", "hashsize", 1, "boolean", "" ] [ "sys", "hashsize", 2, "bigint", "" ] @@ -405,6 +421,8 @@ Ready. [ "sys", "netmask", 1, "inet", "" ] [ "sys", "network", 0, "inet", "create function \"network\" (p inet) returns inet\n\texternal name inet.\"network\";" ] [ "sys", "network", 1, "inet", "" ] +[ "sys", "newdictionary", 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-- Portions created by CWI are Copyright (C) 1997-July 2008 CWI.\n-- Copyright August 2008-2014 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate procedure newdictionary (s string, t string)\n external name sql.newdictionary;" ] +[ "sys", "newdictionary", 1, "clob", "" ] [ "sys", "newurl", 0, "url", "create function newurl(protocol string, hostname string, \"port\" int, file string) \n\treturns url \n\texternal name url.\"new\";" ] [ "sys", "newurl", 1, "clob", "" ] [ "sys", "newurl", 2, "clob", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list