Changeset: 603594fa7157 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=603594fa7157 Modified Files: sql/test/ADT2006/Tests/bram.stable.out Branch: Aug2011 Log Message:
Reapprove stable output. Diff on some platforms seems to have difficulty seeing that all differences that exist between the old stable output and the test output were to be ignored. diffs (truncated from 488 to 300 lines): diff --git a/sql/test/ADT2006/Tests/bram.stable.out b/sql/test/ADT2006/Tests/bram.stable.out --- a/sql/test/ADT2006/Tests/bram.stable.out +++ b/sql/test/ADT2006/Tests/bram.stable.out @@ -1,145 +1,378 @@ stdout of test 'bram` in directory 'test/ADT2006` itself: -# 11:56:15 > -# 11:56:15 > mserver5 "--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set xrpc_port=49769 --set monet_prompt= --trace "--dbname=mTests_src_test_ADT2006" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. -# 11:56:15 > +# 14:44:20 > +# 14:44:20 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/ufs/sjoerd/Monet-candidate/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=33320" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_test_ADT2006" "--set" "mal_listing=0" +# 14:44:20 > -# MonetDB server v5.6.1, based on kernel v1.24.1 -# Serving database 'mTests_src_test_ADT2006' +# MonetDB 5 server v11.5.4 +# This is an unreleased version +# Serving database 'mTests_test_ADT2006', using 4 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Copyright (c) 1993-2008 CWI, all rights reserved -# Visit http://monetdb.cwi.nl/ for further information -# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/ -# MonetDB/SQL module v2.24.1 loaded +# Found 7.749 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://ottar.ins.cwi.nl:33320/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded Ready. -#function user.main():void; -# clients.quit(); -#end main; +# 14:44:21 > +# 14:44:21 > "mclient" "-lsql" "-ftest" "-i" "-e" "--host=ottar" "--port=33320" +# 14:44:21 > -# 16:54:49 > -# 16:54:49 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=37395 < bram.sql -# 16:54:49 > - +#CREATE TABLE victim ( +#name VARCHAR(50) PRIMARY KEY NOT NULL, +#date_of_birth VARCHAR(10), +#length CHAR(8), +#eyes CHAR(20), +#hair VARCHAR(30), +#date DATE, +#location VARCHAR(250), +#picture VARCHAR(150), +#features TEXT, +#survived BOOLEAN DEFAULT FALSE +#); +#CREATE TABLE suspect ( +#name VARCHAR(50) PRIMARY KEY NOT NULL, +#picture VARCHAR(150), +#notes TEXT +#); +#CREATE TABLE inspector ( +#name VARCHAR(50) PRIMARY KEY NOT NULL, +#picture VARCHAR(150) +#); +#CREATE TABLE witness ( +#name VARCHAR(50), +#victim VARCHAR(50), +#time VARCHAR(50), +#appearence TEXT, +#diction TEXT, +#CONSTRAINT "witness_pkey" PRIMARY KEY (name, victim), +#CONSTRAINT "witness_victim_fkey" FOREIGN KEY (victim) REFERENCES victim (name) ON UPDATE CASCADE ON DELETE CASCADE +#); +#CREATE TABLE doctor ( +#name VARCHAR(50) NOT NULL, +#victim VARCHAR(50) NOT NULL, +#CONSTRAINT "doctor_pkey" PRIMARY KEY (name, victim), +#CONSTRAINT "doctor_victim_fkey" FOREIGN KEY (victim) REFERENCES victim (name) ON UPDATE CASCADE ON DELETE CASCADE +#); +#CREATE TABLE event ( +#id INTEGER AUTO_INCREMENT, +#victim VARCHAR(50) NOT NULL, +#time VARCHAR(50), +#description TEXT, +#CONSTRAINT "event_pkey" PRIMARY KEY (id, victim), +#CONSTRAINT "event_victim_fkey" FOREIGN KEY (victim) REFERENCES victim (name) ON UPDATE CASCADE ON DELETE CASCADE +#); +#CREATE TABLE suspect_victim ( +#suspect VARCHAR(50) NOT NULL, +#victim VARCHAR(50) NOT NULL, +#CONSTRAINT "suspect_victim_pkey" PRIMARY KEY (suspect, victim), +#CONSTRAINT "suspect_victim_victim_fkey" FOREIGN KEY (victim) REFERENCES victim (name) ON UPDATE CASCADE ON DELETE CASCADE, +#CONSTRAINT "suspect_suspect_victim_fkey" FOREIGN KEY (suspect) REFERENCES suspect (name) ON UPDATE CASCADE ON DELETE CASCADE +#); +#CREATE TABLE inspector_victim ( +#inspector VARCHAR(50) NOT NULL, +#victim VARCHAR(50) NOT NULL, +#CONSTRAINT "inspector_victim_pkey" PRIMARY KEY (inspector, victim), +#CONSTRAINT "inspector_victim_victim_fkey" FOREIGN KEY (victim) REFERENCES victim (name) ON UPDATE CASCADE ON DELETE CASCADE, +#CONSTRAINT "inspector_victim_inspector_fkey" FOREIGN KEY (inspector) REFERENCES inspector (name) ON UPDATE CASCADE ON DELETE CASCADE +#); +#INSERT INTO inspector VALUES ('Inspector Frederick Abberline', 'http://www.casebook.org/images/police_abb1.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Sir Robert Anderson', 'http://www.casebook.org/images/police_and.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Inspector Walter Andrews', 'http://www.casebook.org/images/police_walter_andrews.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Superintendent Thomas Arnold', 'http://www.casebook.org/images/police_thomas_arnold.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Detective Constable Walter Dew', 'http://www.casebook.org/images/police_dew.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Detective Sergeant George Godley', 'http://www.casebook.org/images/police_god.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('P.C. James Harvey', 'http://www.casebook.org/images/police_sag.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Inspector Joseph Henry Helson', 'http://www.casebook.org/images/police_helson.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Chief Inspector John George', 'http://www.casebook.org/images/police_lc.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Sir Melville Macnaghten', 'http://www.casebook.org/images/police_mac.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('James Monro', 'http://www.casebook.org/images/police_mon.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Chief Inspector Henry Moore', 'http://www.casebook.org/images/police_henry_moore.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('P.C. John Neil', 'http://www.casebook.org/images/police_john_neil.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Inspector Edmund Reid', 'http://www.casebook.org/images/police_edmund_reid.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Detective Constable Robert Sagar', 'http://www.casebook.org/images/police_sag.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Major Henry Smith', 'http://www.casebook.org/images/police_smi.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('P.C. William Smith', 'http://www.casebook.org/images/police_william_smith.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Inspector John Spratling', 'http://www.casebook.org/images/police_sag.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Chief Inspector Donald Swanson', 'http://www.casebook.org/images/police_sut.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Sergeant William Thick', 'http://www.casebook.org/images/police_thi.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('P.C. Ernest Thompson', 'http://www.casebook.org/images/police_ernest_thompson.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Sir Charles Warren', 'http://www.casebook.org/images/police_war.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('P.C. Edward Watkins', 'http://www.casebook.org/images/police_edward_watkins.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Sergeant Stephen White', 'http://www.casebook.org/images/police_steven_white.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('Chief Constable Adolphus Frederick Williamson', 'http://www.casebook.org/images/police_frederick_williamson.jpg'); [ 1 ] +#INSERT INTO inspector VALUES ('P.C. Neil', 'http://www.casebook.org/images/neil.jpg'); [ 1 ] +#INSERT INTO suspect VALUES ('Prince Albert Victor', 'http://www.casebook.org/images/ed1890b.jpg', 'one of the most famous suspects'); [ 1 ] +#INSERT INTO suspect VALUES ('Joseph Barnett', 'http://www.casebook.org/images/barnett2.jpg', 'was not described as a Ripper suspect until the 1970s'); [ 1 ] +#INSERT INTO suspect VALUES ('Alfred Napier Blanchard', 'http://www.casebook.org/images/suspect_lodge.jpg', 'made a false confession'); [ 1 ] +#INSERT INTO suspect VALUES ('William Henry Bury', 'http://www.casebook.org/images/whbury.jpg', 'Police at the time investigated the matter but did not seem to consider Bury a viable suspect'); [ 1 ] +#INSERT INTO suspect VALUES ('Lewis Carroll', 'http://www.casebook.org/images/suspect_carroll.jpg', 'a very unlikely suspect'); [ 1 ] +#INSERT INTO suspect VALUES ('David Cohen', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a poor Polish Jew, living in Whitechapel and who had "homocidal tendensies and a great hatred of women", and was confined to a lunatic asylum at the right time for the murders to stop and died shortly afterwards'); [ 1 ] +#INSERT INTO suspect VALUES ('Dr. Thomas Neill Cream', 'http://www.casebook.org/suspects/cream.html', 'did commit murders, but by poisoning'); [ 1 ] +#INSERT INTO suspect VALUES ('Frederick Bailey Deeming', 'http://www.casebook.org/images/suspect_deem.jpg', 'The only two links he may have had with the Whitechapel murders were (1) his insanity and (2) his method of killing his family'); [ 1 ] +#INSERT INTO suspect VALUES ('Montague John Druitt', 'http://www.casebook.org/images/suspect_druitt.jpg', 'He is considered by many to be the number one suspect in the case, yet there is little evidence'); [ 1 ] +#INSERT INTO suspect VALUES ('Fogelma', 'http://www.casebook.org/images/suspect_lodge.jpg', 'no outside evidence to corroborate the story told by the Empire News'); [ 1 ] +#INSERT INTO suspect VALUES ('George Hutchinson (Br.)', 'http://www.casebook.org/images/suspect_lodge.jpg', 'Police at the time interviewed him but did not seem to consider him a suspect'); [ 1 ] +#INSERT INTO suspect VALUES ('Mrs. Mary Pearcey', 'http://www.casebook.org/images/suspect_jill.jpg', 'Not very likely "Jill the Ripper"-theory, first published in 1939'); [ 1 ] +#INSERT INTO suspect VALUES ('James Kelly', 'http://www.casebook.org/images/suspect_jkell.jpg', 'there are some reasons in favour of and some against suspecting him'); [ 1 ] +#INSERT INTO suspect VALUES ('Severin Klosowski (George Chapman)', 'http://www.casebook.org/images/suspect_klos.jpg', 'there are some reasons in favour of and some against suspecting him'); [ 1 ] +#INSERT INTO suspect VALUES ('Aaron Kosminski', 'http://www.casebook.org/images/suspect_kosm.jpg', 'According to Anderson and Swanson, identified by a witness as the Ripper, but no charges were brought against him due to the witness\'s reluctance to testify against "a fellow Jew." Known to have been insane.'); [ 1 ] +#INSERT INTO suspect VALUES ('Jacob Levy', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a butcher, and the cuts inflicted upon Catharine Eddowes were suggestive of a butcher'); [ 1 ] +#INSERT INTO suspect VALUES ('The Lodger (Frances Tumblety)', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a very strong suspect'); [ 1 ] +#INSERT INTO suspect VALUES ('James Maybrick', 'http://www.casebook.org/images/suspect_may.jpg', 'The mysterious emergence of the so-called Maybrick journal in 1992 however, immediately thrust him to the forefront of credible Ripper suspects.'); [ 1 ] +#INSERT INTO suspect VALUES ('Michael Ostrog', 'http://www.casebook.org/images/suspect_ost.jpg', 'Mentioned for the first time as a suspect in 1894,in 1994 a lot of information was published making him a prime suspect'); [ 1 ] +#INSERT INTO suspect VALUES ('Dr. Alexander Pedachenko', 'http://www.casebook.org/images/suspect_lodge.jpg', 'may never have existed'); [ 1 ] +#INSERT INTO suspect VALUES ('The Royal Conspiracy', 'http://www.casebook.org/images/suspec\'_royal.jpg', 'a fascinating tapestry of conspiracy involving virtually every person who has ever been a Ripper suspect plus a few new ones'); [ 1 ] +#INSERT INTO suspect VALUES ('Walter Sickert', 'http://www.casebook.org/images/suspect_sickert.jpg', 'a valid suspect since the 1990s'); [ 1 ] +#INSERT INTO suspect VALUES ('James Kenneth Stephen', 'http://www.casebook.org/images/suspect_jkstep.jpg', 'Known misogynist and lunatic but no connections with the East End'); [ 1 ] +#INSERT INTO suspect VALUES ('R. D´Onston Stephenson', 'http://www.casebook.org/images/suspect_dons.jpg', 'Known to have had an extraordinary interest in the murders. Wrote numerous articles and letters on the matter. Resided in the East End.'); [ 1 ] +#INSERT INTO suspect VALUES ('Alois Szemeredy', 'http://www.casebook.org/images/suspect_szemeredy.jpg', 'from Buenos Aires, suspected of the Jack the Ripper- and other murders'); [ 1 ] +#INSERT INTO suspect VALUES ('Francis Thompson', 'http://www.casebook.org/images/suspect_thompson.jpg', 'At 29, Thompson was the right age to fit the Ripper descriptions, and we know he had some medical training. He was also said to carry a dissecting scalpel around with him, which he claimed he used to shave'); [ 1 ] +#INSERT INTO suspect VALUES ('Frances Tumblety', 'http://www.casebook.org/images/suspect_tumb.jpg', 'There is a strong case to be made that he was indeed the Batty Street Lodger'); [ 1 ] +#INSERT INTO suspect VALUES ('Nikolay Vasiliev', 'http://www.casebook.org/images/suspect_lodge.jpg', 'an elusive legend, which probably had some basis in reality, but was mostly embellished by the journalists who wrote it up'); [ 1 ] +#INSERT INTO suspect VALUES ('Dr. John Williams', 'http://www.casebook.org/images/dr-john-williams.jpg', 'there is very little to suggest that he was Jack the Ripper'); [ 1 ] +#INSERT INTO victim VALUES ('Mary Ann Walker', NULL, '5\'12"', 'brown', 'brown hair turning grey', '1888-08-31', 'Buck\'s Row by Charles Cross', 'http://www.casebook.org/images/victims_nichols.jpg', ' +# five front teeth missing (Rumbelow); two bottom-one top +# front (Fido), her teeth are slightly discoloured. She is +# described as having small, delicate features with high +# cheekbones and grey eyes. She has a small scar on her +# forehead from a childhood injury. She is described by +# Emily Holla [ 1 ] +#INSERT INTO victim VALUES ('Annie Chapman', NULL, '5\'', 'blue', 'dark brown, wavy', '1888-09-08', '29 Hanbury Street', 'http://www.casebook.org/images/victims_chapman.jpg', 'Pallid complexion, excellent teeth (possibly two missing in lower jaw), strongly built (stout), thick nose', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Elisabeth Stride', NULL, '5\'5"', 'light gray', 'curly dark brown', '1888-09-30', 'Berner Street (Henriques Street today)', 'http://www.casebook.org/images/victims_stride.jpg', 'pale complexion, all the teeth in her lower left jaw were missing +# ', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Catherine Eddowes', NULL, '5\'', 'hazel', 'dark auburn', '1888-09-30', 'Mitre Square', 'http://www.casebook.org/images/eddowes1.jpg', 'She has a tattoo in blue ink on her left forearm "TC."', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Mary Jane Kelly', NULL, '5\'7"', 'blue', 'blonde', '1888-11-09', '13 Miller\'s Court', 'http://www.casebook.org/images/victims_kelly.jpg', 'a fair complexion. "Said to have been possessed of considerable personal attractions." (McNaughten) She was last seen wearing a linsey frock and a red shawl pulled around her shoulders. She was bare headed. Detective Constable Walter Dew claimed to know Kelly well by sight and says that she was attractive and paraded around, usually in the co [ 1 ] +#INSERT INTO victim VALUES ('"Fairy Fay"', NULL, 'unknown', 'unknown', 'unknown', '1887-12-26', 'the alleys of Commercial Road', 'http://www.casebook.org/images/victims_fairy.jpg', 'not recorded +# ', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Annie Millwood', NULL, NULL, NULL, NULL, '1888-02-15', 'White\'s Row, Spitalfields', 'http://www.casebook.org/images/victims_millwood.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Ada Wilson', NULL, NULL, NULL, NULL, '1888-03-28', '19 Maidman Street', 'http://www.casebook.org/images/victims_wilson.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Emma Smith', NULL, NULL, NULL, NULL, '1888-03-03', 'just outside Taylor Brothers Mustard and Cocoa Mill which was on the north-east corner of the Wentworth/Old Montague Street crossroads', 'http://www.casebook.org/images/victims_smith.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Martha Tabram', NULL, NULL, NULL, NULL, '1888-08-07', 'George Yard, a narrow north-south alley connecting Wentworth Street and Whitechapel High Street', 'http://www.casebook.org/images/victims_tabram.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Whitehall Mystery', NULL, NULL, NULL, NULL, '1888-10-03', 'a vault soon to become a section of the cellar of New Scotland Yard', 'http://www.casebook.org/images/victims_whitehall.jpg', 'the headless and limbless torso of a woman', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Annie Farmer', NULL, NULL, NULL, NULL, '1888-11-20', NULL, 'http://www.casebook.org/images/victims_farmer.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Rose Mylett', NULL, NULL, NULL, NULL, '1888-12-20', 'the yard between 184 and 186 Poplar High Street, in Clarke\'s Yard', 'http://www.casebook.org/images/victims_mylett.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Elisabeth Jackson', NULL, NULL, NULL, NULL, '1889-06-01', 'the Thames', 'http://www.casebook.org/images/victims_jackson.jpg', NULL, NULL); [ 1 ] +#INSERT INTO victim VALUES ('Alice MacKenzie', NULL, NULL, NULL, NULL, '1889-07-17', 'Castle Alley', 'http://www.casebook.org/images/victims_mckenzie.jpg', 'as a freckle-faced woman with a penchant for both smoke and drink. Her left thumb was also injured in what was no doubt some sort of industrial accident.', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Pinchin Street Murder, possibly Lydia Hart', NULL, NULL, NULL, NULL, '1889-09-10', 'under a railway arch in Pinchin Street', 'http://www.casebook.org/images/victims_pinchin.jpg', 'body, missing both head and legs +# ', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Frances Coles', NULL, NULL, NULL, NULL, '1891-02-13', 'Swallow Gardens', 'http://www.casebook.org/images/victims_coles.jpg', 'is often heralded as the prettiest of all the murder victims +# ', NULL); [ 1 ] +#INSERT INTO victim VALUES ('Carrie Brown', NULL, '5\'8"', NULL, NULL, '1891-04-24', 'the room of the East River Hotel on the Manhattan waterfront of New York, U.S.A.', 'http://www.casebook.org/images/victims_brown.jpg', NULL, NULL); [ 1 ] +#INSERT INTO witness VALUES ('Patrick Mulshaw', 'Mary Ann Walker', '4:00AM', 'suspicious', 'Watchman, old man, I believe somebody is murdered down the street.'); [ 1 ] +#INSERT INTO witness VALUES ('Emily Walter', 'Annie Chapman', '2:00 A.M.', 'Foreigner aged 37, dark beard and moustache. Wearing short dark jacket, dark vest and trousers, black scarf and black felt hat.', 'Asked witness to enter the backyard of 29 Hanbury Street.'); [ 1 ] +#INSERT INTO witness VALUES ('Elizabeth Long', 'Annie Chapman', '5:30 A.M.', 'Dark complexion, brown deerstalker hat, possibly a dark overcoat. Aged over 40, somewhat taller than Chapman. A foreigner of "shabby genteel."', '"Will you?"'); [ 1 ] +#INSERT INTO witness VALUES ('J. Best and John Gardner', 'Elisabeth Stride', '11 P.M.', '5\'5" tall, English, black moustache, sandy eyelashes, weak, wearing a morning suit and a billycock hat.', '(none)'); [ 1 ] +#INSERT INTO witness VALUES ('William Marshall', 'Elisabeth Stride', '11:45 P.M.', 'Small, black coat, dark trousers, middle aged, round cap with a small sailor-like peak. 5\'6", stout, appearance of a clerk. No moustache, no gloves, with a cutaway coat.', '"You would say anything but your prayers." Spoken mildly, with an English accent, and in an educated manner.'); [ 1 ] +#INSERT INTO witness VALUES ('Matthew Packer', 'Elisabeth Stride', '12:00 - 12:30 P.M.', 'Aged 25-30, 5\'7", long black coat buttoned up, soft felt hawker hat, broad shoulders. Maybe a young clerk, frock coat, no gloves.', 'Quiet in speaking, with a rough voice'); [ 1 ] +#INSERT INTO witness VALUES ('P.C. William Smith', 'Elisabeth Stride', '12:30 A.M.', 'Aged 28, cleanshaven and respectable appearance, 5\'7", hard dark felt deerstalker hat, dark clothes. Carrying a newspaper parcel 18 x 7 inches.', '(none)'); [ 1 ] +#INSERT INTO witness VALUES ('James Brown', 'Elisabeth Stride', '12:45 A.M.', '5\'7", stout, long black diagonal coat which reached almost to his heels.', '(none)'); [ 1 ] +#INSERT INTO witness VALUES ('Israel Schwartz', 'Elisabeth Stride', '12:45 A.M.', 'First man: Aged 30, 5\'5", brown haired, fair complexion, small brown moustache, full face, broad shoulders, dark jacket and trousers, black cap with peak. Second man: Aged 35, 5\'11", fresh complexion, light brown hair, dark overcoat, old black hard felt hat with a wide brim, clay pipe.', '"Lipski!"'); [ 1 ] +#INSERT INTO witness VALUES ('Joseph Lawende', 'Catherine Eddowes', '1:30 A.M', 'Aged 30, 5\'7", fair complexion, brown moustache, salt-and-pepper coat, red neckerchief, grey peaked cloth cap. Sailor-like.', '(none)'); [ 1 ] +#INSERT INTO witness VALUES ('James Blenkinsop', 'Catherine Eddowes', '1:30 A.M.', 'Well-dressed.', '"Have you seen a man and a woman go through here?"'); [ 1 ] +#INSERT INTO witness VALUES ('Mary Ann Cox', 'Mary Jane Kelly', '11:45 P.M.', 'Short, stout man, shabbily dressed. Billycock hat, blotchy face, carroty moustache, holding quart can of beer', '(none)'); [ 1 ] +#INSERT INTO witness VALUES ('George Hutchinson', 'Mary Jane Kelly', '2:00 A.M.', 'Aged 34-35, 5\'6", pale complexion, dark hair, slight moustached curled at each end, long dark coat, collar cuffs of astrakhan, dark jacket underneath. Light waistcoat, thick gold chain with a red stone seal, dark trousers an\' button boots, gaiters, white buttons. White shirt, black tie fastened with a horseshoe pin. Dark hat, turned down in middle. Red kerchief. Jewish and respectable in appearance.', '(none)'); [ 1 ] +#INSERT INTO witness VALUES ('Ada Wilson herself', 'Ada Wilson', NULL, 'a man of about 30 years of age, 5ft 6ins in height, with a sunburnt face and a fair moustache. He was wearing a dark coat, light trousers and a wideawake hat.', '.'); [ 1 ] +#INSERT INTO witness VALUES ('Rose Bierman', 'Ada Wilson', NULL, 'a young fair man with a light coat on', NULL); [ 1 ] +#INSERT INTO witness VALUES ('"Jumbo" Friday', 'Frances Coles', NULL, NULL, '.'); [ 1 ] +#INSERT INTO witness VALUES ('Duncan Campnell', 'Frances Coles', NULL, NULL, '.'); [ 1 ] +#INSERT INTO witness VALUES ('Mary Miniter', 'Carrie Brown', 'between 10:30 and 11:00', 'About 32 years of age. Five feet, eight inches tall. Slim build. Long, sharp nose. Heavy moustache of light color. Foreign in appearance, possibly German. Dark-brown cutaway coat. Black trousers. Old black derby hat with dented crown.', '.'); [ 1 ] +#INSERT INTO inspector_victim VALUES ('P.C. Neil', 'Mary Ann Walker'); [ 1 ] +#INSERT INTO inspector_victim VALUES ('Inspector Edmund Reid', '"Fairy Fay"'); [ 1 ] +#INSERT INTO inspector_victim VALUES ('Inspector Edmund Reid', 'Martha Tabram'); _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
