Changeset: 4f38dc357f08 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4f38dc357f08
Modified Files:
clients/Tests/SQL-dump_all.stable.out.oid32
clients/Tests/SQL-dump_geom.stable.out.64bit.oid32
Branch: default
Log Message:
Approved oid32 clients tests.
diffs (truncated from 6246 to 300 lines):
diff --git a/clients/Tests/SQL-dump_all.stable.out.oid32
b/clients/Tests/SQL-dump_all.stable.out.oid32
--- a/clients/Tests/SQL-dump_all.stable.out.oid32
+++ b/clients/Tests/SQL-dump_all.stable.out.oid32
@@ -821,7 +821,8 @@ create function "host" (p inet) returns
external name inet."host";
create function "hostmask" (p inet) returns inet
external name inet."hostmask";
-create filter function "ilike"(val string, pat string, esc string) external
name algebra.ilikesubselect;
+create filter function "ilike"(val string, pat string, esc string) external
name algebra."ilike";
+create filter function "ilike"(val string, pat string) external name
algebra."ilike";
create function sys.imprintsize(i bigint, nme string)
returns bigint
begin
@@ -868,7 +869,8 @@ create function length(g geometry) retur
-- Copyright August 2008-2014 MonetDB B.V.
-- All Rights Reserved.
-create filter function "like"(val string, pat string, esc string) external
name algebra.likesubselect;
+create filter function "like"(val string, pat string, esc string) external
name algebra."like";
+create filter function "like"(val string, pat string) external name
algebra."like";
create function linefromtext(wkt string, srid smallint) returns linestring
external name geom."LineFromText";
create function "masklen" (p inet) returns int
external name inet."masklen";
@@ -1730,167 +1732,167 @@ 5228 "auth_id" "int" 32 0 5226
NULL true
5229 "privileges" "int" 32 0 5226 NULL true 2
NULL
5230 "grantor" "int" 32 0 5226 NULL true 3
NULL
5231 "grantable" "int" 32 0 5226 NULL true 4
NULL
-5392 "id" "oid" 31 0 5399 NULL true 0 NULL
-5393 "owner" "clob" 0 0 5399 NULL true 1 NULL
-5394 "defined" "timestamp" 7 0 5399 NULL true
2 NULL
-5395 "query" "clob" 0 0 5399 NULL true 3 NULL
-5396 "pipe" "clob" 0 0 5399 NULL true 4 NULL
-5397 "mal" "int" 32 0 5399 NULL true 5 NULL
-5398 "optimize" "bigint" 64 0 5399 NULL true
6 NULL
-5401 "id" "oid" 31 0 5411 NULL true 0 NULL
-5402 "start" "timestamp" 7 0 5411 NULL true 1
NULL
-5403 "stop" "timestamp" 7 0 5411 NULL true 2
NULL
-5404 "arguments" "clob" 0 0 5411 NULL true 3
NULL
-5405 "tuples" "wrd" 64 0 5411 NULL true 4
NULL
-5406 "run" "bigint" 64 0 5411 NULL true 5
NULL
-5407 "ship" "bigint" 64 0 5411 NULL true 6
NULL
-5408 "cpu" "int" 32 0 5411 NULL true 7 NULL
-5409 "io" "int" 32 0 5411 NULL true 8 NULL
-5410 "space" "bigint" 64 0 5411 NULL true 9
NULL
-5413 "id" "oid" 31 0 5429 NULL true 0 NULL
-5414 "owner" "clob" 0 0 5429 NULL true 1 NULL
-5415 "defined" "timestamp" 7 0 5429 NULL true
2 NULL
-5416 "query" "clob" 0 0 5429 NULL true 3 NULL
-5417 "pipe" "clob" 0 0 5429 NULL true 4 NULL
-5418 "mal" "int" 32 0 5429 NULL true 5 NULL
-5419 "optimize" "bigint" 64 0 5429 NULL true
6 NULL
-5420 "start" "timestamp" 7 0 5429 NULL true 7
NULL
-5421 "stop" "timestamp" 7 0 5429 NULL true 8
NULL
-5422 "arguments" "clob" 0 0 5429 NULL true 9
NULL
-5423 "tuples" "wrd" 64 0 5429 NULL true 10
NULL
-5424 "run" "bigint" 64 0 5429 NULL true 11
NULL
-5425 "ship" "bigint" 64 0 5429 NULL true 12
NULL
-5426 "cpu" "int" 32 0 5429 NULL true 13 NULL
-5427 "space" "bigint" 64 0 5429 NULL true 14
NULL
-5428 "io" "int" 32 0 5429 NULL true 15 NULL
-5454 "event" "int" 32 0 5466 NULL true 0 NULL
-5455 "clk" "varchar" 20 0 5466 NULL true 1
NULL
-5456 "pc" "varchar" 50 0 5466 NULL true 2
NULL
-5457 "thread" "int" 32 0 5466 NULL true 3
NULL
-5458 "user" "int" 32 0 5466 NULL true 4 NULL
-5459 "ticks" "bigint" 64 0 5466 NULL true 5
NULL
-5460 "reads" "bigint" 64 0 5466 NULL true 6
NULL
-5461 "writes" "bigint" 64 0 5466 NULL true
7 NULL
-5462 "rbytes" "bigint" 64 0 5466 NULL true
8 NULL
-5463 "wbytes" "bigint" 64 0 5466 NULL true
9 NULL
-5464 "type" "clob" 0 0 5466 NULL true 10 NULL
-5465 "stmt" "clob" 0 0 5466 NULL true 11 NULL
-5585 "user" "clob" 0 0 5591 NULL true 0 NULL
-5586 "login" "timestamp" 7 0 5591 NULL true 1
NULL
-5587 "sessiontimeout" "bigint" 64 0 5591 NULL
true 2 NULL
-5588 "lastcommand" "timestamp" 7 0 5591 NULL true
3 NULL
-5589 "querytimeout" "bigint" 64 0 5591 NULL true
4 NULL
-5590 "active" "boolean" 1 0 5591 NULL true
5 NULL
-5668 "name" "clob" 0 0 5671 NULL true 0 NULL
-5669 "def" "clob" 0 0 5671 NULL true 1 NULL
-5670 "status" "clob" 0 0 5671 NULL true 2
NULL
-5677 "name" "clob" 0 0 5679 NULL true 0 NULL
-5678 "value" "clob" 0 0 5679 NULL true 1 NULL
-5709 "qtag" "bigint" 64 0 5717 NULL true 0
NULL
-5710 "user" "clob" 0 0 5717 NULL true 1 NULL
-5711 "started" "timestamp" 7 0 5717 NULL true
2 NULL
-5712 "estimate" "timestamp" 7 0 5717 NULL true
3 NULL
-5713 "progress" "int" 32 0 5717 NULL true 4
NULL
-5714 "status" "clob" 0 0 5717 NULL true 5
NULL
-5715 "tag" "oid" 31 0 5717 NULL true 6 NULL
-5716 "query" "clob" 0 0 5717 NULL true 7 NULL
-6361 "schema" "clob" 0 0 6373 NULL true 0
NULL
-6362 "table" "clob" 0 0 6373 NULL true 1 NULL
-6363 "column" "clob" 0 0 6373 NULL true 2
NULL
-6364 "type" "clob" 0 0 6373 NULL true 3 NULL
-6365 "location" "clob" 0 0 6373 NULL true 4
NULL
-6366 "count" "bigint" 64 0 6373 NULL true 5
NULL
-6367 "typewidth" "int" 32 0 6373 NULL true 6
NULL
-6368 "columnsize" "bigint" 64 0 6373 NULL true
7 NULL
-6369 "heapsize" "bigint" 64 0 6373 NULL true
8 NULL
-6370 "hashes" "bigint" 64 0 6373 NULL true
9 NULL
-6371 "imprints" "bigint" 64 0 6373 NULL true
10 NULL
-6372 "sorted" "boolean" 1 0 6373 NULL true
11 NULL
-6375 "schema" "clob" 0 0 6385 NULL true 0
NULL
-6376 "table" "clob" 0 0 6385 NULL true 1 NULL
-6377 "column" "clob" 0 0 6385 NULL true 2
NULL
-6378 "type" "clob" 0 0 6385 NULL true 3 NULL
-6379 "typewidth" "int" 32 0 6385 NULL true 4
NULL
-6380 "count" "bigint" 64 0 6385 NULL true 5
NULL
-6381 "distinct" "bigint" 64 0 6385 NULL true
6 NULL
-6382 "atomwidth" "int" 32 0 6385 NULL true 7
NULL
-6383 "reference" "boolean" 1 0 6385 NULL true
8 NULL
-6384 "sorted" "boolean" 1 0 6385 NULL true
9 NULL
-6423 "schema" "clob" 0 0 6433 NULL true 0
NULL
-6424 "table" "clob" 0 0 6433 NULL true 1 NULL
-6425 "column" "clob" 0 0 6433 NULL true 2
NULL
-6426 "type" "clob" 0 0 6433 NULL true 3 NULL
-6427 "count" "bigint" 64 0 6433 NULL true 4
NULL
-6428 "columnsize" "bigint" 64 0 6433 NULL true
5 NULL
-6429 "heapsize" "bigint" 64 0 6433 NULL true
6 NULL
-6430 "hashes" "bigint" 64 0 6433 NULL true
7 NULL
-6431 "imprints" "bigint" 64 0 6433 NULL true
8 NULL
-6432 "sorted" "boolean" 1 0 6433 NULL true
9 NULL
-6435 "schema" "clob" 0 0 6443 NULL true 0
NULL
-6436 "table" "clob" 0 0 6443 NULL true 1 NULL
-6437 "count" "bigint" 64 0 6443 NULL true 2
NULL
-6438 "columnsize" "bigint" 64 0 6443 NULL true
3 NULL
-6439 "heapsize" "bigint" 64 0 6443 NULL true
4 NULL
-6440 "hashes" "bigint" 64 0 6443 NULL true
5 NULL
-6441 "imprints" "bigint" 64 0 6443 NULL true
6 NULL
-6442 "auxillary" "bigint" 53 0 6443 NULL true
7 NULL
-6445 "schema" "clob" 0 0 6458 NULL true 0
NULL
-6446 "table" "clob" 0 0 6458 NULL true 1 NULL
-6447 "column" "clob" 0 0 6458 NULL true 2
NULL
-6448 "type" "clob" 0 0 6458 NULL true 3 NULL
-6449 "width" "int" 32 0 6458 NULL true 4 NULL
-6450 "stamp" "timestamp" 7 0 6458 NULL true 5
NULL
-6451 "sample" "bigint" 64 0 6458 NULL true
6 NULL
-6452 "count" "bigint" 64 0 6458 NULL true 7
NULL
-6453 "unique" "bigint" 64 0 6458 NULL true
8 NULL
-6454 "nils" "bigint" 64 0 6458 NULL true 9
NULL
-6455 "minval" "clob" 0 0 6458 NULL true 10
NULL
-6456 "maxval" "clob" 0 0 6458 NULL true 11
NULL
-6457 "sorted" "boolean" 1 0 6458 NULL true
12 NULL
-6553 "file_id" "bigint" 64 0 6561 NULL false
0 NULL
-6554 "file_location" "clob" 0 0 6561 NULL false 1
NULL
-6555 "dbschema" "smallint" 16 0 6561 NULL false
2 NULL
-6556 "format_version" "varchar" 7 0 6561 NULL
true 3 NULL
-6557 "sorting_order" "varchar" 10 0 6561 NULL true
4 NULL
-6558 "comments" "clob" 0 0 6561 NULL true 5
NULL
-6563 "sn" "clob" 0 0 6574 NULL false 0 NULL
-6564 "file_id" "bigint" 64 0 6574 NULL false
1 NULL
-6565 "ln" "int" 32 0 6574 NULL true 2 NULL
-6566 "as" "int" 32 0 6574 NULL true 3 NULL
-6567 "m5" "clob" 0 0 6574 NULL true 4 NULL
-6568 "sp" "clob" 0 0 6574 NULL true 5 NULL
-6569 "ur" "clob" 0 0 6574 NULL true 6 NULL
-6576 "id" "clob" 0 0 6593 NULL false 0 NULL
-6577 "file_id" "bigint" 64 0 6593 NULL false
1 NULL
-6578 "cn" "clob" 0 0 6593 NULL true 2 NULL
-6579 "ds" "clob" 0 0 6593 NULL true 3 NULL
-6580 "dt" "timestamp" 7 0 6593 NULL true 4
NULL
-6581 "fo" "clob" 0 0 6593 NULL true 5 NULL
-6582 "ks" "clob" 0 0 6593 NULL true 6 NULL
-6583 "lb" "clob" 0 0 6593 NULL true 7 NULL
-6584 "pg" "clob" 0 0 6593 NULL true 8 NULL
-6585 "pi" "int" 32 0 6593 NULL true 9 NULL
-6586 "pl" "clob" 0 0 6593 NULL true 10 NULL
-6587 "pu" "clob" 0 0 6593 NULL true 11 NULL
-6588 "sm" "clob" 0 0 6593 NULL true 12 NULL
-6595 "id" "clob" 0 0 6605 NULL false 0 NULL
-6596 "file_id" "bigint" 64 0 6605 NULL false
1 NULL
-6597 "pn" "clob" 0 0 6605 NULL true 2 NULL
-6598 "cl" "clob" 0 0 6605 NULL true 3 NULL
-6599 "pp" "clob" 0 0 6605 NULL true 4 NULL
-6600 "vn" "clob" 0 0 6605 NULL true 5 NULL
-6607 "qname" "clob" 0 0 6618 NULL false 0 NULL
-6608 "flag" "smallint" 16 0 6618 NULL false 1
NULL
-6609 "rname" "clob" 0 0 6618 NULL false 2 NULL
-6610 "pos" "int" 32 0 6618 NULL false 3 NULL
-6611 "mapq" "smallint" 16 0 6618 NULL false 4
NULL
-6612 "cigar" "clob" 0 0 6618 NULL false 5 NULL
-6613 "rnext" "clob" 0 0 6618 NULL false 6 NULL
-6614 "pnext" "int" 32 0 6618 NULL false 7 NULL
-6615 "tlen" "int" 32 0 6618 NULL false 8 NULL
-6616 "seq" "clob" 0 0 6618 NULL false 9 NULL
-6617 "qual" "clob" 0 0 6618 NULL false 10 NULL
-6688 "function_id" "int" 32 0 6689 NULL true 0
NULL
+5400 "id" "oid" 31 0 5407 NULL true 0 NULL
+5401 "owner" "clob" 0 0 5407 NULL true 1 NULL
+5402 "defined" "timestamp" 7 0 5407 NULL true
2 NULL
+5403 "query" "clob" 0 0 5407 NULL true 3 NULL
+5404 "pipe" "clob" 0 0 5407 NULL true 4 NULL
+5405 "mal" "int" 32 0 5407 NULL true 5 NULL
+5406 "optimize" "bigint" 64 0 5407 NULL true
6 NULL
+5409 "id" "oid" 31 0 5419 NULL true 0 NULL
+5410 "start" "timestamp" 7 0 5419 NULL true 1
NULL
+5411 "stop" "timestamp" 7 0 5419 NULL true 2
NULL
+5412 "arguments" "clob" 0 0 5419 NULL true 3
NULL
+5413 "tuples" "wrd" 64 0 5419 NULL true 4
NULL
+5414 "run" "bigint" 64 0 5419 NULL true 5
NULL
+5415 "ship" "bigint" 64 0 5419 NULL true 6
NULL
+5416 "cpu" "int" 32 0 5419 NULL true 7 NULL
+5417 "io" "int" 32 0 5419 NULL true 8 NULL
+5418 "space" "bigint" 64 0 5419 NULL true 9
NULL
+5421 "id" "oid" 31 0 5437 NULL true 0 NULL
+5422 "owner" "clob" 0 0 5437 NULL true 1 NULL
+5423 "defined" "timestamp" 7 0 5437 NULL true
2 NULL
+5424 "query" "clob" 0 0 5437 NULL true 3 NULL
+5425 "pipe" "clob" 0 0 5437 NULL true 4 NULL
+5426 "mal" "int" 32 0 5437 NULL true 5 NULL
+5427 "optimize" "bigint" 64 0 5437 NULL true
6 NULL
+5428 "start" "timestamp" 7 0 5437 NULL true 7
NULL
+5429 "stop" "timestamp" 7 0 5437 NULL true 8
NULL
+5430 "arguments" "clob" 0 0 5437 NULL true 9
NULL
+5431 "tuples" "wrd" 64 0 5437 NULL true 10
NULL
+5432 "run" "bigint" 64 0 5437 NULL true 11
NULL
+5433 "ship" "bigint" 64 0 5437 NULL true 12
NULL
+5434 "cpu" "int" 32 0 5437 NULL true 13 NULL
+5435 "space" "bigint" 64 0 5437 NULL true 14
NULL
+5436 "io" "int" 32 0 5437 NULL true 15 NULL
+5462 "event" "int" 32 0 5474 NULL true 0 NULL
+5463 "clk" "varchar" 20 0 5474 NULL true 1
NULL
+5464 "pc" "varchar" 50 0 5474 NULL true 2
NULL
+5465 "thread" "int" 32 0 5474 NULL true 3
NULL
+5466 "user" "int" 32 0 5474 NULL true 4 NULL
+5467 "ticks" "bigint" 64 0 5474 NULL true 5
NULL
+5468 "reads" "bigint" 64 0 5474 NULL true 6
NULL
+5469 "writes" "bigint" 64 0 5474 NULL true
7 NULL
+5470 "rbytes" "bigint" 64 0 5474 NULL true
8 NULL
+5471 "wbytes" "bigint" 64 0 5474 NULL true
9 NULL
+5472 "type" "clob" 0 0 5474 NULL true 10 NULL
+5473 "stmt" "clob" 0 0 5474 NULL true 11 NULL
+5593 "user" "clob" 0 0 5599 NULL true 0 NULL
+5594 "login" "timestamp" 7 0 5599 NULL true 1
NULL
+5595 "sessiontimeout" "bigint" 64 0 5599 NULL
true 2 NULL
+5596 "lastcommand" "timestamp" 7 0 5599 NULL true
3 NULL
+5597 "querytimeout" "bigint" 64 0 5599 NULL true
4 NULL
+5598 "active" "boolean" 1 0 5599 NULL true
5 NULL
+5676 "name" "clob" 0 0 5679 NULL true 0 NULL
+5677 "def" "clob" 0 0 5679 NULL true 1 NULL
+5678 "status" "clob" 0 0 5679 NULL true 2
NULL
+5685 "name" "clob" 0 0 5687 NULL true 0 NULL
+5686 "value" "clob" 0 0 5687 NULL true 1 NULL
+5717 "qtag" "bigint" 64 0 5725 NULL true 0
NULL
+5718 "user" "clob" 0 0 5725 NULL true 1 NULL
+5719 "started" "timestamp" 7 0 5725 NULL true
2 NULL
+5720 "estimate" "timestamp" 7 0 5725 NULL true
3 NULL
+5721 "progress" "int" 32 0 5725 NULL true 4
NULL
+5722 "status" "clob" 0 0 5725 NULL true 5
NULL
+5723 "tag" "oid" 31 0 5725 NULL true 6 NULL
+5724 "query" "clob" 0 0 5725 NULL true 7 NULL
+6369 "schema" "clob" 0 0 6381 NULL true 0
NULL
+6370 "table" "clob" 0 0 6381 NULL true 1 NULL
+6371 "column" "clob" 0 0 6381 NULL true 2
NULL
+6372 "type" "clob" 0 0 6381 NULL true 3 NULL
+6373 "location" "clob" 0 0 6381 NULL true 4
NULL
+6374 "count" "bigint" 64 0 6381 NULL true 5
NULL
+6375 "typewidth" "int" 32 0 6381 NULL true 6
NULL
+6376 "columnsize" "bigint" 64 0 6381 NULL true
7 NULL
+6377 "heapsize" "bigint" 64 0 6381 NULL true
8 NULL
+6378 "hashes" "bigint" 64 0 6381 NULL true
9 NULL
+6379 "imprints" "bigint" 64 0 6381 NULL true
10 NULL
+6380 "sorted" "boolean" 1 0 6381 NULL true
11 NULL
+6383 "schema" "clob" 0 0 6393 NULL true 0
NULL
+6384 "table" "clob" 0 0 6393 NULL true 1 NULL
+6385 "column" "clob" 0 0 6393 NULL true 2
NULL
+6386 "type" "clob" 0 0 6393 NULL true 3 NULL
+6387 "typewidth" "int" 32 0 6393 NULL true 4
NULL
+6388 "count" "bigint" 64 0 6393 NULL true 5
NULL
+6389 "distinct" "bigint" 64 0 6393 NULL true
6 NULL
+6390 "atomwidth" "int" 32 0 6393 NULL true 7
NULL
+6391 "reference" "boolean" 1 0 6393 NULL true
8 NULL
+6392 "sorted" "boolean" 1 0 6393 NULL true
9 NULL
+6431 "schema" "clob" 0 0 6441 NULL true 0
NULL
+6432 "table" "clob" 0 0 6441 NULL true 1 NULL
+6433 "column" "clob" 0 0 6441 NULL true 2
NULL
+6434 "type" "clob" 0 0 6441 NULL true 3 NULL
+6435 "count" "bigint" 64 0 6441 NULL true 4
NULL
+6436 "columnsize" "bigint" 64 0 6441 NULL true
5 NULL
+6437 "heapsize" "bigint" 64 0 6441 NULL true
6 NULL
+6438 "hashes" "bigint" 64 0 6441 NULL true
7 NULL
+6439 "imprints" "bigint" 64 0 6441 NULL true
8 NULL
+6440 "sorted" "boolean" 1 0 6441 NULL true
9 NULL
+6443 "schema" "clob" 0 0 6451 NULL true 0
NULL
+6444 "table" "clob" 0 0 6451 NULL true 1 NULL
+6445 "count" "bigint" 64 0 6451 NULL true 2
NULL
+6446 "columnsize" "bigint" 64 0 6451 NULL true
3 NULL
+6447 "heapsize" "bigint" 64 0 6451 NULL true
4 NULL
+6448 "hashes" "bigint" 64 0 6451 NULL true
5 NULL
+6449 "imprints" "bigint" 64 0 6451 NULL true
6 NULL
+6450 "auxillary" "bigint" 53 0 6451 NULL true
7 NULL
+6453 "schema" "clob" 0 0 6466 NULL true 0
NULL
+6454 "table" "clob" 0 0 6466 NULL true 1 NULL
+6455 "column" "clob" 0 0 6466 NULL true 2
NULL
+6456 "type" "clob" 0 0 6466 NULL true 3 NULL
+6457 "width" "int" 32 0 6466 NULL true 4 NULL
+6458 "stamp" "timestamp" 7 0 6466 NULL true 5
NULL
+6459 "sample" "bigint" 64 0 6466 NULL true
6 NULL
+6460 "count" "bigint" 64 0 6466 NULL true 7
NULL
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
