3
# The author disclaims copyright to this source code. In place of
4
# a legal notice, here is a blessing:
6
# May you do good and not evil.
7
# May you find forgiveness for yourself and forgive others.
8
# May you share freely, never taking more than you give.
10
#*************************************************************************
11
# This file implements regression tests for SQLite library. The
12
# focus of this script is testing the FTS1 module.
14
# $Id: fts1c.test,v 1.11 2006/10/04 17:35:28 drh Exp $
17
set testdir [file dirname $argv0]
18
source $testdir/tester.tcl
20
# If SQLITE_ENABLE_FTS1 is defined, omit this file.
26
# Create a table of sample email data. The data comes from email
27
# archives of Enron executives that was published as part of the
28
# litigation against that company.
32
CREATE VIRTUAL TABLE email USING fts1([from],[to],subject,body);
34
INSERT INTO email([from],[to],subject,body) VALUES('savita.puthigai@enron.com', 'traders.eol@enron.com, traders.eol@enron.com', 'EnronOnline- Change to Autohedge', 'Effective Monday, October 22, 2001 the following changes will be made to the Autohedge functionality on EnronOnline.
36
The volume on the hedge will now respect the minimum volume and volume increment settings on the parent product. See rules below:
38
? If the transaction volume on the child is less than half of the parent''s minimum volume no hedge will occur.
39
? If the transaction volume on the child is more than half the parent''s minimum volume but less than half the volume increment on the parent, the hedge will volume will be the parent''s minimum volume.
40
? For all other volumes, the same rounding rules will apply based on the volume increment on the parent product.
42
Please see example below:
48
Volume on Autohedge transaction Volume Hedged
52
INSERT INTO email([from],[to],subject,body) VALUES('dana.davis@enron.com', 'laynie.east@enron.com, lisa.king@enron.com, lisa.best@enron.com,', 'Leaving Early', 'FYI:
53
If it''s ok with everyone''s needs, I would like to leave @4pm. If you think
54
you will need my assistance past the 4 o''clock hour just let me know; I''ll
55
be more than willing to stay.');
56
INSERT INTO email([from],[to],subject,body) VALUES('enron_update@concureworkplace.com', 'louise.kitchen@enron.com', '<<Concur Expense Document>> - CC02.06.02', 'The following expense report is ready for approval:
58
Employee Name: Christopher F. Calger
59
Status last changed by: Mollie E. Gustafson Ms
60
Expense Report Name: CC02.06.02
61
Report Total: $3,972.93
62
Amount Due Employee: $3,972.93
65
To approve this expense report, click on the following link for Concur Expense.
66
http://expensexms.enron.com');
67
INSERT INTO email([from],[to],subject,body) VALUES('jeff.duff@enron.com', 'julie.johnson@enron.com', 'Work request', 'Julie,
69
Could you print off the current work request report by 1:30 today?
73
I''d like to review this today at 1:30 in our office. Also, could you provide
74
me with your activity reports so I can have Julie enter this information.
77
INSERT INTO email([from],[to],subject,body) VALUES('v.weldon@enron.com', 'gary.l.carrier@usa.dupont.com, scott.joyce@bankofamerica.com', 'Enron News', 'This could turn into something big....
78
http://biz.yahoo.com/rf/010129/n29305829.html');
79
INSERT INTO email([from],[to],subject,body) VALUES('mark.haedicke@enron.com', 'paul.simons@enron.com', 'Re: First Polish Deal!', 'Congrats! Things seem to be building rapidly now on the Continent. Mark');
80
INSERT INTO email([from],[to],subject,body) VALUES('e..carter@enron.com', 't..robinson@enron.com', 'FW: Producers Newsletter 9-24-2001', '
81
The producer lumber pricing sheet.
82
-----Original Message-----
84
Sent: Tuesday, October 16, 2001 3:42 PM
86
Subject: FW: Producers Newsletter 9-24-2001
90
-----Original Message-----
92
Sent: Friday, September 21, 2001 8:33 PM
93
Subject: Producers Newsletter 9-24-2001
96
INSERT INTO email([from],[to],subject,body) VALUES('david.delainey@enron.com', 'kenneth.lay@enron.com', 'Greater Houston Partnership', 'Ken, in response to the letter from Mr Miguel San Juan, my suggestion would
97
be to offer up the Falcon for their use; however, given the tight time frame
98
and your recent visit with Mr. Fox that it would be difficult for either you
101
I spoke to Max and he agrees with this approach.
103
I hope this meets with your approval.
107
INSERT INTO email([from],[to],subject,body) VALUES('lachandra.fenceroy@enron.com', 'lindy.donoho@enron.com', 'FW: Bus Applications Meeting Follow Up', 'Lindy,
109
Here is the original memo we discussed earlier. Please provide any information that you may have.
111
Your cooperation is greatly appreciated.
115
lachandra.fenceroy@enron.com
119
-----Original Message-----
121
Sent: Wednesday, September 26, 2001 7:50 AM
122
To: Fenceroy, LaChandra
123
Subject: FW: Bus Applications Meeting Follow Up
125
Lachandra, Please get with David Duff today and see what this is about. Who are our TW accounting business users?
127
-----Original Message-----
129
Sent: Tuesday, September 25, 2001 2:41 PM
131
Subject: Bus Applications Meeting Follow Up
133
Lisa brought up a TW change effective Nov 1. It involves eliminating a turnback surcharge. I have no other information, but you might check with the business folks for any system changes required.
136
INSERT INTO email([from],[to],subject,body) VALUES('danny.mccarty@enron.com', 'fran.fagan@enron.com', 'RE: worksheets', 'Fran,
137
If Julie''s merit needs to be lump sum, just move it over to that column. Also, send me Eric Gadd''s sheets as well. Thanks.
140
-----Original Message-----
142
Sent: Thursday, December 20, 2001 11:10 AM
146
As discussed, attached are your sheets for bonus and merit.
155
<< File: McCartyMerit.xls >> << File: mccartyBonusCommercial_UnP.xls >>
158
INSERT INTO email([from],[to],subject,body) VALUES('bert.meyers@enron.com', 'shift.dl-portland@enron.com', 'OCTOBER SCHEDULE', 'TEAM,
160
PLEASE SEND ME ANY REQUESTS THAT YOU HAVE FOR OCTOBER. SO FAR I HAVE THEM FOR LEAF. I WOULD LIKE TO HAVE IT DONE BY THE 15TH OF THE MONTH. ANY QUESTIONS PLEASE GIVE ME A CALL.
163
INSERT INTO email([from],[to],subject,body) VALUES('errol.mclaughlin@enron.com', 'john.arnold@enron.com, bilal.bajwa@enron.com, john.griffith@enron.com,', 'TRV Notification: (NG - PROPT P/L - 09/27/2001)', 'The report named: NG - PROPT P/L <http://trv.corp.enron.com/linkFromExcel.asp?report_cd=11&report_name=NG+-+PROPT+P/L&category_cd=5&category_name=FINANCIAL&toc_hide=1&sTV1=5&TV1Exp=Y¤t_efct_date=09/27/2001>, published as of 09/27/2001 is now available for viewing on the website.');
164
INSERT INTO email([from],[to],subject,body) VALUES('patrice.mims@enron.com', 'calvin.eakins@enron.com', 'Re: Small business supply assistance', 'Hi Calvin
167
I spoke with Rickey (boy, is he long-winded!!). Gave him the name of our
168
credit guy, Russell Diamond.
170
Thank for your help!');
171
INSERT INTO email([from],[to],subject,body) VALUES('legal <.hall@enron.com>', 'stephanie.panus@enron.com', 'Termination update', 'City of Vernon and Salt River Project terminated their contracts. I will fax these notices to you.');
172
INSERT INTO email([from],[to],subject,body) VALUES('d..steffes@enron.com', 'richard.shapiro@enron.com', 'EES / ENA Government Affairs Staffing & Outside Services', 'Rick --
174
Here is the information on staffing and outside services. Call if you need anything else.
179
INSERT INTO email([from],[to],subject,body) VALUES('gelliott@industrialinfo.com', 'pcopello@industrialinfo.com', 'ECAAR (Gavin), WSCC (Diablo Canyon), & NPCC (Seabrook)', 'Dear Power Outage Database Customer,
180
Attached you will find an excel document. The outages contained within are forced or rescheduled outages. Your daily delivery will still contain these outages.
181
In addition to the two excel documents, there is a dbf file that is formatted like your daily deliveries you receive nightly. This will enable you to load the data into your regular database. Any questions please let me know. Thanks.
185
outages@industrialinfo.com
186
THE INFORMATION CONTAINED IN THIS E-MAIL IS LEGALLY PRIVILEGED AND CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION, OR COPY OF THIS E-MAIL TO UNAUTHORIZED ENTITIES IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS
187
E-MAIL IN ERROR, PLEASE DELETE IT.
191
INSERT INTO email([from],[to],subject,body) VALUES('enron.announcements@enron.com', 'all_ena_egm_eim@enron.com', 'EWS Brown Bag', 'MARK YOUR LUNCH CALENDARS NOW !
193
You are invited to attend the EWS Brown Bag Lunch Series
195
Featuring: RAY BOWEN, COO
197
Topic: Enron Industrial Markets
199
Thursday, March 15, 2001
204
You bring your lunch, Limited Seating
205
We provide drinks and dessert. RSVP x 3-9610');
206
INSERT INTO email([from],[to],subject,body) VALUES('chris.germany@enron.com', 'ingrid.immer@williams.com', 'Re: About St Pauls', 'Sounds good to me. I bet this is next to the Warick?? Hotel.
211
"Immer, Ingrid" <Ingrid.Immer@Williams.com> on 12/21/2000 11:48:47 AM
212
To: "''chris.germany@enron.com''" <chris.germany@enron.com>
214
Subject: About St Pauls
219
<<About St Pauls.url>>
221
?http://www.stpaulshouston.org/about.html
225
I like the looks of this place.? What do you think about going here Christmas
226
eve?? They have an 11:00 a.m. service and a candlelight service at 5:00 p.m.,
234
INSERT INTO email([from],[to],subject,body) VALUES('nas@cpuc.ca.gov', 'skatz@sempratrading.com, kmccrea@sablaw.com, thompson@wrightlaw.com,', 'Reply Brief filed July 31, 2000', ' - CPUC01-#76371-v1-Revised_Reply_Brief__Due_today_7_31_.doc');
235
INSERT INTO email([from],[to],subject,body) VALUES('gascontrol@aglresources.com', 'dscott4@enron.com, lcampbel@enron.com', 'Alert Posted 10:00 AM November 20,2000: E-GAS Request Reminder', 'Alert Posted 10:00 AM November 20,2000: E-GAS Request Reminder
236
As discussed in the Winter Operations Meeting on Sept.29,2000,
237
E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC.
238
Marketers and Poolers can receive gas via Peaking and IBSS nominations(daisy
239
chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle.
241
INSERT INTO email([from],[to],subject,body) VALUES('dutch.quigley@enron.com', 'rwolkwitz@powermerchants.com', '', '
243
Here is a goody for you');
244
INSERT INTO email([from],[to],subject,body) VALUES('ryan.o''rourke@enron.com', 'k..allen@enron.com, randy.bhatia@enron.com, frank.ermis@enron.com,', 'TRV Notification: (West VaR - 11/07/2001)', 'The report named: West VaR <http://trv.corp.enron.com/linkFromExcel.asp?report_cd=36&report_name=West+VaR&category_cd=2&category_name=WEST&toc_hide=1&sTV1=2&TV1Exp=Y¤t_efct_date=11/07/2001>, published as of 11/07/2001 is now available for viewing on the website.');
245
INSERT INTO email([from],[to],subject,body) VALUES('mjones7@txu.com', 'cstone1@txu.com, ggreen2@txu.com, timpowell@txu.com,', 'Enron / HPL Actuals for July 10, 2000', 'Teco Tap 10.000 / Enron ; 110.000 / HPL IFERC
247
LS HPL LSK IC 30.000 / Enron
249
INSERT INTO email([from],[to],subject,body) VALUES('susan.pereira@enron.com', 'kkw816@aol.com', 'soccer practice', 'Kathy-
251
Is it safe to assume that practice is cancelled for tonight??
254
INSERT INTO email([from],[to],subject,body) VALUES('mark.whitt@enron.com', 'barry.tycholiz@enron.com', 'Huber Internal Memo', 'Please look at this. I didn''t know how deep to go with the desk. Do you think this works.
257
INSERT INTO email([from],[to],subject,body) VALUES('m..forney@enron.com', 'george.phillips@enron.com', '', 'George,
258
Give me a call and we will further discuss opportunities on the 13st floor.
263
INSERT INTO email([from],[to],subject,body) VALUES('brad.mckay@enron.com', 'angusmcka@aol.com', 'Re: (no subject)', 'not yet');
264
INSERT INTO email([from],[to],subject,body) VALUES('adam.bayer@enron.com', 'jonathan.mckay@enron.com', 'FW: Curve Fetch File', 'Here is the curve fetch file sent to me. It has plenty of points in it. If you give me a list of which ones you need we may be able to construct a secondary worksheet to vlookup the values.
270
-----Original Message-----
272
Sent: Tuesday, September 25, 2001 11:37 AM
274
Subject: Curve Fetch File
276
Let me know if it works. It may be required to have a certain version of Oracle for it to work properly.
283
Phone: 713-853-5295');
284
INSERT INTO email([from],[to],subject,body) VALUES('matt.smith@enron.com', 'yan.wang@enron.com', 'Report Formats', 'Yan,
286
The merged reports look great. I believe the only orientation changes are to
287
"unmerge" the following six reports:
291
40 Rockies Production
296
The orientation of the individual reports should be correct. Thanks.
300
PS. Just a reminder to add the "*" by the title of calculated points.');
301
INSERT INTO email([from],[to],subject,body) VALUES('michelle.lokay@enron.com', 'jimboman@bigfoot.com', 'Egyptian Festival', '---------------------- Forwarded by Michelle Lokay/ET&S/Enron on 09/07/2000
302
10:08 AM ---------------------------
305
"Karkour, Randa" <Randa.Karkour@COMPAQ.com> on 09/07/2000 09:01:04 AM
306
To: "''Agheb (E-mail)" <Agheb@aol.com>, "Leila Mankarious (E-mail)"
307
<Leila_Mankarious@mhhs.org>, "''Marymankarious (E-mail)"
308
<marymankarious@aol.com>, "Michelle lokay (E-mail)" <mlokay@enron.com>, "Ramy
309
Mankarious (E-mail)" <Mankarious@aol.com>
312
Subject: Egyptian Festival
315
<<Egyptian Festival.url>>
317
http://www.egyptianfestival.com/
319
- Egyptian Festival.url
321
INSERT INTO email([from],[to],subject,body) VALUES('errol.mclaughlin@enron.com', 'sherry.dawson@enron.com', 'Urgent!!! --- New EAST books', 'This has to be done..................................
324
---------------------- Forwarded by Errol McLaughlin/Corp/Enron on 12/20/2000
325
08:39 AM ---------------------------
329
From: William Kelly @ ECT 12/20/2000 08:31 AM
332
To: Kam Keiser/HOU/ECT@ECT, Darron C Giron/HOU/ECT@ECT, David
333
Baumbach/HOU/ECT@ECT, Errol McLaughlin/Corp/Enron@ENRON
334
cc: Kimat Singla/HOU/ECT@ECT, Kulvinder Fowler/NA/Enron@ENRON, Kyle R
335
Lilly/HOU/ECT@ECT, Jeff Royed/Corp/Enron@ENRON, Alejandra
336
Chavez/NA/Enron@ENRON, Crystal Hyde/HOU/ECT@ECT
338
Subject: New EAST books
340
We have new book names in TAGG for our intramonth portfolios and it is
341
extremely important that any deal booked to the East is communicated quickly
342
to someone on my team. I know it will take some time for the new names to
343
sink in and I do not want us to miss any positions or P&L.
345
Thanks for your help on this.
348
Scott Neal : East Northeast
349
Dick Jenkins: East Marketeast
353
INSERT INTO email([from],[to],subject,body) VALUES('david.forster@enron.com', 'eol.wide@enron.com', 'Change to Stack Manager', 'Effective immediately, there is a change to the Stack Manager which will
354
affect any Inactive Child.
356
An inactive Child with links to Parent products will not have their
357
calculated prices updated until the Child product is Activated.
359
When the Child Product is activated, the price will be recalculated and
360
updated BEFORE it is displayed on the web.
362
This means that if you are inputting a basis price on a Child product, you
363
will not see the final, calculated price until you Activate the product, at
364
which time the customer will also see it.
366
If you have any questions, please contact the Help Desk on:
368
Americas: 713 853 4357
369
Europe: + 44 (0) 20 7783 7783
370
Asia/Australia: +61 2 9229 2300
373
INSERT INTO email([from],[to],subject,body) VALUES('vince.kaminski@enron.com', 'jhh1@email.msn.com', 'Re: Light reading - see pieces beginning on page 7', 'John,
375
I saw it. Very interesting.
383
"John H Herbert" <jhh1@email.msn.com> on 07/28/2000 08:38:08 AM
384
To: "Vince J Kaminski" <Vince_J_Kaminski@enron.com>
386
Subject: Light reading - see pieces beginning on page 7
389
Cheers and have a nice weekend,
402
INSERT INTO email([from],[to],subject,body) VALUES('matthew.lenhart@enron.com', 'mmmarcantel@equiva.com', 'RE:', 'i will try to line up a pig for you ');
403
INSERT INTO email([from],[to],subject,body) VALUES('jae.black@enron.com', 'claudette.harvey@enron.com, chaun.roberts@enron.com, judy.martinez@enron.com,', 'Disaster Recovery Equipment', 'As a reminder...there are several pieces of equipment that are set up on the 30th Floor, as well as on our floor, for the Disaster Recovery Team. PLEASE DO NOT TAKE, BORROW OR USE this equipment. Should you need to use another computer system, other than yours, or make conference calls please work with your Assistant to help find or set up equipment for you to use.
405
Thanks for your understanding in this matter.
409
Assistant to Kevin Presto
413
INSERT INTO email([from],[to],subject,body) VALUES('eric.bass@enron.com', 'dale.neuner@enron.com', '5 X 24', 'Dale,
415
Have you heard anything more on the 5 X 24s? We would like to get this
422
INSERT INTO email([from],[to],subject,body) VALUES('messenger@smartreminders.com', 'm..tholt@enron.com', '10% Coupon - PrintPal Printer Cartridges - 100% Guaranteed', '[IMAGE]
423
[IMAGE][IMAGE][IMAGE]
424
Dear SmartReminders Member,
425
[IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE]
447
We respect your privacy and are a Certified Participant of the BBBOnLine
448
Privacy Program. To be removed from future offers,click here.
449
SmartReminders.com is a permission based service. To unsubscribe click here . ');
450
INSERT INTO email([from],[to],subject,body) VALUES('benjamin.rogers@enron.com', 'mark.bernstein@enron.com', '', 'The guy you are talking about left CIN under a "cloud of suspicion" sort of
451
speak. He was the one who got into several bad deals and PPA''s in California
452
for CIN, thus he left on a bad note. Let me know if you need more detail
453
than that, I felt this was the type of info you were looking for. Thanks!
455
INSERT INTO email([from],[to],subject,body) VALUES('enron_update@concureworkplace.com', 'michelle.cash@enron.com', 'Expense Report Receipts Not Received', 'Employee Name: Michelle Cash
456
Report Name: Houston Cellular 8-11-01
457
Report Date: 12/13/01
458
Report ID: 594D37C9ED2111D5B452
459
Submitted On: 12/13/01
461
You are only allowed 2 reports with receipts outstanding. Your expense reports will not be paid until you meet this requirement.');
462
INSERT INTO email([from],[to],subject,body) VALUES('susan.mara@enron.com', 'ray.alvarez@enron.com, mark.palmer@enron.com, karen.denne@enron.com,', 'CAISO Emergency Motion -- to discontinue market-based rates for', 'FYI. the latest broadside against the generators.
468
----- Forwarded by Susan J Mara/NA/Enron on 06/08/2001 12:24 PM -----
471
"Milner, Marcie" <MMilner@coral-energy.com> 06/08/2001 11:13 AM To: "''smara@enron.com''" <smara@enron.com> cc: Subject: CAISO Emergency Motion
474
Sue, did you see this emergency motion the CAISO filed today? Apparently
475
they are requesting that FERC discontinue market-based rates immediately and
476
grant refunds plus interest on the difference between cost-based rates and
477
market revenues received back to May 2000. They are requesting the
478
commission act within 14 days. Have you heard anything about what they are
483
http://www.caiso.com/docs/2001/06/08/200106081005526469.pdf
485
INSERT INTO email([from],[to],subject,body) VALUES('fletcher.sturm@enron.com', 'eloy.escobar@enron.com', 'Re: General Brinks Position Meeting', 'Eloy,
487
Who is General Brinks?
490
INSERT INTO email([from],[to],subject,body) VALUES('nailia.dindarova@enron.com', 'richard.shapiro@enron.com', 'Documents for Mark Frevert (on EU developments and lessons from', 'Rick,
492
Here are the documents that Peter has prepared for Mark Frevert.
495
---------------------- Forwarded by Nailia Dindarova/LON/ECT on 25/06/2001
496
16:36 ---------------------------
501
To: Michael Brown/Enron@EUEnronXGate
502
cc: Ross Sankey/Enron@EUEnronXGate, Eric Shaw/ENRON@EUEnronXGate, Peter
505
Subject: Documents for Mark Frevert (on EU developments and lessons from
511
These are the documents that Peter promised to give to you for Mark Frevert.
512
He has now handed them to him in person but asked me to transmit them
513
electronically to you, as well as Eric and Ross.
522
INSERT INTO email([from],[to],subject,body) VALUES('peggy.a.kostial@accenture.com', 'dave.samuels@enron.com', 'EOL-Accenture Deal Sheet', 'Dave -
524
Attached are our comments and suggested changes. Please call to review.
526
On the time line for completion, we have four critical steps to complete:
527
Finalize market analysis to refine business case, specifically
528
projected revenue stream
529
Complete counterparty surveying, including targeting 3 CPs for letters
531
Review Enron asset base for potential reuse/ licensing
532
Contract negotiations
534
Joe will come back to us with an updated time line, but it is my
535
expectation that we are still on the same schedule (we just begun week
536
three) with possibly a week or so slippage.....contract negotiations will
537
probably be the critical path.
539
We will send our cut at the actual time line here shortly. Thanks,
543
(See attached file: accenture-dealpoints v2.doc)
544
- accenture-dealpoints v2.doc ');
545
INSERT INTO email([from],[to],subject,body) VALUES('thomas.martin@enron.com', 'thomas.martin@enron.com', 'Re: Guadalupe Power Partners LP', '---------------------- Forwarded by Thomas A Martin/HOU/ECT on 03/20/2001
546
03:49 PM ---------------------------
551
To: Patrick Wade/HOU/ECT@ECT
553
Subject: Re: Guadalupe Power Partners LP
555
The deal is physically served at Oasis Waha or Oasis Katy and is priced at
556
either HSC, Waha or Katytailgate GD at buyers option three days prior to
560
INSERT INTO email([from],[to],subject,body) VALUES('judy.townsend@enron.com', 'dan.junek@enron.com, chris.germany@enron.com', 'Columbia Distribution''s Capacity Available for Release - Sum', '---------------------- Forwarded by Judy Townsend/HOU/ECT on 03/09/2001 11:04
561
AM ---------------------------
564
agoddard@nisource.com on 03/08/2001 09:16:57 AM
565
To: " - *Koch, Kent" <kkoch@nisource.com>, " -
566
*Millar, Debra" <dmillar@nisource.com>, " - *Burke, Lynn"
567
<lburke@nisource.com>
568
cc: " - *Heckathorn, Tom" <theckathorn@nisource.com>
569
Subject: Columbia Distribution''s Capacity Available for Release - Sum
572
Attached is Columbia Distribution''s notice of capacity available for release
574
the summer of 2001 (Apr. 2001 through Oct. 2001).
576
Please note that the deadline for bids is 3:00pm EST on March 20, 2001.
578
If you have any questions, feel free to contact any of the representatives
580
at the bottom of the attachment.
589
INSERT INTO email([from],[to],subject,body) VALUES('rhonda.denton@enron.com', 'tim.belden@enron.com, dana.davis@enron.com, genia.fitzgerald@enron.com,', 'Split Rock Energy LLC', 'We have received the executed EEI contract from this CP dated 12/12/2000.
590
Copies will be distributed to Legal and Credit.');
591
INSERT INTO email([from],[to],subject,body) VALUES('kerrymcelroy@dwt.com', 'jack.speer@alcoa.com, crow@millernash.com, michaelearly@earthlink.net,', 'Oral Argument Request', ' - Oral Argument Request.doc');
592
INSERT INTO email([from],[to],subject,body) VALUES('mike.carson@enron.com', 'rlmichaelis@hormel.com', '', 'Did you come in town this wk end..... My new number at our house is :
593
713-668-3712...... my cell # is 281-381-7332
596
INSERT INTO email([from],[to],subject,body) VALUES('cooper.richey@enron.com', 'trycooper@hotmail.com', 'FW: Contact Info', '
598
-----Original Message-----
600
Sent: Thursday, December 13, 2001 2:35 PM
602
Subject: Contact Info
607
Its been a real pleasure working with you (even though it was for only a small amount of time)
608
I hope we can stay in touch.
611
email: kpunja@hotmail.com
617
INSERT INTO email([from],[to],subject,body) VALUES('bjm30@earthlink.net', 'mcguinn.k@enron.com, mcguinn.ian@enron.com, mcguinn.stephen@enron.com,', 'email address change', 'Hello all.
619
I haven''t talked to many of you via email recently but I do want to give you
620
my new address for your email file:
627
INSERT INTO email([from],[to],subject,body) VALUES('shelley.corman@enron.com', 'steve.hotte@enron.com', 'Flat Panels', 'Can you please advise what is going on with the flat panels that we had planned to distribute to our gas logistics team. It was in the budget and we had the okay, but now I''m hearing there is some hold-up & the units are stored on 44.
630
INSERT INTO email([from],[to],subject,body) VALUES('sara.davidson@enron.com', 'john.schwartzenburg@enron.com, scott.dieball@enron.com, recipients@enron.com,', '2001 Enron Law Conference (Distribution List 2)', ' Enron Law Conference
632
San Antonio, Texas May 2-4, 2001 Westin Riverwalk
634
See attached memo for more details!!
637
? Registration for the law conference this year will be handled through an
638
Online RSVP Form on the Enron Law Conference Website at
639
http://lawconference.corp.enron.com. The website is still under construction
640
and will not be available until Thursday, March 15, 2001.
642
? We will send you another e-mail to confirm when the Law Conference Website
645
? Please complete the Online RSVP Form as soon as it is available and submit
646
it no later than Friday, March 30th.
652
INSERT INTO email([from],[to],subject,body) VALUES('tori.kuykendall@enron.com', 'heath.b.taylor@accenture.com', 'Re:', 'hey - thats funny about john - he definitely remembers him - i''ll call pat
653
and let him know - we are coming on saturday - i just havent had a chance to
654
call you guys back -- looking forward to it -- i probably need the
655
directions again though');
656
INSERT INTO email([from],[to],subject,body) VALUES('darron.giron@enron.com', 'bryce.baxter@enron.com', 'Re: Feedback for Audrey Cook', 'Bryce,
658
I''ll get it done today.
666
From: Bryce Baxter 06/12/2000 07:15 PM
669
To: Darron C Giron/HOU/ECT@ECT
671
Subject: Feedback for Audrey Cook
673
You were identified as a reviewer for Audrey Cook. If possible, could you
674
complete her feedback by end of business Wednesday? It will really help me
675
in the PRC process to have your input. Thanks.
678
INSERT INTO email([from],[to],subject,body) VALUES('casey.evans@enron.com', 'stephanie.sever@enron.com', 'Gas EOL ID', 'Stephanie,
680
In conjunction with the recent movement of several power traders, they are changing the names of their gas books as well. The names of the new gas books and traders are as follows:
682
PWR-NG-LT-SPP: Mike Carson
683
PWR-NG-LT-SERC: Jeff King
685
If you need to know their power desk to map their ID to their gas books, those desks are as follows:
687
EPMI-LT-SPP: Mike Carson
688
EPMI-LT-SERC: Jeff King
690
I will be in training this afternoon, but will be back when class is over. Let me know if you have any questions.
692
Thanks for your help!
694
INSERT INTO email([from],[to],subject,body) VALUES('darrell.schoolcraft@enron.com', 'david.roensch@enron.com, kimberly.watson@enron.com, michelle.lokay@enron.com,', 'Postings', 'Please see the attached.
703
INSERT INTO email([from],[to],subject,body) VALUES('mcominsky@aol.com', 'cpatman@bracepatt.com, james_derrick@enron.com', 'Jurisprudence Luncheon', 'Carrin & Jim --
705
It was an honor and a pleasure to meet both of you yesterday. I know we will
706
have fun working together on this very special event.
708
Jeff left the jurisprudence luncheon lists for me before he left on vacation.
709
I wasn''t sure whether he transmitted them to you as well. Would you please
710
advise me if you would like them sent to you? I can email the MS Excel files
711
or I can fax the hard copies to you. Please advise what is most convenient.
713
I plan to be in town through the holidays and can be reached by phone, email,
714
or cell phone at any time. My cell phone number is 713/705-4829.
716
Thanks again for your interest in the ADL''s work. Martin.
719
Director, Southwest Region
720
Anti-Defamation League
721
713/627-3490, ext. 122
724
INSERT INTO email([from],[to],subject,body) VALUES('phillip.love@enron.com', 'todagost@utmb.edu, gbsonnta@utmb.edu', 'New President', 'I had a little bird put a word in my ear. Is there any possibility for Ben
725
Raimer to be Bush''s secretary of HHS? Just curious about that infamous UTMB
726
rumor mill. Hope things are well, happy holidays.
728
INSERT INTO email([from],[to],subject,body) VALUES('marie.heard@enron.com', 'ehamilton@fna.com', 'ISDA Master Agreement', 'Erin:
730
Pursuant to your request, attached are the Schedule to the ISDA Master Agreement, together with Paragraph 13 to the ISDA Credit Support Annex. Please let me know if you need anything else. We look forward to hearing your comments.
735
Senior Legal Specialist
736
Enron North America Corp.
737
Phone: (713) 853-3907
739
marie.heard@enron.com
742
INSERT INTO email([from],[to],subject,body) VALUES('andrea.ring@enron.com', 'beverly.beaty@enron.com', 'Re: Tennessee Buy - Louis Dreyfus', 'Beverly - once again thanks so much for your help on this.
747
INSERT INTO email([from],[to],subject,body) VALUES('karolyn.criado@enron.com', 'j..bonin@enron.com, felicia.case@enron.com, b..clapp@enron.com,', 'Price List week of Oct. 8-9, 2001', '
748
Please contact me if you have any questions regarding last weeks prices.
758
INSERT INTO email([from],[to],subject,body) VALUES('kevin.presto@enron.com', 'edward.baughman@enron.com, billy.braddock@enron.com', 'Associated', 'Please begin working on filling our Associated short position in 02. I would like to take this risk off the books.
760
In addition, please find out what a buy-out of VEPCO would cost us. With Rogers transitioning to run our retail risk management, I would like to clean up our customer positions.
762
We also need to continue to explore a JEA buy-out.
765
INSERT INTO email([from],[to],subject,body) VALUES('stacy.dickson@enron.com', 'gregg.penman@enron.com', 'RE: Constellation TC 5-7-01', 'Gregg,
767
I am at home with a sick baby. (Lots of fun!) I will call you about this
771
INSERT INTO email([from],[to],subject,body) VALUES('joe.quenet@enron.com', 'dfincher@utilicorp.com', '', 'hey big guy.....check this out.....
773
w ww.gorelieberman-2000.com/');
774
INSERT INTO email([from],[to],subject,body) VALUES('k..allen@enron.com', 'jacqestc@aol.com', '', 'Jacques,
776
I sent you a fax of Kevin Kolb''s comments on the release. The payoff on the note would be $36,248 ($36090(principal) + $158 (accrued interest)).
777
This is assuming we wrap this up on Tuesday.
779
Please email to confirm that their changes are ok so I can set up a meeting on Tuesday to reach closure.
782
INSERT INTO email([from],[to],subject,body) VALUES('kourtney.nelson@enron.com', 'mike.swerzbin@enron.com', 'Adjusted L/R Balance', 'Mike,
784
I placed the adjusted L/R Balance on the Enronwest site. It is under the "Staff/Kourtney Nelson". There are two links:
786
1) "Adj L_R" is the same data/format from the weekly strategy meeting.
787
2) "New Gen 2001_2002" link has all of the supply side info that is used to calculate the L/R balance
788
-Please note the Data Flag column, a value of "3" indicates the project was cancelled, on hold, etc and is not included in the calc.
790
Both of these sheets are interactive Excel spreadsheets and thus you can play around with the data as you please. Also, James Bruce is working to get his gen report on the web. That will help with your access to information on new gen.
792
Please let me know if you have any questions or feedback,
802
kourtney.nelson@enron.com');
803
INSERT INTO email([from],[to],subject,body) VALUES('d..thomas@enron.com', 'naveed.ahmed@enron.com', 'FW: Current Enron TCC Portfolio', '
805
-----Original Message-----
806
From: Grace, Rebecca M.
807
Sent: Monday, December 17, 2001 9:44 AM
809
Cc: Cashion, Jim; Allen, Thresa A.; May, Tom
810
Subject: RE: Current Enron TCC Portfolio
815
I reviewed NY''s list. I agree with all of their contracts numbers and mw amounts.
817
Call if you have any more questions.
823
-----Original Message-----
824
From: Thomas, Paul D.
825
Sent: Monday, December 17, 2001 9:08 AM
826
To: Grace, Rebecca M.
827
Subject: FW: Current Enron TCC Portfolio
829
<< File: enrontccs.xls >>
831
Let me know if you see any differences.
835
-----Original Message-----
836
From: Thomas, Paul D.
837
Sent: Monday, December 17, 2001 9:04 AM
839
Subject: FW: Current Enron TCC Portfolio
844
-----Original Message-----
845
From: Thomas, Paul D.
846
Sent: Thursday, December 13, 2001 10:01 AM
847
To: Baughman, Edward D.
848
Subject: Current Enron TCC Portfolio
852
INSERT INTO email([from],[to],subject,body) VALUES('stephanie.panus@enron.com', 'william.bradford@enron.com, debbie.brackett@enron.com,', 'Coastal Merchant Energy/El Paso Merchant Energy', 'Coastal Merchant Energy, L.P. merged with and into El Paso Merchant Energy,
853
L.P., effective February 1, 2001, with the surviving entity being El Paso
854
Merchant Energy, L.P. We currently have ISDA Master Agreements with both
855
counterparties. Please see the attached memo regarding the existing Masters
856
and let us know which agreement should be terminated.
861
INSERT INTO email([from],[to],subject,body) VALUES('kam.keiser@enron.com', 'c..kenne@enron.com', 'RE: What about this too???', '
863
-----Original Message-----
865
Sent: Wednesday, February 06, 2002 11:50 AM
867
Subject: What about this too???
870
<< File: Netco Trader Matrix.xls >>
872
INSERT INTO email([from],[to],subject,body) VALUES('chris.meyer@enron.com', 'joe.parks@enron.com', 'Centana', 'Talked to Chip. We do need Cash Committe approval given the netting feature of your deal, which means Batch Funding Request. Please update per my previous e-mail and forward.
878
INSERT INTO email([from],[to],subject,body) VALUES('debra.perlingiere@enron.com', 'jworman@academyofhealth.com', '', 'Have a great weekend! Happy Fathers Day!
882
Enron North America Corp.
883
1400 Smith Street, EB 3885
888
INSERT INTO email([from],[to],subject,body) VALUES('outlook.team@enron.com', '', 'Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia &', 'CALENDAR ENTRY: APPOINTMENT
891
Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia & Dir Rpts. - 4102
894
Time: 9:00 AM - 10:00 AM (Central Standard Time)
896
Chairperson: Outlook Migration Team
898
Detailed Description:');
899
INSERT INTO email([from],[to],subject,body) VALUES('diana.seifert@enron.com', 'mark.taylor@enron.com', 'Guest access Chile', 'Hello Mark,
901
Justin Boyd told me that your can help me with questions regarding Chile.
902
We got a request for guest access through MG.
903
The company is called Escondida and is a subsidiary of BHP Australia.
905
Please advise if I can set up a guest account or not.
906
F.Y.I.: MG is planning to put a "in w/h Chile" contract for Copper on-line as
907
soon as Enron has done the due diligence for this country.
915
INSERT INTO email([from],[to],subject,body) VALUES('enron_update@concureworkplace.com', 'mark.whitt@enron.com', '<<Concur Expense Document>> - 121001', 'The Approval status has changed on the following report:
917
Status last changed by: Barry L. Tycholiz
918
Expense Report Name: 121001
919
Report Total: $198.98
920
Amount Due Employee: $198.98
921
Amount Approved: $198.98
923
Approval Status: Approved
924
Payment Status: Pending
927
To review this expense report, click on the following link for Concur Expense.
928
http://expensexms.enron.com');
929
INSERT INTO email([from],[to],subject,body) VALUES('kevin.hyatt@enron.com', '', 'Technical Support', 'Outside the U.S., please refer to the list below:
945
eurosupport@palm.3com.com
947
Please refer to the Worldwide Customer Support card for a complete technical support contact list.');
948
INSERT INTO email([from],[to],subject,body) VALUES('geoff.storey@enron.com', 'dutch.quigley@enron.com', 'RE:', 'duke contact?
950
-----Original Message-----
952
Sent: Wednesday, October 31, 2001 10:14 AM
956
bp corp Albert LaMore 281-366-4962
958
running the reports now
961
-----Original Message-----
963
Sent: Wednesday, October 31, 2001 10:10 AM
967
give me a contact over there too
971
-----Original Message-----
973
Sent: Wednesday, October 31, 2001 9:42 AM
977
Coral Jeff Whitnah 713-767-5374
978
Relaint Steve McGinn 713-207-4000');
979
INSERT INTO email([from],[to],subject,body) VALUES('pete.davis@enron.com', 'pete.davis@enron.com', 'Start Date: 4/22/01; HourAhead hour: 3; <CODESITE>', 'Start Date: 4/22/01; HourAhead hour: 3; No ancillary schedules awarded.
981
Variances detected in Load schedule.
985
PARSING FILE -->> O:\Portland\WestDesk\California Scheduling\ISO Final
986
Schedules\2001042203.txt
988
---- Load Schedule ----
989
$$$ Variance found in table tblLoads.
990
Details: (Hour: 3 / Preferred: 1.92 / Final: 1.89)
998
INSERT INTO email([from],[to],subject,body) VALUES('john.postlethwaite@enron.com', 'john.zufferli@enron.com', 'Reference', 'John, hope things are going well up there for you. The big day is almost here for you and Jessica. I was wondering if I could use your name as a job reference if need be. I am just trying to get everything in order just in case something happens.
1001
INSERT INTO email([from],[to],subject,body) VALUES('jeffrey.shankman@enron.com', 'lschiffm@jonesday.com', 'Re:', 'I saw you called on the cell this a.m. Sorry I missed you. (I was in the
1002
shower). I have had a shitty week--I suspect my silence (not only to you,
1003
but others) after our phone call is a result of the week. I''m seeing Glen at
1004
11:15....talk to you');
1005
INSERT INTO email([from],[to],subject,body) VALUES('litebytz@enron.com', '', 'Lite Bytz RSVP', '
1006
This week''s Lite Bytz presentation will feature the following TOOLZ speaker:
1010
Thursday, June 7, 2001
1012
If you have not already signed up, please RSVP via email to litebytz@enron.com by the end of the day Tuesday, June 5, 2001.
1014
*Remember: this is now a Brown Bag Event--so bring your lunch and we will provide cookies and drinks.
1016
Click below for more details.
1018
http://home.enron.com:84/messaging/litebytztoolzprint.jpg');
1023
###############################################################################
1024
# Everything above just builds an interesting test database. The actual
1025
# tests come after this comment.
1026
###############################################################################
1030
SELECT rowid FROM email WHERE email MATCH 'mark'
1032
} {6 17 25 38 40 42 73 74}
1035
SELECT rowid FROM email WHERE email MATCH 'susan'
1040
SELECT rowid FROM email WHERE email MATCH 'mark susan'
1045
SELECT rowid FROM email WHERE email MATCH 'susan mark'
1050
SELECT rowid FROM email WHERE email MATCH '"mark susan"'
1055
SELECT rowid FROM email WHERE email MATCH 'mark -susan'
1057
} {6 17 25 38 42 73 74}
1060
SELECT rowid FROM email WHERE email MATCH '-mark susan'
1065
SELECT rowid FROM email WHERE email MATCH 'mark OR susan'
1067
} {6 17 24 25 38 40 42 73 74}
1069
# Some simple tests of the automatic "offsets(email)" column. In the sample
1070
# data set above, only one message, number 20, contains the words
1071
# "gas" and "reminder" in both body and subject.
1075
SELECT rowid, offsets(email) FROM email
1076
WHERE email MATCH 'gas reminder'
1078
} {20 {2 0 42 3 2 1 54 8 3 0 42 3 3 1 54 8 3 0 129 3 3 0 143 3 3 0 240 3}}
1081
SELECT rowid, offsets(email) FROM email
1082
WHERE email MATCH 'subject:gas reminder'
1084
} {20 {2 0 42 3 2 1 54 8 3 1 54 8}}
1087
SELECT rowid, offsets(email) FROM email
1088
WHERE email MATCH 'body:gas reminder'
1090
} {20 {2 1 54 8 3 0 42 3 3 1 54 8 3 0 129 3 3 0 143 3 3 0 240 3}}
1093
SELECT rowid, offsets(email) FROM email
1094
WHERE subject MATCH 'gas reminder'
1096
} {20 {2 0 42 3 2 1 54 8}}
1099
SELECT rowid, offsets(email) FROM email
1100
WHERE body MATCH 'gas reminder'
1102
} {20 {3 0 42 3 3 1 54 8 3 0 129 3 3 0 143 3 3 0 240 3}}
1104
# Document 32 contains 5 instances of the world "child". But only
1105
# 3 of them are paired with "product". Make sure only those instances
1106
# that match the phrase appear in the offsets(email) list.
1110
SELECT rowid, offsets(email) FROM email
1111
WHERE body MATCH 'child product' AND +rowid=32
1113
} {32 {3 0 94 5 3 0 114 5 3 0 207 5 3 1 213 7 3 0 245 5 3 1 251 7 3 0 409 5 3 1 415 7 3 1 493 7}}
1116
SELECT rowid, offsets(email) FROM email
1117
WHERE body MATCH '"child product"'
1119
} {32 {3 0 207 5 3 1 213 7 3 0 245 5 3 1 251 7 3 0 409 5 3 1 415 7}}
1121
# Snippet generator tests
1125
SELECT snippet(email) FROM email
1126
WHERE email MATCH 'subject:gas reminder'
1128
} {{Alert Posted 10:00 AM November 20,2000: E-<b>GAS</b> Request <b>Reminder</b>}}
1131
SELECT snippet(email) FROM email
1132
WHERE email MATCH 'christmas candlelight'
1134
} {{<b>...</b> place.? What do you think about going here <b>Christmas</b>
1135
eve?? They have an 11:00 a.m. service and a <b>candlelight</b> service at 5:00 p.m.,
1136
among others. <b>...</b>}}
1140
SELECT snippet(email) FROM email
1141
WHERE email MATCH 'deal sheet potential reuse'
1143
} {{EOL-Accenture <b>Deal</b> <b>Sheet</b> <b>...</b> intent
1144
Review Enron asset base for <b>potential</b> <b>reuse</b>/ licensing
1145
Contract negotiations <b>...</b>}}
1148
SELECT snippet(email,'<<<','>>>',' ') FROM email
1149
WHERE email MATCH 'deal sheet potential reuse'
1151
} {{EOL-Accenture <<<Deal>>> <<<Sheet>>> intent
1152
Review Enron asset base for <<<potential>>> <<<reuse>>>/ licensing
1153
Contract negotiations }}
1156
SELECT snippet(email,'<<<','>>>',' ') FROM email
1157
WHERE email MATCH 'first things'
1159
} {{Re: <<<First>>> Polish Deal! Congrats! <<<Things>>> seem to be building rapidly now on the }}
1162
SELECT snippet(email) FROM email
1163
WHERE email MATCH 'chris is here'
1165
} {{<b>chris</b>.germany@enron.com <b>...</b> Sounds good to me. I bet this <b>is</b> next to the Warick?? Hotel. <b>...</b> place.? What do you think about going <b>here</b> Christmas
1166
eve?? They have an 11:00 a.m. <b>...</b>}}
1169
SELECT snippet(email) FROM email
1170
WHERE email MATCH '"pursuant to"'
1174
<b>Pursuant</b> <b>to</b> your request, attached are the Schedule to <b>...</b>}}
1177
SELECT snippet(email) FROM email
1178
WHERE email MATCH 'ancillary load davis'
1180
} {{pete.<b>davis</b>@enron.com <b>...</b> Start Date: 4/22/01; HourAhead hour: 3; No <b>ancillary</b> schedules awarded.
1182
Variances detected in <b>Load</b> schedule.
1186
PARSING <b>...</b>}}
1188
# Combinations of AND and OR operators:
1192
SELECT snippet(email) FROM email
1193
WHERE email MATCH 'questar enron OR com'
1195
} {{matt.smith@<b>enron</b>.<b>com</b> <b>...</b> six reports:
1197
31 Keystone Receipts
1198
15 <b>Questar</b> Pipeline
1199
40 Rockies Production
1200
22 West_2 <b>...</b>}}
1203
SELECT snippet(email) FROM email
1204
WHERE email MATCH 'enron OR com questar'
1206
} {{matt.smith@<b>enron</b>.<b>com</b> <b>...</b> six reports:
1208
31 Keystone Receipts
1209
15 <b>Questar</b> Pipeline
1210
40 Rockies Production
1211
22 West_2 <b>...</b>}}
added
removed
third_party/sqlite_google/test/fts1c.test
