Changeset: 34f6fac25122 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=34f6fac25122
Modified Files:
clients/Tests/SQL-dump_geom.stable.out.32bit
Branch: default
Log Message:
Approved 32 bit output.
diffs (truncated from 4725 to 300 lines):
diff --git a/clients/Tests/SQL-dump_geom.stable.out.32bit
b/clients/Tests/SQL-dump_geom.stable.out.32bit
--- a/clients/Tests/SQL-dump_geom.stable.out.32bit
+++ b/clients/Tests/SQL-dump_geom.stable.out.32bit
@@ -53,7 +53,6 @@ Ready.
SYSTEM SCHEMA json
SYSTEM SCHEMA sys
SYSTEM SCHEMA tmp
-SYSTEM SCHEMA sys
SYSTEM TABLE sys._columns
SYSTEM TABLE sys._tables
SYSTEM TABLE sys.args
@@ -352,9 +351,7 @@ CREATE TABLE "sys"."sequences" (
"cycle" BOOLEAN
);
CREATE TABLE "sys"."statistics" (
- "schema" CHARACTER LARGE OBJECT,
- "table" CHARACTER LARGE OBJECT,
- "column" CHARACTER LARGE OBJECT,
+ "column_id" INTEGER,
"type" CHARACTER LARGE OBJECT,
"width" INTEGER,
"stamp" TIMESTAMP,
@@ -1529,7 +1526,7 @@ CREATE TABLE "sys"."_columns" (
"number" INTEGER,
"storage" VARCHAR(2048)
);
-COPY 286 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS
'\t','\n','"';
+COPY 284 RECORDS INTO "sys"."_columns" FROM stdin USING DELIMITERS
'\t','\n','"';
2002 "id" "int" 32 0 2001 NULL true 0 NULL
2003 "name" "varchar" 1024 0 2001 NULL true 1
NULL
2004 "authorization" "int" 32 0 2001 NULL true 2
NULL
@@ -1663,159 +1660,157 @@ 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
-5184 "id" "int" 32 0 5183 NULL true 0 NULL
-5185 "name" "varchar" 1024 0 5183 NULL true 1
NULL
-5186 "schema_id" "int" 32 0 5183 NULL true 2
NULL
-5187 "query" "varchar" 2048 0 5183 NULL true 3
NULL
-5188 "type" "smallint" 16 0 5183 NULL true 4
NULL
-5189 "system" "boolean" 1 0 5183 NULL true
5 NULL
-5190 "commit_action" "smallint" 16 0 5183 NULL true
6 NULL
-5191 "readonly" "boolean" 1 0 5183 NULL true
7 NULL
-5192 "temporary" "smallint" 16 0 5183 NULL true
8 NULL
-5194 "id" "int" 32 0 5193 NULL true 0 NULL
-5195 "name" "varchar" 1024 0 5193 NULL true 1
NULL
-5196 "type" "varchar" 1024 0 5193 NULL true 2
NULL
-5197 "type_digits" "int" 32 0 5193 NULL true 3
NULL
-5198 "type_scale" "int" 32 0 5193 NULL true 4
NULL
-5199 "table_id" "int" 32 0 5193 NULL true 5
NULL
-5200 "default" "varchar" 2048 0 5193 NULL true
6 NULL
-5201 "null" "boolean" 1 0 5193 NULL true 7
NULL
-5202 "number" "int" 32 0 5193 NULL true 8
NULL
-5203 "storage" "varchar" 2048 0 5193 NULL true
9 NULL
-5210 "name" "varchar" 1024 0 5209 NULL true 0
NULL
-5211 "fullname" "varchar" 2048 0 5209 NULL true
1 NULL
-5212 "default_schema" "int" 9 0 5209 NULL true
2 NULL
-5216 "name" "varchar" 1024 0 5215 NULL true 0
NULL
-5217 "fullname" "varchar" 2024 0 5215 NULL true
1 NULL
-5218 "default_schema" "int" 9 0 5215 NULL true
2 NULL
-5220 "login_id" "int" 32 0 5219 NULL true 0
NULL
-5221 "role_id" "int" 32 0 5219 NULL true 1
NULL
-5223 "id" "int" 32 0 5222 NULL true 0 NULL
-5224 "name" "varchar" 1024 0 5222 NULL true 1
NULL
-5225 "grantor" "int" 32 0 5222 NULL true 2
NULL
-5227 "obj_id" "int" 32 0 5226 NULL true 0
NULL
-5228 "auth_id" "int" 32 0 5226 NULL true 1
NULL
-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
-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" 32 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" 32 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
-6364 "schema" "clob" 0 0 6376 NULL true 0
NULL
-6365 "table" "clob" 0 0 6376 NULL true 1 NULL
-6366 "column" "clob" 0 0 6376 NULL true 2
NULL
-6367 "type" "clob" 0 0 6376 NULL true 3 NULL
-6368 "location" "clob" 0 0 6376 NULL true 4
NULL
-6369 "count" "bigint" 64 0 6376 NULL true 5
NULL
-6370 "typewidth" "int" 32 0 6376 NULL true 6
NULL
-6371 "columnsize" "bigint" 64 0 6376 NULL true
7 NULL
-6372 "heapsize" "bigint" 64 0 6376 NULL true
8 NULL
-6373 "hashes" "bigint" 64 0 6376 NULL true
9 NULL
-6374 "imprints" "bigint" 64 0 6376 NULL true
10 NULL
-6375 "sorted" "boolean" 1 0 6376 NULL true
11 NULL
-6378 "schema" "clob" 0 0 6388 NULL true 0
NULL
-6379 "table" "clob" 0 0 6388 NULL true 1 NULL
-6380 "column" "clob" 0 0 6388 NULL true 2
NULL
-6381 "type" "clob" 0 0 6388 NULL true 3 NULL
-6382 "typewidth" "int" 32 0 6388 NULL true 4
NULL
-6383 "count" "bigint" 64 0 6388 NULL true 5
NULL
-6384 "distinct" "bigint" 64 0 6388 NULL true
6 NULL
-6385 "atomwidth" "int" 32 0 6388 NULL true 7
NULL
-6386 "reference" "boolean" 1 0 6388 NULL true
8 NULL
-6387 "sorted" "boolean" 1 0 6388 NULL true
9 NULL
-6426 "schema" "clob" 0 0 6436 NULL true 0
NULL
-6427 "table" "clob" 0 0 6436 NULL true 1 NULL
-6428 "column" "clob" 0 0 6436 NULL true 2
NULL
-6429 "type" "clob" 0 0 6436 NULL true 3 NULL
-6430 "count" "bigint" 64 0 6436 NULL true 4
NULL
-6431 "columnsize" "bigint" 64 0 6436 NULL true
5 NULL
-6432 "heapsize" "bigint" 64 0 6436 NULL true
6 NULL
-6433 "hashes" "bigint" 64 0 6436 NULL true
7 NULL
-6434 "imprints" "bigint" 64 0 6436 NULL true
8 NULL
-6435 "sorted" "boolean" 1 0 6436 NULL true
9 NULL
-6438 "schema" "clob" 0 0 6446 NULL true 0
NULL
-6439 "table" "clob" 0 0 6446 NULL true 1 NULL
-6440 "count" "bigint" 64 0 6446 NULL true 2
NULL
-6441 "columnsize" "bigint" 64 0 6446 NULL true
3 NULL
-6442 "heapsize" "bigint" 64 0 6446 NULL true
4 NULL
-6443 "hashes" "bigint" 64 0 6446 NULL true
5 NULL
-6444 "imprints" "bigint" 64 0 6446 NULL true
6 NULL
-6445 "auxillary" "bigint" 53 0 6446 NULL true
7 NULL
-6448 "schema" "clob" 0 0 6461 NULL true 0
NULL
-6449 "table" "clob" 0 0 6461 NULL true 1 NULL
-6450 "column" "clob" 0 0 6461 NULL true 2
NULL
-6451 "type" "clob" 0 0 6461 NULL true 3 NULL
-6452 "width" "int" 32 0 6461 NULL true 4 NULL
-6453 "stamp" "timestamp" 7 0 6461 NULL true 5
NULL
-6454 "sample" "bigint" 64 0 6461 NULL true
6 NULL
-6455 "count" "bigint" 64 0 6461 NULL true 7
NULL
-6456 "unique" "bigint" 64 0 6461 NULL true
8 NULL
-6457 "nils" "bigint" 64 0 6461 NULL true 9
NULL
-6458 "minval" "clob" 0 0 6461 NULL true 10
NULL
-6459 "maxval" "clob" 0 0 6461 NULL true 11
NULL
-6460 "sorted" "boolean" 1 0 6461 NULL true
12 NULL
-6582 "function_id" "int" 32 0 6583 NULL true 0
NULL
+5196 "id" "int" 32 0 5195 NULL true 0 NULL
+5197 "name" "varchar" 1024 0 5195 NULL true 1
NULL
+5198 "schema_id" "int" 32 0 5195 NULL true 2
NULL
+5199 "query" "varchar" 2048 0 5195 NULL true 3
NULL
+5200 "type" "smallint" 16 0 5195 NULL true 4
NULL
+5201 "system" "boolean" 1 0 5195 NULL true
5 NULL
+5202 "commit_action" "smallint" 16 0 5195 NULL true
6 NULL
+5203 "readonly" "boolean" 1 0 5195 NULL true
7 NULL
+5204 "temporary" "smallint" 16 0 5195 NULL true
8 NULL
+5206 "id" "int" 32 0 5205 NULL true 0 NULL
+5207 "name" "varchar" 1024 0 5205 NULL true 1
NULL
+5208 "type" "varchar" 1024 0 5205 NULL true 2
NULL
+5209 "type_digits" "int" 32 0 5205 NULL true 3
NULL
+5210 "type_scale" "int" 32 0 5205 NULL true 4
NULL
+5211 "table_id" "int" 32 0 5205 NULL true 5
NULL
+5212 "default" "varchar" 2048 0 5205 NULL true
6 NULL
+5213 "null" "boolean" 1 0 5205 NULL true 7
NULL
+5214 "number" "int" 32 0 5205 NULL true 8
NULL
+5215 "storage" "varchar" 2048 0 5205 NULL true
9 NULL
+5222 "name" "varchar" 1024 0 5221 NULL true 0
NULL
+5223 "fullname" "varchar" 2048 0 5221 NULL true
1 NULL
+5224 "default_schema" "int" 9 0 5221 NULL true
2 NULL
+5228 "name" "varchar" 1024 0 5227 NULL true 0
NULL
+5229 "fullname" "varchar" 2024 0 5227 NULL true
1 NULL
+5230 "default_schema" "int" 9 0 5227 NULL true
2 NULL
+5232 "login_id" "int" 32 0 5231 NULL true 0
NULL
+5233 "role_id" "int" 32 0 5231 NULL true 1
NULL
+5235 "id" "int" 32 0 5234 NULL true 0 NULL
+5236 "name" "varchar" 1024 0 5234 NULL true 1
NULL
+5237 "grantor" "int" 32 0 5234 NULL true 2
NULL
+5239 "obj_id" "int" 32 0 5238 NULL true 0
NULL
+5240 "auth_id" "int" 32 0 5238 NULL true 1
NULL
+5241 "privileges" "int" 32 0 5238 NULL true 2
NULL
+5242 "grantor" "int" 32 0 5238 NULL true 3
NULL
+5243 "grantable" "int" 32 0 5238 NULL true 4
NULL
+5412 "id" "oid" 31 0 5419 NULL true 0 NULL
+5413 "owner" "clob" 0 0 5419 NULL true 1 NULL
+5414 "defined" "timestamp" 7 0 5419 NULL true
2 NULL
+5415 "query" "clob" 0 0 5419 NULL true 3 NULL
+5416 "pipe" "clob" 0 0 5419 NULL true 4 NULL
+5417 "mal" "int" 32 0 5419 NULL true 5 NULL
+5418 "optimize" "bigint" 64 0 5419 NULL true
6 NULL
+5421 "id" "oid" 31 0 5431 NULL true 0 NULL
+5422 "start" "timestamp" 7 0 5431 NULL true 1
NULL
+5423 "stop" "timestamp" 7 0 5431 NULL true 2
NULL
+5424 "arguments" "clob" 0 0 5431 NULL true 3
NULL
+5425 "tuples" "wrd" 32 0 5431 NULL true 4
NULL
+5426 "run" "bigint" 64 0 5431 NULL true 5
NULL
+5427 "ship" "bigint" 64 0 5431 NULL true 6
NULL
+5428 "cpu" "int" 32 0 5431 NULL true 7 NULL
+5429 "io" "int" 32 0 5431 NULL true 8 NULL
+5430 "space" "bigint" 64 0 5431 NULL true 9
NULL
+5433 "id" "oid" 31 0 5449 NULL true 0 NULL
+5434 "owner" "clob" 0 0 5449 NULL true 1 NULL
+5435 "defined" "timestamp" 7 0 5449 NULL true
2 NULL
+5436 "query" "clob" 0 0 5449 NULL true 3 NULL
+5437 "pipe" "clob" 0 0 5449 NULL true 4 NULL
+5438 "mal" "int" 32 0 5449 NULL true 5 NULL
+5439 "optimize" "bigint" 64 0 5449 NULL true
6 NULL
+5440 "start" "timestamp" 7 0 5449 NULL true 7
NULL
+5441 "stop" "timestamp" 7 0 5449 NULL true 8
NULL
+5442 "arguments" "clob" 0 0 5449 NULL true 9
NULL
+5443 "tuples" "wrd" 32 0 5449 NULL true 10
NULL
+5444 "run" "bigint" 64 0 5449 NULL true 11
NULL
+5445 "ship" "bigint" 64 0 5449 NULL true 12
NULL
+5446 "cpu" "int" 32 0 5449 NULL true 13 NULL
+5447 "space" "bigint" 64 0 5449 NULL true 14
NULL
+5448 "io" "int" 32 0 5449 NULL true 15 NULL
+5474 "event" "int" 32 0 5486 NULL true 0 NULL
+5475 "clk" "varchar" 20 0 5486 NULL true 1
NULL
+5476 "pc" "varchar" 50 0 5486 NULL true 2
NULL
+5477 "thread" "int" 32 0 5486 NULL true 3
NULL
+5478 "user" "int" 32 0 5486 NULL true 4 NULL
+5479 "ticks" "bigint" 64 0 5486 NULL true 5
NULL
+5480 "reads" "bigint" 64 0 5486 NULL true 6
NULL
+5481 "writes" "bigint" 64 0 5486 NULL true
7 NULL
+5482 "rbytes" "bigint" 64 0 5486 NULL true
8 NULL
+5483 "wbytes" "bigint" 64 0 5486 NULL true
9 NULL
+5484 "type" "clob" 0 0 5486 NULL true 10 NULL
+5485 "stmt" "clob" 0 0 5486 NULL true 11 NULL
+5605 "user" "clob" 0 0 5611 NULL true 0 NULL
+5606 "login" "timestamp" 7 0 5611 NULL true 1
NULL
+5607 "sessiontimeout" "bigint" 64 0 5611 NULL
true 2 NULL
+5608 "lastcommand" "timestamp" 7 0 5611 NULL true
3 NULL
+5609 "querytimeout" "bigint" 64 0 5611 NULL true
4 NULL
+5610 "active" "boolean" 1 0 5611 NULL true
5 NULL
+5688 "name" "clob" 0 0 5691 NULL true 0 NULL
+5689 "def" "clob" 0 0 5691 NULL true 1 NULL
+5690 "status" "clob" 0 0 5691 NULL true 2
NULL
+5697 "name" "clob" 0 0 5699 NULL true 0 NULL
+5698 "value" "clob" 0 0 5699 NULL true 1 NULL
+5729 "qtag" "bigint" 64 0 5737 NULL true 0
NULL
+5730 "user" "clob" 0 0 5737 NULL true 1 NULL
+5731 "started" "timestamp" 7 0 5737 NULL true
2 NULL
+5732 "estimate" "timestamp" 7 0 5737 NULL true
3 NULL
+5733 "progress" "int" 32 0 5737 NULL true 4
NULL
+5734 "status" "clob" 0 0 5737 NULL true 5
NULL
+5735 "tag" "oid" 31 0 5737 NULL true 6 NULL
+5736 "query" "clob" 0 0 5737 NULL true 7 NULL
+6376 "schema" "clob" 0 0 6388 NULL true 0
NULL
+6377 "table" "clob" 0 0 6388 NULL true 1 NULL
+6378 "column" "clob" 0 0 6388 NULL true 2
NULL
+6379 "type" "clob" 0 0 6388 NULL true 3 NULL
+6380 "location" "clob" 0 0 6388 NULL true 4
NULL
+6381 "count" "bigint" 64 0 6388 NULL true 5
NULL
+6382 "typewidth" "int" 32 0 6388 NULL true 6
NULL
+6383 "columnsize" "bigint" 64 0 6388 NULL true
7 NULL
+6384 "heapsize" "bigint" 64 0 6388 NULL true
8 NULL
+6385 "hashes" "bigint" 64 0 6388 NULL true
9 NULL
+6386 "imprints" "bigint" 64 0 6388 NULL true
10 NULL
+6387 "sorted" "boolean" 1 0 6388 NULL true
11 NULL
+6390 "schema" "clob" 0 0 6400 NULL true 0
NULL
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
