Changeset: 157c2204aa37 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=157c2204aa37
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures_gsl.stable.out
clients/Tests/MAL-signatures_nocfitsio.stable.out
clients/Tests/MAL-signatures_sphinxclient.stable.out
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.64bit.oid32
clients/Tests/SQL-dump_gsl.stable.out
clients/Tests/SQL-dump_gsl.stable.out.oid32
clients/Tests/SQL-dump_nogeom.stable.out
clients/Tests/exports.stable.out
gdk/gdk.h
gdk/gdk_bat.c
monetdb5/modules/kernel/bat5.c
monetdb5/modules/kernel/bat5.mal
Branch: default
Log Message:
Cleanup: removed unused defines and deprecated function BATmadvise.
diffs (truncated from 2861 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -32052,14 +32052,6 @@ command bat.setHash(b:bat[:oid,:any_2],p
address BKCsetHash;
comment Create a hash structure on the column
-command bat.setMemoryAdvise(b:bat[:oid,:any_2],mode:int):bit
-address BKCmadvise2;
-comment alias for madvise(b, mode, mode, mode, mode)
-
-command
bat.setMemoryAdvise(b:bat[:oid,:any_2],head_mode:int,tail_mode:int,hheap_mode:int,theap_mode:int):bit
-address BKCmadvise;
-comment Modern Operating Systems allow users to influence the buffer
management policy of virtual memory. This is a crucial feature for
database systems, and eliminates the need to reimplement the OS in a
database buffer manager. The supported flags are BUF_NORMAL (the
normal adaptive kernel algorithm), BUF_RANDOM (no page prefetching),
BUF_SEQUENTIAL (prefetch and swapout), BUF_WILLNEED (load everything with
prefetch), BUF_DONTNEED (swapout). These buffer management modes are not
persistent. Returns the BAT operated upon.
-
command bat.setMemoryMap(b:bat[:oid,:any_2],mode:int):bit
address BKCmmap2;
comment Alias for mmap(b, mode, mode, mode, mode)
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
@@ -32064,14 +32064,6 @@ command bat.setHash(b:bat[:oid,:any_2],p
address BKCsetHash;
comment Create a hash structure on the column
-command bat.setMemoryAdvise(b:bat[:oid,:any_2],mode:int):bit
-address BKCmadvise2;
-comment alias for madvise(b, mode, mode, mode, mode)
-
-command
bat.setMemoryAdvise(b:bat[:oid,:any_2],head_mode:int,tail_mode:int,hheap_mode:int,theap_mode:int):bit
-address BKCmadvise;
-comment Modern Operating Systems allow users to influence the buffer
management policy of virtual memory. This is a crucial feature for
database systems, and eliminates the need to reimplement the OS in a
database buffer manager. The supported flags are BUF_NORMAL (the
normal adaptive kernel algorithm), BUF_RANDOM (no page prefetching),
BUF_SEQUENTIAL (prefetch and swapout), BUF_WILLNEED (load everything with
prefetch), BUF_DONTNEED (swapout). These buffer management modes are not
persistent. Returns the BAT operated upon.
-
command bat.setMemoryMap(b:bat[:oid,:any_2],mode:int):bit
address BKCmmap2;
comment Alias for mmap(b, mode, mode, mode, mode)
diff --git a/clients/Tests/MAL-signatures_nocfitsio.stable.out
b/clients/Tests/MAL-signatures_nocfitsio.stable.out
--- a/clients/Tests/MAL-signatures_nocfitsio.stable.out
+++ b/clients/Tests/MAL-signatures_nocfitsio.stable.out
@@ -32052,14 +32052,6 @@ command bat.setHash(b:bat[:oid,:any_2],p
address BKCsetHash;
comment Create a hash structure on the column
-command bat.setMemoryAdvise(b:bat[:oid,:any_2],mode:int):bit
-address BKCmadvise2;
-comment alias for madvise(b, mode, mode, mode, mode)
-
-command
bat.setMemoryAdvise(b:bat[:oid,:any_2],head_mode:int,tail_mode:int,hheap_mode:int,theap_mode:int):bit
-address BKCmadvise;
-comment Modern Operating Systems allow users to influence the buffer
management policy of virtual memory. This is a crucial feature for
database systems, and eliminates the need to reimplement the OS in a
database buffer manager. The supported flags are BUF_NORMAL (the
normal adaptive kernel algorithm), BUF_RANDOM (no page prefetching),
BUF_SEQUENTIAL (prefetch and swapout), BUF_WILLNEED (load everything with
prefetch), BUF_DONTNEED (swapout). These buffer management modes are not
persistent. Returns the BAT operated upon.
-
command bat.setMemoryMap(b:bat[:oid,:any_2],mode:int):bit
address BKCmmap2;
comment Alias for mmap(b, mode, mode, mode, mode)
diff --git a/clients/Tests/MAL-signatures_sphinxclient.stable.out
b/clients/Tests/MAL-signatures_sphinxclient.stable.out
--- a/clients/Tests/MAL-signatures_sphinxclient.stable.out
+++ b/clients/Tests/MAL-signatures_sphinxclient.stable.out
@@ -32052,14 +32052,6 @@ command bat.setHash(b:bat[:oid,:any_2],p
address BKCsetHash;
comment Create a hash structure on the column
-command bat.setMemoryAdvise(b:bat[:oid,:any_2],mode:int):bit
-address BKCmadvise2;
-comment alias for madvise(b, mode, mode, mode, mode)
-
-command
bat.setMemoryAdvise(b:bat[:oid,:any_2],head_mode:int,tail_mode:int,hheap_mode:int,theap_mode:int):bit
-address BKCmadvise;
-comment Modern Operating Systems allow users to influence the buffer
management policy of virtual memory. This is a crucial feature for
database systems, and eliminates the need to reimplement the OS in a
database buffer manager. The supported flags are BUF_NORMAL (the
normal adaptive kernel algorithm), BUF_RANDOM (no page prefetching),
BUF_SEQUENTIAL (prefetch and swapout), BUF_WILLNEED (load everything with
prefetch), BUF_DONTNEED (swapout). These buffer management modes are not
persistent. Returns the BAT operated upon.
-
command bat.setMemoryMap(b:bat[:oid,:any_2],mode:int):bit
address BKCmmap2;
comment Alias for mmap(b, mode, mode, mode, mode)
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -1680,60 +1680,60 @@ 5713 "progress" "int" 32 0 5717
NULL tru
5714 "status" "clob" 0 0 5717 NULL true 5
NULL
5715 "tag" "oid" 63 0 5717 NULL true 6 NULL
5716 "query" "clob" 0 0 5717 NULL true 7 NULL
-6352 "schema" "clob" 0 0 6364 NULL true 0
NULL
-6353 "table" "clob" 0 0 6364 NULL true 1 NULL
-6354 "column" "clob" 0 0 6364 NULL true 2
NULL
-6355 "type" "clob" 0 0 6364 NULL true 3 NULL
-6356 "location" "clob" 0 0 6364 NULL true 4
NULL
-6357 "count" "bigint" 64 0 6364 NULL true 5
NULL
-6358 "typewidth" "int" 32 0 6364 NULL true 6
NULL
-6359 "columnsize" "bigint" 64 0 6364 NULL true
7 NULL
-6360 "heapsize" "bigint" 64 0 6364 NULL true
8 NULL
-6361 "hashes" "bigint" 64 0 6364 NULL true
9 NULL
-6362 "imprints" "bigint" 64 0 6364 NULL true
10 NULL
-6363 "sorted" "boolean" 1 0 6364 NULL true
11 NULL
-6366 "schema" "clob" 0 0 6376 NULL true 0
NULL
-6367 "table" "clob" 0 0 6376 NULL true 1 NULL
-6368 "column" "clob" 0 0 6376 NULL true 2
NULL
-6369 "type" "clob" 0 0 6376 NULL true 3 NULL
-6370 "typewidth" "int" 32 0 6376 NULL true 4
NULL
-6371 "count" "bigint" 64 0 6376 NULL true 5
NULL
-6372 "distinct" "bigint" 64 0 6376 NULL true
6 NULL
-6373 "atomwidth" "int" 32 0 6376 NULL true 7
NULL
-6374 "reference" "boolean" 1 0 6376 NULL true
8 NULL
-6375 "sorted" "boolean" 1 0 6376 NULL true
9 NULL
-6414 "schema" "clob" 0 0 6424 NULL true 0
NULL
-6415 "table" "clob" 0 0 6424 NULL true 1 NULL
-6416 "column" "clob" 0 0 6424 NULL true 2
NULL
-6417 "type" "clob" 0 0 6424 NULL true 3 NULL
-6418 "count" "bigint" 64 0 6424 NULL true 4
NULL
-6419 "columnsize" "bigint" 64 0 6424 NULL true
5 NULL
-6420 "heapsize" "bigint" 64 0 6424 NULL true
6 NULL
-6421 "hashes" "bigint" 64 0 6424 NULL true
7 NULL
-6422 "imprints" "bigint" 64 0 6424 NULL true
8 NULL
-6423 "sorted" "boolean" 1 0 6424 NULL true
9 NULL
-6426 "schema" "clob" 0 0 6434 NULL true 0
NULL
-6427 "table" "clob" 0 0 6434 NULL true 1 NULL
-6428 "count" "bigint" 64 0 6434 NULL true 2
NULL
-6429 "columnsize" "bigint" 64 0 6434 NULL true
3 NULL
-6430 "heapsize" "bigint" 64 0 6434 NULL true
4 NULL
-6431 "hashes" "bigint" 64 0 6434 NULL true
5 NULL
-6432 "imprints" "bigint" 64 0 6434 NULL true
6 NULL
-6433 "auxillary" "bigint" 53 0 6434 NULL true
7 NULL
-6436 "schema" "clob" 0 0 6449 NULL true 0
NULL
-6437 "table" "clob" 0 0 6449 NULL true 1 NULL
-6438 "column" "clob" 0 0 6449 NULL true 2
NULL
-6439 "type" "clob" 0 0 6449 NULL true 3 NULL
-6440 "width" "int" 32 0 6449 NULL true 4 NULL
-6441 "stamp" "timestamp" 7 0 6449 NULL true 5
NULL
-6442 "sample" "bigint" 64 0 6449 NULL true
6 NULL
-6443 "count" "bigint" 64 0 6449 NULL true 7
NULL
-6444 "unique" "bigint" 64 0 6449 NULL true
8 NULL
-6445 "nils" "bigint" 64 0 6449 NULL true 9
NULL
-6446 "minval" "clob" 0 0 6449 NULL true 10
NULL
-6447 "maxval" "clob" 0 0 6449 NULL true 11
NULL
-6448 "sorted" "boolean" 1 0 6449 NULL true
12 NULL
-6502 "function_id" "int" 32 0 6503 NULL true 0
NULL
+6356 "schema" "clob" 0 0 6368 NULL true 0
NULL
+6357 "table" "clob" 0 0 6368 NULL true 1 NULL
+6358 "column" "clob" 0 0 6368 NULL true 2
NULL
+6359 "type" "clob" 0 0 6368 NULL true 3 NULL
+6360 "location" "clob" 0 0 6368 NULL true 4
NULL
+6361 "count" "bigint" 64 0 6368 NULL true 5
NULL
+6362 "typewidth" "int" 32 0 6368 NULL true 6
NULL
+6363 "columnsize" "bigint" 64 0 6368 NULL true
7 NULL
+6364 "heapsize" "bigint" 64 0 6368 NULL true
8 NULL
+6365 "hashes" "bigint" 64 0 6368 NULL true
9 NULL
+6366 "imprints" "bigint" 64 0 6368 NULL true
10 NULL
+6367 "sorted" "boolean" 1 0 6368 NULL true
11 NULL
+6370 "schema" "clob" 0 0 6380 NULL true 0
NULL
+6371 "table" "clob" 0 0 6380 NULL true 1 NULL
+6372 "column" "clob" 0 0 6380 NULL true 2
NULL
+6373 "type" "clob" 0 0 6380 NULL true 3 NULL
+6374 "typewidth" "int" 32 0 6380 NULL true 4
NULL
+6375 "count" "bigint" 64 0 6380 NULL true 5
NULL
+6376 "distinct" "bigint" 64 0 6380 NULL true
6 NULL
+6377 "atomwidth" "int" 32 0 6380 NULL true 7
NULL
+6378 "reference" "boolean" 1 0 6380 NULL true
8 NULL
+6379 "sorted" "boolean" 1 0 6380 NULL true
9 NULL
+6418 "schema" "clob" 0 0 6428 NULL true 0
NULL
+6419 "table" "clob" 0 0 6428 NULL true 1 NULL
+6420 "column" "clob" 0 0 6428 NULL true 2
NULL
+6421 "type" "clob" 0 0 6428 NULL true 3 NULL
+6422 "count" "bigint" 64 0 6428 NULL true 4
NULL
+6423 "columnsize" "bigint" 64 0 6428 NULL true
5 NULL
+6424 "heapsize" "bigint" 64 0 6428 NULL true
6 NULL
+6425 "hashes" "bigint" 64 0 6428 NULL true
7 NULL
+6426 "imprints" "bigint" 64 0 6428 NULL true
8 NULL
+6427 "sorted" "boolean" 1 0 6428 NULL true
9 NULL
+6430 "schema" "clob" 0 0 6438 NULL true 0
NULL
+6431 "table" "clob" 0 0 6438 NULL true 1 NULL
+6432 "count" "bigint" 64 0 6438 NULL true 2
NULL
+6433 "columnsize" "bigint" 64 0 6438 NULL true
3 NULL
+6434 "heapsize" "bigint" 64 0 6438 NULL true
4 NULL
+6435 "hashes" "bigint" 64 0 6438 NULL true
5 NULL
+6436 "imprints" "bigint" 64 0 6438 NULL true
6 NULL
+6437 "auxillary" "bigint" 53 0 6438 NULL true
7 NULL
+6440 "schema" "clob" 0 0 6453 NULL true 0
NULL
+6441 "table" "clob" 0 0 6453 NULL true 1 NULL
+6442 "column" "clob" 0 0 6453 NULL true 2
NULL
+6443 "type" "clob" 0 0 6453 NULL true 3 NULL
+6444 "width" "int" 32 0 6453 NULL true 4 NULL
+6445 "stamp" "timestamp" 7 0 6453 NULL true 5
NULL
+6446 "sample" "bigint" 64 0 6453 NULL true
6 NULL
+6447 "count" "bigint" 64 0 6453 NULL true 7
NULL
+6448 "unique" "bigint" 64 0 6453 NULL true
8 NULL
+6449 "nils" "bigint" 64 0 6453 NULL true 9
NULL
+6450 "minval" "clob" 0 0 6453 NULL true 10
NULL
+6451 "maxval" "clob" 0 0 6453 NULL true 11
NULL
+6452 "sorted" "boolean" 1 0 6453 NULL true
12 NULL
+6506 "function_id" "int" 32 0 6507 NULL true 0
NULL
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."_tables" (
@@ -1781,12 +1781,12 @@ 5591 "sessions" 2000 "create view sys.se
5671 "optimizers" 2000 "create view sys.optimizers as select * from
sys.optimizers();" 1 true 0 false
5679 "environment" 2000 "create view sys.environment as select * from
sys.environment();" 1 true 0 false
5717 "queue" 2000 "create view sys.queue as select * from sys.queue();"
1 true 0 false
-6364 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
-6376 "storagemodelinput" 2000 NULL 0 true 0 false
-6424 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
-6434 "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
-6449 "statistics" 2000 NULL 0 true 0 false
-6503 "systemfunctions" 2000 NULL 0 true 0 false
+6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false
+6380 "storagemodelinput" 2000 NULL 0 true 0 false
+6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false
+6438 "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
+6453 "statistics" 2000 NULL 0 true 0 false
+6507 "systemfunctions" 2000 NULL 0 true 0 false
COMMIT;
START TRANSACTION;
CREATE TABLE "sys"."args" (
@@ -1799,7 +1799,7 @@ CREATE TABLE "sys"."args" (
"inout" TINYINT,
"number" INTEGER
);
-COPY 3654 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"';
+COPY 3656 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
2157 29 "res_0" "oid" 63 0 0 0
@@ -5385,75 +5385,77 @@ 6316 6314 "js" "json" 0 0 1
1
6319 6318 "result" "clob" 0 0 0 0
6320 6318 "x" "clob" 0 0 1 1
6323 6322 "result" "clob" 0 0 0 0
-6324 6322 "v" "clob" 0 0 1 1
-6328 6327 "result" "uuid" 0 0 0 0
-6331 6330 "result" "uuid" 0 0 0 0
-6332 6330 "u" "uuid" 0 0 1 1
+6324 6322 "x" "double" 53 0 1 1
+6327 6326 "result" "clob" 0 0 0 0
+6328 6326 "v" "clob" 0 0 1 1
+6332 6331 "result" "uuid" 0 0 0 0
6335 6334 "result" "uuid" 0 0 0 0
-6336 6334 "u" "clob" 0 0 1 1
-6339 6338 "schema" "clob" 0 0 0 0
-6340 6338 "table" "clob" 0 0 0 1
-6341 6338 "column" "clob" 0 0 0 2
-6342 6338 "type" "clob" 0 0 0 3
-6343 6338 "location" "clob" 0 0 0 4
-6344 6338 "count" "bigint" 64 0 0 5
-6345 6338 "typewidth" "int" 32 0 0 6
-6346 6338 "columnsize" "bigint" 64 0 0 7
-6347 6338 "heapsize" "bigint" 64 0 0 8
-6348 6338 "hashes" "bigint" 64 0 0 9
-6349 6338 "imprints" "bigint" 64 0 0 10
-6350 6338 "sorted" "boolean" 1 0 0 11
-6381 6380 "result" "bigint" 64 0 0 0
-6382 6380 "nme" "clob" 0 0 1 1
-6383 6380 "i" "bigint" 64 0 1 2
-6384 6380 "d" "bigint" 64 0 1 3
-6387 6386 "result" "bigint" 64 0 0 0
-6388 6386 "tpe" "clob" 0 0 1 1
-6389 6386 "i" "bigint" 64 0 1 2
-6390 6386 "w" "int" 32 0 1 3
-6393 6392 "result" "bigint" 64 0 0 0
-6394 6392 "b" "boolean" 1 0 1 1
-6395 6392 "i" "bigint" 64 0 1 2
-6398 6397 "result" "bigint" 64 0 0 0
-6399 6397 "i" "bigint" 64 0 1 1
-6400 6397 "nme" "clob" 0 0 1 2
-6403 6402 "schema" "clob" 0 0 0 0
-6404 6402 "table" "clob" 0 0 0 1
-6405 6402 "column" "clob" 0 0 0 2
-6406 6402 "type" "clob" 0 0 0 3
-6407 6402 "count" "bigint" 64 0 0 4
-6408 6402 "columnsize" "bigint" 64 0 0 5
-6409 6402 "heapsize" "bigint" 64 0 0 6
-6410 6402 "hashes" "bigint" 64 0 0 7
-6411 6402 "imprints" "bigint" 64 0 0 8
-6412 6402 "sorted" "boolean" 1 0 0 9
-6454 6453 "tbl" "clob" 0 0 1 0
-6457 6456 "sch" "clob" 0 0 1 0
-6458 6456 "tbl" "clob" 0 0 1 1
+6336 6334 "u" "uuid" 0 0 1 1
+6339 6338 "result" "uuid" 0 0 0 0
+6340 6338 "u" "clob" 0 0 1 1
+6343 6342 "schema" "clob" 0 0 0 0
+6344 6342 "table" "clob" 0 0 0 1
+6345 6342 "column" "clob" 0 0 0 2
+6346 6342 "type" "clob" 0 0 0 3
+6347 6342 "location" "clob" 0 0 0 4
+6348 6342 "count" "bigint" 64 0 0 5
+6349 6342 "typewidth" "int" 32 0 0 6
+6350 6342 "columnsize" "bigint" 64 0 0 7
+6351 6342 "heapsize" "bigint" 64 0 0 8
+6352 6342 "hashes" "bigint" 64 0 0 9
+6353 6342 "imprints" "bigint" 64 0 0 10
+6354 6342 "sorted" "boolean" 1 0 0 11
+6385 6384 "result" "bigint" 64 0 0 0
+6386 6384 "nme" "clob" 0 0 1 1
+6387 6384 "i" "bigint" 64 0 1 2
+6388 6384 "d" "bigint" 64 0 1 3
+6391 6390 "result" "bigint" 64 0 0 0
+6392 6390 "tpe" "clob" 0 0 1 1
+6393 6390 "i" "bigint" 64 0 1 2
+6394 6390 "w" "int" 32 0 1 3
+6397 6396 "result" "bigint" 64 0 0 0
+6398 6396 "b" "boolean" 1 0 1 1
+6399 6396 "i" "bigint" 64 0 1 2
+6402 6401 "result" "bigint" 64 0 0 0
+6403 6401 "i" "bigint" 64 0 1 1
+6404 6401 "nme" "clob" 0 0 1 2
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
