Changeset: 74e29a0bad91 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=74e29a0bad91 Added Files: sql/test/xquery/Tests/create.test sql/test/xquery/Tests/drop.test sql/test/xquery/Tests/q01.test Branch: mtest Log Message:
Converted sql/test/xquery. diffs (truncated from 156917 to 300 lines): diff --git a/sql/test/xquery/Tests/create.test b/sql/test/xquery/Tests/create.test new file mode 100644 --- /dev/null +++ b/sql/test/xquery/Tests/create.test @@ -0,0 +1,156805 @@ +statement ok +START TRANSACTION + +statement ok +create table names( + nameid integer not null primary key, + name varchar(100)) + +statement ok +create table doc( + pre integer not null primary key, + size integer not null, + level smallint not null, + kind smallint not null, + nameid integer references names(nameid), + value varchar(100)) + +statement ok +copy 77 RECORDS into names from stdin DELIMITERS ',',E'\n','"' +<COPY_INTO_DATA> +0,"site" +1,"regions" +2,"africa" +3,"item" +4,"id" +5,"location" +6,"quantity" +7,"name" +8,"payment" +9,"description" +10,"parlist" +11,"listitem" +12,"text" +13,"keyword" +14,"shipping" +15,"incategory" +16,"category" +17,"mailbox" +18,"mail" +19,"from" +20,"to" +21,"date" +22,"emph" +23,"bold" +24,"featured" +25,"asia" +26,"australia" +27,"europe" +28,"namerica" +29,"samerica" +30,"categories" +31,"catgraph" +32,"edge" +33,"people" +34,"person" +35,"emailaddress" +36,"phone" +37,"homepage" +38,"profile" +39,"income" +40,"interest" +41,"education" +42,"gender" +43,"business" +44,"age" +45,"address" +46,"street" +47,"city" +48,"country" +49,"province" +50,"zipcode" +51,"watches" +52,"watch" +53,"open_auction" +54,"creditcard" +55,"open_auctions" +56,"initial" +57,"bidder" +58,"time" +59,"personref" +60,"increase" +61,"current" +62,"privacy" +63,"itemref" +64,"seller" +65,"annotation" +66,"author" +67,"happiness" +68,"type" +69,"interval" +70,"start" +71,"end" +72,"reserve" +73,"closed_auctions" +74,"closed_auction" +75,"buyer" +76,"price" + +statement ok +copy 156690 RECORDS into doc from stdin DELIMITERS ',',E'\n','"' NULL as '' +<COPY_INTO_DATA> +2,0,2,3,," " +4,0,3,3,," " +6,0,4,3,," " +8,0,5,2,4,"item0" +9,0,5,3,," " +11,0,6,3,,"United States" +10,1,5,1,5,"" +12,0,5,3,," " +14,0,6,3,,"1" +13,1,5,1,6,"" +15,0,5,3,," " +17,0,6,3,,"duteous nine eighteen " +16,1,5,1,7,"" +18,0,5,3,," " +20,0,6,3,,"Creditcard" +19,1,5,1,8,"" +21,0,5,3,," " +23,0,6,3,," " +25,0,7,3,," " +27,0,8,3,," " +29,0,9,3,," page rous lady idle authority capt professes stabs monster petition heave humbly removes rescue run" +31,0,10,3,," officer embrace such fears distinction attires " +30,1,9,1,13,"" +32,0,9,3,," " +28,4,8,1,12,"" +33,0,8,3,," " +26,7,7,1,11,"" +34,0,7,3,," " +36,0,8,3,," " +38,0,9,3,," shepherd noble supposed dotage humble servilius bitch theirs venus dismal wounds gum merely raise r" +37,1,8,1,12,"" +39,0,8,3,," " +35,4,7,1,11,"" +40,0,7,3,," " +24,16,6,1,10,"" +41,0,6,3,," " +22,19,5,1,9,"" +42,0,5,3,," " +44,0,6,3,,"Will ship internationally,See description for charges" +43,1,5,1,14,"" +45,0,5,3,," " +47,0,6,2,16,"category15" +46,1,5,1,15,"" +48,0,5,3,," " +50,0,6,2,16,"category12" +49,1,5,1,15,"" +51,0,5,3,," " +53,0,6,2,16,"category28" +52,1,5,1,15,"" +54,0,5,3,," " +56,0,6,2,16,"category22" +55,1,5,1,15,"" +57,0,5,3,," " +59,0,6,2,16,"category0" +58,1,5,1,15,"" +60,0,5,3,," " +62,0,6,3,," " +64,0,7,3,," " +66,0,8,3,,"Libero Rive mailto:r...@hitachi.com"; +65,1,7,1,19,"" +67,0,7,3,," " +69,0,8,3,,"Benedikte Glew mailto:g...@sds.no"; +68,1,7,1,20,"" +70,0,7,3,," " +72,0,8,3,,"07/05/2000" +71,1,7,1,21,"" +73,0,7,3,," " +75,0,8,3,," virgin preventions half logotype weapons granted factious already carved fretted impress pestilent " +77,0,9,3,," girdles deserts flood george nobility reprieve " +76,1,8,1,13,"" +78,0,8,3,," discomfort sinful conceiv corn preventions greatly suit observe sinews enforcement " +80,0,9,3,," armed " +79,1,8,1,22,"" +81,0,8,3,," gold gazing set almost catesby turned servilius cook doublet preventions shrunk smooth great choice" +74,7,7,1,12,"" +82,0,7,3,," " +63,19,6,1,18,"" +83,0,6,3,," " +61,22,5,1,17,"" +84,0,5,3,," " +7,77,4,1,3,"" +85,0,4,3,," " +87,0,5,2,4,"item1" +88,0,5,3,," " +90,0,6,3,,"Moldova,Republic Of" +89,1,5,1,5,"" +91,0,5,3,," " +93,0,6,3,,"1" +92,1,5,1,6,"" +94,0,5,3,," " +96,0,6,3,,"condemn " +95,1,5,1,7,"" +97,0,5,3,," " +99,0,6,3,,"Money order,Creditcard,Cash" +98,1,5,1,8,"" +100,0,5,3,," " +102,0,6,3,," " +104,0,7,3,," gold promotions despair flow tempest pitch concluded dian wenches musing author debase get bourn op" +103,1,6,1,12,"" +105,0,6,3,," " +101,4,5,1,9,"" +106,0,5,3,," " +108,0,6,3,,"Will ship only within country,Buyer pays fixed shipping charges,See description for charges" +107,1,5,1,14,"" +109,0,5,3,," " +111,0,6,2,16,"category28" +110,1,5,1,15,"" +112,0,5,3,," " +114,0,6,2,16,"category14" +113,1,5,1,15,"" +115,0,5,3,," " +117,0,6,2,16,"category21" +116,1,5,1,15,"" +118,0,5,3,," " +120,0,6,2,16,"category20" +119,1,5,1,15,"" +121,0,5,3,," " +123,0,6,2,16,"category14" +122,1,5,1,15,"" +124,0,5,3,," " +126,0,6,2,16,"category1" +125,1,5,1,15,"" +127,0,5,3,," " +129,0,6,2,16,"category28" +128,1,5,1,15,"" +130,0,5,3,," " +132,0,6,2,16,"category1" +131,1,5,1,15,"" +133,0,5,3,," " +135,0,6,2,16,"category6" +134,1,5,1,15,"" +136,0,5,3,," " +138,0,6,3,," " +140,0,7,3,," " +142,0,8,3,,"Javam Suwanda mailto:suwa...@gmu.edu"; +141,1,7,1,19,"" +143,0,7,3,," " +145,0,8,3,,"Mehrdad Glew mailto:g...@cohera.com"; +144,1,7,1,20,"" +146,0,7,3,," " +148,0,8,3,,"05/28/2001" +147,1,7,1,21,"" +149,0,7,3,," " +151,0,8,3,," back greg flay across sickness peter enough royal herb embrace piteous die servilius avoid " +153,0,9,3,," laying chance dungeons pleasant thyself fellow purse steward heaven ambassador terrible doubtfully " +152,1,8,1,13,"" +154,0,8,3,," milk sky clouds unbraced put sacrifices seas childish longer flout heavy pitch rosalind orderly mus" +156,0,9,3,," preparation rejoice gallants shepherd barbarian ford " +155,1,8,1,13,"" +157,0,8,3,," ruin coxcomb excess " +159,0,9,3,," childish carrions imaginary wooden preventions bounteous sounded consider sayings fishified fine pr" +158,1,8,1,23,"" +160,0,8,3,," ponderous doubtful rite " +162,0,9,3,," dotage discipline choughs mew here " +161,1,8,1,22,"" +163,0,8,3,," vill discontent manage beatrice straight muse shame prays maecenas any conveyance fingers whereupon" +165,0,9,3,," season presently victory women beating " +164,1,8,1,13,"" +166,0,8,3,," deprive almost wed dreams slew " +150,16,7,1,12,"" +167,0,7,3,," " +139,28,6,1,18,"" +168,0,6,3,," " +137,31,5,1,17,"" +169,0,5,3,," " +86,83,4,1,3,"" +170,0,4,3,," " +172,0,5,2,4,"item2" +173,0,5,3,," " +175,0,6,3,,"United States" +174,1,5,1,5,"" +176,0,5,3,," " +178,0,6,3,,"1" +177,1,5,1,6,"" +179,0,5,3,," " +181,0,6,3,,"earnestly subtle spotted attend " +180,1,5,1,7,"" +182,0,5,3,," " +184,0,6,3,,"Money order,Cash" +183,1,5,1,8,"" +185,0,5,3,," " +187,0,6,3,," " +189,0,7,3,," " +191,0,8,3,," " +193,0,9,3,," tormenting " +195,0,10,3,," naturally sanctuary riddle exile coming awake senseless chance famous albans " +194,1,9,1,23,"" +196,0,9,3,," service cricket limb from clouds amongst shore penker defend quantity dumb churlish uncover swung e" +198,0,10,3,," battle friar prophetess " +197,1,9,1,23,"" +199,0,9,3,," spirits delays turning cassio finding unpractis steel sweets promises credulity err nym complete st" +201,0,10,3,," tract element sails course placed fouler four plac joint " +200,1,9,1,13,"" +202,0,9,3,," words blessing fortified loving forfeit doctor valiant crying wife county planet charge haughty pre" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
