Changeset: 253677227079 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=253677227079
Modified Files:
clients/Tests/MAL-signatures_gsl.stable.out
clients/Tests/SQL-dump_gsl.stable.out
sql/test/Tests/systemfunctions_gsl.stable.out
sql/test/leaks/Tests/check1_gsl.stable.out
sql/test/leaks/Tests/check2_gsl.stable.out
sql/test/leaks/Tests/check3_gsl.stable.out
sql/test/leaks/Tests/check4_gsl.stable.out
sql/test/leaks/Tests/check5_gsl.stable.out
Branch: default
Log Message:
Approve new output
diffs (truncated from 979 to 300 lines):
diff --git a/clients/Tests/MAL-signatures_gsl.stable.out
b/clients/Tests/MAL-signatures_gsl.stable.out
--- a/clients/Tests/MAL-signatures_gsl.stable.out
+++ b/clients/Tests/MAL-signatures_gsl.stable.out
@@ -2415,7 +2415,7 @@ address ALGgroupby;
comment Produces a new BAT with groups identified by the head column. The
result contains tail times the head value, ie the tail contains the result
group sizes.
command algebra.ilikesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str)
(l:bat[:oid,:oid],r:bat[:oid,:oid])
-address PCREilike_join_pcre;
+address PCREilike_join_pcr5;
function
algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid];
function
algebra.ilikesubselect(b:bat[:oid,:str],pat:str,esc:str,anti:bit):bat[:oid,:oid];
command
algebra.indexjoin(left:bat[:any_1,:any_2],right:bat[:any_2,:any_3]):bat[:any_1,:any_3]
@@ -39667,30 +39667,6 @@ pattern language.source(f:str):void
address CMDevalFile;
comment Merge the instructions stored in the file with the current program.
-command lock.create():lock
-address LCKcreate;
-comment Create an unset lock
-
-command lock.destroy(l:lock):void
-address LCKdestroy;
-comment Destroy a lock
-
-command lock.set(l:lock):void
-address LCKset;
-comment Try to set a lock. If set, block till it is freed
-
-command lock.tostr(l:lock):void
-address lockToStr;
-comment Overloaded atom function
-
-command lock.try(l:lock):int
-address LCKtry;
-comment Try a lock. If free set it, if not return EBUSY
-
-command lock.unset(l:lock):void
-address LCKunset;
-comment Unset a lock
-
command lsst.angsep(ra1:dbl,dec1:dbl,ra2:dbl,dec2:dbl):dbl
address qserv_angSep;
comment Returns the angular separation in degrees between two
sphericalcoordinate pairs (ra1,dec1) and (ra2,dec2)
@@ -41054,57 +41030,22 @@ comment Collect trace of a specific oper
pattern optimizer.trace():str
address OPTwrapper;
-command pcre.compile(pat:str):pcre
-address PCREcompile_wrap;
-comment compile a pattern
-
-command pcre.#del():void
-address pcre_del;
-command pcre.#fromstr():void
-address pcre_fromstr;
-command pcre.#heap():void
-address pcre_heap;
-command pcre.#hash():void
-address pcre_hash;
command pcre.imatch(s:str,pat:str):bit
address PCREimatch;
comment Caseless Perl Compatible Regular Expression pattern matching against a
string
-function pcre.ilike_filter(s:bat[:oid,:str],pat:str):bat[:oid,:str];
-command pcre.ilike_select(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:str]
-address PCREilike_select_pcre;
command pcre.ilikesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str)
(l:bat[:oid,:oid],r:bat[:oid,:oid])
address PCREilike_join_pcre;
-command pcre.ilike_filter(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:oid]
-address PCREilike_uselect_pcre;
-command pcre.ilike_uselect(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:oid]
-address PCREilike_uselect_pcre;
command pcre.index(pat:pcre,s:str):int
address PCREindex;
comment match a pattern, return matched position (or 0 when not found)
-command pcre.like_select(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:str]
-address PCRElike_select_pcre;
command pcre.likesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str)
(l:bat[:oid,:oid],r:bat[:oid,:oid])
address PCRElike_join_pcre;
-command pcre.like_filter(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:oid]
-address PCRElike_uselect_pcre;
-command pcre.like_uselect(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:oid]
-address PCRElike_uselect_pcre;
-command pcre.#length():void
-address pcre_length;
command pcre.match(s:str,pat:str):bit
address PCREmatch;
comment Perl Compatible Regular Expression pattern matching against a string
-command pcre.match(pat:pcre,s:str):bit
-address PCREexec_wrap;
-comment match a pattern
-
-command pcre.#null():void
-address pcre_null;
-command pcre.#nequal():void
-address pcre_nequal;
pattern pcre.prelude():void
address pcre_init;
comment Initialize pcre
@@ -41117,8 +41058,6 @@ command pcre.patindex(pat:str,s:str):int
address PCREpatindex;
comment Location of the first POSIX pattern matching against a string
-command pcre.#put():void
-address pcre_put;
command
pcre.replace(orig:bat[:oid,:str],pat:str,repl:str,flag:str):bat[:oid,:str]
address PCREreplace_bat_wrap;
command pcre.replace(origin:str,pat:str,repl:str,flags:str):str
@@ -41133,12 +41072,6 @@ command pcre.select(pat:str,strs:bat[:oi
address PCREselectDef;
comment Select tuples based on the pattern
-command pcre.#tostr():void
-address pcre_tostr;
-command pcre.uselect(pat:str,strs:bat[:oid,:str]):bat[:oid,:oid]
-address PCREuselectDef;
-comment Select tuples based on the pattern, only returning the head
-
command pqueue.dequeue_max(h:bat[:oid,:any_1]):void
address PQdequeue_anymax;
comment Removes top element of the max-pqueue and updates it
@@ -41717,22 +41650,6 @@ pattern scheduler.volumeCost(a:any):lng
address RUNvolumeCost;
comment A sample cost function based on materialized results
-command sema.create(init:int):sema
-address SEMAcreate;
-comment Create an unset sema, with an initial value
-
-command sema.destroy(s:sema):void
-address SEMAdestroy;
-comment Destroy a semaphore
-
-command sema.down(s:sema):void
-address SEMAdown;
-comment Decrement the semaphpore if >0; else block
-
-command sema.up(s:sema):void
-address SEMAup;
-comment Increment the semaphore
-
command sql.alpha(dec:dbl,theta:dbl):dbl
address SQLcst_alpha_cst;
comment Implementation of astronomy alpha function: expands the radius theta
depending on the declination
diff --git a/clients/Tests/SQL-dump_gsl.stable.out
b/clients/Tests/SQL-dump_gsl.stable.out
--- a/clients/Tests/SQL-dump_gsl.stable.out
+++ b/clients/Tests/SQL-dump_gsl.stable.out
@@ -765,6 +765,8 @@ create function isaurl(theurl url) retur
external name url."isaURL";
create function sys.isauuid(u uuid)
returns uuid external name uuid."isaUUID";
+create function sys.isauuid(u string)
+returns uuid external name uuid."isaUUID";
create function isempty(g geometry) returns boolean external name
geom."IsEmpty";
create function issimple(g geometry) returns boolean external name
geom."IsSimple";
create function length(g geometry) returns float external name geom."Length";
@@ -1711,60 +1713,60 @@ 5627 "progress" "int" 32 0 5631
NULL tru
5628 "status" "clob" 0 0 5631 NULL true 5
NULL
5629 "tag" "oid" 63 0 5631 NULL true 6 NULL
5630 "query" "clob" 0 0 5631 NULL true 7 NULL
-6251 "schema" "clob" 0 0 6263 NULL true 0
NULL
-6252 "table" "clob" 0 0 6263 NULL true 1 NULL
-6253 "column" "clob" 0 0 6263 NULL true 2
NULL
-6254 "type" "clob" 0 0 6263 NULL true 3 NULL
-6255 "location" "clob" 0 0 6263 NULL true 4
NULL
-6256 "count" "bigint" 64 0 6263 NULL true 5
NULL
-6257 "typewidth" "int" 32 0 6263 NULL true 6
NULL
-6258 "columnsize" "bigint" 64 0 6263 NULL true
7 NULL
-6259 "heapsize" "bigint" 64 0 6263 NULL true
8 NULL
-6260 "hashes" "bigint" 64 0 6263 NULL true
9 NULL
-6261 "imprints" "bigint" 64 0 6263 NULL true
10 NULL
-6262 "sorted" "boolean" 1 0 6263 NULL true
11 NULL
-6265 "schema" "clob" 0 0 6275 NULL true 0
NULL
-6266 "table" "clob" 0 0 6275 NULL true 1 NULL
-6267 "column" "clob" 0 0 6275 NULL true 2
NULL
-6268 "type" "clob" 0 0 6275 NULL true 3 NULL
-6269 "typewidth" "int" 32 0 6275 NULL true 4
NULL
-6270 "count" "bigint" 64 0 6275 NULL true 5
NULL
-6271 "distinct" "bigint" 64 0 6275 NULL true
6 NULL
-6272 "atomwidth" "int" 32 0 6275 NULL true 7
NULL
-6273 "reference" "boolean" 1 0 6275 NULL true
8 NULL
-6274 "sorted" "boolean" 1 0 6275 NULL true
9 NULL
-6313 "schema" "clob" 0 0 6323 NULL true 0
NULL
-6314 "table" "clob" 0 0 6323 NULL true 1 NULL
-6315 "column" "clob" 0 0 6323 NULL true 2
NULL
-6316 "type" "clob" 0 0 6323 NULL true 3 NULL
-6317 "count" "bigint" 64 0 6323 NULL true 4
NULL
-6318 "columnsize" "bigint" 64 0 6323 NULL true
5 NULL
-6319 "heapsize" "bigint" 64 0 6323 NULL true
6 NULL
-6320 "hashes" "bigint" 64 0 6323 NULL true
7 NULL
-6321 "imprints" "bigint" 64 0 6323 NULL true
8 NULL
-6322 "sorted" "boolean" 1 0 6323 NULL true
9 NULL
-6325 "schema" "clob" 0 0 6333 NULL true 0
NULL
-6326 "table" "clob" 0 0 6333 NULL true 1 NULL
-6327 "count" "bigint" 64 0 6333 NULL true 2
NULL
-6328 "columnsize" "bigint" 64 0 6333 NULL true
3 NULL
-6329 "heapsize" "bigint" 64 0 6333 NULL true
4 NULL
-6330 "hashes" "bigint" 64 0 6333 NULL true
5 NULL
-6331 "imprints" "bigint" 64 0 6333 NULL true
6 NULL
-6332 "auxillary" "bigint" 53 0 6333 NULL true
7 NULL
-6335 "schema" "clob" 0 0 6348 NULL true 0
NULL
-6336 "table" "clob" 0 0 6348 NULL true 1 NULL
-6337 "column" "clob" 0 0 6348 NULL true 2
NULL
-6338 "type" "clob" 0 0 6348 NULL true 3 NULL
-6339 "width" "int" 32 0 6348 NULL true 4 NULL
-6340 "stamp" "timestamp" 7 0 6348 NULL true 5
NULL
-6341 "sample" "bigint" 64 0 6348 NULL true
6 NULL
-6342 "count" "bigint" 64 0 6348 NULL true 7
NULL
-6343 "unique" "bigint" 64 0 6348 NULL true
8 NULL
-6344 "nils" "bigint" 64 0 6348 NULL true 9
NULL
-6345 "minval" "clob" 0 0 6348 NULL true 10
NULL
-6346 "maxval" "clob" 0 0 6348 NULL true 11
NULL
-6347 "sorted" "boolean" 1 0 6348 NULL true
12 NULL
-6401 "function_id" "int" 32 0 6402 NULL true 0
NULL
+6255 "schema" "clob" 0 0 6267 NULL true 0
NULL
+6256 "table" "clob" 0 0 6267 NULL true 1 NULL
+6257 "column" "clob" 0 0 6267 NULL true 2
NULL
+6258 "type" "clob" 0 0 6267 NULL true 3 NULL
+6259 "location" "clob" 0 0 6267 NULL true 4
NULL
+6260 "count" "bigint" 64 0 6267 NULL true 5
NULL
+6261 "typewidth" "int" 32 0 6267 NULL true 6
NULL
+6262 "columnsize" "bigint" 64 0 6267 NULL true
7 NULL
+6263 "heapsize" "bigint" 64 0 6267 NULL true
8 NULL
+6264 "hashes" "bigint" 64 0 6267 NULL true
9 NULL
+6265 "imprints" "bigint" 64 0 6267 NULL true
10 NULL
+6266 "sorted" "boolean" 1 0 6267 NULL true
11 NULL
+6269 "schema" "clob" 0 0 6279 NULL true 0
NULL
+6270 "table" "clob" 0 0 6279 NULL true 1 NULL
+6271 "column" "clob" 0 0 6279 NULL true 2
NULL
+6272 "type" "clob" 0 0 6279 NULL true 3 NULL
+6273 "typewidth" "int" 32 0 6279 NULL true 4
NULL
+6274 "count" "bigint" 64 0 6279 NULL true 5
NULL
+6275 "distinct" "bigint" 64 0 6279 NULL true
6 NULL
+6276 "atomwidth" "int" 32 0 6279 NULL true 7
NULL
+6277 "reference" "boolean" 1 0 6279 NULL true
8 NULL
+6278 "sorted" "boolean" 1 0 6279 NULL true
9 NULL
+6317 "schema" "clob" 0 0 6327 NULL true 0
NULL
+6318 "table" "clob" 0 0 6327 NULL true 1 NULL
+6319 "column" "clob" 0 0 6327 NULL true 2
NULL
+6320 "type" "clob" 0 0 6327 NULL true 3 NULL
+6321 "count" "bigint" 64 0 6327 NULL true 4
NULL
+6322 "columnsize" "bigint" 64 0 6327 NULL true
5 NULL
+6323 "heapsize" "bigint" 64 0 6327 NULL true
6 NULL
+6324 "hashes" "bigint" 64 0 6327 NULL true
7 NULL
+6325 "imprints" "bigint" 64 0 6327 NULL true
8 NULL
+6326 "sorted" "boolean" 1 0 6327 NULL true
9 NULL
+6329 "schema" "clob" 0 0 6337 NULL true 0
NULL
+6330 "table" "clob" 0 0 6337 NULL true 1 NULL
+6331 "count" "bigint" 64 0 6337 NULL true 2
NULL
+6332 "columnsize" "bigint" 64 0 6337 NULL true
3 NULL
+6333 "heapsize" "bigint" 64 0 6337 NULL true
4 NULL
+6334 "hashes" "bigint" 64 0 6337 NULL true
5 NULL
+6335 "imprints" "bigint" 64 0 6337 NULL true
6 NULL
+6336 "auxillary" "bigint" 53 0 6337 NULL true
7 NULL
+6339 "schema" "clob" 0 0 6352 NULL true 0
NULL
+6340 "table" "clob" 0 0 6352 NULL true 1 NULL
+6341 "column" "clob" 0 0 6352 NULL true 2
NULL
+6342 "type" "clob" 0 0 6352 NULL true 3 NULL
+6343 "width" "int" 32 0 6352 NULL true 4 NULL
+6344 "stamp" "timestamp" 7 0 6352 NULL true 5
NULL
+6345 "sample" "bigint" 64 0 6352 NULL true
6 NULL
+6346 "count" "bigint" 64 0 6352 NULL true 7
NULL
+6347 "unique" "bigint" 64 0 6352 NULL true
8 NULL
+6348 "nils" "bigint" 64 0 6352 NULL true 9
NULL
+6349 "minval" "clob" 0 0 6352 NULL true 10
NULL
+6350 "maxval" "clob" 0 0 6352 NULL true 11
NULL
+6351 "sorted" "boolean" 1 0 6352 NULL true
12 NULL
+6405 "function_id" "int" 32 0 6406 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1812,12 +1814,12 @@ 5505 "sessions" 2000 "create view sys.se
5585 "optimizers" 2000 "create view sys.optimizers as select * from
sys.optimizers();" 1 true 0 false
5593 "environment" 2000 "create view sys.environment as select * from
sys.environment();" 1 true 0 false
5631 "queue" 2000 "create view sys.queue as select * from sys.queue();"
1 true 0 false
-6263 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
-6275 "storagemodelinput" 2000 NULL 0 true 0 false
-6323 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6333 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 *
count else 0 end) as auxillary\nfrom sys.storagemodel() group by
\"schema\",\"table\";" 1 true 0 false
-6348 "statistics" 2000 NULL 0 true 0 false
-6402 "systemfunctions" 2000 NULL 0 true 0 false
+6267 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
+6279 "storagemodelinput" 2000 NULL 0 true 0 false
+6327 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
+6337 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxillary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(imprints) as imprints,\n\tsum(case when sorted = false then 8 *
count else 0 end) as auxillary\nfrom sys.storagemodel() group by
\"schema\",\"table\";" 1 true 0 false
+6352 "statistics" 2000 NULL 0 true 0 false
+6406 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."args" (
@@ -1830,7 +1832,7 @@ CREATE TABLE "sys"."args" (
"inout" TINYINT,
"number" INTEGER
);
-COPY 3553 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 3555 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
2155 28 "res_0" "oid" 63 0 0 0
2156 28 "arg_1" "wrd" 64 0 1 1
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
