Changeset: ab4e5351f91f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ab4e5351f91f Modified Files: Branch: default Log Message:
Merge with Oct2010 branch. diffs (truncated from 271979 to 300 lines): diff -r 71ba1e183f9a -r ab4e5351f91f sql/src/test/VOC/Tests/VOC.stable.out --- a/sql/src/test/VOC/Tests/VOC.stable.out Wed Oct 27 14:01:17 2010 +0200 +++ b/sql/src/test/VOC/Tests/VOC.stable.out Wed Oct 27 14:17:16 2010 +0200 @@ -1,19 +1,19 @@ stdout of test 'VOC` in directory 'src/test/VOC` itself: -# 17:11:18 > -# 17:11:18 > mserver5 "--config=/ufs/sjoerd/Monet-candidate/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=0 --set gdk_testing=true --set "monet_mod_path=/ufs/sjoerd/Monet-candidate/lib64/MonetDB5:/ufs/sjoerd/Monet-candidate/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-candidate/lib64/MonetDB5/bin" --set "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB5/dbfarm" --set mapi_open=true --set xrpc_open=true --set mapi_port=30367 --set xrpc_port=48749 --set monet_prompt= --set mal_listing=2 --trace "--dbname=mTests_src_test_VOC" --set mal_listing=0 ; echo ; echo Over.. -# 17:11:18 > +# 14:08:45 > +# 14:08:45 > mserver5 "--config=/ufs/sjoerd/Monet-candidate/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=1 --set "monet_mod_path=/ufs/sjoerd/Monet-candidate/lib64/MonetDB5:/ufs/sjoerd/Monet-candidate/lib64/MonetDB5/lib:/ufs/sjoerd/Monet-candidate/lib64/MonetDB5/bin" --set "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB5/dbfarm" --set mapi_open=true --set xrpc_open=true --set mapi_port=35193 --set xrpc_port=45172 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_src_test_VOC" --set mal_listing=0 ; echo ; echo Over.. +# 14:08:45 > # MonetDB server v5.22.0, based on kernel v1.40.0 # Not released -# Serving database 'mTests_src_test_VOC', using 4 threads +# Serving database 'mTests_src_test_VOC', using 1 thread # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # Found 7.750 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information -# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:30367/ +# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:35193/ # MonetDB/SQL module v2.40.0 loaded # MonetDB/GIS module v0.20.0 loaded @@ -22,14 +22,14 @@ Over.. -# 17:11:18 > -# 17:11:18 > /usr/bin/python VOC.SQL.py VOC -# 17:11:18 > +# 14:08:46 > +# 14:08:46 > /usr/bin/python VOC.SQL.py VOC +# 14:08:46 > -# 17:11:18 > -# 17:11:18 > mclient -lsql -ftest -e --host=ottar --port=30367 ../../../../../../../../../../../ufs/sjoerd/src/MonetDB/candidate/sql/src/test/VOC/Tests/../VOCcreate_user.sql -# 17:11:18 > +# 14:08:46 > +# 14:08:46 > Mtimeout -timeout 120 mclient -lsql -ftest -e --host=ottar --port=35193 ../../../../../../../../../../../ufs/sjoerd/src/MonetDB/candidate/sql/src/test/VOC/Tests/../VOCcreate_user.sql +# 14:08:46 > #START TRANSACTION; #CREATE USER "voc" WITH PASSWORD 'voc' NAME 'VOC_EXPLORER' SCHEMA "sys"; @@ -37,9 +37,9 @@ #ALTER USER "voc" SET SCHEMA "voc"; #commit; -# 17:11:18 > -# 17:11:18 > mclient -lsql -ftest -e --host=ottar --port=30367 ../../../../../../../../../../../ufs/sjoerd/src/MonetDB/candidate/sql/src/test/VOC/Tests/../VOCschema.sql -# 17:11:18 > +# 14:08:46 > +# 14:08:46 > Mtimeout -timeout 120 mclient -lsql -ftest -e --host=ottar --port=35193 ../../../../../../../../../../../ufs/sjoerd/src/MonetDB/candidate/sql/src/test/VOC/Tests/../VOCschema.sql +# 14:08:46 > #START TRANSACTION; #CREATE TABLE "voyages" ( @@ -140,58290 +140,213589 @@ #); #commit; -# 17:11:18 > -# 17:11:18 > mclient -lsql -ftest -e --host=ottar --port=30367 ../../../../../../../../../../../ufs/sjoerd/src/MonetDB/candidate/sql/src/test/VOC/Tests/../VOCinsert.sql -# 17:11:18 > +# 14:08:46 > +# 14:08:46 > Mtimeout -timeout 120 mclient -lsql -ftest -e --host=ottar --port=35193 ../../../../../../../../../../../ufs/sjoerd/src/MonetDB/candidate/sql/src/test/VOC/Tests/../VOCinsert.sql +# 14:08:46 > #START TRANSACTION; -#INSERT INTO "voyages" VALUES (1, '', 1, '', 'AMSTERDAM', 'Jan Jakobsz. Schellinger', 260, NULL, '1594', NULL, NULL, 'A', NULL, '1595-04-02', 'Texel', NULL, NULL, true, '1596-06-06', 'Engano', NULL, 'from 04-08 till 11-08 in the Mosselbaai; from 13-09 till 07-10 in the Ampalazabaai; from 09-10 till 13-12 in S. Augustins Bay, where before departure 127 of the 249 men were still alive; 11-01 till 21-01 at Ste. Marie I.; from 23-01 till 12-02 in the Bay of Antongil. The AMSTERDAM was set on fire near Bawean, 11 -[ 1 ] -#INSERT INTO "voyages" VALUES (2, '', 1, '', 'DUIFJE', 'Simon Lambrechtsz. Mau', 50, 'pinas', '1594', NULL, NULL, 'A', NULL, '1595-04-02', 'Texel', NULL, NULL, true, '1596-06-06', 'Engano', 5001, 'HOLLANDIA on 26-10-1595; he was succeeded by Hendrik Jansz.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (3, '', 1, '', 'HOLLANDIA', 'Jan Dignumsz. van Kwadijk+', 460, NULL, '1594', NULL, NULL, 'A', NULL, '1595-04-02', 'Texel', NULL, NULL, true, '1596-06-06', 'Engano', 5002, 'Jan Dignumsz. died on 29-05-1595 and Mau was his successor.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (4, '', 1, '', 'MAURITIUS', 'Jan Jansz. Molenaar', 460, NULL, '1594', NULL, NULL, 'A', NULL, '1595-04-02', 'Texel', NULL, NULL, true, '1596-06-06', 'Engano', 5003, 'Jan Jansz. died on 25-12-1596 and Hendrik Jansz. was his successor.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (5, '', 1, '', 'LANGEBARK', 'Hans Huibrechtsz. Tonneman', 300, NULL, NULL, NULL, NULL, NULL, NULL, '1598-03-25', 'Zeeland', NULL, NULL, true, '1599-03-01', 'Bantam', 5010, 'other.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (6, '', 1, '', 'MAAN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1598-03-25', 'Zeeland', NULL, NULL, true, NULL, NULL, NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (7, '', 1, '', 'ZON', NULL, 140, NULL, NULL, NULL, NULL, NULL, NULL, '1598-03-25', 'Zeeland', NULL, NULL, true, '1599-02-01', 'Bantam', 5011, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (8, '', 1, '', 'LEEUW', 'Stokmans', 400, NULL, NULL, NULL, NULL, NULL, NULL, '1598-03-28', 'Veere', NULL, NULL, true, '1599-06-30', 'Atjeh', 5012, '01-04 till 17-04 at Torbay; from 11-05 till 19-05 at S. Nicolas; from 21-06 till 05-09 before Fernando de Noronha; from 17-11 till 18-11 in St. Helena Bay; from 21-11 till 07-12 in the Saldanha Bay; from 13-02 till 24-03 in S. Augustins Bay; from 10-04 till 27-04 at Mayotte; from 29-04 till 08-05 at Anjouan.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (9, '', 1, '', 'LEEUWIN', 'Frederik de Houtman', 250, NULL, NULL, NULL, NULL, NULL, NULL, '1598-03-28', 'Veere', NULL, NULL, true, '1599-06-30', 'Atjeh', 5013, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (26, '', 1, '', 'HOOP', 'Jakob Jansz. Huidekoper', 50, 'jacht', NULL, NULL, NULL, NULL, NULL, '1598-09-13', 'Zeeland', NULL, NULL, true, NULL, NULL, NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (27, '', 1, '', 'MAURITIUS', 'Huigen Jansz. van Troyen', 250, NULL, NULL, NULL, NULL, NULL, NULL, '1598-09-13', 'Zeeland', NULL, NULL, true, '1601-01-29', 'Djaratan', 5022, 'A'); -[ 1 ] -#INSERT INTO "voyages" VALUES (28, '', 1, '', 'WASSENDE MAAN', 'Kornelis Heinsz.', 500, NULL, NULL, NULL, NULL, NULL, NULL, '1599-04-06', 'Texel', NULL, NULL, true, '1600-03-13', 'Bantam', 5017, 'till 16-05 at Maio I.; from 02-07 till 17-07 before Corsico; from 27-10 till 10-11 Sonnebaai (Madagascar) and from 17-11 till 21-12 in the Bay of Antongil.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (29, '', 1, '', 'MORGENSTER', 'Kornelis Jansz. Melknap', 400, NULL, NULL, NULL, NULL, NULL, NULL, '1599-04-06', 'Texel', NULL, NULL, true, '1600-03-13', 'Bantam', 5019, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (30, '', 1, '', 'ZON', 'Kornelis Jansz. Schouten', 580, NULL, NULL, NULL, NULL, NULL, NULL, '1599-04-06', 'Texel', NULL, NULL, true, '1600-03-13', 'Bantam', 5022, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (31, '', 2, '', 'FRIESLAND', 'Jakob Pietersz.', 180, 'jacht', NULL, NULL, NULL, NULL, NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-09-01', 'Bantam', 5016, 'Squadron (0031-0034) of the fleet of Van Neck which sailed later under command of vice-admiraal Jakob Willekens aboard the MAURITIUS.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (32, '', 3, '', 'HOLLANDIA', 'Pieter Klaasz. Nek', 460, NULL, '1594', NULL, NULL, 'A', NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-09-01', 'Bantam', 5026, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (33, '', 3, '', 'OVERIJSSEL', 'Thijmen Michielsz.', 50, 'jacht', '1594', NULL, NULL, 'A', NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-09-01', 'Bantam', 5028, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (34, '', 3, '', 'MAURITIUS', 'Govert Jansz.', 460, NULL, '1594', NULL, NULL, 'A', NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-09-01', 'Bantam', 5018, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (35, '', 1, '', 'HOF VAN HOLLAND', 'Jakob Dirksz.', 360, NULL, NULL, NULL, NULL, NULL, NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-08-06', 'Bantam', 5024, 'Fleet (0035-0038) under command of admiraal Pieter Both aboard the NEDERLAND and vice-admiraal Paulus van Caerden aboard the VERENIGDE LANDEN, equipped by the Nieuwe Brabantsche Compagnie.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (36, '', 1, '', 'VERENIGDE LANDEN', 'Klaas Gerritsz.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-08-06', 'Bantam', 5025, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (37, '', 1, '', 'NASSAU', 'Frederik Kornelisz.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-08-06', 'Bantam', 5020, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (38, '', 1, '', 'NEDERLAND', 'Ernst van Ommeren', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1599-12-21', 'Texel', NULL, NULL, true, '1600-08-06', 'Bantam', 5021, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (39, '', 1, '', 'ZWARTE AREND', NULL, 600, NULL, NULL, NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-10-01', 'Bantam', 5032, 'Fleet (0039-0040) under command of admiraal Guilleaume Seneschel aboard the ZWARTE AREND, equipped by the Nieuwe Brabantsche Compagnie. From 01-07 till 06-07 at the Downs; from 12-07 till 14-07 at Portland; from 29-09 till 31-09 at Annabon.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (40, '', 1, '', 'WITTE AREND', NULL, 600, NULL, NULL, NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-10-01', 'Bantam', 5031, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (41, '', 1, '', 'AMSTERDAM', 'Simon Lambrechtsz. Mau', 900, NULL, '1600', NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-03-30', 'Bantam', 5042, 'Fleet (0041-0046) under command of Van Neck aboard the AM-STERDAM and Foreest aboard the DORDRECHT, equipped by the Oude Oostindische Compagnie. From 01-10 till 10-10 at Annabon whereafter the fleet was divided into 2 squadrons: 1 squadron under command of Van Neck, consisted of the AMSTERDAM, the GOUDA, the DEL -[ 1 ] -#INSERT INTO "voyages" VALUES (42, '', 1, '', 'DELFT', 'Simon Jansz. Hoen', 300, 'jacht', NULL, NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-03-30', 'Bantam', 5023, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (43, '', 1, '', 'DORDRECHT', 'Dirk Mol', 900, NULL, '1600', NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-08-09', 'Bantam', 5033, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (44, '', 1, '', 'GOUDA', 'Klaas Kornelisz.', 280, 'jacht', '1600', NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-03-30', 'Bantam', 5043, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (45, '', 1, '', 'HAARLEM', 'Kornelis Klaasz.', 350, NULL, '1600', NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-08-09', 'Bantam', NULL, 'Left behind at Patani in September 1603 as unseaworthy.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (46, '', 1, '', 'LEIDEN', 'Hendrik Jansz.', 280, NULL, NULL, NULL, NULL, NULL, NULL, '1600-06-28', 'Texel', NULL, NULL, true, '1601-08-09', 'Bantam', 5056, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (47, '', 2, '', 'LANGEBARK', 'Nikolaas Anthonisz.', 300, NULL, NULL, NULL, NULL, NULL, NULL, '1601-01-28', 'Zeeland', NULL, NULL, true, '1601-08-23', 'Atjeh', 5029, 'number of deaths 5.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (48, '', 1, '', 'MIDDELBURG', 'Hans Huibrechtsz. Tonneman', 400, NULL, NULL, NULL, NULL, NULL, NULL, '1601-01-28', 'Zeeland', NULL, NULL, true, '1601-08-23', 'Atjeh', 5044, 'The master died at Patani in 1602.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (49, '', 1, '', 'ZEELANDIA', 'Kornelis Bastiaansz.', 600, NULL, NULL, NULL, NULL, NULL, NULL, '1601-01-28', 'Zeeland', NULL, NULL, true, '1601-08-23', 'Atjeh', 5030, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (50, '', 2, '', 'ZON', 'Kornelis Adriaansz. Valk', 140, NULL, NULL, NULL, NULL, NULL, NULL, '1601-01-28', 'Zeeland', NULL, NULL, true, '1601-08-23', 'Atjeh', 5045, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (51, '', 2, '', 'GELDERLAND', 'Jan Bruin', 360, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1601-12-26', 'Bantam', 5040, 'Bouwer, equipped by the Oude Oostindische Compagnie. From 27-09 till 20-10 at Mauritius.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (52, '', 1, '', 'DUIFJE', 'Willem Kornelisz. Schouten', 60, 'jacht', NULL, NULL, NULL, NULL, NULL, '1611-04-23', 'Texel', NULL, NULL, true, '1601-12-26', 'Bantam', 5039, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (53, '', 2, '', 'UTRECHT', 'Jan Martensz.', 240, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1601-12-26', 'Bantam', NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (54, '', 1, '', 'WACHTER', 'Gerrit Hendriksz. Roobol', 130, 'jacht', NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1601-12-26', 'Bantam', NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (55, '', 2, '', 'ZEELANDIA', 'Jan Kornelisz.', 360, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1601-12-26', 'Bantam', 5041, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (56, '', 1, '', 'ALKMAAR', 'Pieter Stokmans', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1602-02-22', 'Bantam', 5050, 'Fleet (0056-0063) under command of admiraal Jakob van Heemskerk aboard the AMSTERDAM, equipped by the Eerste Verenigde Compagnie op Oost-Indie. From 24-06 till 01-07 at Fernando Noronha; from 10-11 till 08-12 at Mayotte.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (57, '', 2, '', 'AMSTERDAM', NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1602-02-22', 'Bantam', 5034, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (58, '', 1, '', 'ENKHUIZEN', 'Willem van Westzanen', NULL, 'jacht', NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1602-02-22', 'Bantam', 5035, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (59, '', 1, '', 'HOORN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1602-02-22', 'Bantam', 5036, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (60, '', 1, '', 'GROENE LEEUW', NULL, NULL, 'jacht', NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1602-02-22', 'Bantam', 5037, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (61, '', 1, '', 'RODE LEEUW', 'Pieter Klaasz.', NULL, 'jacht', NULL, NULL, NULL, NULL, NULL, '1601-04-23', 'Texel', NULL, NULL, true, NULL, NULL, NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (62, '', 1, '', 'WITTE LEEUW', NULL, 540, 'jacht', NULL, NULL, NULL, 'A', NULL, '1601-04-23', 'Texel', NULL, NULL, true, '1602-02-22', 'Bantam', 5051, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (63, '', 1, '', 'ZWARTE LEEUW', 'Adriaan Blok', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1601-04-22', 'Wielingen', NULL, NULL, true, '1602-04-04', 'Bantam', 5038, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (64, '', 1, '', 'LAM', 'Willem Jansz.', NULL, 'jacht or pinas', NULL, NULL, NULL, NULL, NULL, '1601-05-05', 'Veere', NULL, NULL, true, NULL, 'Atjeh', 5048, 'Compagnie de Moucheron. T otal number of those on board 225. From 10-05 till 15-05 at Dartmouth; from 14-06 till 20-06 at Portugal; from 02-08 till 11-08 at Corisco; from 17-08 till 30-08 at Cape Lopez; from 15-11 till 20-11 at St. Helena Bay. The SCHAAP took on provisions from 21-02 till 04-04 at the Comoro and May 31th at -[ 1 ] -#INSERT INTO "voyages" VALUES (65, '', 1, '', 'RAM', 'Guyon Le Fort', 110, NULL, NULL, NULL, NULL, NULL, NULL, '1601-05-05', 'Veere', NULL, NULL, true, '1602-09-16', 'Atjeh', NULL, 'With the death of Le Fort (26-06) the RAM was sold to the V.O.C. and put under the command of Sebald de Weert (see 0067-69).'); -[ 1 ] -#INSERT INTO "voyages" VALUES (66, '', 1, '', 'SCHAAP', 'Pieter Kornelisz.', 110, NULL, NULL, NULL, NULL, NULL, NULL, '1601-05-05', 'Veere', NULL, NULL, true, '1602-09-16', 'Atjeh', 5049, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (67, '', 1, '', 'TER GOES', 'Marten Jelisz. Spanjaard', 240, NULL, NULL, NULL, NULL, NULL, 'Z', '1602-03-31', 'Wielingen', NULL, NULL, true, '1602-11-28', 'Ceylon', 5059, 'fleet of Van Warwyck. The three ships of Zeeland preceded the rest of the fleet. Took on provisions in the Bay of Antongil.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (68, '', 1, '', 'VLISSINGEN', 'Laurens Fransz. van Vlissingen', 400, NULL, NULL, NULL, NULL, NULL, 'Z', '1602-03-31', 'Wielingen', NULL, NULL, true, '1602-11-28', 'Ceylon', 5070, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (69, '', 1, '', 'ZIERIKZEE', 'Govert Jansz.', 760, NULL, NULL, NULL, NULL, NULL, 'Z', '1602-03-31', 'Wielingen', NULL, NULL, true, '1602-11-28', 'Ceylon', 5061, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (70, '', 1, '', 'MAAGD VAN ENKHUIZEN', 'Kornelis Pietersz.', 320, NULL, NULL, NULL, NULL, NULL, 'E', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', 5047, 'The equipment (0070-0081) of the `Fourteen ships\' (without the jacht PAPEGAAITJE) under admiraal Wybrand van Warwyck on the MAURITIUS.From June 24th till July 10th the fleet lay off Plymouth; from October 11th till 21th off Annabon; and was on December 12th near the Cape. December 14th the HOLLAND, the HOLLA -[ 1 ] -#INSERT INTO "voyages" VALUES (71, '', 1, '', 'HOLLANDIA', 'Dirk Gerritsz. van Hoorn', 600, NULL, NULL, NULL, NULL, 'A', 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-03-10', 'Atjeh', 5069, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (72, '', 1, '', 'MAAN', 'Jan Kornelisz. Melknap', 500, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (73, '', 1, '', 'MAURITIUS', 'Pieter Kornelisz. van Petten', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', 5052, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (74, '', 1, '', 'NASSAU', 'Kornelis van de Venne', 320, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', 5057, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (75, '', 1, '', 'PAPEGAAITJE', NULL, 50, 'jacht', NULL, NULL, NULL, NULL, 'E', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (76, '', 1, '', 'STER', 'Abraham Mathijsz.', 360, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-03-10', 'Atjeh', 5058, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (77, '', 1, '', 'HOLLANDSE TUIN', 'Hendrik Haak', 360, NULL, NULL, NULL, NULL, NULL, 'E', '1602-06-17', 'Texel', NULL, NULL, true, '1603-03-10', 'Atjeh', 5060, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (78, '', 2, '', 'ZON', '(GROTE) Kornelis Jansz. Schouten', 580, NULL, NULL, NULL, NULL, NULL, 'A', '1602-06-17', 'Texel', NULL, NULL, true, '1603-04-29', 'Bantam', NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (79, '', 1, '', 'EENDRACHT', 'Adriaan Kornelisz. Haai', 240, NULL, NULL, NULL, NULL, NULL, 'D', '1602-06-18', 'Maas', NULL, NULL, true, '1603-04-29', 'Bantam', 5046, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (80, '', 1, '', 'ERASMUS', 'Klaas Jansz. van Dijk', 540, NULL, NULL, NULL, NULL, NULL, 'R', '1602-06-18', 'Maas', NULL, NULL, true, '1603-04-29', 'Bantam', 5055, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (81, '', 1, '', 'ROTTERDAM', 'Pieter Klaasz. Rochussen', 800, NULL, NULL, NULL, NULL, NULL, 'R', '1602-06-18', 'Maas', NULL, NULL, true, '1603-04-29', 'Bantam', 5053, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (82, '', 1, '', 'AMSTERDAM', 'Arend Klaasz. Kalkbuis', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1603-12-18', 'Texel', NULL, NULL, true, '1604-12-31', 'Bantam', 5067, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (83, '', 2, '', 'DELFT', 'Willem Kornelisz. Schouten', 300, 'jacht', NULL, NULL, NULL, NULL, 'A', '1603-12-18', 'Texel', NULL, NULL, true, '1605-01-01', 'Atjeh', NULL, 'According to Commelin the master was Willem Lok. The ship stayed in the Indies.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (84, '', 1, '', 'DORDRECHT', 'Hans Riemland', 900, NULL, NULL, NULL, NULL, NULL, 'Z', '1603-12-18', 'Wielingen', NULL, NULL, true, '1604-12-31', 'Bantam', 5068, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (85, '', 1, '', 'DUIFJE', 'Willem Jansz.', 60, 'jacht', NULL, NULL, NULL, 'A', 'A', '1603-12-18', 'Texel', NULL, NULL, true, '1604-12-11', 'Bantam', NULL, 'Stayed in the Indies.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (86, '', 1, '', 'ENKHUIZEN', 'Klaas Thijsz. Collet', 300, 'jacht', NULL, NULL, NULL, NULL, 'E', '1603-12-18', 'Texel', NULL, NULL, true, '1605-08-21', 'Bantam', NULL, 'Ran aground off Halmaheira, 1607.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (87, '', 1, '', 'GELDERLAND', 'Jan Jansz. Mol', 500, NULL, NULL, NULL, NULL, NULL, 'A', '1603-12-18', 'Texel', NULL, NULL, true, '1604-12-31', 'Bantam', 5062, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (88, '', 1, '', 'HOF VAN HOLLAND', 'Willem Lok', 360, NULL, NULL, NULL, NULL, NULL, 'A', '1603-12-18', 'Texel', NULL, NULL, true, NULL, 'Madagascar', 5054, 'Commelin the master was Willem Kornelisz. Schouten.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (89, '', 1, '', 'HOORN', 'Dirk Klaasz. Mooilieven', 700, NULL, NULL, NULL, NULL, 'H', 'H', '1603-12-18', 'Texel', NULL, NULL, true, '1604-12-31', 'Bantam', 5066, 'Took on provisions for about one month at Mauritius. Mooilieven was succeeded by Jan Konnelisz. van Avenhorn.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (90, '', 1, '', 'MEDEMBLIK', 'Dirk Klaasz. Mooilieven', 250, 'jacht', NULL, NULL, NULL, NULL, 'H', '1603-12-18', 'Texel', NULL, NULL, true, '1604-07-01', 'Bantam', 5074, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (91, '', 1, '', 'GEUNIEERDE PROVINCIEN', 'Simon Jansz. Hoen', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1603-12-18', 'Texel', NULL, NULL, true, '1604-12-31', 'Bantam', 5065, 'took over the cargo and sailed back home, the ME-DEMBLIK proceeded to Bantam.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (92, '', 1, '', 'WESTFRIESLAND', 'Jakob Jakobsz. Klunt', 700, NULL, NULL, NULL, NULL, 'E', 'E', '1603-12-18', 'Texel', NULL, NULL, true, '1604-12-31', 'Bantam', 5064, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (93, '', 1, '', 'ZEELANDIA', 'Krijn Pietersz.', 500, NULL, NULL, NULL, NULL, 'Z', 'Z', '1603-12-18', 'Wielingen', NULL, NULL, true, '1604-07-01', 'Cambodia', 5071, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (94, '', 1, '', 'GOUDA', 'Kornelis Heinsz. Pronk', 260, NULL, NULL, NULL, NULL, 'A', 'A', '1604-07-02', 'Texel', NULL, NULL, true, NULL, NULL, 5063, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (95, '', 1, '', 'EENDRACHT', 'Adriaan Kornelisz. Haai', 240, NULL, NULL, NULL, NULL, NULL, 'D', '1605-05-12', NULL, NULL, NULL, true, '1606-07-13', 'Bantam', NULL, 'Sent to Mauritius to collect ebony. According to Commelin departure 20-05-1605. At Mauritius 22-05-1606 (see 5068 and 5069). Destroyed by fire on the coast of Coromandel (1610).'); -[ 1 ] -#INSERT INTO "voyages" VALUES (96, '', 2, '', 'WITTE LEEUW', 'Wouter Jakobsz.', 540, 'jacht', NULL, NULL, NULL, 'A', 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 5073, 'was Gerrit Hendriksz. Roobol; according to Mac Leod Klaas Jansz. Melknap.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (97, '', 1, '', 'ZWARTE LEEUW', 'Gerrit Hendriksz. Roobol', 600, NULL, NULL, NULL, NULL, 'A', 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 5075, 'According to Mac Leod the master was Abraham Mathijsz.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (98, '', 2, '', 'MAURITIUS', 'Gerrit Klaasz.', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 5077, 'According to Mac Leod the master was Klaas Gerritsz.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (99, '', 1, '', 'MIDDELBURG', 'Simon Lambrechtsz. Mau.', 600, NULL, NULL, NULL, NULL, NULL, 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 18, '-08-1606 burnt in action before Malacca.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (100, '', 2, '', 'NASSAU', 'Abraham Mathijsz.', 320, NULL, NULL, NULL, NULL, NULL, 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 22, '-08-1606 burnt in action before Malacca. According to Commelin the master was Wouter Jakobsz.; according to Mac Leod Walter Karelsz. There were also 15 blacks on board.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (101, '', 1, '', 'ORANJE', 'Dirk Klaasz. Mol', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 5078, 'fleet was before Johore where it started operations against the Portuguese. The ERASMUS, the PRO-VINCIEN and probably the EENDRACHT departed not before 30-05 from the Maas. The first 2 ships joined Matelieff on 14-07-1607 off Malacca, the EENDRACHT was sent for Mauritius to collect ebony. In August 1610 this ship was destr -[ 1 ] -#INSERT INTO "voyages" VALUES (102, '', 1, '', 'GROTE ZON', 'Klaas Jansz. Melknap', 540, NULL, NULL, NULL, NULL, NULL, 'A', '1605-05-12', 'Texel', NULL, NULL, true, '1606-05-01', 'Johore', 5083, 'Purchased from the Admirality of Amsterdam, 1604.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (103, '', 1, '', 'AMSTERDAM', 'Reinier Lambrechtsz.', 700, NULL, NULL, NULL, NULL, 'A', 'Z', '1605-05-24', 'Wielingen', NULL, NULL, true, '1606-05-01', 'Johore', 5072, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (104, '', 1, '', 'KLEINE ZON', 'Kornelis Jorisz.', 220, NULL, NULL, NULL, NULL, 'Z', 'Z', '1605-05-24', 'Wielingen', NULL, NULL, true, '1606-05-01', 'Johore', NULL, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (105, '', 2, '', 'ERASMUS', 'Olivier Kornelisz.', 540, NULL, NULL, NULL, NULL, NULL, 'R', '1605-05-30', 'Goeree', NULL, NULL, true, '1606-07-14', 'Johore', 5081, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (106, '', 1, '', 'GEUNIEERDE PROVINCIEN', 'Anthonis Anthonisz. (Zwarte Teun)', 400, NULL, NULL, NULL, NULL, 'D', 'D', '1605-05-30', 'Goeree', NULL, NULL, true, '1606-07-14', 'Johore', 5076, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (107, '', 1, '', 'BANDA', 'Jan Bruin', 600, NULL, NULL, NULL, NULL, NULL, 'A', '1606-04-20', 'Texel', NULL, NULL, true, '1607-10-02', 'Goa', 5088, 'number of those on board was 1060. From 23-05 till 03-06 on the roadstead of the isle of Wight, the 3 ships from Zeeland arrived here 25-05; 29-03 at Mozambique, where they started operations against the Portuguese. When leaving, 26-05, the ZIERIKZEE ran aground and was lost; the mainfleet was therefore unable to sail before June, 29 -[ 1 ] -#INSERT INTO "voyages" VALUES (108, '', 1, '', 'BANTAM', 'Pieter Kornelisz. van Petten', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1606-04-20', 'Texel', NULL, NULL, true, '1607-10-02', 'Goa', 5079, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (109, '', 1, '', 'CEYLON', 'Willem Dirksz.', 340, NULL, NULL, NULL, NULL, 'A', 'A', '1606-04-20', 'Texel', NULL, NULL, true, '1607-10-02', 'Goa', 5080, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (110, '', 1, '', 'CHINA', 'Kornelis Maartensz.', 420, NULL, NULL, NULL, NULL, 'H', 'H', '1606-04-20', 'Texel', NULL, NULL, true, '1607-10-02', 'Goa', NULL, 'Riding at anchor off Ternate in 1608, the ship was lost due to bad weather (July 1608).'); -[ 1 ] -#INSERT INTO "voyages" VALUES (111, '', 1, '', 'PATANIA', 'Dirk Albertsz. de Vries', 340, NULL, NULL, NULL, NULL, 'E', 'E', '1606-04-20', 'Texel', NULL, NULL, true, '1607-10-02', 'Goa', 5087, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (112, '', 1, '', 'TER VEERE', 'Adriaan Looy', 700, NULL, NULL, NULL, NULL, 'Z', 'Z', '1606-05-14', 'Wielingen', NULL, NULL, true, '1607-10-02', 'Goa', 5082, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (113, '', 1, '', 'WALCHEREN', 'Arend Maartensz.', 700, NULL, NULL, NULL, NULL, 'Z', 'Z', '1606-05-14', 'Wielingen', NULL, NULL, true, '1607-10-02', 'Goa', NULL, 'Riding at anchor off Ternate in 1608, the ship was lost due to bad weather.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (114, '', 2, '', 'ZIERIKZEE', 'Adriaan Kornelisz.', 760, NULL, NULL, NULL, NULL, 'Z', 'Z', '1606-05-14', 'Wielingen', NULL, NULL, true, NULL, NULL, NULL, 'Foundered 1607 Cabacella (Moz.).'); -[ 1 ] -#INSERT INTO "voyages" VALUES (115, '', 2, '', 'GELDERLAND', NULL, 500, NULL, NULL, NULL, NULL, NULL, 'A', '1606-12-13', 'Texel', NULL, NULL, true, NULL, NULL, NULL, 'The ship was forced by bad weather to take refuge in the harbour of Vlissingen, July 19th and was lost, making its way out July 20th.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (116, '', 2, '', 'GOUDA', 'Jakob Gerritsz.', 260, NULL, NULL, NULL, NULL, 'A', 'A', '1606-12-13', 'Texel', NULL, NULL, true, '1608-01-01', 'Atjeh', 5084, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (117, '', 1, '', 'GELDERLAND', 'Jan Jansz. Mol', 700, NULL, NULL, NULL, NULL, NULL, 'A', '1607-04-26', 'Zeeland', NULL, NULL, true, '1607-10-26', 'Malabar', 5085, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (118, '', 1, '', 'MIDDELBURG', 'Kornelis Leendertsz. Krakeel', 800, NULL, NULL, NULL, NULL, NULL, 'Z', '1607-12-21', 'Wielingen', NULL, NULL, true, '1608-09-18', 'Goa', 5096, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (119, '', 1, '', 'VALK', 'Kornelis Adriaansz. Hooiwagen', 140, 'jacht', NULL, NULL, NULL, 'Z', 'Z', '1607-12-21', 'Wielingen', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'Captured by the Spaniards off Manila, 25-04-1610.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (120, '', 2, '', 'ZEELANDIA', 'Willem Jakobsz. van Arnemuiden', 500, NULL, NULL, NULL, NULL, 'Z', 'Z', '1607-12-21', 'Wielingen', NULL, NULL, true, '1608-09-18', 'Goa', 5086, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (121, '', 2, '', 'AMSTERDAM', 'Pieter Gerritsz.', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'Captured by the Spaniards off Manilla, 25-04-1610.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (122, '', 1, '', 'AREND', 'Rutger Thomasz.', 140, 'jacht', NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'Captured and burnt by the Spaniards off Manilla 25-04-1610.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (123, '', 1, '', 'DELFT', 'Simon Maartensz. (Zwarte Simon)', 800, NULL, NULL, NULL, NULL, 'D', 'D', '1607-12-22', 'Goeree', NULL, NULL, true, '1608-09-18', 'Goa', 5094, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (124, '', 1, '', 'GRIFFIOEN', 'Kornelis Kornelisz. \'t Hert', 140, 'jacht', NULL, NULL, NULL, 'R', 'R', '1607-12-22', 'Goeree', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'The ship stayed in the Indies.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (125, '', 2, '', 'HOLLANDIA', 'Simon Jansz. Hoen', 800, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', 5097, 'illemsz. Verhoeff aboard the GEUNIEERDE PROVINCIEN and vice-adm. Frans Hendriksz. Wittert aboard the MIDDELBURG. The 3 Zeeland ships and the mainfleet met at Maio I. February 1608; from 15-05 till 02-06 at St. Helena; 28-06 somewhere in the regions off the Cape; from 28-06 till 23-08 the fleet started operations against th -[ 1 ] -#INSERT INTO "voyages" VALUES (126, '', 2, '', 'HOORN', 'Maarten Jansz. Kloot', 700, NULL, NULL, NULL, NULL, 'H', 'H', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', 5091, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (127, '', 1, '', 'RODE LEEUW MET PIJLEN', 'Jan Walijchsz.', 400, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', 5089, NULL); -[ 1 ] -#INSERT INTO "voyages" VALUES (128, '', 1, '', 'PAUW', 'Meeuwis Gijsbertsz.', 140, 'jacht', NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-18', 'Goa', NULL, 'The ship stayed in the Indies.'); -[ 1 ] -#INSERT INTO "voyages" VALUES (129, '', 2, '', 'GEUNIEERDE PROVINCIEN', 'Frans Jakobsz. de Vries', 700, NULL, NULL, NULL, NULL, 'A', 'A', '1607-12-22', 'Texel', NULL, NULL, true, '1608-09-19', 'Goa', 5092, 'May 22th 1609 Frans -#Jakobsz. de Vries was murdered by the inhabitants of Banda.'); _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
