# MonetDB 5 server v11.54.0
# This is an unreleased version
# Serving database 'mTests_sql_test_ADT2006', using 8 threads
# Compiled for ppc64-pc-linux-gnu/64bit with 128bit integers
# Found 255.358 GiB available main-memory of which we use 208.117 GiB
# Virtual memory usage limited to 32.000 GiB
# Copyright (c) 2024, 2025 MonetDB Foundation, all rights reserved
# Visit https://www.monetdb.org/ for further information
# MonetDB/SQL module loaded
# Listening for connection requests on mapi:monetdb://power8:34233/
# Listening for UNIX domain connection requests on mapi:monetdb:///tmp/mtest-107927/.s.monetdb.34233
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table inspector (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table victim (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table suspect (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table witness (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table doctor (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table scene (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table timeline (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table scene_witness (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table scene_doctor (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: create table scene_inspector (
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table suspect add foreign key ("victim_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene add foreign key ("victim_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene add foreign key ("suspect_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table timeline add foreign key ("victim_id")
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_witness add primary key ("scene_id", "witness_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_witness add foreign key ("scene_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_witness add foreign key ("witness_id")
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_doctor add primary key ("scene_id", "doctor_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_doctor add foreign key ("scene_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_doctor add foreign key ("doctor_id")
#remapped: batmkey.hash
#remapped: batmkey.rotate_xor_hash
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_inspector add primary key ("scene_id", "inspector_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_inspector add foreign key ("scene_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: alter table scene_inspector add foreign key ("inspector_id")
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (1,'Mary', 'Ann', 'Walker', '1845-08-26', '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 fe
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (2,'Annie', null, 'Chapman', '1841-09', '5''', 'blue', 'dark brown, wavy', '1888-09-08', 'B29 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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (3,'Elisabeth', null, 'Stride', '1843-11-27', '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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (4,'Catherine', null, 'Eddowes', '1842-04-14', '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."')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (5,'Mary', 'Jane', 'Kelly', 'around 1863', '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 should
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (6,null, null, 'Fairy Fay', null, null, null, null, '1887-12-26', 'the alleys of Commercial Road', 'http://www.casebook.org/images/victims_fairy.jpg', 'not recorded')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (7,'Annie', null, 'Millwood', '1850', null, null, null, '1888-02-15', 'White''s Row, Spitalfields', 'http://www.casebook.org/images/victims_millwood.jpg', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (8,'Ada', null, 'Wilson', null, null, null, null, '(survived the attack on 1888-28-03)', '19 Maidman Street', 'http://www.casebook.org/images/victims_wilson.jpg', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (9,'Emma', null, 'Smith', '1843', 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)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (10,'Martha', null, 'Tabram', '1849-05-10', 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)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (11,'Whitehall', null, '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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (12,'Annie', null, 'Farmer', null, null, null, null, '(survived the attack on 1888-11-20)', null, 'http://www.casebook.org/images/victims_farmer.jpg', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (13,'Rose', null, 'Mylett', '1862', 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)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (14,'Elisabeth', null, 'Jackson', null, null, null, null, '1889-06', 'the Thames ', 'http://www.casebook.org/images/victims_jackson.jpg', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (15,'Alice', null, 'MacKenzie', '1849', 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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (16,null, null, '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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (17, 'Frances', null, 'Coles', '1865', 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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into victim values (18, 'Carrie', null, '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)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (1, 'Patrick Mulshaw', '04:00:00', 'suspicious', 'Watchman, old man, I believe somebody is murdered down the street.')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (2, 'Emily Walter', '02:00:00', '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.')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (3, 'Elizabeth Long', '05:30:00', 'Dark complexion, brown deerstalker hat, possibly a dark overcoat. Aged over 40, somewhat taller than Chapman. A foreigner of "shabby genteel."', '"Will you?"')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (4, 'J. Best and John Gardner', '23:00:00', '5''5" tall, English, black moustache, sandy eyelashes, weak, wearing a morning suit and a billycock hat.', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (5, 'William Marshall', '23:45:00', 'mall, 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.')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (6, 'Matthew Packer', '12:30:00', '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')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (7, 'P.C. William Smith', '00:30:00', 'Aged 28, cleanshaven and respectable appearance, 5''7", hard dark felt deerstalker hat, dark clothes. Carrying a newspaper parcel 18 x 7 inches.', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (8, 'Israel Schwartz', '00:45:00', '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!"')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (9, 'Joseph Lawende', '01:30:00', 'Aged 30, 5''7", fair complexion, brown moustache, salt-and-pepper coat, red neckerchief, grey peaked cloth cap. Sailor-like.', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (10, 'James Blenkinsop', '01:30:00', 'Well-dressed.', 'Have you seen a man and a woman go through here?')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (11, 'Mary Ann Cox', '23:45:00', 'Short, stout man, shabbily dressed. Billycock hat, blotchy face, carroty moustache, holding quart can of beer', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (12, 'George Hutchinson', '02:00:00', '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 wi
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (13, 'Ada Wilson herself', 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.', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (14, 'Rose Bierman', null, 'a young fair man with a light coat on', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (15, '"Jumbo" Friday', null, null, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (16, 'Duncan Campnell', null, null, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (17, 'Mary Miniter', '10:45: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. ', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into witness values (18, 'James Brown', '00:45:00', '5''7", stout, long black diagonal coat which reached almost to his heels.', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (1, 'Chief', 'Constable', 'Adolphus', 'Frederick', 'Williamson', 'http://www.casebook.org/images/police_frederick_williamson.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (2, 'Sergeant', null, 'Stephen', null, 'White', 'http://www.casebook.org/images/police_steven_white.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (3, 'Sir', null, 'Charles', null, 'Warren', 'http://www.casebook.org/images/police_war.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (4, 'P.C.', null, 'Edward', null, 'Watkins', 'http://www.casebook.org/images/police_edward_watkins.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (5, 'P.C.', null, 'Ernest', null, 'Thompson', 'http://www.casebook.org/images/police_ernest_thompson.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (6, 'Sergeant', null, 'William', null, 'Thick', 'http://www.casebook.org/images/police_thi.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (7, 'Chief', 'Inspector', 'Donald', null, 'Swanson', 'http://www.casebook.org/images/police_sut.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (8, 'Inspector', null, 'John', null, 'Spratling', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (9, 'P.C.', null, 'William', null, 'Smith', 'http://www.casebook.org/images/police_william_smith.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (10, 'Major', null, 'Henry', null, 'Smith', 'http://www.casebook.org/images/police_smi.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (11, 'Detective', 'Constable', 'Robert', null, 'Sagar', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (12, 'Inspector', null, 'Edmund', null, 'Reid', 'http://www.casebook.org/images/police_edmund_reid.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (13, 'P.C.', null, 'John', null, 'Neil', 'http://www.casebook.org/images/police_john_neil.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (14, 'Chief', 'Inspector', 'Henry', null, 'Moore', 'http://www.casebook.org/images/police_henry_moore.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (15, null, null, 'James', null, 'Monro', 'http://www.casebook.org/images/police_mon.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (16, 'Sir', null, 'Melville', null, 'Macnaghten', 'http://www.casebook.org/images/police_mac.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (17, 'Chief', 'Inspector', 'John', null, 'George', 'http://www.casebook.org/images/police_lc.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (18, 'Inspector', null, 'Joseph', 'Henry', 'Helson', 'http://www.casebook.org/images/police_helson.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (19, 'P.C.', null, 'James', null, 'Harvey', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (20, 'Detective', 'Sergeant', 'George', null, 'Godley', 'http://www.casebook.org/images/police_god.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (21, 'Detective', 'Constable', 'Walter', null, 'Dew', 'http://www.casebook.org/images/police_dew.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (22, 'Superintendent', null, 'Thomas', null, 'Arnold', 'http://www.casebook.org/images/police_thomas_arnold.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (23, 'Inspector', null, 'Walter', null, 'Andrews', 'http://www.casebook.org/images/police_walter_andrews.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (24, 'Sir', null, 'Robert', null, 'Anderson', 'http://www.casebook.org/images/police_and.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (25, 'Inspector', null, 'Frederick', null, 'Abberline', 'http://www.casebook.org/images/police_abb1.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into inspector values (26, 'P.C.', null, null, null, 'Neil', 'http://www.casebook.org/images/neil.jpg')
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (1, 'Dr.', null, null, 'Llewellyn', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (2, 'Dr.', 'George', 'Baxter', 'Phillips', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (3, 'Dr.', 'Frederick', 'Gordon', 'Brown', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (4, 'Dr.', 'Thomas', null, 'Bond', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (5, 'Dr.', 'Timothy', 'Robert', 'Killeen', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (6, 'Dr.', 'Matthew', null, 'Brownfield', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (7, null, 'Cornoer', 'Wynne E.', 'Baxter', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into doctor values (8, 'Dr.', null, null, 'Jenkins', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (1, 'Dr. John Williams', 'http://www.casebook.org/images/dr-john-williams.jpg', 'there is very little to suggest that he was Jack the Ripper', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (2, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (3, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (4, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (5, 'Alois Szemeredy', 'http://www.casebook.org/images/suspect_szemeredy.jpg', 'from Buenos Aires, suspected of the Jack the Ripper- and other murders', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (6, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (7, 'James Kenneth Stephen', 'http://www.casebook.org/images/suspect_jkstep.jpg', 'Known misogynist and lunatic but no connections with the East End', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (8, 'Walter Sickert', 'http://www.casebook.org/images/suspect_sickert.jpg', 'a valid suspect since the 1990s', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (9, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (10, 'Dr. Alexander Pedachenko', 'http://www.casebook.org/images/suspect_lodge.jpg', 'may never have existed', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (11, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (12, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (13, 'The Lodger (Frances Tumblety)', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a very strong suspect', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (14, 'Jacob Levy', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a butcher, and the cuts inflicted upon Catharine Eddowes were suggestive of a butcher', 4)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (15, '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.', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (16, 'Severin Klosowski (George Chapman)', 'http://www.casebook.org/images/suspect_klos.jpg', 'there are some reasons in favour of and some against suspecting him', 18)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (17, 'James Kelly', 'http://www.casebook.org/images/suspect_jkell.jpg', 'there are some reasons in favour of and some against suspecting him', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (18, 'Mrs. Mary Pearcey', 'http://www.casebook.org/images/suspect_jill.jpg', 'Not very likely "Jill the Ripper"-theory, first published in 1939', 5)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (19, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (20, 'Fogelma', 'http://www.casebook.org/images/suspect_lodge.jpg', 'no outside evidence to corroborate the story told by the Empire News', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (21, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (22, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (23, 'Dr. Thomas Neill Cream', 'http://www.casebook.org/suspects/cream.html', 'did commit murders, but by poisoning', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (24, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (25, 'Lewis Carroll', 'http://www.casebook.org/images/suspect_carroll.jpg', 'a very unlikely suspect', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (26, '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', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (27, 'Alfred Napier Blanchard', 'http://www.casebook.org/images/suspect_lodge.jpg', 'made a false confession', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (28, 'Joseph Barnett', 'http://www.casebook.org/images/barnett2.jpg', 'was not described as a Ripper suspect until the 1970s', 5)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into suspect values (29, 'Prince Albert Victor', 'http://www.casebook.org/images/ed1890b.jpg', 'one of the most famous suspects', null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (1, 1, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (2, 2, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (3, 3, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (4, 4, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (5, 5, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (6, 6, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (7, 7, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (8, 8, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (9, 9, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (10, 10, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (11, 11, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (12, 12, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (13, 13, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (14, 14, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (15, 15, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (16, 16, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (17, 17, null)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene values (18, 18, 16)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into timeline values (1, '23:00:00', 'Polly is seen walking down Whitechapel Road, she is probably soliciting trade.',1)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into timeline values (2, '00:30:00', 'She is seen leaving the Frying Pan Public House at the corner of Brick Lane and Thrawl Street. She returns to the lodging house at 18 Thrawl Street.',1)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into timeline values (3, '01:30:00', 'She is told by the deputy to leave the kitchen of the lodging house because she could not produce her doss money. Polly, on leaving, asks him to save a bed for her. "Never Mind!" She says, "I''ll soon get my doss money. See what a jolly bonnet I''ve got now." She indicates a little black bonnet which no one had seen bef
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into timeline values (4, '02:30:00', 'She meets Emily Holland, who was returning from watching the Shadwell Dry Dock fire, outside of a grocer''s shop on the corner of Whitechapel Road and Osborn Street. Polly had come down Osborn Street. Holland describes her as "very drunk and staggered against the wall." Holland calls attention to the church clock striki
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into timeline values (5, '03:15:00', 'P.C. John Thain, 96J, passes down Buck''s Row on his beat. He sees nothing unusual. At approximately the same time Sgt. Kerby passes down Bucks Row and reports the same.',1)
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into timeline values (6, '03:45:00', 'Polly Nichols'' body is discovered in Buck''s Row by Charles Cross, a carman, on his way to work at Pickfords in the City Road., and Robert Paul who joins him at his request. "Come and look over here, there''s a woman." Cross calls to Paul. Cross believes she is dead. Her hands and face are cold but the arms above the e
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (1,1)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (2,2)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (2,3)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (3,4)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (3,5)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (3,6)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (3,7)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (3,8)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (3,18)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (4,9)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (4,10)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (5,11)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (5,12)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (8,13)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (8,14)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (17,15)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (17,16)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_witness values (18,17)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (1,1)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (2,2)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (3,2)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (4,3)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (5,2)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (5,4)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (10,5)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (13,6)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:38: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (13,2)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (15,2)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (17,7)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_doctor values (18,8)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (1,26)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (6,12)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (10,12)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (15,12)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (15,24)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (15,15)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (16,15)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (16,16)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (16,7)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: insert into scene_inspector values (17,16)
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: commit
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select first_name, surname, date from victim where date like '%survived%'
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select count(*) from scene_witness where scene_id in ( select scene_id from scene where victim_id in ( select victim_id from victim where surname='Stride'))
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select count(*) from scene_inspector where inspector_id in (select inspector_id from inspector where surname='Monro') group by inspector_id
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select count(*) from victim where eyes='blue'
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select first_name, surname, picture from victim order by surname
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select surname, location from victim order by surname
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select title, first_name, other_names, surname from doctor d, scene_doctor s where d.doctor_id = s.doctor_id and s.scene_id in( select scene_id from scene s, victim v where s.victim_id = v.victim_id and v.surname='Stride')
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: select count(*) from victim
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table scene_witness
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table scene_doctor
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table scene_inspector
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table inspector
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table scene
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table suspect
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table timeline
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table victim
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table witness
#2025-04-05 00:46:39: client0017: SQLrun: INFO: Executing: drop table doctor
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table victim (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table suspect (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table inspector (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table witness (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table doctor (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table event (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table suspect_victim (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: create table inspector_victim (
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Inspector Frederick Abberline', 'http://www.casebook.org/images/police_abb1.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Sir Robert Anderson', 'http://www.casebook.org/images/police_and.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Inspector Walter Andrews', 'http://www.casebook.org/images/police_walter_andrews.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Superintendent Thomas Arnold', 'http://www.casebook.org/images/police_thomas_arnold.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Detective Constable Walter Dew', 'http://www.casebook.org/images/police_dew.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Detective Sergeant George Godley', 'http://www.casebook.org/images/police_god.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('P.C. James Harvey', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Inspector Joseph Henry Helson', 'http://www.casebook.org/images/police_helson.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Chief Inspector John George', 'http://www.casebook.org/images/police_lc.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Sir Melville Macnaghten', 'http://www.casebook.org/images/police_mac.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('James Monro', 'http://www.casebook.org/images/police_mon.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Chief Inspector Henry Moore', 'http://www.casebook.org/images/police_henry_moore.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('P.C. John Neil', 'http://www.casebook.org/images/police_john_neil.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Inspector Edmund Reid', 'http://www.casebook.org/images/police_edmund_reid.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Detective Constable Robert Sagar', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Major Henry Smith', 'http://www.casebook.org/images/police_smi.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('P.C. William Smith', 'http://www.casebook.org/images/police_william_smith.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Inspector John Spratling', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Chief Inspector Donald Swanson', 'http://www.casebook.org/images/police_sut.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Sergeant William Thick', 'http://www.casebook.org/images/police_thi.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('P.C. Ernest Thompson', 'http://www.casebook.org/images/police_ernest_thompson.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Sir Charles Warren', 'http://www.casebook.org/images/police_war.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('P.C. Edward Watkins', 'http://www.casebook.org/images/police_edward_watkins.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Sergeant Stephen White', 'http://www.casebook.org/images/police_steven_white.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('Chief Constable Adolphus Frederick Williamson', 'http://www.casebook.org/images/police_frederick_williamson.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector values ('P.C. Neil', 'http://www.casebook.org/images/neil.jpg')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Prince Albert Victor', 'http://www.casebook.org/images/ed1890b.jpg', 'one of the most famous suspects')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Joseph Barnett', 'http://www.casebook.org/images/barnett2.jpg', 'was not described as a Ripper suspect until the 1970s')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Alfred Napier Blanchard', 'http://www.casebook.org/images/suspect_lodge.jpg', 'made a false confession')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Lewis Carroll', 'http://www.casebook.org/images/suspect_carroll.jpg', 'a very unlikely suspect')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Dr. Thomas Neill Cream', 'http://www.casebook.org/suspects/cream.html', 'did commit murders, but by poisoning')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('The Lodger (Frances Tumblety)', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a very strong suspect')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Dr. Alexander Pedachenko', 'http://www.casebook.org/images/suspect_lodge.jpg', 'may never have existed')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect values ('Walter Sickert', 'http://www.casebook.org/images/suspect_sickert.jpg', 'a valid suspect since the 1990s')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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', '
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into victim values ('Annie Farmer', null, null, null, null, '1888-11-20', null, 'http://www.casebook.org/images/victims_farmer.jpg', null, null)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into witness values ('Patrick Mulshaw', 'Mary Ann Walker', '4:00AM', 'suspicious', 'Watchman, old man, I believe somebody is murdered down the street.')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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?"')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.'
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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 p
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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?"')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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)')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.', '.')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into witness values ('Rose Bierman', 'Ada Wilson', null, 'a young fair man with a light coat on', null)
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into witness values ('"Jumbo" Friday', 'Frances Coles', null, null, '.')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into witness values ('Duncan Campnell', 'Frances Coles', null, null, '.')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: 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.', '.')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('P.C. Neil', 'Mary Ann Walker')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Inspector Edmund Reid', '"Fairy Fay"')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Inspector Edmund Reid', 'Martha Tabram')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Inspector Edmund Reid', 'Alice MacKenzie')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Sir Robert Anderson', 'Alice MacKenzie')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('James Monro', 'Alice MacKenzie')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('James Monro', 'Pinchin Street Murder, possibly Lydia Hart')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Sir Melville Macnaghten', 'Pinchin Street Murder, possibly Lydia Hart')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Chief Inspector Donald Swanson', 'Pinchin Street Murder, possibly Lydia Hart')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into inspector_victim values ('Sir Melville Macnaghten', 'Frances Coles')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect_victim values ('Joseph Barnett', 'Mary Jane Kelly')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect_victim values ('William Henry Bury', 'Mary Ann Walker')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect_victim values ('David Cohen', 'Catherine Eddowes')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect_victim values ('Mrs. Mary Pearcey', 'Mary Jane Kelly')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect_victim values ('Severin Klosowski (George Chapman)', 'Carrie Brown')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into suspect_victim values ('Jacob Levy', 'Catherine Eddowes')
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into event(victim, time, description) values ('Mary Ann Walker', '11:00 PM', '
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into event(victim, time, description) values ('Mary Ann Walker', '12:30 AM', '
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into event(victim, time, description) values ('Mary Ann Walker', '1:20 or 1:40 AM', '
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into event(victim, time, description) values ('Mary Ann Walker', '2:30 AM', '
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into event(victim, time, description) values ('Mary Ann Walker', '3:15 AM', '
#remapped: batcalc.==
#remapped: batcalc.==
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: insert into event(victim, time, description) values ('Mary Ann Walker', '3:40 or 3:45 AM', '
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select name, date from victim where survived = true
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: (select 1 as mon, count(v.name) as murders from victim v where extract(month from v.date) = 1)
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#remapped: batmtime.month
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: (select 1 as mon, v.name as victim from victim v where extract(month from v.date) = 1)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select v.name, count(w.name) as witness_count from victim v join witness w on (w.victim = v.name)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select i.name, count(v.victim) as cases from inspector i join inspector_victim v on (v.inspector = i.name)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: (select 'Detective' as grade, count(name) as inspectors from inspector
#remapped: batstr.locate
#remapped: batcalc.-
#remapped: batstr.substring3
#remapped: batcalc.*
#remapped: batstr.locate
#remapped: batcalc.-
#remapped: batstr.substring3
#remapped: batcalc.*
#remapped: batstr.locate
#remapped: batcalc.+
#remapped: batstr.locate
#remapped: batstr.locate
#remapped: batcalc.-
#remapped: batcalc.-
#remapped: batstr.substring3
#remapped: batcalc.+
#remapped: batstr.locate
#remapped: batcalc.-
#remapped: batstr.substring3
#remapped: batcalc.*
#remapped: batstr.locate
#remapped: batcalc.-
#remapped: batstr.substring3
#remapped: batcalc.*
#remapped: batstr.locate
#remapped: batcalc.+
#remapped: batstr.locate
#remapped: batstr.locate
#remapped: batcalc.-
#remapped: batcalc.-
#remapped: batstr.substring3
#remapped: batcalc.+
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: (select 'blonde', (cast(cast(floor(avg(h.height)/12) as integer) as char) || ''''
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select name as victim from victim where date_of_birth is null or date_of_birth = 'unknown'
#remapped: batcalc.!=
#remapped: batcalc.not
#remapped: batcalc.ifthenelse
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: select d.name as doctor, d.victim, v.date from doctor d join victim v on (d.victim = v.name)
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table suspect_victim
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table inspector_victim
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table suspect
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table inspector
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table witness
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table doctor
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table event
#2025-04-05 00:46:39: client0018: SQLrun: INFO: Executing: drop table victim
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: create table suspect ( name varchar(100), picture_uri
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select * from suspect
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: select * from suspect
#2025-04-05 00:46:39: client0019: SQLrun: INFO: Executing: drop table suspect
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_scene (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_event (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_doctor (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_inspector (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_suspect (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_victim (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_witness (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_scene_doctors (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_scene_inspectors (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_scene_suspects (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: create table jtr_scene_witnesses (
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (0, 'Mary Ann Walker')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_event (event_id, scene_id, time, "text") values (0, 0, '11:00 PM', 'Polly is seen walking down Whitechapel Road, she is
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_event (event_id, scene_id, time, "text") values (1, 0, '12:30 AM', 'She is seen leaving the Frying Pan Public House at
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_event (event_id, scene_id, time, "text") values (2, 0, '1:20 or 1:40 AM', 'She is told by the deputy to leave the kitchen of
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_event (event_id, scene_id, time, "text") values (3, 0, '2:30 AM', 'She meets Emily Holland, who was returning from
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_event (event_id, scene_id, time, "text") values (4, 0, '3:15 AM', 'P.C. John Thain, 96J, passes down Buck''s Row on his
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_event (event_id, scene_id, time, "text") values (5, 0, '3:40 or 3:45 AM', 'Polly Nichols'' body is discovered in Buck''s Row by
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (0, 'Dr. Llewellyn')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (0, 'P.C. Neil')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (0, 'Patrick Mulshaw')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (1, 'Annie Chapman')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (1, 'Dr. George Baxter Phillips')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (1, 'Emily Walter')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (1, 'Elizabeth Long')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (2, 'Elisabeth Stride')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (2, 'Dr. George Baxter Phillips')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (2, 'J. Best and John Gardner')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (2, 'William Marshall')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (2, 'Matthew Packer')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (2, 'P.C. William Smith')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (2, 'James Brown')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (2, 'Israel Schwartz')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (3, 'Catherine Eddowes')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (3, 'Dr. Frederick Gordon Brown')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (3, 'Joseph Lawende')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (3, 'James Blenkinsop')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (4, 'Mary Jane Kelly')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (4, 'Dr. George Baxter Phillips')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (4, 'Dr. Thomas Bond')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (4, 'Mary Ann Cox')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (4, 'George Hutchinson')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (5, '"Fairy Fay"')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (5, 'Inspector Edmund Reid')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (6, 'Annie Millwood')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (6, 'no witnesses')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (7, 'Ada Wilson')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (7, 'Ada Wilson herself')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (7, 'Rose Bierman')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (8, 'Emma Smith')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (9, 'Martha Tabram')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (9, 'Dr. Timothy Robert Killeen')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (9, 'Inspector Edmund Reid')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (10, 'Whitehall Mystery')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (11, 'Annie Farmer')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (12, 'Rose Mylett')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (12, 'Dr. Matthew Brownfield')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (12, 'Dr. George Baxter Phillips')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (13, 'Elisabeth Jackson')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (14, 'Alice MacKenzie')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (14, 'Dr. George Baxter Phillips')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (14, 'Inspector Edmund Reid')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (14, 'Sir Robert Anderson')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (14, 'James Monro')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (15, 'Pinchin Street Murder, possibly Lydia Hart')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (15, 'James Monro')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (15, 'Sir Melville Macnaghten')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (15, 'Chief Inspector Donald Swanson')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (16, 'Frances Coles')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (16, 'Cornoer Wynne E. Baxter')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_inspectors (scene_id, inspector) values (16, 'Sir Melville Macnaghten')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (16, '"Jumbo" Friday')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (16, 'Duncan Campnell')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene (scene_id, victim) values (17, 'Carrie Brown')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_doctors (scene_id, doctor) values (17, 'Dr. Jenkins')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_suspects (scene_id, suspect) values (17, 'Severin Klosowski (George Chapman)')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_scene_witnesses (scene_id, witness) values (17, 'Mary Miniter')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. Llewellyn', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. George Baxter Phillips', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. Frederick Gordon Brown', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. Thomas Bond', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. Timothy Robert Killeen', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. Matthew Brownfield', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Cornoer Wynne E. Baxter', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_doctor (name, picture) values ('Dr. Jenkins', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Inspector Frederick Abberline', 'http://www.casebook.org/images/police_abb1.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Sir Robert Anderson', 'http://www.casebook.org/images/police_and.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Inspector Walter Andrews', 'http://www.casebook.org/images/police_walter_andrews.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Superintendent Thomas Arnold', 'http://www.casebook.org/images/police_thomas_arnold.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Detective Constable Walter Dew', 'http://www.casebook.org/images/police_dew.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Detective Sergeant George Godley', 'http://www.casebook.org/images/police_god.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('P.C. James Harvey', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Inspector Joseph Henry Helson', 'http://www.casebook.org/images/police_helson.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Chief Inspector John George', 'http://www.casebook.org/images/police_lc.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Sir Melville Macnaghten', 'http://www.casebook.org/images/police_mac.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('James Monro', 'http://www.casebook.org/images/police_mon.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Chief Inspector Henry Moore', 'http://www.casebook.org/images/police_henry_moore.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('P.C. John Neil', 'http://www.casebook.org/images/police_john_neil.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Inspector Edmund Reid', 'http://www.casebook.org/images/police_edmund_reid.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Detective Constable Robert Sagar', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Major Henry Smith', 'http://www.casebook.org/images/police_smi.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('P.C. William Smith', 'http://www.casebook.org/images/police_william_smith.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Inspector John Spratling', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Chief Inspector Donald Swanson', 'http://www.casebook.org/images/police_sut.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Sergeant William Thick', 'http://www.casebook.org/images/police_thi.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('P.C. Ernest Thompson', 'http://www.casebook.org/images/police_ernest_thompson.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Sir Charles Warren', 'http://www.casebook.org/images/police_war.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('P.C. Edward Watkins', 'http://www.casebook.org/images/police_edward_watkins.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Sergeant Stephen White', 'http://www.casebook.org/images/police_steven_white.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('Chief Constable Adolphus Frederick Williamson', 'http://www.casebook.org/images/police_frederick_williamson.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_inspector (name, picture) values ('P.C. Neil', 'http://www.casebook.org/images/neil.jpg')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Prince Albert Victor', 'http://www.casebook.org/images/ed1890b.jpg', 'one of the most famous suspects')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Joseph Barnett', 'http://www.casebook.org/images/barnett2.jpg', 'was not described as a Ripper suspect until the 1970s')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Alfred Napier Blanchard', 'http://www.casebook.org/images/suspect_lodge.jpg', 'made a false confession')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Lewis Carroll', 'http://www.casebook.org/images/suspect_carroll.jpg', 'a very unlikely suspect')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Dr. Thomas Neill Cream', 'http://www.casebook.org/suspects/cream.html', 'did commit murders, but by poisoning')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Fogelma', 'http://www.casebook.org/images/suspect_lodge.jpg', 'no outside evidence to corroborate the story told by the Empire News')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Mrs. Mary Pearcey', 'http://www.casebook.org/images/suspect_jill.jpg', 'Not very likely "Jill the Ripper"-theory, first published in 1939')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('James Kelly', 'http://www.casebook.org/images/suspect_jkell.jpg', 'there are some reasons in favour of and some against suspecting him')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('The Lodger (Frances Tumblety)', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a very strong suspect')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Dr. Alexander Pedachenko', 'http://www.casebook.org/images/suspect_lodge.jpg', 'may never have existed')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('The Royal Conspiracy', 'http://www.casebook.org/images/suspect_royal.jpg', 'a fascinating tapestry of conspiracy involving virtually every person who has ever been a Ripper suspect plus a few new ones')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Walter Sickert', 'http://www.casebook.org/images/suspect_sickert.jpg', 'a valid suspect since the 1990s')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('James Kenneth Stephen', 'http://www.casebook.org/images/suspect_jkstep.jpg', 'Known misogynist and lunatic but no connections with the East End')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) values ('Alois Szemeredy', 'http://www.casebook.org/images/suspect_szemeredy.jpg', 'from Buenos Aires, suspected of the Jack the Ripper- and other murders')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_suspect (name, picture, notes) 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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Mary Ann Walker', 'http://www.casebook.org/images/victims_nichols.jpg', '1845-08-26', '5''12"', 'brown', 'brown hair turning grey', '1888-08-31', 'Buck''s Row by Charles Cross', 'five front teeth missing (Rumbelow); two bottom-one top
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Annie Chapman', 'http://www.casebook.org/images/victims_chapman.jpg', '1841-09', '5''', 'blue', 'dark brown, wavy', '1888-09-08', '29 Hanbury Street', 'Pallid complexion, excellent teeth (possibly two missing in lower jaw), strongly built (stout), thick nose')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Elisabeth Stride', 'http://www.casebook.org/images/victims_stride.jpg', '1843-11-27', '5''5"', 'light gray', 'curly dark brown', '1888-09-30', 'Berner Street (Henriques Street today)', 'pale complexion, all the teeth in her lower left jaw were missing')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Catherine Eddowes', 'http://www.casebook.org/images/eddowes1.jpg', '1842-04-14', '5''', 'hazel', 'dark auburn', '1888-09-30', 'Mitre Square', 'She has a tattoo in blue ink on her left forearm "TC."')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Mary Jane Kelly', 'http://www.casebook.org/images/victims_kelly.jpg', 'around 1863', '5''7"', 'blue', 'blonde', '1888-11-09', '13 Miller''s Court', 'a fair complexion. "Said to have been possessed of considerable personal attractions." (McNaughten) She was last seen 
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('"Fairy Fay"', 'http://www.casebook.org/images/victims_fairy.jpg', 'unknown', 'unknown', 'unknown', 'unknown', '1887-12-26', 'the alleys of Commercial Road', 'not recorded')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Annie Millwood', 'http://www.casebook.org/images/victims_millwood.jpg', '1850', '', '', '', '1888-02-15', 'White''s Row, Spitalfields', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Ada Wilson', 'http://www.casebook.org/images/victims_wilson.jpg', '', '', '', '', '(survived the attack on 1888-28-03)', '19 Maidman Street', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Emma Smith', 'http://www.casebook.org/images/victims_smith.jpg', '1843', '', '', '', '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', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Martha Tabram', 'http://www.casebook.org/images/victims_tabram.jpg', '1849-05-10', '', '', '', '1888-08-07', 'George Yard, a narrow north-south alley connecting Wentworth Street and Whitechapel High Street', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Whitehall Mystery', 'http://www.casebook.org/images/victims_whitehall.jpg', '', '', '', '', '1888-10-03', 'a vault soon to become a section of the cellar of New Scotland Yard', 'the headless and limbless torso of a woman')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Annie Farmer', 'http://www.casebook.org/images/victims_farmer.jpg', '1848', '', '', '', '(survived the attack on 1888-11-20)', '', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Rose Mylett', 'http://www.casebook.org/images/victims_mylett.jpg', '1862', '', '', '', '1888-12-20', 'the yard between 184 and 186 Poplar High Street, in Clarke''s Yard', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Elisabeth Jackson', 'http://www.casebook.org/images/victims_jackson.jpg', '', '', '', '', '1889-06', 'the Thames', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Alice MacKenzie', 'http://www.casebook.org/images/victims_mckenzie.jpg', '1849', '', '', '', '1889-07-17', 'Castle Alley', '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
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Pinchin Street Murder, possibly Lydia Hart', 'http://www.casebook.org/images/victims_pinchin.jpg', '', '', '', '', '1889-09-10', 'under a railway arch in Pinchin Street', 'body, missing both head and legs')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Frances Coles', 'http://www.casebook.org/images/victims_coles.jpg', '1865', '', '', '', '1891-02-13', 'Swallow Gardens', 'is often heralded as the prettiest of all the murder victims')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_victim (name, picture, dob, length, eyes, hair, date, location, features) values ('Carrie Brown', 'http://www.casebook.org/images/victims_brown.jpg', '', '5''8"', '', '', '1891-04-24', 'the room of the East River Hotel on the Manhattan waterfront of New York, U.S.A.', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Patrick Mulshaw', '4:00AM', 'suspicious', 'Watchman, old man, I believe somebody is murdered down the street.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Emily Walter', '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.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Elizabeth Long', '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?"')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('J. Best and John Gardner', '11 P.M.', '5''5" tall, English, black moustache, sandy eyelashes, weak, wearing a morning suit and a billycock hat.', '(none)')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('William Marshall', '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
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Matthew Packer', '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')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('P.C. William Smith', '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)')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('James Brown', '12:45 A.M.', '5''7", stout, long black diagonal coat which reached almost to his heels.', '(none)')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Israel Schwartz', '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
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Joseph Lawende', '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)')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('James Blenkinsop', '1:30 A.M.', 'Well-dressed.', '"Have you seen a man and a woman go through here?"')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Mary Ann Cox', '11:45 P.M.', 'Short, stout man, shabbily dressed. Billycock hat, blotchy face, carroty moustache, holding quart can of beer', '(none)')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('George Hutchinson', '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.
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('no witnesses', '', '', '.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Ada Wilson herself', '', '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.', '.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Rose Bierman', '', 'a young fair man with a light coat on', '')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('"Jumbo" Friday', '', '', '.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Duncan Campnell', '', '', '.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: insert into jtr_witness (name, time, appearence, diction) values ('Mary Miniter', '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.', '.')
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select s.victim, v.location, e.time, e."text" from jtr_scene s inner join jtr_victim v on s.victim = v.name left outer join jtr_event e on e.scene_id = s.scene_id order by s.victim, v.location, e.time, e."text"
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select v.name, sp.name, sp.picture from jtr_scene sc inner join jtr_victim v on v.name = sc.victim left outer join (jtr_scene_suspects map inner join jtr_suspect sp on map.suspect = sp.name )on sc.scene_id = map.scene_id order by v.name, sp.name, sp.picture
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select i.name, count(si.scene_id) as times from jtr_inspector i left outer join jtr_scene_inspectors si on i.name = si.inspector group by i.name order by i.name, times desc
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select i.name as name_inspector, d.name as name_doctor from jtr_scene s inner join jtr_scene_inspectors si on si.scene_id = s.scene_id inner join jtr_scene_doctors sd on sd.scene_id = s.scene_id inner join jtr_inspector i on si.inspector = i.name inner join jtr_doctor d on sd.doctor = d.name order by name_inspector, name_doctor
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select name, eyes, hair, features from jtr_victim where features like '%missing%' order by name, eyes, hair, features
#remapped: batcalc.==
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select eyes, count(name) as times from jtr_victim where not eyes = '' group by eyes order by eyes, times desc
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: select s.victim, count(w.witness) as witnesses, count(i.inspector) as inspectors, count(d.doctor) as doctors, count(sp.suspect) as suspects from jtr_scene s left outer join jtr_scene_witnesses w on w.scene_id = s.scene_id left outer join jtr_scene_inspectors i on i.scene_id = s.scene_id left outer join jtr_scene_doctors d on d.scene_id = s.scene_id left outer join
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_scene
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_event
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_doctor
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_inspector
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_suspect
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_victim
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_witness
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_scene_doctors
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_scene_inspectors
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_scene_suspects
#2025-04-05 00:46:39: client0020: SQLrun: INFO: Executing: drop table jtr_scene_witnesses
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: create table "timeline"(
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "timeline" values('Mary Ann Walker', 'Polly is seen walking down Whitechapel Road, she is probably soliciting trade.', '11:00 PM')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "timeline" values('', 'She is seen leaving the Frying Pan Public House at the corner of Brick Lane and Thrawl Street. She returns to the lodging house at 18 Thrawl Street.', '12:30 AM')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: create table "victim"(
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Mary Ann Walker', '1845-08-26', '(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 feat
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Annie Chapman', '1841-09', '(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', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Elisabeth Stride', '1843-11-27', '(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', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Catherine Eddowes', '1842-04-14', '(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."', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Mary Jane Kelly', 'around 1863', '(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.
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('"Fairy Fay"', 'unknown', 'unknown', 'unknown', 'unknown', '1887-12-26', '"the alleys of Commercial Road"', 'http://www.casebook.org/images/victims_fairy.jpg', 'not recorded', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Ada Wilson', '', '', '', '', '1888-28-03', '"19 Maidman Street"', 'http://www.casebook.org/images/victims_wilson.jpg', '', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Emma Smith', '1843', '', '', '', '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', '', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Martha Tabram', '1849-05-10', '', '', '', '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', '', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Whitehall Mystery', '', '', '', '', '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', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Annie Farmer', '1848', '', '', '', '1888-11-20', '', 'http://www.casebook.org/images/victims_farmer.jpg', '', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Rose Mylett', '1862', '', '', '', '1888-12-20', '"the yard between 184 and 186 Poplar High Street, in Clarke''s Yard"', 'http://www.casebook.org/images/victims_mylett.jpg', '', '')
#2025-04-05 00:46:39: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Elisabeth Jackson', '1862', '', '', '', '1889-06', '"the Thames"', 'http://www.casebook.org/images/victims_jackson.jpg', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Alice MacKenzie', '1849', '', '', '', '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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Lydia Hart', '1849', '', '', '', '1889-09-10', '"under a railway arch in Pinchin Street"', 'http://www.casebook.org/images/victims_pinchin.jpg', 'body, missing both head and legs', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Frances Coles', '1865', '', '', '', '1891-02-13', '"Swallow Gardens"', 'http://www.casebook.org/images/victims_coles.jpg', 'is often heralded as the prettiest of all the murder victims', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "victim" values ('Carrie Brown', '', '(5''8")', '', '', '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', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "victim" values ('', '', '', '', '', '', '', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: create table "witness"(
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Patrick Mulshaw', '4:00AM', 'suspicious', 'Watchman, old man, I believe somebody is murdered down the street.')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Emily Walter', '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.')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Elizabeth Long', '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?"')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('J. Best and John Gardner', '11 P.M.', '5''5" tall, English, black moustache, sandy eyelashes, weak, wearing a morning suit and a billycock hat."', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('William Marshall', '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.')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Matthew Packer', '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')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('P.C. William Smith', '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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('James Brown', '12:45 A.M.', '5''7", stout, long black diagonal coat which reached almost to his heels.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Israel Schwartz', '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!"')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Joseph Lawende', '1:30 A.M', 'Aged 30, 5''7", fair complexion, brown moustache, salt-and-pepper coat, red neckerchief, grey peaked cloth cap. Sailor-like.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('James Blenkinsop', '1:30 A.M.', 'Well-dressed.', '"Have you seen a man and a woman go through here?"')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Mary Ann Cox', '11:45 P.M.', 'Short, stout man, shabbily dressed. Billycock hat, blotchy face, carroty moustache, holding quart can of beer', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Mary Miniter', '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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('George Hutchinson', '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 and button boots, gaiters, white buttons. White shirt, black tie fastened with 
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Ada Wilson', '', '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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Rose Bierman', '', 'a young fair man with a light coat on', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('"Jumbo" Friday', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('Duncan Campnell', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('George Chapman', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "witness" values('', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: create table "suspect" (
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Prince Albert Victor', 'http://www.casebook.org/images/ed1890b.jpg', 'one of the most famous suspects', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Joseph Barnett', 'http://www.casebook.org/images/barnett2.jpg', 'was not described as a Ripper suspect until the 1970s', 'Mary Kelly')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Alfred Napier Blanchard', 'http://www.casebook.org/images/suspect_lodge.jpg', 'made a false confession', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', 'Polly Nichols')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Lewis Carroll', 'http://www.casebook.org/images/suspect_carroll.jpg', 'a very unlikely suspect', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', 'Catherine Eddowes')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Dr. Thomas Neill Cream', 'http://www.casebook.org/suspects/cream.html', 'did commit murders, but by poisoning', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', 'Mary Kelly')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('George Chapman', 'http://www.casebook.org/images/suspect_klos.jpg', 'there are some reasons in favour of and some against suspecting him', 'Carrie Brown')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', 'Catharine Eddowes')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('The Lodger (Frances Tumblety)', 'http://www.casebook.org/images/suspect_lodge.jpg', 'a very strong suspect', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Dr. Alexander Pedachenko', 'http://www.casebook.org/images/suspect_lodge.jpg', 'may never have existed', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('The Royal Conspiracy', 'http://www.casebook.org/images/suspect_royal.jpg', 'a fascinating tapestry of conspiracy involving virtually every person who has ever been a Ripper suspect plus a few new ones', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('Walter Sickert', 'http://www.casebook.org/images/suspect_sickert.jpg', 'a valid suspect since the 1990s', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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.', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: 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', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "suspect" values('', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: create table "doctor"(
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. Llewellyn', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. Frederick Gordon Brown', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. Thomas Bond', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. Timothy Robert Killeen', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. Matthew Brownfield', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Cornoer Wynne E. Baxter', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('Dr. Jenkins', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "doctor" values('', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: create table "inspector" (
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Inspector Frederick Abberline', 'http://www.casebook.org/images/police_abb1.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Sir Robert Anderson', 'http://www.casebook.org/images/police_and.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Inspector Walter Andrews', 'http://www.casebook.org/images/police_walter_andrews.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Superintendent Thomas Arnold', 'http://www.casebook.org/images/police_thomas_arnold.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Detective Constable Walter Dew', 'http://www.casebook.org/images/police_dew.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Detective Sergeant George Godley', 'http://www.casebook.org/images/police_god.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('P.C. James Harvey', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Inspector Joseph Henry Helson', 'http://www.casebook.org/images/police_helson.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Chief Inspector John George', 'http://www.casebook.org/images/police_lc.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Sir Melville Macnaghten', 'http://www.casebook.org/images/police_mac.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('James Monro', 'http://www.casebook.org/images/police_mon.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Chief Inspector Henry Moore', 'http://www.casebook.org/images/police_henry_moore.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('P.C. John Neil', 'http://www.casebook.org/images/police_john_neil.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Inspector Edmund Reid', 'http://www.casebook.org/images/police_edmund_reid.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Detective Constable Robert Sagar', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Major Henry Smith', 'http://www.casebook.org/images/police_smi.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('P.C. William Smith', 'http://www.casebook.org/images/police_william_smith.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Inspector John Spratling', 'http://www.casebook.org/images/police_sag.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Chief Inspector Donald Swanson', 'http://www.casebook.org/images/police_sut.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Sergeant William Thick', 'http://www.casebook.org/images/police_thi.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('P.C. Ernest Thompson', 'http://www.casebook.org/images/police_ernest_thompson.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Sir Charles Warren', 'http://www.casebook.org/images/police_war.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('P.C. Edward Watkins', 'http://www.casebook.org/images/police_edward_watkins.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Sergeant Stephen White', 'http://www.casebook.org/images/police_steven_white.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('Chief Constable Adolphus Frederick Williamson', 'http://www.casebook.org/images/police_frederick_williamson.jpg')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "inspector" values ('','')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: create table "scene"(
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Mary Ann Walker', '', 'Patrick Mulshaw', 'Dr. Llewellyn', 'P.C. John Neil')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Annie Chapman', '', 'Emily Walter', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Annie Chapman', '', 'Elizabeth Long', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Stride', '', 'J. Best and John Gardner', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Stride', '', 'William Marshall', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Stride', '', 'Matthew Packer', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Stride', '', 'P.C. William Smith', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Stride', '', 'James Brown', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Stride', '', 'Israel Schwartz', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Catherine Eddowes', '', 'Joseph Lawende', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Catherine Eddowes', '', 'James Blenkinsop', 'Dr. Frederick Gordon Brown', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Mary Jane Kelly', '', 'Mary Ann Cox', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Mary Jane Kelly', '', 'George Hutchinson', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Mary Jane Kelly', '', 'Mary Ann Cox', 'Dr. Thomas Bond', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Mary Jane Kelly', '', 'George Hutchinson', 'Dr. Thomas Bond', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('"Fairy Fay"', '', '', '', 'Inspector Edmund Reid')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Ada Wilson', '', 'Ada Wilson', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Ada Wilson', '', 'Rose Bierman', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Emma Smith', '', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Martha Tabram', '', '', 'Dr. Timothy Robert Killeen', 'Inspector Edmund Reid')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Whitehall Mystery', '', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Annie Farmer', '', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Rose Mylett', '', '', 'Dr. Matthew Brownfield', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Rose Mylett', '', '', 'Dr. George Baxter Phillips', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Elisabeth Jackson', '', '', '', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Alice MacKenzie', '', '', 'Dr. George Baxter Phillips', 'Inspector Edmund Reid')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Alice MacKenzie', '', '', 'Dr. George Baxter Phillips', 'Sir Robert Anderson')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Alice MacKenzie', '', '', 'Dr. George Baxter Phillips', 'James Monro')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Lydia Hart', '', '', '', 'James Monro')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Lydia Hart', '', '', '', 'Sir Melville Macnaghten')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Lydia Hart', '', '', '', 'Chief Inspector Donald Swanson')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Frances Coles', '', '"Jumbo" Friday', 'Cornoer Wynne E. Baxter', 'Sir Melville Macnaghten')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Frances Coles', '', 'Duncan Campnell', 'Cornoer Wynne E. Baxter', 'Sir Melville Macnaghten')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: insert into "scene" values ('Carrie Brown', 'George Chapman', 'Mary Miniter', 'Dr. Jenkins', '')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select name from victim where eyes='blue'
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select name from victim where features is null
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select date_of_birth from victim where length is not null
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select location from victim where name in (select name from inspector where name='P.C. Neil ')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select name from victim where name in (select name from doctor where name='Dr. George Baxter Phillips')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select picture from suspect where victim is null
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select name from witness where appearence in (select "eyes" from victim where "eyes" is null or "eyes"='unknown')
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: select name from victim where name in (select name from suspect where name is not null)
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "scene"
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "suspect"
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "inspector"
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "doctor"
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "witness"
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "victim"
#2025-04-05 00:46:40: client0021: SQLrun: INFO: Executing: drop table "timeline"
#remapped: batcalc.+
#remapped: batcalc.==
#remapped: batcalc.+
#remapped: batcalc.not
#remapped: batcalc.>
#remapped: batcalc.and
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select s.name, t.name, case when t.type in (select table_type_id from sys.table_types where table_type_name like '%VIEW%') then 'VIEW' else 'TABLE' end from sys.tables t, sys.schemas s where not t.system and t.schema_id = s.id
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select s.name, f.name, ft.function_type_keyword from functions f, schemas s, function_types ft where not f.system and f.schema_id = s.id and f.type = ft.function_type_id
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select s.name, q.name from sys.sequences q, schemas s where q.schema_id = s.id
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select name from sys.schemas where not system
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select name from sys.users where name not in ('monetdb', '.snapshot')
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select sqlname from sys.types where systemname is null order by id
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: call sys.setsessiontimeout(60)
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select * from sys.types where sqlname = 'hugeint'
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: start transaction
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table victim (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table victimtimeline (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table scenedoctors (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table sceneinspectors (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table scenesuspects (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table scenewitnesses (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table suspect (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table suspectnotes (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table suspectvictims (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table inspector (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table inspectorsuspects (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table doctor (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: create table witness (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: commit
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select * from sceneinspectors
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select inspector.name, victim.name
#remapped: batstr.substring3
#remapped: batstr.substring3
#remapped: batcalc.-
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select cast(substring(murderdate,1,4) as integer) - cast(substring(dateofbirth,1,4) as integer)
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select avg(num)
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select name,features
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select min(murderdate),max(murderdate)
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select distinct(doctor)
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: select distinct(name) from (
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table victim
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table victimtimeline
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table scenedoctors
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table sceneinspectors
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table scenesuspects
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table scenewitnesses
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table suspect
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table suspectnotes
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table suspectvictims
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table inspector
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table inspectorsuspects
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table doctor
#2025-04-05 00:46:40: client0022: SQLrun: INFO: Executing: drop table witness
#SIGUSR1 info start
#Virtual memory allocated: 9565344, of which 9565344 with malloc
#gdk_vm_maxsize: 34359738368, gdk_mem_maxsize: 223463815249
#gdk_mmap_minsize_persistent 262144, gdk_mmap_minsize_transient 4294967296
#Virtual size: 1214251008, anonymous RSS: 91357184, shared RSS: 20578304 (together: 111935488)
#BATs:
#fix, dirty, persistent, loaded, hot: 1 bats, 0 virtual, 0 malloc
#fix, dirty, transient, loaded, hot: 556 bats, 30104 virtual, 30104 malloc
#fix, clean, persistent, loaded, hot: 5 bats, 9216 virtual, 9216 malloc
#no fix, dirty, persistent, loaded, hot: 125 bats, 512 virtual, 512 malloc
#no fix, dirty, transient, loaded, hot: 49 bats, 0 virtual, 0 malloc
#no fix, clean, persistent, loaded, hot: 153 bats, 1626232 virtual, 1626232 malloc
#1140 bats total, 889 in use, 126 free bats in common shared list
#Threads:
#client0022, tid 22, Thread 0x7fff839cf180, 0 free bats, waiting for nothing, working on exiting
#heartbeat, tid 14, Thread 0x7fff83bdf180, 0 free bats, waiting for nothing, working on sleeping
#listenThread, tid 13, Thread 0x7fff83def180, 0 free bats, waiting for nothing, working on nothing
#logmanager, tid 12, Thread 0x7fff83fff180, 46 free bats, waiting for nothing, working on sleeping
#DFLOWworker0011, tid 11, Thread 0x7fffa838f180, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0010, tid 10, Thread 0x7fffa859f180, 9 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0009, tid 9, Thread 0x7fffa87af180, 1 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0008, tid 8, Thread 0x7fffa89bf180, 5 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0007, tid 7, Thread 0x7fffa8bcf180, 7 free bats, waiting for semaphore DFLOWsema0007, working on idle, waiting for new client
#DFLOWworker0006, tid 6, Thread 0x7fffa8ddf180, 44 free bats, waiting for semaphore DFLOWsema0006, working on idle, waiting for new client
#DFLOWworker0005, tid 5, Thread 0x7fffa8fef180, 0 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0004, tid 4, Thread 0x7fffa91ff180, 8 free bats, waiting for semaphore todo, working on waiting for work
#DFLOWworker0003, tid 3, Thread 0x7fffa940f180, 0 free bats, waiting for semaphore todo, working on waiting for work
#BBPmanager, tid 2, Thread 0x7fffaeb7f180, 0 free bats, waiting for nothing, working on sleeping
#main-thread, tid 1, Thread 0x7fffbd228aa0, 0 free bats, waiting for nothing, working on nothing
#Clients:
#0 active clients, 0 finishing clients, 0 blocked clients; max: 64
#WAL:
#SQL store oldest pending 1209
#logger sql:
#current log file 110, last handled log file 109
#current transaction id 462, saved transaction id 450
#number of flushers: 0
#number of catalog entries 278, of which 0 deleted
#pending range 110: drops 0, last_ts 1209, flushed_ts 1209, refcount 1, file size 1482 (current)
#SIGUSR1 info end
# mserver5 exiting