Changeset: b0a285839a2c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b0a285839a2c Modified Files: sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions_gsl.stable.out sql/test/Tests/systemfunctions_nogeom.stable.out Branch: Oct2014 Log Message:
Approvals. diffs (87 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 @@ -391,6 +391,12 @@ Ready. [ "sys", "isempty", 1, "geometry", "" ] [ "sys", "issimple", 0, "boolean", "create function issimple(g geometry) returns boolean external name geom.\"IsSimple\";" ] [ "sys", "issimple", 1, "geometry", "" ] +[ "sys", "left_shift", 0, "boolean", "create function \"left_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<\";" ] +[ "sys", "left_shift", 1, "inet", "" ] +[ "sys", "left_shift", 2, "inet", "" ] +[ "sys", "left_shift_assign", 0, "boolean", "create function \"left_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<=\";" ] +[ "sys", "left_shift_assign", 1, "inet", "" ] +[ "sys", "left_shift_assign", 2, "inet", "" ] [ "sys", "length", 0, "double", "create function length(g geometry) returns float external name geom.\"Length\";" ] [ "sys", "length", 1, "geometry", "" ] [ "sys", "like", 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-2015 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate filter function \"like\"(val string, pat string, esc string) external name algebra.likesubselect;" ] @@ -566,6 +572,12 @@ Ready. [ "sys", "reuse", 1, "clob", "" ] [ "sys", "reverse", 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-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;" ] [ "sys", "reverse", 1, "clob", "" ] +[ "sys", "right_shift", 0, "boolean", "create function \"right_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\">>\";" ] +[ "sys", "right_shift", 1, "inet", "" ] +[ "sys", "right_shift", 2, "inet", "" ] +[ "sys", "right_shift_assign", 0, "boolean", "create function \"right_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\">>=\";" ] +[ "sys", "right_shift_assign", 1, "inet", "" ] +[ "sys", "right_shift_assign", 2, "inet", "" ] [ "sys", "sessions", 0, "clob", "create function sys.sessions()\nreturns table(\"user\" string, \"login\" timestamp, \"sessiontimeout\" bigint, \"lastcommand\" timestamp, \"querytimeout\" bigint, \"active\" bool)\nexternal name sql.sessions;" ] [ "sys", "sessions", 1, "timestamp", "" ] [ "sys", "sessions", 2, "bigint", "" ] diff --git a/sql/test/Tests/systemfunctions_gsl.stable.out b/sql/test/Tests/systemfunctions_gsl.stable.out --- a/sql/test/Tests/systemfunctions_gsl.stable.out +++ b/sql/test/Tests/systemfunctions_gsl.stable.out @@ -394,6 +394,12 @@ Ready. [ "sys", "isempty", 1, "geometry", "" ] [ "sys", "issimple", 0, "boolean", "create function issimple(g geometry) returns boolean external name geom.\"IsSimple\";" ] [ "sys", "issimple", 1, "geometry", "" ] +[ "sys", "left_shift", 0, "boolean", "create function \"left_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<\";" ] +[ "sys", "left_shift", 1, "inet", "" ] +[ "sys", "left_shift", 2, "inet", "" ] +[ "sys", "left_shift_assign", 0, "boolean", "create function \"left_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<=\";" ] +[ "sys", "left_shift_assign", 1, "inet", "" ] +[ "sys", "left_shift_assign", 2, "inet", "" ] [ "sys", "length", 0, "double", "create function length(g geometry) returns float external name geom.\"Length\";" ] [ "sys", "length", 1, "geometry", "" ] [ "sys", "like", 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-2015 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate filter function \"like\"(val string, pat string, esc string) external name algebra.likesubselect;" ] @@ -569,6 +575,12 @@ Ready. [ "sys", "reuse", 1, "clob", "" ] [ "sys", "reverse", 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-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;" ] [ "sys", "reverse", 1, "clob", "" ] +[ "sys", "right_shift", 0, "boolean", "create function \"right_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\">>\";" ] +[ "sys", "right_shift", 1, "inet", "" ] +[ "sys", "right_shift", 2, "inet", "" ] +[ "sys", "right_shift_assign", 0, "boolean", "create function \"right_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\">>=\";" ] +[ "sys", "right_shift_assign", 1, "inet", "" ] +[ "sys", "right_shift_assign", 2, "inet", "" ] [ "sys", "sessions", 0, "clob", "create function sys.sessions()\nreturns table(\"user\" string, \"login\" timestamp, \"sessiontimeout\" bigint, \"lastcommand\" timestamp, \"querytimeout\" bigint, \"active\" bool)\nexternal name sql.sessions;" ] [ "sys", "sessions", 1, "timestamp", "" ] [ "sys", "sessions", 2, "bigint", "" ] 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 @@ -337,6 +337,12 @@ Ready. [ "sys", "isauuid", 1, "uuid", "" ] [ "sys", "isauuid", 0, "uuid", "create function sys.isauuid(u string)\nreturns uuid external name uuid.\"isaUUID\";" ] [ "sys", "isauuid", 1, "clob", "" ] +[ "sys", "left_shift", 0, "boolean", "create function \"left_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<\";" ] +[ "sys", "left_shift", 1, "inet", "" ] +[ "sys", "left_shift", 2, "inet", "" ] +[ "sys", "left_shift_assign", 0, "boolean", "create function \"left_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\"<<=\";" ] +[ "sys", "left_shift_assign", 1, "inet", "" ] +[ "sys", "left_shift_assign", 2, "inet", "" ] [ "sys", "like", 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-2015 MonetDB B.V.\n-- All Rights Reserved.\n\ncreate filter function \"like\"(val string, pat string, esc string) external name algebra.likesubselect;" ] [ "sys", "like", 1, "clob", "" ] [ "sys", "like", 2, "clob", "" ] @@ -474,6 +480,12 @@ Ready. [ "sys", "reuse", 1, "clob", "" ] [ "sys", "reverse", 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-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;" ] [ "sys", "reverse", 1, "clob", "" ] +[ "sys", "right_shift", 0, "boolean", "create function \"right_shift\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\">>\";" ] +[ "sys", "right_shift", 1, "inet", "" ] +[ "sys", "right_shift", 2, "inet", "" ] +[ "sys", "right_shift_assign", 0, "boolean", "create function \"right_shift_assign\"(i1 inet, i2 inet) returns boolean\n\texternal name inet.\">>=\";" ] +[ "sys", "right_shift_assign", 1, "inet", "" ] +[ "sys", "right_shift_assign", 2, "inet", "" ] [ "sys", "sessions", 0, "clob", "create function sys.sessions()\nreturns table(\"user\" string, \"login\" timestamp, \"sessiontimeout\" bigint, \"lastcommand\" timestamp, \"querytimeout\" bigint, \"active\" bool)\nexternal name sql.sessions;" ] [ "sys", "sessions", 1, "timestamp", "" ] [ "sys", "sessions", 2, "bigint", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list