Changeset: 7e4b0e9bac77 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7e4b0e9bac77
Modified Files:
clients/Tests/SQL-dump.stable.out
monetdb5/modules/mal/Tests/remote03.stable.out
sql/test/Tests/systemfunctions.stable.out
sql/test/pg_regress/Tests/box.stable.err
sql/test/pg_regress/Tests/box.stable.out
Branch: geo
Log Message:
Approved some tests (64 bit)
diffs (truncated from 12962 to 300 lines):
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
@@ -1046,13 +1046,6 @@ create procedure sys.pause(tag int)
external name sql.sysmon_pause;
create procedure sys.pause(tag bigint)
external name sql.sysmon_pause;
-create function point(x double,y double) returns point external name
geom.point;
-create function pointfromtext(wkt string, srid smallint) returns point
external name geom."PointFromText";
-create function polyfromtext(wkt string, srid smallint) returns polygon
external name geom."PolyFromText";
--- alias
-create function polygonfromtext(wkt string, srid smallint) returns polygon
external name geom."PolyFromText";
-create procedure profiler_openstream(host string, port int) external name
profiler."openStream";
-create procedure profiler_stethoscope(ticks int) external name
profiler.stethoscope;
create aggregate quantile(val tinyint, q double) returns tinyint
external name "aggr"."quantile";
create aggregate quantile(val smallint, q double) returns smallint
@@ -1631,234 +1624,246 @@ 2149 "statement" "varchar" 2048 0
2139 N
2151 "id" "int" 32 0 2150 NULL true 0 NULL
2152 "name" "varchar" 1024 0 2150 NULL true 1
NULL
2153 "nr" "int" 32 0 2150 NULL true 2 NULL
-5205 "id" "int" 32 0 5204 NULL true 0 NULL
-5206 "name" "varchar" 1024 0 5204 NULL true 1
NULL
-5207 "schema_id" "int" 32 0 5204 NULL true 2
NULL
-5208 "query" "varchar" 2048 0 5204 NULL true 3
NULL
-5209 "type" "smallint" 16 0 5204 NULL true 4
NULL
-5210 "system" "boolean" 1 0 5204 NULL true
5 NULL
-5211 "commit_action" "smallint" 16 0 5204 NULL true
6 NULL
-5212 "access" "smallint" 16 0 5204 NULL true
7 NULL
-5213 "temporary" "smallint" 16 0 5204 NULL true
8 NULL
-5215 "id" "int" 32 0 5214 NULL true 0 NULL
-5216 "name" "varchar" 1024 0 5214 NULL true 1
NULL
-5217 "type" "varchar" 1024 0 5214 NULL true 2
NULL
-5218 "type_digits" "int" 32 0 5214 NULL true 3
NULL
-5219 "type_scale" "int" 32 0 5214 NULL true 4
NULL
-5220 "table_id" "int" 32 0 5214 NULL true 5
NULL
-5221 "default" "varchar" 2048 0 5214 NULL true
6 NULL
-5222 "null" "boolean" 1 0 5214 NULL true 7
NULL
-5223 "number" "int" 32 0 5214 NULL true 8
NULL
-5224 "storage" "varchar" 2048 0 5214 NULL true
9 NULL
-5231 "name" "varchar" 1024 0 5230 NULL true 0
NULL
-5232 "fullname" "varchar" 2048 0 5230 NULL true
1 NULL
-5233 "default_schema" "int" 9 0 5230 NULL true
2 NULL
-5237 "name" "varchar" 1024 0 5236 NULL true 0
NULL
-5238 "fullname" "varchar" 2024 0 5236 NULL true
1 NULL
-5239 "default_schema" "int" 9 0 5236 NULL true
2 NULL
-5241 "login_id" "int" 32 0 5240 NULL true 0
NULL
-5242 "role_id" "int" 32 0 5240 NULL true 1
NULL
-5244 "id" "int" 32 0 5243 NULL true 0 NULL
-5245 "name" "varchar" 1024 0 5243 NULL true 1
NULL
-5246 "grantor" "int" 32 0 5243 NULL true 2
NULL
-5248 "obj_id" "int" 32 0 5247 NULL true 0
NULL
-5249 "auth_id" "int" 32 0 5247 NULL true 1
NULL
-5250 "privileges" "int" 32 0 5247 NULL true 2
NULL
-5251 "grantor" "int" 32 0 5247 NULL true 3
NULL
-5252 "grantable" "int" 32 0 5247 NULL true 4
NULL
-5461 "id" "oid" 63 0 5469 NULL true 0 NULL
-5462 "owner" "clob" 0 0 5469 NULL true 1 NULL
-5463 "defined" "timestamp" 7 0 5469 NULL true
2 NULL
-5464 "query" "clob" 0 0 5469 NULL true 3 NULL
-5465 "pipe" "clob" 0 0 5469 NULL true 4 NULL
-5466 "plan" "clob" 0 0 5469 NULL true 5 NULL
-5467 "mal" "int" 32 0 5469 NULL true 6 NULL
-5468 "optimize" "bigint" 64 0 5469 NULL true
7 NULL
-5471 "id" "oid" 63 0 5480 NULL true 0 NULL
-5472 "start" "timestamp" 7 0 5480 NULL true 1
NULL
-5473 "stop" "timestamp" 7 0 5480 NULL true 2
NULL
-5474 "arguments" "clob" 0 0 5480 NULL true 3
NULL
-5475 "tuples" "wrd" 64 0 5480 NULL true 4
NULL
-5476 "run" "bigint" 64 0 5480 NULL true 5
NULL
-5477 "ship" "bigint" 64 0 5480 NULL true 6
NULL
-5478 "cpu" "int" 32 0 5480 NULL true 7 NULL
-5479 "io" "int" 32 0 5480 NULL true 8 NULL
-5482 "id" "oid" 63 0 5498 NULL true 0 NULL
-5483 "owner" "clob" 0 0 5498 NULL true 1 NULL
-5484 "defined" "timestamp" 7 0 5498 NULL true
2 NULL
-5485 "query" "clob" 0 0 5498 NULL true 3 NULL
-5486 "pipe" "clob" 0 0 5498 NULL true 4 NULL
-5487 "plan" "clob" 0 0 5498 NULL true 5 NULL
-5488 "mal" "int" 32 0 5498 NULL true 6 NULL
-5489 "optimize" "bigint" 64 0 5498 NULL true
7 NULL
-5490 "start" "timestamp" 7 0 5498 NULL true 8
NULL
-5491 "stop" "timestamp" 7 0 5498 NULL true 9
NULL
-5492 "arguments" "clob" 0 0 5498 NULL true 10
NULL
-5493 "tuples" "wrd" 64 0 5498 NULL true 11
NULL
-5494 "run" "bigint" 64 0 5498 NULL true 12
NULL
-5495 "ship" "bigint" 64 0 5498 NULL true 13
NULL
-5496 "cpu" "int" 32 0 5498 NULL true 14 NULL
-5497 "io" "int" 32 0 5498 NULL true 15 NULL
-5524 "event" "int" 32 0 5537 NULL true 0 NULL
-5525 "clk" "varchar" 20 0 5537 NULL true 1
NULL
-5526 "pc" "varchar" 50 0 5537 NULL true 2
NULL
-5527 "thread" "int" 32 0 5537 NULL true 3
NULL
-5528 "ticks" "bigint" 64 0 5537 NULL true 4
NULL
-5529 "rrsmb" "bigint" 64 0 5537 NULL true 5
NULL
-5530 "vmmb" "bigint" 64 0 5537 NULL true 6
NULL
-5531 "reads" "bigint" 64 0 5537 NULL true 7
NULL
-5532 "writes" "bigint" 64 0 5537 NULL true
8 NULL
-5533 "minflt" "bigint" 64 0 5537 NULL true
9 NULL
-5534 "majflt" "bigint" 64 0 5537 NULL true
10 NULL
-5535 "nvcsw" "bigint" 64 0 5537 NULL true 11
NULL
-5536 "stmt" "clob" 0 0 5537 NULL true 12 NULL
-5671 "user" "clob" 0 0 5677 NULL true 0 NULL
-5672 "login" "timestamp" 7 0 5677 NULL true 1
NULL
-5673 "sessiontimeout" "bigint" 64 0 5677 NULL
true 2 NULL
-5674 "lastcommand" "timestamp" 7 0 5677 NULL true
3 NULL
-5675 "querytimeout" "bigint" 64 0 5677 NULL true
4 NULL
-5676 "active" "boolean" 1 0 5677 NULL true
5 NULL
-5754 "name" "clob" 0 0 5757 NULL true 0 NULL
-5755 "def" "clob" 0 0 5757 NULL true 1 NULL
-5756 "status" "clob" 0 0 5757 NULL true 2
NULL
-5763 "name" "clob" 0 0 5765 NULL true 0 NULL
-5764 "value" "clob" 0 0 5765 NULL true 1 NULL
-5801 "qtag" "bigint" 64 0 5809 NULL true 0
NULL
-5802 "user" "clob" 0 0 5809 NULL true 1 NULL
-5803 "started" "timestamp" 7 0 5809 NULL true
2 NULL
-5804 "estimate" "timestamp" 7 0 5809 NULL true
3 NULL
-5805 "progress" "int" 32 0 5809 NULL true 4
NULL
-5806 "status" "clob" 0 0 5809 NULL true 5
NULL
-5807 "tag" "oid" 63 0 5809 NULL true 6 NULL
-5808 "query" "clob" 0 0 5809 NULL true 7 NULL
-5835 "rowid" "bigint" 64 0 5839 NULL true 0
NULL
-5836 "fldid" "int" 32 0 5839 NULL true 1 NULL
-5837 "message" "clob" 0 0 5839 NULL true 2
NULL
-5838 "input" "clob" 0 0 5839 NULL true 3 NULL
-6459 "keyword" "varchar" 40 0 6462 NULL false
0 NULL
-6464 "table_type_id" "smallint" 16 0 6470 NULL false
0 NULL
-6467 "table_type_name" "varchar" 25 0 6470 NULL
false 1 NULL
-6472 "dependency_type_id" "smallint" 16 0 6478 NULL
false 0 NULL
-6475 "dependency_type_name" "varchar" 15 0 6478 NULL
false 1 NULL
-6493 "file_id" "int" 32 0 6495 NULL true 0
NULL
-6494 "location" "char" 256 0 6495 NULL true 1
NULL
-6497 "dim_id" "int" 32 0 6501 NULL true 0
NULL
-6498 "file_id" "int" 32 0 6501 NULL true 1
NULL
-6499 "name" "varchar" 64 0 6501 NULL true 2
NULL
-6500 "length" "int" 32 0 6501 NULL true 3
NULL
-6503 "var_id" "int" 32 0 6509 NULL true 0
NULL
-6504 "file_id" "int" 32 0 6509 NULL true 1
NULL
-6505 "name" "varchar" 64 0 6509 NULL true 2
NULL
-6506 "vartype" "varchar" 64 0 6509 NULL true
3 NULL
-6507 "ndim" "int" 32 0 6509 NULL true 4 NULL
-6508 "coord_dim_id" "int" 32 0 6509 NULL true 5
NULL
-6511 "var_id" "int" 32 0 6515 NULL true 0
NULL
-6512 "dim_id" "int" 32 0 6515 NULL true 1
NULL
-6513 "file_id" "int" 32 0 6515 NULL true 2
NULL
-6514 "dimpos" "int" 32 0 6515 NULL true 3
NULL
-6517 "obj_name" "varchar" 256 0 6523 NULL true
0 NULL
-6518 "att_name" "varchar" 256 0 6523 NULL true
1 NULL
-6519 "att_type" "varchar" 64 0 6523 NULL true
2 NULL
-6520 "value" "clob" 0 0 6523 NULL true 3 NULL
-6521 "file_id" "int" 32 0 6523 NULL true 4
NULL
-6522 "gr_name" "varchar" 256 0 6523 NULL true
5 NULL
-6548 "schema" "clob" 0 0 6562 NULL true 0
NULL
-6549 "table" "clob" 0 0 6562 NULL true 1 NULL
-6550 "column" "clob" 0 0 6562 NULL true 2
NULL
-6551 "type" "clob" 0 0 6562 NULL true 3 NULL
-6552 "mode" "clob" 0 0 6562 NULL true 4 NULL
-6553 "location" "clob" 0 0 6562 NULL true 5
NULL
-6554 "count" "bigint" 64 0 6562 NULL true 6
NULL
-6555 "typewidth" "int" 32 0 6562 NULL true 7
NULL
-6556 "columnsize" "bigint" 64 0 6562 NULL true
8 NULL
-6557 "heapsize" "bigint" 64 0 6562 NULL true
9 NULL
-6558 "hashes" "bigint" 64 0 6562 NULL true
10 NULL
-6559 "phash" "boolean" 1 0 6562 NULL true 11
NULL
-6560 "imprints" "bigint" 64 0 6562 NULL true
12 NULL
-6561 "sorted" "boolean" 1 0 6562 NULL true
13 NULL
-6564 "schema" "clob" 0 0 6574 NULL true 0
NULL
-6565 "table" "clob" 0 0 6574 NULL true 1 NULL
-6566 "column" "clob" 0 0 6574 NULL true 2
NULL
-6567 "type" "clob" 0 0 6574 NULL true 3 NULL
-6568 "typewidth" "int" 32 0 6574 NULL true 4
NULL
-6569 "count" "bigint" 64 0 6574 NULL true 5
NULL
-6570 "distinct" "bigint" 64 0 6574 NULL true
6 NULL
-6571 "atomwidth" "int" 32 0 6574 NULL true 7
NULL
-6572 "reference" "boolean" 1 0 6574 NULL true
8 NULL
-6573 "sorted" "boolean" 1 0 6574 NULL true
9 NULL
-6612 "schema" "clob" 0 0 6622 NULL true 0
NULL
-6613 "table" "clob" 0 0 6622 NULL true 1 NULL
-6614 "column" "clob" 0 0 6622 NULL true 2
NULL
-6615 "type" "clob" 0 0 6622 NULL true 3 NULL
-6616 "count" "bigint" 64 0 6622 NULL true 4
NULL
-6617 "columnsize" "bigint" 64 0 6622 NULL true
5 NULL
-6618 "heapsize" "bigint" 64 0 6622 NULL true
6 NULL
-6619 "hashes" "bigint" 64 0 6622 NULL true
7 NULL
-6620 "imprints" "bigint" 64 0 6622 NULL true
8 NULL
-6621 "sorted" "boolean" 1 0 6622 NULL true
9 NULL
-6624 "schema" "clob" 0 0 6632 NULL true 0
NULL
-6625 "table" "clob" 0 0 6632 NULL true 1 NULL
-6626 "count" "bigint" 64 0 6632 NULL true 2
NULL
-6627 "columnsize" "bigint" 64 0 6632 NULL true
3 NULL
-6628 "heapsize" "bigint" 64 0 6632 NULL true
4 NULL
-6629 "hashes" "bigint" 64 0 6632 NULL true
5 NULL
-6630 "imprints" "bigint" 64 0 6632 NULL true
6 NULL
-6631 "auxiliary" "bigint" 64 0 6632 NULL true
7 NULL
-6634 "column_id" "int" 32 0 6645 NULL true 0
NULL
-6635 "type" "clob" 0 0 6645 NULL true 1 NULL
-6636 "width" "int" 32 0 6645 NULL true 2 NULL
-6637 "stamp" "timestamp" 7 0 6645 NULL true 3
NULL
-6638 "sample" "bigint" 64 0 6645 NULL true
4 NULL
-6639 "count" "bigint" 64 0 6645 NULL true 5
NULL
-6640 "unique" "bigint" 64 0 6645 NULL true
6 NULL
-6641 "nils" "bigint" 64 0 6645 NULL true 7
NULL
-6642 "minval" "clob" 0 0 6645 NULL true 8
NULL
-6643 "maxval" "clob" 0 0 6645 NULL true 9
NULL
-6644 "sorted" "boolean" 1 0 6645 NULL true
10 NULL
-6735 "file_id" "bigint" 64 0 6743 NULL false
0 NULL
-6736 "file_location" "clob" 0 0 6743 NULL false 1
NULL
-6737 "dbschema" "smallint" 16 0 6743 NULL false
2 NULL
-6738 "format_version" "varchar" 7 0 6743 NULL
true 3 NULL
-6739 "sorting_order" "varchar" 10 0 6743 NULL true
4 NULL
-6740 "comments" "clob" 0 0 6743 NULL true 5
NULL
-6745 "sn" "clob" 0 0 6756 NULL false 0 NULL
-6746 "file_id" "bigint" 64 0 6756 NULL false
1 NULL
-6747 "ln" "int" 32 0 6756 NULL true 2 NULL
-6748 "as" "int" 32 0 6756 NULL true 3 NULL
-6749 "m5" "clob" 0 0 6756 NULL true 4 NULL
-6750 "sp" "clob" 0 0 6756 NULL true 5 NULL
-6751 "ur" "clob" 0 0 6756 NULL true 6 NULL
-6758 "id" "clob" 0 0 6775 NULL false 0 NULL
-6759 "file_id" "bigint" 64 0 6775 NULL false
1 NULL
-6760 "cn" "clob" 0 0 6775 NULL true 2 NULL
-6761 "ds" "clob" 0 0 6775 NULL true 3 NULL
-6762 "dt" "timestamp" 7 0 6775 NULL true 4
NULL
-6763 "fo" "clob" 0 0 6775 NULL true 5 NULL
-6764 "ks" "clob" 0 0 6775 NULL true 6 NULL
-6765 "lb" "clob" 0 0 6775 NULL true 7 NULL
-6766 "pg" "clob" 0 0 6775 NULL true 8 NULL
-6767 "pi" "int" 32 0 6775 NULL true 9 NULL
-6768 "pl" "clob" 0 0 6775 NULL true 10 NULL
-6769 "pu" "clob" 0 0 6775 NULL true 11 NULL
-6770 "sm" "clob" 0 0 6775 NULL true 12 NULL
-6777 "id" "clob" 0 0 6787 NULL false 0 NULL
-6778 "file_id" "bigint" 64 0 6787 NULL false
1 NULL
-6779 "pn" "clob" 0 0 6787 NULL true 2 NULL
-6780 "cl" "clob" 0 0 6787 NULL true 3 NULL
-6781 "pp" "clob" 0 0 6787 NULL true 4 NULL
-6782 "vn" "clob" 0 0 6787 NULL true 5 NULL
-6789 "qname" "clob" 0 0 6800 NULL false 0 NULL
-6790 "flag" "smallint" 16 0 6800 NULL false 1
NULL
-6791 "rname" "clob" 0 0 6800 NULL false 2 NULL
-6792 "pos" "int" 32 0 6800 NULL false 3 NULL
-6793 "mapq" "smallint" 16 0 6800 NULL false 4
NULL
-6794 "cigar" "clob" 0 0 6800 NULL false 5 NULL
-6795 "rnext" "clob" 0 0 6800 NULL false 6 NULL
-6796 "pnext" "int" 32 0 6800 NULL false 7 NULL
-6797 "tlen" "int" 32 0 6800 NULL false 8 NULL
-6798 "seq" "clob" 0 0 6800 NULL false 9 NULL
-6799 "qual" "clob" 0 0 6800 NULL false 10 NULL
-6870 "function_id" "int" 32 0 6871 NULL true 0
NULL
+5682 "id" "int" 32 0 5681 NULL true 0 NULL
+5683 "name" "varchar" 1024 0 5681 NULL true 1
NULL
+5684 "schema_id" "int" 32 0 5681 NULL true 2
NULL
+5685 "query" "varchar" 2048 0 5681 NULL true 3
NULL
+5686 "type" "smallint" 16 0 5681 NULL true 4
NULL
+5687 "system" "boolean" 1 0 5681 NULL true
5 NULL
+5688 "commit_action" "smallint" 16 0 5681 NULL true
6 NULL
+5689 "access" "smallint" 16 0 5681 NULL true
7 NULL
+5690 "temporary" "smallint" 16 0 5681 NULL true
8 NULL
+5692 "id" "int" 32 0 5691 NULL true 0 NULL
+5693 "name" "varchar" 1024 0 5691 NULL true 1
NULL
+5694 "type" "varchar" 1024 0 5691 NULL true 2
NULL
+5695 "type_digits" "int" 32 0 5691 NULL true 3
NULL
+5696 "type_scale" "int" 32 0 5691 NULL true 4
NULL
+5697 "table_id" "int" 32 0 5691 NULL true 5
NULL
+5698 "default" "varchar" 2048 0 5691 NULL true
6 NULL
+5699 "null" "boolean" 1 0 5691 NULL true 7
NULL
+5700 "number" "int" 32 0 5691 NULL true 8
NULL
+5701 "storage" "varchar" 2048 0 5691 NULL true
9 NULL
+5708 "name" "varchar" 1024 0 5707 NULL true 0
NULL
+5709 "fullname" "varchar" 2048 0 5707 NULL true
1 NULL
+5710 "default_schema" "int" 9 0 5707 NULL true
2 NULL
+5714 "name" "varchar" 1024 0 5713 NULL true 0
NULL
+5715 "fullname" "varchar" 2024 0 5713 NULL true
1 NULL
+5716 "default_schema" "int" 9 0 5713 NULL true
2 NULL
+5718 "login_id" "int" 32 0 5717 NULL true 0
NULL
+5719 "role_id" "int" 32 0 5717 NULL true 1
NULL
+5721 "id" "int" 32 0 5720 NULL true 0 NULL
+5722 "name" "varchar" 1024 0 5720 NULL true 1
NULL
+5723 "grantor" "int" 32 0 5720 NULL true 2
NULL
+5725 "obj_id" "int" 32 0 5724 NULL true 0
NULL
+5726 "auth_id" "int" 32 0 5724 NULL true 1
NULL
+5727 "privileges" "int" 32 0 5724 NULL true 2
NULL
+5728 "grantor" "int" 32 0 5724 NULL true 3
NULL
+5729 "grantable" "int" 32 0 5724 NULL true 4
NULL
+5938 "id" "oid" 63 0 5946 NULL true 0 NULL
+5939 "owner" "clob" 0 0 5946 NULL true 1 NULL
+5940 "defined" "timestamp" 7 0 5946 NULL true
2 NULL
+5941 "query" "clob" 0 0 5946 NULL true 3 NULL
+5942 "pipe" "clob" 0 0 5946 NULL true 4 NULL
+5943 "plan" "clob" 0 0 5946 NULL true 5 NULL
+5944 "mal" "int" 32 0 5946 NULL true 6 NULL
+5945 "optimize" "bigint" 64 0 5946 NULL true
7 NULL
+5948 "id" "oid" 63 0 5957 NULL true 0 NULL
+5949 "start" "timestamp" 7 0 5957 NULL true 1
NULL
+5950 "stop" "timestamp" 7 0 5957 NULL true 2
NULL
+5951 "arguments" "clob" 0 0 5957 NULL true 3
NULL
+5952 "tuples" "wrd" 64 0 5957 NULL true 4
NULL
+5953 "run" "bigint" 64 0 5957 NULL true 5
NULL
+5954 "ship" "bigint" 64 0 5957 NULL true 6
NULL
+5955 "cpu" "int" 32 0 5957 NULL true 7 NULL
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
