Changeset: 135b9658d15a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=135b9658d15a Modified Files: clients/Tests/SQL-dump.stable.out.32bit Branch: default Log Message:
SQL-dump: approved 32-bit output diffs (truncated from 2854 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out.32bit b/clients/Tests/SQL-dump.stable.out.32bit --- a/clients/Tests/SQL-dump.stable.out.32bit +++ b/clients/Tests/SQL-dump.stable.out.32bit @@ -1,22 +1,20 @@ stdout of test 'SQL-dump` in directory 'clients` itself: -# 15:01:36 > -# 15:01:36 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34237" "--set" "mapi_usock=/var/tmp/mtest-13451/.s.monetdb.34237" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_clients" "--set" "mal_listing=0" -# 15:01:36 > +# 03:59:59 > +# 03:59:59 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35201" "--set" "mapi_usock=/var/tmp/mtest-38510/.s.monetdb.35201" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/Volumes/scratch/monet/GNU-Darwin-i386-propcheck-bbd8d343a80b-default/tests/clients/dbfarm/mTests_clients" "--set" "mal_listing=0" +# 03:59:59 > -# MonetDB 5 server v11.17.0 (hg id: 51cced809df4) -# This is an unreleased version +# MonetDB 5 server v11.20.0 "default-bbd8d343a80b" # Serving database 'mTests_clients', using 8 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Found 15.591 GiB available main-memory. +# Compiled for i686-apple-darwin9/32bit with 32bit OIDs dynamically linked +# Found 2.000 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://madrid.ins.cwi.nl:34237/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-13451/.s.monetdb.34237 +# Listening for connection requests on mapi:monetdb://build-x86-macosx:35201/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-38510/.s.monetdb.35201 # MonetDB/GIS module loaded -# MonetDB/JAQL module loaded # MonetDB/SQL module loaded Ready. @@ -29,8 +27,6 @@ Ready. # loading sql script: 14_inet.sql # loading sql script: 15_querylog.sql # loading sql script: 16_tracelog.sql -# loading sql script: 17_compress.sql -# loading sql script: 18_dictionary.sql # loading sql script: 19_cluster.sql # loading sql script: 20_vacuum.sql # loading sql script: 21_dependency_functions.sql @@ -44,15 +40,15 @@ Ready. # loading sql script: 40_json.sql # loading sql script: 41_jsonstore.sql # loading sql script: 45_uuid.sql -# loading sql script: 46_gsl.sql # loading sql script: 75_storagemodel.sql # loading sql script: 80_statistics.sql # loading sql script: 80_udf.sql +# loading sql script: 90_generator.sql # loading sql script: 99_system.sql -# 15:01:36 > -# 15:01:36 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13451" "--port=34237" -# 15:01:36 > +# 03:59:59 > +# 03:59:59 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-38510" "--port=35201" +# 03:59:59 > SCHEMA json SCHEMA tmp @@ -141,6 +137,7 @@ SYSTEM FUNCTION sys.environment SYSTEM FUNCTION sys.equals SYSTEM FUNCTION sys.evalalgebra SYSTEM FUNCTION sys.fuse +SYSTEM FUNCTION sys.generate_series SYSTEM FUNCTION sys.geomcollectionfromtext SYSTEM FUNCTION sys.geometrytypeid SYSTEM FUNCTION sys.geomfromtext @@ -303,7 +300,7 @@ CREATE TABLE "sys"."functions" ( "name" VARCHAR(256), "func" VARCHAR(8196), "mod" VARCHAR(8196), - "sql" BOOLEAN, + "language" INTEGER, "type" INTEGER, "side_effect" BOOLEAN, "varres" BOOLEAN, @@ -1218,7 +1215,6 @@ external name sql.sysmon_stop; -- Copyright August 2008-2014 MonetDB B.V. -- All Rights Reserved. - -- Author M.Kersten -- This script gives the database administrator insight in the actual -- footprint of the persistent tables and the maximum playground used @@ -1283,7 +1279,6 @@ begin set "distinct" = "count" -- assume all distinct where "type" = 'varchar' or "type"='clob'; end; - -- The contents of this file are subject to the MonetDB Public License -- Version 1.1 (the "License"); you may not use this file except in -- compliance with the License. You may obtain a copy of the License at @@ -1466,7 +1461,7 @@ 2017 "id" "int" 32 0 2016 NULL true 0 NU 2018 "name" "varchar" 256 0 2016 NULL true 1 NULL 2019 "func" "varchar" 8196 0 2016 NULL true 2 NULL 2020 "mod" "varchar" 8196 0 2016 NULL true 3 NULL -2021 "sql" "boolean" 1 0 2016 NULL true 4 NULL +2021 "language" "int" 32 0 2016 NULL true 4 NULL 2022 "type" "int" 32 0 2016 NULL true 5 NULL 2023 "side_effect" "boolean" 1 0 2016 NULL true 6 NULL 2024 "varres" "boolean" 1 0 2016 NULL true 7 NULL @@ -1734,7 +1729,7 @@ 6449 "nils" "bigint" 64 0 6453 NULL true 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 +6563 "function_id" "int" 32 0 6564 NULL true 0 NULL COMMIT; START TRANSACTION; CREATE TABLE "sys"."_tables" ( @@ -1787,7 +1782,7 @@ 6380 "storagemodelinput" 2000 NULL 0 tru 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 +6564 "systemfunctions" 2000 NULL 0 true 0 false COMMIT; START TRANSACTION; CREATE TABLE "sys"."args" ( @@ -1800,7 +1795,7 @@ CREATE TABLE "sys"."args" ( "inout" TINYINT, "number" INTEGER ); -COPY 3656 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"'; +COPY 3693 RECORDS INTO "sys"."args" FROM stdin USING DELIMITERS '\t','\n','"'; 2155 28 "res_0" "oid" 31 0 0 0 2156 28 "arg_1" "wrd" 32 0 1 1 2157 29 "res_0" "oid" 31 0 0 0 @@ -5457,6 +5452,43 @@ 6499 6496 "two" "smallint" 16 0 1 2 6502 6501 "result" "bigint" 64 0 0 0 6503 6501 "one" "int" 32 0 1 1 6504 6501 "two" "int" 32 0 1 2 +6507 6506 "value" "tinyint" 8 0 0 0 +6508 6506 "first" "tinyint" 8 0 1 1 +6509 6506 "last" "tinyint" 8 0 1 2 +6512 6511 "value" "tinyint" 8 0 0 0 +6513 6511 "first" "tinyint" 8 0 1 1 +6514 6511 "last" "tinyint" 8 0 1 2 +6515 6511 "stepsize" "tinyint" 8 0 1 3 +6518 6517 "value" "int" 32 0 0 0 +6519 6517 "first" "int" 32 0 1 1 +6520 6517 "last" "int" 32 0 1 2 +6523 6522 "value" "int" 32 0 0 0 +6524 6522 "first" "int" 32 0 1 1 +6525 6522 "last" "int" 32 0 1 2 +6526 6522 "stepsize" "int" 32 0 1 3 +6529 6528 "value" "bigint" 64 0 0 0 +6530 6528 "first" "bigint" 64 0 1 1 +6531 6528 "last" "bigint" 64 0 1 2 +6534 6533 "value" "bigint" 64 0 0 0 +6535 6533 "first" "bigint" 64 0 1 1 +6536 6533 "last" "bigint" 64 0 1 2 +6537 6533 "stepsize" "bigint" 64 0 1 3 +6540 6539 "value" "real" 24 0 0 0 +6541 6539 "first" "real" 24 0 1 1 +6542 6539 "last" "real" 24 0 1 2 +6543 6539 "stepsize" "real" 24 0 1 3 +6546 6545 "value" "double" 53 0 0 0 +6547 6545 "first" "double" 53 0 1 1 +6548 6545 "last" "double" 53 0 1 2 +6549 6545 "stepsize" "double" 53 0 1 3 +6552 6551 "value" "decimal" 10 2 0 0 +6553 6551 "first" "decimal" 10 2 1 1 +6554 6551 "last" "decimal" 10 2 1 2 +6555 6551 "stepsize" "decimal" 10 2 1 3 +6558 6557 "value" "timestamp" 7 0 0 0 +6559 6557 "first" "timestamp" 7 0 1 1 +6560 6557 "last" "timestamp" 7 0 1 2 +6561 6557 "stepsize" "sec_interval" 13 0 1 3 COMMIT; START TRANSACTION; CREATE TABLE "sys"."auths" ( @@ -5708,7 +5740,7 @@ CREATE TABLE "sys"."functions" ( "name" VARCHAR(256), "func" VARCHAR(8196), "mod" VARCHAR(8196), - "sql" BOOLEAN, + "language" INTEGER, "type" INTEGER, "side_effect" BOOLEAN, "varres" BOOLEAN, @@ -5716,1314 +5748,1314 @@ CREATE TABLE "sys"."functions" ( "schema_id" INTEGER ); COPY 1318 RECORDS INTO "sys"."functions" FROM stdin USING DELIMITERS '\t','\n','"'; -28 "not_uniques" "not_uniques" "sql" false 1 false false false 0 -29 "not_uniques" "not_uniques" "sql" false 1 false false false 0 -30 "hash" "hash" "mkey" false 1 false false false 0 -31 "rotate_xor_hash" "rotate_xor_hash" "calc" false 1 false false false 0 -32 "=" "=" "calc" false 1 false false false 0 -33 "<>" "!=" "calc" false 1 false false false 0 -34 "isnull" "isnil" "calc" false 1 false false false 0 -35 ">" ">" "calc" false 1 false false false 0 -36 ">=" ">=" "calc" false 1 false false false 0 -37 "<" "<" "calc" false 1 false false false 0 -38 "<=" "<=" "calc" false 1 false false false 0 -42 "in" "in" "calc" false 1 false false false 0 -43 "identity" "identity" "calc" false 1 false false false 0 -44 "rowid" "identity" "calc" false 1 false false false 0 -45 "rowid" "rowid" "calc" false 1 false false false 0 -48 "sql_min" "min" "calc" false 1 false false false 0 -49 "sql_max" "max" "calc" false 1 false false false 0 -50 "ifthenelse" "ifthenelse" "calc" false 1 false false false 0 -68 "mod" "%" "calc" false 1 false false false 0 -69 "mod" "%" "calc" false 1 false false false 0 -70 "mod" "%" "calc" false 1 false false false 0 -71 "mod" "%" "calc" false 1 false false false 0 -72 "mod" "%" "calc" false 1 false false false 0 -73 "mod" "%" "calc" false 1 false false false 0 -74 "mod" "%" "calc" false 1 false false false 0 -75 "mod" "%" "calc" false 1 false false false 0 -76 "mod" "%" "calc" false 1 false false false 0 -77 "mod" "%" "calc" false 1 false false false 0 -78 "mod" "%" "calc" false 1 false false false 0 -79 "mod" "%" "calc" false 1 false false false 0 -87 "rank" "rank_grp" "calc" false 1 false false false 0 -88 "dense_rank" "dense_rank_grp" "calc" false 1 false false false 0 -89 "percent_rank" "precent_rank_grp" "calc" false 1 false false false 0 -90 "cume_dist" "cume_dist_grp" "calc" false 1 false false false 0 -91 "row_number" "mark_grp" "calc" false 1 false false false 0 -92 "rank" "rank_grp" "calc" false 1 false false false 0 -93 "dense_rank" "dense_rank_grp" "calc" false 1 false false false 0 -94 "percent_rank" "precent_rank_grp" "calc" false 1 false false false 0 -95 "cume_dist" "cume_dist_grp" "calc" false 1 false false false 0 -96 "row_number" "mark_grp" "calc" false 1 false false false 0 -97 "rank" "rank_grp" "calc" false 1 false false false 0 -98 "dense_rank" "dense_rank_grp" "calc" false 1 false false false 0 -99 "percent_rank" "precent_rank_grp" "calc" false 1 false false false 0 -100 "cume_dist" "cume_dist_grp" "calc" false 1 false false false 0 -101 "row_number" "mark_grp" "calc" false 1 false false false 0 -102 "lag" "lag_grp" "calc" false 1 false false false 0 -103 "lead" "lead_grp" "calc" false 1 false false false 0 -104 "lag" "lag_grp" "calc" false 1 false false false 0 -105 "lead" "lead_grp" "calc" false 1 false false false 0 -106 "lag" "lag_grp" "calc" false 1 false false false 0 -107 "lead" "lead_grp" "calc" false 1 false false false 0 -108 "lag" "lag_grp" "calc" false 1 false false false 0 -109 "lead" "lead_grp" "calc" false 1 false false false 0 -110 "and" "and" "calc" false 1 false false false 0 -111 "or" "or" "calc" false 1 false false false 0 -112 "xor" "xor" "calc" false 1 false false false 0 -113 "not" "not" "calc" false 1 false false false 0 -114 "sql_sub" "-" "calc" false 1 false false false 0 -115 "sql_add" "+" "calc" false 1 false false false 0 -116 "sql_mul" "*" "calc" false 1 false false false 0 -117 "sql_div" "/" "calc" false 1 false false false 0 -118 "bit_and" "and" "calc" false 1 false false false 0 -119 "bit_or" "or" "calc" false 1 false false false 0 -120 "bit_xor" "xor" "calc" false 1 false false false 0 -121 "bit_not" "not" "calc" false 1 false false false 0 -122 "left_shift" "<<" "calc" false 1 false false false 0 -123 "right_shift" ">>" "calc" false 1 false false false 0 -124 "sql_neg" "-" "calc" false 1 false false false 0 -125 "abs" "abs" "calc" false 1 false false false 0 -126 "sign" "sign" "calc" false 1 false false false 0 -127 "scale_up" "*" "calc" false 1 false false false 0 -128 "scale_down" "dec_round" "sql" false 1 false false false 0 -129 "sql_sub" "-" "calc" false 1 false false false 0 -130 "sql_add" "+" "calc" false 1 false false false 0 -131 "sql_mul" "*" "calc" false 1 false false false 0 -132 "sql_div" "/" "calc" false 1 false false false 0 -133 "sql_sub" "-" "calc" false 1 false false false 0 -134 "sql_add" "+" "calc" false 1 false false false 0 -135 "sql_mul" "*" "calc" false 1 false false false 0 -136 "sql_div" "/" "calc" false 1 false false false 0 -137 "sql_sub" "-" "calc" false 1 false false false 0 -138 "sql_add" "+" "calc" false 1 false false false 0 -139 "sql_mul" "*" "calc" false 1 false false false 0 -140 "sql_div" "/" "calc" false 1 false false false 0 -141 "bit_and" "and" "calc" false 1 false false false 0 -142 "bit_or" "or" "calc" false 1 false false false 0 -143 "bit_xor" "xor" "calc" false 1 false false false 0 -144 "bit_not" "not" "calc" false 1 false false false 0 -145 "left_shift" "<<" "calc" false 1 false false false 0 -146 "right_shift" ">>" "calc" false 1 false false false 0 -147 "sql_neg" "-" "calc" false 1 false false false 0 -148 "abs" "abs" "calc" false 1 false false false 0 -149 "sign" "sign" "calc" false 1 false false false 0 -150 "scale_up" "*" "calc" false 1 false false false 0 -151 "scale_down" "dec_round" "sql" false 1 false false false 0 -152 "sql_sub" "-" "calc" false 1 false false false 0 -153 "sql_add" "+" "calc" false 1 false false false 0 -154 "sql_mul" "*" "calc" false 1 false false false 0 -155 "sql_div" "/" "calc" false 1 false false false 0 -156 "sql_sub" "-" "calc" false 1 false false false 0 -157 "sql_add" "+" "calc" false 1 false false false 0 -158 "sql_mul" "*" "calc" false 1 false false false 0 -159 "sql_div" "/" "calc" false 1 false false false 0 -160 "sql_sub" "-" "calc" false 1 false false false 0 -161 "sql_add" "+" "calc" false 1 false false false 0 -162 "sql_mul" "*" "calc" false 1 false false false 0 -163 "sql_div" "/" "calc" false 1 false false false 0 -164 "bit_and" "and" "calc" false 1 false false false 0 -165 "bit_or" "or" "calc" false 1 false false false 0 -166 "bit_xor" "xor" "calc" false 1 false false false 0 -167 "bit_not" "not" "calc" false 1 false false false 0 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
