Changeset: 94bbc5894201 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=94bbc5894201 Modified Files: clients/Tests/SQL-dump_all.stable.out.oid32 clients/Tests/SQL-dump_geom.stable.out.64bit.oid32 Branch: Oct2014 Log Message:
Approved oid32 output. diffs (truncated from 9709 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 @@ -1690,202 +1690,202 @@ 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 -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 +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 +5404 "id" "oid" 31 0 5411 NULL true 0 NULL +5405 "owner" "clob" 0 0 5411 NULL true 1 NULL +5406 "defined" "timestamp" 7 0 5411 NULL true 2 NULL +5407 "query" "clob" 0 0 5411 NULL true 3 NULL +5408 "pipe" "clob" 0 0 5411 NULL true 4 NULL +5409 "mal" "int" 32 0 5411 NULL true 5 NULL +5410 "optimize" "bigint" 64 0 5411 NULL true 6 NULL +5413 "id" "oid" 31 0 5423 NULL true 0 NULL +5414 "start" "timestamp" 7 0 5423 NULL true 1 NULL +5415 "stop" "timestamp" 7 0 5423 NULL true 2 NULL +5416 "arguments" "clob" 0 0 5423 NULL true 3 NULL +5417 "tuples" "wrd" 64 0 5423 NULL true 4 NULL +5418 "run" "bigint" 64 0 5423 NULL true 5 NULL +5419 "ship" "bigint" 64 0 5423 NULL true 6 NULL +5420 "cpu" "int" 32 0 5423 NULL true 7 NULL +5421 "io" "int" 32 0 5423 NULL true 8 NULL +5422 "space" "bigint" 64 0 5423 NULL true 9 NULL +5425 "id" "oid" 31 0 5441 NULL true 0 NULL +5426 "owner" "clob" 0 0 5441 NULL true 1 NULL +5427 "defined" "timestamp" 7 0 5441 NULL true 2 NULL +5428 "query" "clob" 0 0 5441 NULL true 3 NULL +5429 "pipe" "clob" 0 0 5441 NULL true 4 NULL +5430 "mal" "int" 32 0 5441 NULL true 5 NULL +5431 "optimize" "bigint" 64 0 5441 NULL true 6 NULL +5432 "start" "timestamp" 7 0 5441 NULL true 7 NULL +5433 "stop" "timestamp" 7 0 5441 NULL true 8 NULL +5434 "arguments" "clob" 0 0 5441 NULL true 9 NULL +5435 "tuples" "wrd" 64 0 5441 NULL true 10 NULL +5436 "run" "bigint" 64 0 5441 NULL true 11 NULL +5437 "ship" "bigint" 64 0 5441 NULL true 12 NULL +5438 "cpu" "int" 32 0 5441 NULL true 13 NULL +5439 "space" "bigint" 64 0 5441 NULL true 14 NULL +5440 "io" "int" 32 0 5441 NULL true 15 NULL +5466 "event" "int" 32 0 5478 NULL true 0 NULL +5467 "clk" "varchar" 20 0 5478 NULL true 1 NULL +5468 "pc" "varchar" 50 0 5478 NULL true 2 NULL +5469 "thread" "int" 32 0 5478 NULL true 3 NULL +5470 "user" "int" 32 0 5478 NULL true 4 NULL +5471 "ticks" "bigint" 64 0 5478 NULL true 5 NULL +5472 "reads" "bigint" 64 0 5478 NULL true 6 NULL +5473 "writes" "bigint" 64 0 5478 NULL true 7 NULL +5474 "rbytes" "bigint" 64 0 5478 NULL true 8 NULL +5475 "wbytes" "bigint" 64 0 5478 NULL true 9 NULL +5476 "type" "clob" 0 0 5478 NULL true 10 NULL +5477 "stmt" "clob" 0 0 5478 NULL true 11 NULL +5597 "user" "clob" 0 0 5603 NULL true 0 NULL +5598 "login" "timestamp" 7 0 5603 NULL true 1 NULL +5599 "sessiontimeout" "bigint" 64 0 5603 NULL true 2 NULL +5600 "lastcommand" "timestamp" 7 0 5603 NULL true 3 NULL +5601 "querytimeout" "bigint" 64 0 5603 NULL true 4 NULL +5602 "active" "boolean" 1 0 5603 NULL true 5 NULL +5680 "name" "clob" 0 0 5683 NULL true 0 NULL +5681 "def" "clob" 0 0 5683 NULL true 1 NULL +5682 "status" "clob" 0 0 5683 NULL true 2 NULL +5689 "name" "clob" 0 0 5691 NULL true 0 NULL +5690 "value" "clob" 0 0 5691 NULL true 1 NULL +5721 "qtag" "bigint" 64 0 5729 NULL true 0 NULL +5722 "user" "clob" 0 0 5729 NULL true 1 NULL +5723 "started" "timestamp" 7 0 5729 NULL true 2 NULL +5724 "estimate" "timestamp" 7 0 5729 NULL true 3 NULL +5725 "progress" "int" 32 0 5729 NULL true 4 NULL +5726 "status" "clob" 0 0 5729 NULL true 5 NULL _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
