Changeset: a42cbf46fa37 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a42cbf46fa37 Modified Files: sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 Branch: orderidx Log Message:
Approve systemfunctions test diffs (196 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 @@ -188,6 +188,8 @@ Ready. [ "sys", "acos", 1, "real", "" ] [ "sys", "acos", 0, "double", "acos" ] [ "sys", "acos", 1, "double", "" ] +[ "sys", "all", 0, "any", "all" ] +[ "sys", "all", 1, "any", "" ] [ "sys", "alpha", 0, "double", "create function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] [ "sys", "alpha", 1, "double", "" ] [ "sys", "alpha", 2, "double", "" ] @@ -468,6 +470,9 @@ Ready. [ "sys", "cot", 1, "double", "" ] [ "sys", "count", 0, "wrd", "count" ] [ "sys", "count_no_nil", 0, "wrd", "count_no_nil" ] +[ "sys", "createorderindex", 0, "clob", "create procedure sys.createorderindex(sys string, tab string, col string)\n external name sql.createorderindex;" ] +[ "sys", "createorderindex", 1, "clob", "" ] +[ "sys", "createorderindex", 2, "clob", "" ] [ "sys", "curdate", 0, "date", "current_date" ] [ "sys", "current_date", 0, "date", "current_date" ] [ "sys", "current_time", 0, "timetz", "current_time" ] @@ -564,6 +569,9 @@ Ready. [ "sys", "difference", 0, "int", "stringdiff" ] [ "sys", "difference", 1, "clob", "" ] [ "sys", "difference", 2, "clob", "" ] +[ "sys", "droporderindex", 0, "clob", "create procedure sys.droporderindex(sys string, tab string, col string)\n external name sql.droporderindex;" ] +[ "sys", "droporderindex", 1, "clob", "" ] +[ "sys", "droporderindex", 2, "clob", "" ] [ "sys", "editdistance", 0, "int", "editdistance" ] [ "sys", "editdistance", 1, "char", "" ] [ "sys", "editdistance", 2, "char", "" ] @@ -4364,7 +4372,7 @@ Ready. [ "sys", "stddev_samp", 1, "timestamp", "" ] [ "sys", "stop", 0, "int", "create procedure sys.stop(tag int)\nexternal name sql.sysmon_stop;" ] [ "sys", "stop", 0, "bigint", "create procedure sys.stop(tag bigint)\nexternal name sql.sysmon_stop;" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4378,7 +4386,8 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 14, "bigint", "" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4392,8 +4401,9 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 14, "clob", "" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 14, "bigint", "" ] +[ "sys", "storage", 15, "clob", "" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4407,9 +4417,10 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 14, "clob", "" ] +[ "sys", "storage", 14, "bigint", "" ] [ "sys", "storage", 15, "clob", "" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string, cname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 16, "clob", "" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string, cname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4423,10 +4434,11 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 14, "clob", "" ] +[ "sys", "storage", 14, "bigint", "" ] [ "sys", "storage", 15, "clob", "" ] [ "sys", "storage", 16, "clob", "" ] -[ "sys", "storagemodel", 0, "clob", "create function sys.storagemodel()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"count\" bigint,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n imprints bigint,\n sorted boolean)\nbegin\n return select i.\"schema\", i.\"table\", i.\"column\", i.\"type\", i.\"count\",\n columnsize(i.\"type\", i.count, i.\"distinct\"),\n heapsize(i.\"type\", i.\"distinct\", i.\"atomwidth\"),\n hashsize(i.\"reference\", i.\"count\"),\n imprintsize(i.\"count\",i.\"type\"),\n i.sorted\n from sys.storagemodelinput i;\nend;" ] +[ "sys", "storage", 17, "clob", "" ] +[ "sys", "storagemodel", 0, "clob", "create function sys.storagemodel()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"count\" bigint,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n imprints bigint,\n sorted boolean,\n orderidx bigint)\nbegin\n return select i.\"schema\", i.\"table\", i.\"column\", i.\"type\", i.\"count\",\n columnsize(i.\"type\", i.count, i.\"distinct\"),\n heapsize(i.\"type\", i.\"distinct\", i.\"atomwidth\"),\n hashsize(i.\"reference\", i.\"count\"),\n imprintsize(i.\"count\",i.\"type\"),\n i.sorted, i.orderidx\n from sys.storagemodelinput i;\nend;" ] [ "sys", "storagemodel", 1, "clob", "" ] [ "sys", "storagemodel", 2, "clob", "" ] [ "sys", "storagemodel", 3, "clob", "" ] @@ -4436,6 +4448,7 @@ Ready. [ "sys", "storagemodel", 7, "bigint", "" ] [ "sys", "storagemodel", 8, "bigint", "" ] [ "sys", "storagemodel", 9, "boolean", "" ] +[ "sys", "storagemodel", 10, "bigint", "" ] [ "sys", "str_to_date", 0, "date", "create function str_to_date(s string, format string) returns date\n external name mtime.\"str_to_date\";" ] [ "sys", "str_to_date", 1, "clob", "" ] [ "sys", "str_to_date", 2, "clob", "" ] diff --git a/sql/test/Tests/systemfunctions.stable.out.int128 b/sql/test/Tests/systemfunctions.stable.out.int128 --- a/sql/test/Tests/systemfunctions.stable.out.int128 +++ b/sql/test/Tests/systemfunctions.stable.out.int128 @@ -195,6 +195,8 @@ Ready. [ "sys", "acos", 1, "real", "" ] [ "sys", "acos", 0, "double", "acos" ] [ "sys", "acos", 1, "double", "" ] +[ "sys", "all", 0, "any", "all" ] +[ "sys", "all", 1, "any", "" ] [ "sys", "alpha", 0, "double", "create function alpha(pdec double, pradius double)\nreturns double external name sql.alpha;" ] [ "sys", "alpha", 1, "double", "" ] [ "sys", "alpha", 2, "double", "" ] @@ -500,6 +502,9 @@ Ready. [ "sys", "cot", 1, "double", "" ] [ "sys", "count", 0, "wrd", "count" ] [ "sys", "count_no_nil", 0, "wrd", "count_no_nil" ] +[ "sys", "createorderindex", 0, "clob", "create procedure sys.createorderindex(sys string, tab string, col string)\n external name sql.createorderindex;" ] +[ "sys", "createorderindex", 1, "clob", "" ] +[ "sys", "createorderindex", 2, "clob", "" ] [ "sys", "curdate", 0, "date", "current_date" ] [ "sys", "current_date", 0, "date", "current_date" ] [ "sys", "current_time", 0, "timetz", "current_time" ] @@ -596,6 +601,9 @@ Ready. [ "sys", "difference", 0, "int", "stringdiff" ] [ "sys", "difference", 1, "clob", "" ] [ "sys", "difference", 2, "clob", "" ] +[ "sys", "droporderindex", 0, "clob", "create procedure sys.droporderindex(sys string, tab string, col string)\n external name sql.droporderindex;" ] +[ "sys", "droporderindex", 1, "clob", "" ] +[ "sys", "droporderindex", 2, "clob", "" ] [ "sys", "editdistance", 0, "int", "editdistance" ] [ "sys", "editdistance", 1, "char", "" ] [ "sys", "editdistance", 2, "char", "" ] @@ -4904,7 +4912,7 @@ Ready. [ "sys", "stddev_samp", 1, "hugeint", "" ] [ "sys", "stop", 0, "int", "create procedure sys.stop(tag int)\nexternal name sql.sysmon_stop;" ] [ "sys", "stop", 0, "bigint", "create procedure sys.stop(tag bigint)\nexternal name sql.sysmon_stop;" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4918,7 +4926,8 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 14, "bigint", "" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4932,8 +4941,9 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 14, "clob", "" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 14, "bigint", "" ] +[ "sys", "storage", 15, "clob", "" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4947,9 +4957,10 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 14, "clob", "" ] +[ "sys", "storage", 14, "bigint", "" ] [ "sys", "storage", 15, "clob", "" ] -[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string, cname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean\n)\nexternal name sql.\"storage\";" ] +[ "sys", "storage", 16, "clob", "" ] +[ "sys", "storage", 0, "clob", "create function sys.\"storage\"( sname string, tname string, cname string)\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"mode\" string,\n location string,\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n imprints bigint,\n sorted boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] [ "sys", "storage", 1, "clob", "" ] [ "sys", "storage", 2, "clob", "" ] [ "sys", "storage", 3, "clob", "" ] @@ -4963,10 +4974,11 @@ Ready. [ "sys", "storage", 11, "boolean", "" ] [ "sys", "storage", 12, "bigint", "" ] [ "sys", "storage", 13, "boolean", "" ] -[ "sys", "storage", 14, "clob", "" ] +[ "sys", "storage", 14, "bigint", "" ] [ "sys", "storage", 15, "clob", "" ] [ "sys", "storage", 16, "clob", "" ] -[ "sys", "storagemodel", 0, "clob", "create function sys.storagemodel()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"count\" bigint,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n imprints bigint,\n sorted boolean)\nbegin\n return select i.\"schema\", i.\"table\", i.\"column\", i.\"type\", i.\"count\",\n columnsize(i.\"type\", i.count, i.\"distinct\"),\n heapsize(i.\"type\", i.\"distinct\", i.\"atomwidth\"),\n hashsize(i.\"reference\", i.\"count\"),\n imprintsize(i.\"count\",i.\"type\"),\n i.sorted\n from sys.storagemodelinput i;\nend;" ] +[ "sys", "storage", 17, "clob", "" ] +[ "sys", "storagemodel", 0, "clob", "create function sys.storagemodel()\nreturns table (\n \"schema\" string,\n \"table\" string,\n \"column\" string,\n \"type\" string,\n \"count\" bigint,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n imprints bigint,\n sorted boolean,\n orderidx bigint)\nbegin\n return select i.\"schema\", i.\"table\", i.\"column\", i.\"type\", i.\"count\",\n columnsize(i.\"type\", i.count, i.\"distinct\"),\n heapsize(i.\"type\", i.\"distinct\", i.\"atomwidth\"),\n hashsize(i.\"reference\", i.\"count\"),\n imprintsize(i.\"count\",i.\"type\"),\n i.sorted, i.orderidx\n from sys.storagemodelinput i;\nend;" ] [ "sys", "storagemodel", 1, "clob", "" ] [ "sys", "storagemodel", 2, "clob", "" ] [ "sys", "storagemodel", 3, "clob", "" ] @@ -4976,6 +4988,7 @@ Ready. [ "sys", "storagemodel", 7, "bigint", "" ] [ "sys", "storagemodel", 8, "bigint", "" ] [ "sys", "storagemodel", 9, "boolean", "" ] +[ "sys", "storagemodel", 10, "bigint", "" ] [ "sys", "str_to_date", 0, "date", "create function str_to_date(s string, format string) returns date\n external name mtime.\"str_to_date\";" ] [ "sys", "str_to_date", 1, "clob", "" ] [ "sys", "str_to_date", 2, "clob", "" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
