Changeset: d1eda7867a2f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d1eda7867a2f Added Files: sql/test/testdb/Tests/testdb-dump.stable.out.Windows Modified Files: sql/test/testdb/Tests/testdb-dump.timeout sql/test/testdb/Tests/testdb-load.timeout Branch: default Log Message:
Merge with Jul2012 branch. diffs (truncated from 101282 to 300 lines): diff --git a/sql/test/testdb/Tests/testdb-dump.stable.out.Windows b/sql/test/testdb/Tests/testdb-dump.stable.out.Windows new file mode 100644 --- /dev/null +++ b/sql/test/testdb/Tests/testdb-dump.stable.out.Windows @@ -0,0 +1,101265 @@ +stdout of test 'testdb-dump` in directory 'test/testdb` itself: + + +# 11:29:34 > +# 11:29:34 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/ufs/manegold/_/Monet/HG/Apr2012/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=32118" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_testdb" "--set" "mal_listing=0" +# 11:29:34 > + +# MonetDB 5 server v11.9.8 +# This is an unreleased version +# Serving database 'mTests_test_testdb', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.629 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://rome.ins.cwi.nl:32118/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 11:29:34 > +# 11:29:34 > "/usr/bin/python" "testdb-dump.SQL.py" "testdb-dump" +# 11:29:34 > + +START TRANSACTION; +CREATE USER "testuser" WITH ENCRYPTED PASSWORD 'e9e633097ab9ceb3e48ec3f70ee2beba41d05d5420efee5da85f97d97005727587fda33ef4ff2322088f4c79e8133cc9cd9f3512f4d3a303cbdb5bc585415a00' NAME 'Test User' SCHEMA "sys"; +CREATE SCHEMA "testschema" AUTHORIZATION "testuser"; +ALTER USER "testuser" SET SCHEMA "testschema"; +CREATE SEQUENCE "testschema"."selfref_seq" AS INTEGER; +CREATE SEQUENCE "testschema"."test_seq" AS INTEGER; +SET SCHEMA "testschema"; +CREATE TABLE "testschema"."smallstring" ( + "string1" VARCHAR(5), + "string2" CHAR(5), + "string3" CHARACTER LARGE OBJECT +); +COPY 66 RECORDS INTO "testschema"."smallstring" FROM stdin USING DELIMITERS '\t','\n','"'; +"a0" "b0" "c0" +"a1" "b1" "c1" +"a2" "b2" "c2" +"a3" "b3" "c3" +"a4" "b4" "c4" +"a5" "b5" "c5" +"a6" "b6" "c6" +"a7" "b7" "c7" +"a8" "b8" "c8" +"a9" "b9" "c9" +"a10" "b10" "c10" +"a0" "b0" "c0" +"a1" "b1" "c1" +"a2" "b2" "c2" +"a3" "b3" "c3" +"a4" "b4" "c4" +"a5" "b5" "c5" +"a6" "b6" "c6" +"a7" "b7" "c7" +"a8" "b8" "c8" +"a9" "b9" "c9" +"a10" "b10" "c10" +"a0" "b0" "c0" +"a1" "b1" "c1" +"a2" "b2" "c2" +"a3" "b3" "c3" +"a4" "b4" "c4" +"a5" "b5" "c5" +"a6" "b6" "c6" +"a7" "b7" "c7" +"a8" "b8" "c8" +"a9" "b9" "c9" +"a10" "b10" "c10" +"a0" "b0" "c0" +"a1" "b1" "c1" +"a2" "b2" "c2" +"a3" "b3" "c3" +"a4" "b4" "c4" +"a5" "b5" "c5" +"a6" "b6" "c6" +"a7" "b7" "c7" +"a8" "b8" "c8" +"a9" "b9" "c9" +"a10" "b10" "c10" +"a0" "b0" "c0" +"a1" "b1" "c1" +"a2" "b2" "c2" +"a3" "b3" "c3" +"a4" "b4" "c4" +"a5" "b5" "c5" +"a6" "b6" "c6" +"a7" "b7" "c7" +"a8" "b8" "c8" +"a9" "b9" "c9" +"a10" "b10" "c10" +"a0" "b0" "c0" +"a1" "b1" "c1" +"a2" "b2" "c2" +"a3" "b3" "c3" +"a4" "b4" "c4" +"a5" "b5" "c5" +"a6" "b6" "c6" +"a7" "b7" "c7" +"a8" "b8" "c8" +"a9" "b9" "c9" +"a10" "b10" "c10" +CREATE TABLE "testschema"."mediumstring" ( + "string1" VARCHAR(20), + "string2" CHAR(20), + "string3" CHARACTER LARGE OBJECT +); +COPY 1001 RECORDS INTO "testschema"."mediumstring" FROM stdin USING DELIMITERS '\t','\n','"'; +"a222833216428103" "b222833216428103" "c222833216428103" +"a22462275706708" "b22462275706708" "c22462275706708" +"a207961069219280" "b207961069219280" "c207961069219280" +"a1430667456508" "b1430667456508" "c1430667456508" +"a143912596726204" "b143912596726204" "c143912596726204" +"a35882931026608" "b35882931026608" "c35882931026608" +"a12630311241498" "b12630311241498" "c12630311241498" +"a1147528919691" "b1147528919691" "c1147528919691" +"a2463126399106" "b2463126399106" "c2463126399106" +"a26499139713669" "b26499139713669" "c26499139713669" +"a1248634873065" "b1248634873065" "c1248634873065" +"a78212594930635" "b78212594930635" "c78212594930635" +"a14529139788559" "b14529139788559" "c14529139788559" +"a10412828415305" "b10412828415305" "c10412828415305" +"a754999078504" "b754999078504" "c754999078504" +"a985134955047" "b985134955047" "c985134955047" +"a27593261253403" "b27593261253403" "c27593261253403" +"a29091483332322" "b29091483332322" "c29091483332322" +"a29783294642194" "b29783294642194" "c29783294642194" +"a61212319516165" "b61212319516165" "c61212319516165" +"a9790291319652" "b9790291319652" "c9790291319652" +"a128551073512834" "b128551073512834" "c128551073512834" +"a107222526426812" "b107222526426812" "c107222526426812" +"a192822630622328" "b192822630622328" "c192822630622328" +"a1819108732235" "b1819108732235" "c1819108732235" +"a10323207312962" "b10323207312962" "c10323207312962" +"a15370296666320" "b15370296666320" "c15370296666320" +"a187742599011153" "b187742599011153" "c187742599011153" +"a18328230057849" "b18328230057849" "c18328230057849" +"a205222912631044" "b205222912631044" "c205222912631044" +"a392061491190" "b392061491190" "c392061491190" +"a235721900411925" "b235721900411925" "c235721900411925" +"a3638297274421" "b3638297274421" "c3638297274421" +"a304501624130727" "b304501624130727" "c304501624130727" +"a200101806031815" "b200101806031815" "c200101806031815" +"a19477283831120" "b19477283831120" "c19477283831120" +"a324401098630786" "b324401098630786" "c324401098630786" +"a59922976024008" "b59922976024008" "c59922976024008" +"a171451532014245" "b171451532014245" "c171451532014245" +"a24994307510604" "b24994307510604" "c24994307510604" +"a23270699516753" "b23270699516753" "c23270699516753" +"a24460305672989" "b24460305672989" "c24460305672989" +"a3617143832716" "b3617143832716" "c3617143832716" +"a80393188816189" "b80393188816189" "c80393188816189" +"a5998191311481" "b5998191311481" "c5998191311481" +"a5045584029865" "b5045584029865" "c5045584029865" +"a616555128083" "b616555128083" "c616555128083" +"a4184115045075" "b4184115045075" "c4184115045075" +"a281922864920395" "b281922864920395" "c281922864920395" +"a96702087523470" "b96702087523470" "c96702087523470" +"a202741137830465" "b202741137830465" "c202741137830465" +"a4259307028265" "b4259307028265" "c4259307028265" +"a7248668829703" "b7248668829703" "c7248668829703" +"a71971472728823" "b71971472728823" "c71971472728823" +"a233862072515186" "b233862072515186" "c233862072515186" +"a248682577121027" "b248682577121027" "c248682577121027" +"a219653193626539" "b219653193626539" "c219653193626539" +"a3004833525276" "b3004833525276" "c3004833525276" +"a2355315451157" "b2355315451157" "c2355315451157" +"a22750844722033" "b22750844722033" "c22750844722033" +"a1345328721643" "b1345328721643" "c1345328721643" +"a111502123713" "b111502123713" "c111502123713" +"a6647746010401" "b6647746010401" "c6647746010401" +"a35821465725128" "b35821465725128" "c35821465725128" +"a32406527613086" "b32406527613086" "c32406527613086" +"a14824301446089" "b14824301446089" "c14824301446089" +"a3083193415257" "b3083193415257" "c3083193415257" +"a29623166218610" "b29623166218610" "c29623166218610" +"a2131189767387" "b2131189767387" "c2131189767387" +"a3288895815834" "b3288895815834" "c3288895815834" +"a253212241111787" "b253212241111787" "c253212241111787" +"a2596479411999" "b2596479411999" "c2596479411999" +"a29678744119459" "b29678744119459" "c29678744119459" +"a7311110241349" "b7311110241349" "c7311110241349" +"a32440106626625" "b32440106626625" "c32440106626625" +"a12758254864001" "b12758254864001" "c12758254864001" +"a188472857023342" "b188472857023342" "c188472857023342" +"a24104254257195" "b24104254257195" "c24104254257195" +"a327142755626171" "b327142755626171" "c327142755626171" +"a7333308442361" "b7333308442361" "c7333308442361" +"a231672339824773" "b231672339824773" "c231672339824773" +"a21861659425567" "b21861659425567" "c21861659425567" +"a1418513504240" "b1418513504240" "c1418513504240" +"a8772081611264" "b8772081611264" "c8772081611264" +"a22262048821926" "b22262048821926" "c22262048821926" +"a885147814645" "b885147814645" "c885147814645" +"a128521932510447" "b128521932510447" "c128521932510447" +"a3426106613104" "b3426106613104" "c3426106613104" +"a106211060830660" "b106211060830660" "c106211060830660" +"a40241794128736" "b40241794128736" "c40241794128736" +"a6385834119366" "b6385834119366" "c6385834119366" +"a31158105273193" "b31158105273193" "c31158105273193" +"a239572471316697" "b239572471316697" "c239572471316697" +"a24198255904745" "b24198255904745" "c24198255904745" +"a26942781625233" "b26942781625233" "c26942781625233" +"a24621389925711" "b24621389925711" "c24621389925711" +"a64981675112268" "b64981675112268" "c64981675112268" +"a169452017722930" "b169452017722930" "c169452017722930" +"a2004930798770" "b2004930798770" "c2004930798770" +"a17941205418711" "b17941205418711" "c17941205418711" +"a13909843927052" "b13909843927052" "c13909843927052" +"a50868304812" "b50868304812" "c50868304812" +"a37013078729525" "b37013078729525" "c37013078729525" +"a203982221722347" "b203982221722347" "c203982221722347" +"a251442491217395" "b251442491217395" "c251442491217395" +"a176091676521294" "b176091676521294" "c176091676521294" +"a10553232635277" "b10553232635277" "c10553232635277" +"a22821744025454" "b22821744025454" "c22821744025454" +"a129832748923484" "b129832748923484" "c129832748923484" +"a137531266225538" "b137531266225538" "c137531266225538" +"a32465265711209" "b32465265711209" "c32465265711209" +"a26749270798039" "b26749270798039" "c26749270798039" +"a31561307806059" "b31561307806059" "c31561307806059" +"a283181841128276" "b283181841128276" "c283181841128276" +"a178971078720420" "b178971078720420" "c178971078720420" +"a2524283964417" "b2524283964417" "c2524283964417" +"a23818618127680" "b23818618127680" "c23818618127680" +"a29095290032352" "b29095290032352" "c29095290032352" +"a21781921829841" "b21781921829841" "c21781921829841" +"a12497229729735" "b12497229729735" "c12497229729735" +"a5267226693539" "b5267226693539" "c5267226693539" +"a64771665030618" "b64771665030618" "c64771665030618" +"a145161544428631" "b145161544428631" "c145161544428631" +"a205751099414274" "b205751099414274" "c205751099414274" +"a160842889225061" "b160842889225061" "c160842889225061" +"a37363141620689" "b37363141620689" "c37363141620689" +"a81542246726871" "b81542246726871" "c81542246726871" +"a30661879423106" "b30661879423106" "c30661879423106" +"a5419780832324" "b5419780832324" "c5419780832324" +"a24922030522528" "b24922030522528" "c24922030522528" +"a122282557312429" "b122282557312429" "c122282557312429" +"a157673205029080" "b157673205029080" "c157673205029080" +"a136171379811756" "b136171379811756" "c136171379811756" +"a9480160622750" "b9480160622750" "c9480160622750" +"a237541769018874" "b237541769018874" "c237541769018874" +"a160472142617523" "b160472142617523" "c160472142617523" +"a3969295807222" "b3969295807222" "c3969295807222" +"a308403264726016" "b308403264726016" "c308403264726016" +"a2117852981056" "b2117852981056" "c2117852981056" +"a20734779021362" "b20734779021362" "c20734779021362" +"a104952001814167" "b104952001814167" "c104952001814167" +"a22924301713449" "b22924301713449" "c22924301713449" +"a192361663527247" "b192361663527247" "c192361663527247" +"a309922611528853" "b309922611528853" "c309922611528853" +"a209751710213775" "b209751710213775" "c209751710213775" +"a70813812434" "b70813812434" "c70813812434" +"a24604435032014" "b24604435032014" "c24604435032014" +"a31826242231893" "b31826242231893" "c31826242231893" +"a25075236004423" "b25075236004423" "c25075236004423" +"a261311156712214" "b261311156712214" "c261311156712214" +"a147252206232232" "b147252206232232" "c147252206232232" +"a28892122182482" "b28892122182482" "c28892122182482" +"a95733145519117" "b95733145519117" "c95733145519117" +"a40532967912464" "b40532967912464" "c40532967912464" +"a1381788629566" "b1381788629566" "c1381788629566" +"a139142496829948" "b139142496829948" "c139142496829948" +"a16348168041530" "b16348168041530" "c16348168041530" +"a15594158633953" "b15594158633953" "c15594158633953" +"a14720817027553" "b14720817027553" "c14720817027553" +"a1914315336352" "b1914315336352" "c1914315336352" +"a313571625928414" "b313571625928414" "c313571625928414" +"a30822123837865" "b30822123837865" "c30822123837865" +"a536219576552" "b536219576552" "c536219576552" +"a19653260103463" "b19653260103463" "c19653260103463" +"a321172614821350" "b321172614821350" "c321172614821350" +"a28916729413550" "b28916729413550" "c28916729413550" +"a260962364230354" "b260962364230354" "c260962364230354" +"a27626646913449" "b27626646913449" "c27626646913449" +"a315792118921619" "b315792118921619" "c315792118921619" +"a26365756423153" "b26365756423153" "c26365756423153" +"a3271761546644" "b3271761546644" "c3271761546644" +"a28364420819027" "b28364420819027" "c28364420819027" +"a346147448216" "b346147448216" "c346147448216" +"a10013243971458" "b10013243971458" "c10013243971458" +"a134762374627607" "b134762374627607" "c134762374627607" +"a2058198942133" "b2058198942133" "c2058198942133" +"a156081322225776" "b156081322225776" "c156081322225776" +"a13195808132245" "b13195808132245" "c13195808132245" +"a26644689220666" "b26644689220666" "c26644689220666" +"a1549648928230" "b1549648928230" "c1549648928230" +"a58814391616" "b58814391616" "c58814391616" +"a12525288035824" "b12525288035824" "c12525288035824" +"a315523226410568" "b315523226410568" "c315523226410568" +"a700195092197" "b700195092197" "c700195092197" +"a84592298525944" "b84592298525944" "c84592298525944" _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
