Changeset: 2ecc0105ecac for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2ecc0105ecac
Modified Files:
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
sql/test/testdb/Tests/load.test
Branch: ustr
Log Message:
Test dumping of DISTINCT COLUMN NAME.
diffs (truncated from 2073 to 300 lines):
diff --git a/sql/test/testdb/Tests/dump-nogeom.stable.out
b/sql/test/testdb/Tests/dump-nogeom.stable.out
--- a/sql/test/testdb/Tests/dump-nogeom.stable.out
+++ b/sql/test/testdb/Tests/dump-nogeom.stable.out
@@ -12,6 +12,7 @@ CREATE SEQUENCE "testschema"."selfref_se
COMMENT ON SEQUENCE "testschema"."selfref_seq" IS 'sequence number for selfref
table';
CREATE SEQUENCE "testschema"."test_seq" AS INTEGER;
COMMENT ON SEQUENCE "testschema"."test_seq" IS 'sequence number for testing';
+CREATE DISTINCT STRING COLUMN "testschema"."unique_strings";
SET SCHEMA "testschema";
CREATE TABLE "testschema"."smallstring" (
"string1" VARCHAR(5),
@@ -101103,6 +101104,1013 @@ COPY 100001 RECORDS INTO "testschema"."b
"a28376278551650631921433018887220492424110072"
"b28376278551650631921433018887220492424110072"
"c28376278551650631921433018887220492424110072"
"a530225602237628827142912782725361277953237"
"b530225602237628827142912782725361277953237"
"c530225602237628827142912782725361277953237"
"a3062016757282831719336781180126660209592607"
"b3062016757282831719336781180126660209592607"
"c3062016757282831719336781180126660209592607"
+CREATE TABLE "testschema"."mediumstring_unique" (
+ "string1" VARCHAR(20) DISTINCT STRING COLUMN
"testschema"."unique_strings",
+ "string2" CHAR(20) DISTINCT STRING COLUMN
"testschema"."unique_strings",
+ "string3" CHARACTER LARGE OBJECT DISTINCT STRING COLUMN
"testschema"."unique_strings"
+);
+COPY 1001 RECORDS INTO "testschema"."mediumstring_unique" FROM stdin USING
DELIMITERS E'\t',E'\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"
+"a32982504413070" "b32982504413070" "c32982504413070"
+"a5432788426293" "b5432788426293" "c5432788426293"
+"a31208210791606" "b31208210791606" "c31208210791606"
+"a30685149568498" "b30685149568498" "c30685149568498"
+"a18583304528988" "b18583304528988" "c18583304528988"
+"a1404535659427" "b1404535659427" "c1404535659427"
+"a15662160905462" "b15662160905462" "c15662160905462"
+"a21486148744958" "b21486148744958" "c21486148744958"
+"a320552187514467" "b320552187514467" "c320552187514467"
+"a1484303354684" "b1484303354684" "c1484303354684"
+"a2742886529728" "b2742886529728" "c2742886529728"
+"a773162974845" "b773162974845" "c773162974845"
+"a1256473725924" "b1256473725924" "c1256473725924"
+"a286226548112" "b286226548112" "c286226548112"
+"a11360212375796" "b11360212375796" "c11360212375796"
+"a2034825159361" "b2034825159361" "c2034825159361"
+"a297751817725451" "b297751817725451" "c297751817725451"
+"a246968957558" "b246968957558" "c246968957558"
+"a7427618229433" "b7427618229433" "c7427618229433"
+"a21894766727000" "b21894766727000" "c21894766727000"
+"a26579232727866" "b26579232727866" "c26579232727866"
+"a23539100581395" "b23539100581395" "c23539100581395"
+"a28384113146133" "b28384113146133" "c28384113146133"
+"a21541141768787" "b21541141768787" "c21541141768787"
+"a296532553730025" "b296532553730025" "c296532553730025"
+"a26821311732540" "b26821311732540" "c26821311732540"
+"a120431012517949" "b120431012517949" "c120431012517949"
+"a47271259424844" "b47271259424844" "c47271259424844"
+"a122852002231027" "b122852002231027" "c122852002231027"
+"a895091485926" "b895091485926" "c895091485926"
+"a318329598253" "b318329598253" "c318329598253"
+"a310492649918312" "b310492649918312" "c310492649918312"
+"a324442211529626" "b324442211529626" "c324442211529626"
+"a58091088811035" "b58091088811035" "c58091088811035"
+"a1459777743804" "b1459777743804" "c1459777743804"
+"a118541045616921" "b118541045616921" "c118541045616921"
+"a116262249927046" "b116262249927046" "c116262249927046"
+"a29575272266873" "b29575272266873" "c29575272266873"
+"a21651674326895" "b21651674326895" "c21651674326895"
+"a19910156943275" "b19910156943275" "c19910156943275"
+"a25836188776235" "b25836188776235" "c25836188776235"
+"a13221715832734" "b13221715832734" "c13221715832734"
+"a196341683422081" "b196341683422081" "c196341683422081"
+"a1649222644202" "b1649222644202" "c1649222644202"
+"a2752744737976" "b2752744737976" "c2752744737976"
+"a313311632718432" "b313311632718432" "c313311632718432"
+"a15485279538163" "b15485279538163" "c15485279538163"
+"a9763247602622" "b9763247602622" "c9763247602622"
+"a16636136439365" "b16636136439365" "c16636136439365"
+"a1076378625059" "b1076378625059" "c1076378625059"
+"a140392662211168" "b140392662211168" "c140392662211168"
+"a202742794428326" "b202742794428326" "c202742794428326"
+"a202401481012393" "b202401481012393" "c202401481012393"
+"a9553313032269" "b9553313032269" "c9553313032269"
+"a9755260626742" "b9755260626742" "c9755260626742"
+"a177312462623069" "b177312462623069" "c177312462623069"
+"a3395734318254" "b3395734318254" "c3395734318254"
+"a115591710610246" "b115591710610246" "c115591710610246"
+"a1418197523889" "b1418197523889" "c1418197523889"
+"a235461173824675" "b235461173824675" "c235461173824675"
+"a158382577718530" "b158382577718530" "c158382577718530"
+"a270061328313706" "b270061328313706" "c270061328313706"
+"a2256575528517" "b2256575528517" "c2256575528517"
+"a21901030927052" "b21901030927052" "c21901030927052"
+"a44592006420346" "b44592006420346" "c44592006420346"
+"a11201502812204" "b11201502812204" "c11201502812204"
+"a1502842319547" "b1502842319547" "c1502842319547"
+"a19756199823886" "b19756199823886" "c19756199823886"
+"a3000213954861" "b3000213954861" "c3000213954861"
+"a211232494216599" "b211232494216599" "c211232494216599"
+"a1303180129609" "b1303180129609" "c1303180129609"
+"a31561225022892" "b31561225022892" "c31561225022892"
+"a124992481523648" "b124992481523648" "c124992481523648"
+"a8248270051189" "b8248270051189" "c8248270051189"
+"a25323146421253" "b25323146421253" "c25323146421253"
+"a22879989726281" "b22879989726281" "c22879989726281"
+"a2315113991937" "b2315113991937" "c2315113991937"
+"a218633115521919" "b218633115521919" "c218633115521919"
+"a257492838923315" "b257492838923315" "c257492838923315"
+"a306101674515489" "b306101674515489" "c306101674515489"
+"a144412977623501" "b144412977623501" "c144412977623501"
+"a240502856925751" "b240502856925751" "c240502856925751"
+"a14175830017799" "b14175830017799" "c14175830017799"
+"a50551654912036" "b50551654912036" "c50551654912036"
+"a62441908110733" "b62441908110733" "c62441908110733"
+"a27497919220630" "b27497919220630" "c27497919220630"
+"a210111150832030" "b210111150832030" "c210111150832030"
+"a2294860330417" "b2294860330417" "c2294860330417"
+"a120992635226039" "b120992635226039" "c120992635226039"
+"a26462419410016" "b26462419410016" "c26462419410016"
+"a1813558677024" "b1813558677024" "c1813558677024"
+"a8868299182825" "b8868299182825" "c8868299182825"
+"a18521132511125" "b18521132511125" "c18521132511125"
+"a196511638027674" "b196511638027674" "c196511638027674"
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
