sl@0: # 2006 September 14 sl@0: # sl@0: # The author disclaims copyright to this source code. In place of sl@0: # a legal notice, here is a blessing: sl@0: # sl@0: # May you do good and not evil. sl@0: # May you find forgiveness for yourself and forgive others. sl@0: # May you share freely, never taking more than you give. sl@0: # sl@0: #************************************************************************* sl@0: # This file implements regression tests for SQLite library. The sl@0: # focus of this script is testing the FTS1 module. sl@0: # sl@0: # $Id: fts1c.test,v 1.11 2006/10/04 17:35:28 drh Exp $ sl@0: # sl@0: sl@0: set testdir [file dirname $argv0] sl@0: source $testdir/tester.tcl sl@0: sl@0: # If SQLITE_ENABLE_FTS1 is defined, omit this file. sl@0: ifcapable !fts1 { sl@0: finish_test sl@0: return sl@0: } sl@0: sl@0: # Create a table of sample email data. The data comes from email sl@0: # archives of Enron executives that was published as part of the sl@0: # litigation against that company. sl@0: # sl@0: do_test fts1c-1.1 { sl@0: db eval { sl@0: CREATE VIRTUAL TABLE email USING fts1([from],[to],subject,body); sl@0: BEGIN TRANSACTION; sl@0: 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. sl@0: sl@0: The volume on the hedge will now respect the minimum volume and volume increment settings on the parent product. See rules below: sl@0: sl@0: ? If the transaction volume on the child is less than half of the parent''s minimum volume no hedge will occur. sl@0: ? 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. sl@0: ? For all other volumes, the same rounding rules will apply based on the volume increment on the parent product. sl@0: sl@0: Please see example below: sl@0: sl@0: Parent''s Settings: sl@0: Minimum: 5000 sl@0: Increment: 1000 sl@0: sl@0: Volume on Autohedge transaction Volume Hedged sl@0: 1 - 2499 0 sl@0: 2500 - 5499 5000 sl@0: 5500 - 6499 6000'); sl@0: 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: sl@0: If it''s ok with everyone''s needs, I would like to leave @4pm. If you think sl@0: you will need my assistance past the 4 o''clock hour just let me know; I''ll sl@0: be more than willing to stay.'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('enron_update@concureworkplace.com', 'louise.kitchen@enron.com', '<> - CC02.06.02', 'The following expense report is ready for approval: sl@0: sl@0: Employee Name: Christopher F. Calger sl@0: Status last changed by: Mollie E. Gustafson Ms sl@0: Expense Report Name: CC02.06.02 sl@0: Report Total: $3,972.93 sl@0: Amount Due Employee: $3,972.93 sl@0: sl@0: sl@0: To approve this expense report, click on the following link for Concur Expense. sl@0: http://expensexms.enron.com'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('jeff.duff@enron.com', 'julie.johnson@enron.com', 'Work request', 'Julie, sl@0: sl@0: Could you print off the current work request report by 1:30 today? sl@0: sl@0: Gentlemen, sl@0: sl@0: I''d like to review this today at 1:30 in our office. Also, could you provide sl@0: me with your activity reports so I can have Julie enter this information. sl@0: sl@0: JD'); sl@0: 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.... sl@0: http://biz.yahoo.com/rf/010129/n29305829.html'); sl@0: 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'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('e..carter@enron.com', 't..robinson@enron.com', 'FW: Producers Newsletter 9-24-2001', ' sl@0: The producer lumber pricing sheet. sl@0: -----Original Message----- sl@0: From: Johnson, Jay sl@0: Sent: Tuesday, October 16, 2001 3:42 PM sl@0: To: Carter, Karen E. sl@0: Subject: FW: Producers Newsletter 9-24-2001 sl@0: sl@0: sl@0: sl@0: -----Original Message----- sl@0: From: Daigre, Sergai sl@0: Sent: Friday, September 21, 2001 8:33 PM sl@0: Subject: Producers Newsletter 9-24-2001 sl@0: sl@0: '); sl@0: 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 sl@0: be to offer up the Falcon for their use; however, given the tight time frame sl@0: and your recent visit with Mr. Fox that it would be difficult for either you sl@0: or me to participate. sl@0: sl@0: I spoke to Max and he agrees with this approach. sl@0: sl@0: I hope this meets with your approval. sl@0: sl@0: Regards sl@0: Delainey'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('lachandra.fenceroy@enron.com', 'lindy.donoho@enron.com', 'FW: Bus Applications Meeting Follow Up', 'Lindy, sl@0: sl@0: Here is the original memo we discussed earlier. Please provide any information that you may have. sl@0: sl@0: Your cooperation is greatly appreciated. sl@0: sl@0: Thanks, sl@0: sl@0: lachandra.fenceroy@enron.com sl@0: 713.853.3884 sl@0: 877.498.3401 Pager sl@0: sl@0: -----Original Message----- sl@0: From: Bisbee, Joanne sl@0: Sent: Wednesday, September 26, 2001 7:50 AM sl@0: To: Fenceroy, LaChandra sl@0: Subject: FW: Bus Applications Meeting Follow Up sl@0: sl@0: Lachandra, Please get with David Duff today and see what this is about. Who are our TW accounting business users? sl@0: sl@0: -----Original Message----- sl@0: From: Koh, Wendy sl@0: Sent: Tuesday, September 25, 2001 2:41 PM sl@0: To: Bisbee, Joanne sl@0: Subject: Bus Applications Meeting Follow Up sl@0: sl@0: 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. sl@0: sl@0: Wendy'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('danny.mccarty@enron.com', 'fran.fagan@enron.com', 'RE: worksheets', 'Fran, sl@0: 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. sl@0: Dan sl@0: sl@0: -----Original Message----- sl@0: From: Fagan, Fran sl@0: Sent: Thursday, December 20, 2001 11:10 AM sl@0: To: McCarty, Danny sl@0: Subject: worksheets sl@0: sl@0: As discussed, attached are your sheets for bonus and merit. sl@0: sl@0: Thanks, sl@0: sl@0: Fran Fagan sl@0: Sr. HR Rep sl@0: 713.853.5219 sl@0: sl@0: sl@0: << File: McCartyMerit.xls >> << File: mccartyBonusCommercial_UnP.xls >> sl@0: sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('bert.meyers@enron.com', 'shift.dl-portland@enron.com', 'OCTOBER SCHEDULE', 'TEAM, sl@0: sl@0: 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. sl@0: sl@0: BERT'); sl@0: 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 , published as of 09/27/2001 is now available for viewing on the website.'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('patrice.mims@enron.com', 'calvin.eakins@enron.com', 'Re: Small business supply assistance', 'Hi Calvin sl@0: sl@0: sl@0: I spoke with Rickey (boy, is he long-winded!!). Gave him the name of our sl@0: credit guy, Russell Diamond. sl@0: sl@0: Thank for your help!'); sl@0: 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.'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('d..steffes@enron.com', 'richard.shapiro@enron.com', 'EES / ENA Government Affairs Staffing & Outside Services', 'Rick -- sl@0: sl@0: Here is the information on staffing and outside services. Call if you need anything else. sl@0: sl@0: Jim sl@0: sl@0: '); sl@0: 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, sl@0: Attached you will find an excel document. The outages contained within are forced or rescheduled outages. Your daily delivery will still contain these outages. sl@0: 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. sl@0: Greg Elliott sl@0: IIR, Inc. sl@0: 713-783-5147 x 3481 sl@0: outages@industrialinfo.com sl@0: 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 sl@0: E-MAIL IN ERROR, PLEASE DELETE IT. sl@0: - OUTAGE.dbf sl@0: - 111201R.xls sl@0: - 111201.xls '); sl@0: 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 ! sl@0: sl@0: You are invited to attend the EWS Brown Bag Lunch Series sl@0: sl@0: Featuring: RAY BOWEN, COO sl@0: sl@0: Topic: Enron Industrial Markets sl@0: sl@0: Thursday, March 15, 2001 sl@0: 11:30 am - 12:30 pm sl@0: EB 5 C2 sl@0: sl@0: sl@0: You bring your lunch, Limited Seating sl@0: We provide drinks and dessert. RSVP x 3-9610'); sl@0: 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. sl@0: sl@0: sl@0: sl@0: sl@0: "Immer, Ingrid" on 12/21/2000 11:48:47 AM sl@0: To: "''chris.germany@enron.com''" sl@0: cc: sl@0: Subject: About St Pauls sl@0: sl@0: sl@0: sl@0: sl@0: <> sl@0: ? sl@0: ?http://www.stpaulshouston.org/about.html sl@0: sl@0: Chris, sl@0: sl@0: I like the looks of this place.? What do you think about going here Christmas sl@0: eve?? They have an 11:00 a.m. service and a candlelight service at 5:00 p.m., sl@0: among others. sl@0: sl@0: Let me know.?? ii sl@0: sl@0: - About St Pauls.url sl@0: sl@0: '); sl@0: 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'); sl@0: 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 sl@0: As discussed in the Winter Operations Meeting on Sept.29,2000, sl@0: E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC. sl@0: Marketers and Poolers can receive gas via Peaking and IBSS nominations(daisy sl@0: chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle. sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('dutch.quigley@enron.com', 'rwolkwitz@powermerchants.com', '', ' sl@0: sl@0: Here is a goody for you'); sl@0: 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 , published as of 11/07/2001 is now available for viewing on the website.'); sl@0: 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 sl@0: sl@0: LS HPL LSK IC 30.000 / Enron sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('susan.pereira@enron.com', 'kkw816@aol.com', 'soccer practice', 'Kathy- sl@0: sl@0: Is it safe to assume that practice is cancelled for tonight?? sl@0: sl@0: Susan Pereira'); sl@0: 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. sl@0: sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('m..forney@enron.com', 'george.phillips@enron.com', '', 'George, sl@0: Give me a call and we will further discuss opportunities on the 13st floor. sl@0: sl@0: Thanks, sl@0: JMForney sl@0: 3-7160'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('brad.mckay@enron.com', 'angusmcka@aol.com', 'Re: (no subject)', 'not yet'); sl@0: 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. sl@0: sl@0: adam sl@0: 35227 sl@0: sl@0: sl@0: -----Original Message----- sl@0: From: Royed, Jeff sl@0: Sent: Tuesday, September 25, 2001 11:37 AM sl@0: To: Bayer, Adam sl@0: Subject: Curve Fetch File sl@0: sl@0: Let me know if it works. It may be required to have a certain version of Oracle for it to work properly. sl@0: sl@0: sl@0: sl@0: Jeff Royed sl@0: Enron sl@0: Energy Operations sl@0: Phone: 713-853-5295'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('matt.smith@enron.com', 'yan.wang@enron.com', 'Report Formats', 'Yan, sl@0: sl@0: The merged reports look great. I believe the only orientation changes are to sl@0: "unmerge" the following six reports: sl@0: sl@0: 31 Keystone Receipts sl@0: 15 Questar Pipeline sl@0: 40 Rockies Production sl@0: 22 West_2 sl@0: 23 West_3 sl@0: 25 CIG_WIC sl@0: sl@0: The orientation of the individual reports should be correct. Thanks. sl@0: sl@0: Mat sl@0: sl@0: PS. Just a reminder to add the "*" by the title of calculated points.'); sl@0: 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 sl@0: 10:08 AM --------------------------- sl@0: sl@0: sl@0: "Karkour, Randa" on 09/07/2000 09:01:04 AM sl@0: To: "''Agheb (E-mail)" , "Leila Mankarious (E-mail)" sl@0: , "''Marymankarious (E-mail)" sl@0: , "Michelle lokay (E-mail)" , "Ramy sl@0: Mankarious (E-mail)" sl@0: cc: sl@0: sl@0: Subject: Egyptian Festival sl@0: sl@0: sl@0: <> sl@0: sl@0: http://www.egyptianfestival.com/ sl@0: sl@0: - Egyptian Festival.url sl@0: '); sl@0: 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.................................. sl@0: sl@0: Thanks sl@0: ---------------------- Forwarded by Errol McLaughlin/Corp/Enron on 12/20/2000 sl@0: 08:39 AM --------------------------- sl@0: sl@0: sl@0: sl@0: From: William Kelly @ ECT 12/20/2000 08:31 AM sl@0: sl@0: sl@0: To: Kam Keiser/HOU/ECT@ECT, Darron C Giron/HOU/ECT@ECT, David sl@0: Baumbach/HOU/ECT@ECT, Errol McLaughlin/Corp/Enron@ENRON sl@0: cc: Kimat Singla/HOU/ECT@ECT, Kulvinder Fowler/NA/Enron@ENRON, Kyle R sl@0: Lilly/HOU/ECT@ECT, Jeff Royed/Corp/Enron@ENRON, Alejandra sl@0: Chavez/NA/Enron@ENRON, Crystal Hyde/HOU/ECT@ECT sl@0: sl@0: Subject: New EAST books sl@0: sl@0: We have new book names in TAGG for our intramonth portfolios and it is sl@0: extremely important that any deal booked to the East is communicated quickly sl@0: to someone on my team. I know it will take some time for the new names to sl@0: sink in and I do not want us to miss any positions or P&L. sl@0: sl@0: Thanks for your help on this. sl@0: sl@0: New: sl@0: Scott Neal : East Northeast sl@0: Dick Jenkins: East Marketeast sl@0: sl@0: WK sl@0: '); sl@0: 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 sl@0: affect any Inactive Child. sl@0: sl@0: An inactive Child with links to Parent products will not have their sl@0: calculated prices updated until the Child product is Activated. sl@0: sl@0: When the Child Product is activated, the price will be recalculated and sl@0: updated BEFORE it is displayed on the web. sl@0: sl@0: This means that if you are inputting a basis price on a Child product, you sl@0: will not see the final, calculated price until you Activate the product, at sl@0: which time the customer will also see it. sl@0: sl@0: If you have any questions, please contact the Help Desk on: sl@0: sl@0: Americas: 713 853 4357 sl@0: Europe: + 44 (0) 20 7783 7783 sl@0: Asia/Australia: +61 2 9229 2300 sl@0: sl@0: Dave'); sl@0: 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, sl@0: sl@0: I saw it. Very interesting. sl@0: sl@0: Vince sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: "John H Herbert" on 07/28/2000 08:38:08 AM sl@0: To: "Vince J Kaminski" sl@0: cc: sl@0: Subject: Light reading - see pieces beginning on page 7 sl@0: sl@0: sl@0: Cheers and have a nice weekend, sl@0: sl@0: sl@0: JHHerbert sl@0: sl@0: sl@0: sl@0: sl@0: - gd000728.pdf sl@0: sl@0: sl@0: sl@0: '); sl@0: 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 '); sl@0: 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. sl@0: sl@0: Thanks for your understanding in this matter. sl@0: sl@0: T.Jae Black sl@0: East Power Trading sl@0: Assistant to Kevin Presto sl@0: off. 713-853-5800 sl@0: fax 713-646-8272 sl@0: cell 713-539-4760'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('eric.bass@enron.com', 'dale.neuner@enron.com', '5 X 24', 'Dale, sl@0: sl@0: Have you heard anything more on the 5 X 24s? We would like to get this sl@0: product out ASAP. sl@0: sl@0: sl@0: Thanks, sl@0: sl@0: Eric'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('messenger@smartreminders.com', 'm..tholt@enron.com', '10% Coupon - PrintPal Printer Cartridges - 100% Guaranteed', '[IMAGE] sl@0: [IMAGE][IMAGE][IMAGE] sl@0: Dear SmartReminders Member, sl@0: [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] [IMAGE] sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: We respect your privacy and are a Certified Participant of the BBBOnLine sl@0: Privacy Program. To be removed from future offers,click here. sl@0: SmartReminders.com is a permission based service. To unsubscribe click here . '); sl@0: 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 sl@0: speak. He was the one who got into several bad deals and PPA''s in California sl@0: for CIN, thus he left on a bad note. Let me know if you need more detail sl@0: than that, I felt this was the type of info you were looking for. Thanks! sl@0: Ben'); sl@0: 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 sl@0: Report Name: Houston Cellular 8-11-01 sl@0: Report Date: 12/13/01 sl@0: Report ID: 594D37C9ED2111D5B452 sl@0: Submitted On: 12/13/01 sl@0: sl@0: You are only allowed 2 reports with receipts outstanding. Your expense reports will not be paid until you meet this requirement.'); sl@0: 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. sl@0: sl@0: Sue Mara sl@0: Enron Corp. sl@0: Tel: (415) 782-7802 sl@0: Fax:(415) 782-7854 sl@0: ----- Forwarded by Susan J Mara/NA/Enron on 06/08/2001 12:24 PM ----- sl@0: sl@0: sl@0: "Milner, Marcie" 06/08/2001 11:13 AM To: "''smara@enron.com''" cc: Subject: CAISO Emergency Motion sl@0: sl@0: sl@0: Sue, did you see this emergency motion the CAISO filed today? Apparently sl@0: they are requesting that FERC discontinue market-based rates immediately and sl@0: grant refunds plus interest on the difference between cost-based rates and sl@0: market revenues received back to May 2000. They are requesting the sl@0: commission act within 14 days. Have you heard anything about what they are sl@0: doing? sl@0: sl@0: Marcie sl@0: sl@0: http://www.caiso.com/docs/2001/06/08/200106081005526469.pdf sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('fletcher.sturm@enron.com', 'eloy.escobar@enron.com', 'Re: General Brinks Position Meeting', 'Eloy, sl@0: sl@0: Who is General Brinks? sl@0: sl@0: Fletch'); sl@0: 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, sl@0: sl@0: Here are the documents that Peter has prepared for Mark Frevert. sl@0: sl@0: Nailia sl@0: ---------------------- Forwarded by Nailia Dindarova/LON/ECT on 25/06/2001 sl@0: 16:36 --------------------------- sl@0: sl@0: sl@0: Nailia Dindarova sl@0: 25/06/2001 15:36 sl@0: To: Michael Brown/Enron@EUEnronXGate sl@0: cc: Ross Sankey/Enron@EUEnronXGate, Eric Shaw/ENRON@EUEnronXGate, Peter sl@0: Styles/LON/ECT@ECT sl@0: sl@0: Subject: Documents for Mark Frevert (on EU developments and lessons from sl@0: California) sl@0: sl@0: Michael, sl@0: sl@0: sl@0: These are the documents that Peter promised to give to you for Mark Frevert. sl@0: He has now handed them to him in person but asked me to transmit them sl@0: electronically to you, as well as Eric and Ross. sl@0: sl@0: Nailia sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('peggy.a.kostial@accenture.com', 'dave.samuels@enron.com', 'EOL-Accenture Deal Sheet', 'Dave - sl@0: sl@0: Attached are our comments and suggested changes. Please call to review. sl@0: sl@0: On the time line for completion, we have four critical steps to complete: sl@0: Finalize market analysis to refine business case, specifically sl@0: projected revenue stream sl@0: Complete counterparty surveying, including targeting 3 CPs for letters sl@0: of intent sl@0: Review Enron asset base for potential reuse/ licensing sl@0: Contract negotiations sl@0: sl@0: Joe will come back to us with an updated time line, but it is my sl@0: expectation that we are still on the same schedule (we just begun week sl@0: three) with possibly a week or so slippage.....contract negotiations will sl@0: probably be the critical path. sl@0: sl@0: We will send our cut at the actual time line here shortly. Thanks, sl@0: sl@0: Peggy sl@0: sl@0: (See attached file: accenture-dealpoints v2.doc) sl@0: - accenture-dealpoints v2.doc '); sl@0: 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 sl@0: 03:49 PM --------------------------- sl@0: sl@0: sl@0: Thomas A Martin sl@0: 10/11/2000 03:55 PM sl@0: To: Patrick Wade/HOU/ECT@ECT sl@0: cc: sl@0: Subject: Re: Guadalupe Power Partners LP sl@0: sl@0: The deal is physically served at Oasis Waha or Oasis Katy and is priced at sl@0: either HSC, Waha or Katytailgate GD at buyers option three days prior to sl@0: NYMEX close. sl@0: sl@0: '); sl@0: 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 sl@0: AM --------------------------- sl@0: sl@0: sl@0: agoddard@nisource.com on 03/08/2001 09:16:57 AM sl@0: To: " - *Koch, Kent" , " - sl@0: *Millar, Debra" , " - *Burke, Lynn" sl@0: sl@0: cc: " - *Heckathorn, Tom" sl@0: Subject: Columbia Distribution''s Capacity Available for Release - Sum sl@0: sl@0: sl@0: Attached is Columbia Distribution''s notice of capacity available for release sl@0: for sl@0: the summer of 2001 (Apr. 2001 through Oct. 2001). sl@0: sl@0: Please note that the deadline for bids is 3:00pm EST on March 20, 2001. sl@0: sl@0: If you have any questions, feel free to contact any of the representatives sl@0: listed sl@0: at the bottom of the attachment. sl@0: sl@0: Aaron Goddard sl@0: sl@0: sl@0: sl@0: sl@0: - 2001Summer.doc sl@0: '); sl@0: 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. sl@0: Copies will be distributed to Legal and Credit.'); sl@0: 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'); sl@0: 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 : sl@0: 713-668-3712...... my cell # is 281-381-7332 sl@0: sl@0: the kid'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('cooper.richey@enron.com', 'trycooper@hotmail.com', 'FW: Contact Info', ' sl@0: sl@0: -----Original Message----- sl@0: From: Punja, Karim sl@0: Sent: Thursday, December 13, 2001 2:35 PM sl@0: To: Richey, Cooper sl@0: Subject: Contact Info sl@0: sl@0: sl@0: Cooper, sl@0: sl@0: Its been a real pleasure working with you (even though it was for only a small amount of time) sl@0: I hope we can stay in touch. sl@0: sl@0: Home# 234-0249 sl@0: email: kpunja@hotmail.com sl@0: sl@0: Take Care, sl@0: sl@0: Karim. sl@0: '); sl@0: 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. sl@0: sl@0: I haven''t talked to many of you via email recently but I do want to give you sl@0: my new address for your email file: sl@0: sl@0: bjm30@earthlink.net sl@0: sl@0: I hope all is well. sl@0: sl@0: Brian McGuinn'); sl@0: 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. sl@0: sl@0: Shelley'); sl@0: 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 sl@0: sl@0: San Antonio, Texas May 2-4, 2001 Westin Riverwalk sl@0: sl@0: See attached memo for more details!! sl@0: sl@0: sl@0: ? Registration for the law conference this year will be handled through an sl@0: Online RSVP Form on the Enron Law Conference Website at sl@0: http://lawconference.corp.enron.com. The website is still under construction sl@0: and will not be available until Thursday, March 15, 2001. sl@0: sl@0: ? We will send you another e-mail to confirm when the Law Conference Website sl@0: is operational. sl@0: sl@0: ? Please complete the Online RSVP Form as soon as it is available and submit sl@0: it no later than Friday, March 30th. sl@0: sl@0: sl@0: sl@0: sl@0: '); sl@0: 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 sl@0: and let him know - we are coming on saturday - i just havent had a chance to sl@0: call you guys back -- looking forward to it -- i probably need the sl@0: directions again though'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('darron.giron@enron.com', 'bryce.baxter@enron.com', 'Re: Feedback for Audrey Cook', 'Bryce, sl@0: sl@0: I''ll get it done today. sl@0: sl@0: DG 3-9573 sl@0: sl@0: sl@0: sl@0: sl@0: sl@0: From: Bryce Baxter 06/12/2000 07:15 PM sl@0: sl@0: sl@0: To: Darron C Giron/HOU/ECT@ECT sl@0: cc: sl@0: Subject: Feedback for Audrey Cook sl@0: sl@0: You were identified as a reviewer for Audrey Cook. If possible, could you sl@0: complete her feedback by end of business Wednesday? It will really help me sl@0: in the PRC process to have your input. Thanks. sl@0: sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('casey.evans@enron.com', 'stephanie.sever@enron.com', 'Gas EOL ID', 'Stephanie, sl@0: sl@0: 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: sl@0: sl@0: PWR-NG-LT-SPP: Mike Carson sl@0: PWR-NG-LT-SERC: Jeff King sl@0: sl@0: If you need to know their power desk to map their ID to their gas books, those desks are as follows: sl@0: sl@0: EPMI-LT-SPP: Mike Carson sl@0: EPMI-LT-SERC: Jeff King sl@0: sl@0: I will be in training this afternoon, but will be back when class is over. Let me know if you have any questions. sl@0: sl@0: Thanks for your help! sl@0: Casey'); sl@0: 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. sl@0: sl@0: sl@0: ds sl@0: sl@0: sl@0: sl@0: sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('mcominsky@aol.com', 'cpatman@bracepatt.com, james_derrick@enron.com', 'Jurisprudence Luncheon', 'Carrin & Jim -- sl@0: sl@0: It was an honor and a pleasure to meet both of you yesterday. I know we will sl@0: have fun working together on this very special event. sl@0: sl@0: Jeff left the jurisprudence luncheon lists for me before he left on vacation. sl@0: I wasn''t sure whether he transmitted them to you as well. Would you please sl@0: advise me if you would like them sent to you? I can email the MS Excel files sl@0: or I can fax the hard copies to you. Please advise what is most convenient. sl@0: sl@0: I plan to be in town through the holidays and can be reached by phone, email, sl@0: or cell phone at any time. My cell phone number is 713/705-4829. sl@0: sl@0: Thanks again for your interest in the ADL''s work. Martin. sl@0: sl@0: Martin B. Cominsky sl@0: Director, Southwest Region sl@0: Anti-Defamation League sl@0: 713/627-3490, ext. 122 sl@0: 713/627-2011 (fax) sl@0: MCominsky@aol.com'); sl@0: 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 sl@0: Raimer to be Bush''s secretary of HHS? Just curious about that infamous UTMB sl@0: rumor mill. Hope things are well, happy holidays. sl@0: PL'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('marie.heard@enron.com', 'ehamilton@fna.com', 'ISDA Master Agreement', 'Erin: sl@0: sl@0: 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. sl@0: sl@0: Marie sl@0: sl@0: Marie Heard sl@0: Senior Legal Specialist sl@0: Enron North America Corp. sl@0: Phone: (713) 853-3907 sl@0: Fax: (713) 646-3490 sl@0: marie.heard@enron.com sl@0: sl@0: '); sl@0: 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. sl@0: sl@0: sl@0: sl@0: '); sl@0: 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', ' sl@0: Please contact me if you have any questions regarding last weeks prices. sl@0: sl@0: Thank you, sl@0: Karolyn Criado sl@0: 3-9441 sl@0: sl@0: sl@0: sl@0: sl@0: '); sl@0: 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. sl@0: sl@0: 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. sl@0: sl@0: We also need to continue to explore a JEA buy-out. sl@0: sl@0: Thanks.'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('stacy.dickson@enron.com', 'gregg.penman@enron.com', 'RE: Constellation TC 5-7-01', 'Gregg, sl@0: sl@0: I am at home with a sick baby. (Lots of fun!) I will call you about this sl@0: tomorrow. sl@0: sl@0: Stacy'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('joe.quenet@enron.com', 'dfincher@utilicorp.com', '', 'hey big guy.....check this out..... sl@0: sl@0: w ww.gorelieberman-2000.com/'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('k..allen@enron.com', 'jacqestc@aol.com', '', 'Jacques, sl@0: sl@0: 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)). sl@0: This is assuming we wrap this up on Tuesday. sl@0: sl@0: Please email to confirm that their changes are ok so I can set up a meeting on Tuesday to reach closure. sl@0: sl@0: Phillip'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('kourtney.nelson@enron.com', 'mike.swerzbin@enron.com', 'Adjusted L/R Balance', 'Mike, sl@0: sl@0: I placed the adjusted L/R Balance on the Enronwest site. It is under the "Staff/Kourtney Nelson". There are two links: sl@0: sl@0: 1) "Adj L_R" is the same data/format from the weekly strategy meeting. sl@0: 2) "New Gen 2001_2002" link has all of the supply side info that is used to calculate the L/R balance sl@0: -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. sl@0: sl@0: 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. sl@0: sl@0: Please let me know if you have any questions or feedback, sl@0: sl@0: Kourtney sl@0: sl@0: sl@0: sl@0: Kourtney Nelson sl@0: Fundamental Analysis sl@0: Enron North America sl@0: (503) 464-8280 sl@0: kourtney.nelson@enron.com'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('d..thomas@enron.com', 'naveed.ahmed@enron.com', 'FW: Current Enron TCC Portfolio', ' sl@0: sl@0: -----Original Message----- sl@0: From: Grace, Rebecca M. sl@0: Sent: Monday, December 17, 2001 9:44 AM sl@0: To: Thomas, Paul D. sl@0: Cc: Cashion, Jim; Allen, Thresa A.; May, Tom sl@0: Subject: RE: Current Enron TCC Portfolio sl@0: sl@0: sl@0: Paul, sl@0: sl@0: I reviewed NY''s list. I agree with all of their contracts numbers and mw amounts. sl@0: sl@0: Call if you have any more questions. sl@0: sl@0: Rebecca sl@0: sl@0: sl@0: sl@0: -----Original Message----- sl@0: From: Thomas, Paul D. sl@0: Sent: Monday, December 17, 2001 9:08 AM sl@0: To: Grace, Rebecca M. sl@0: Subject: FW: Current Enron TCC Portfolio sl@0: sl@0: << File: enrontccs.xls >> sl@0: Rebecca, sl@0: Let me know if you see any differences. sl@0: sl@0: Paul sl@0: X 3-0403 sl@0: -----Original Message----- sl@0: From: Thomas, Paul D. sl@0: Sent: Monday, December 17, 2001 9:04 AM sl@0: To: Ahmed, Naveed sl@0: Subject: FW: Current Enron TCC Portfolio sl@0: sl@0: sl@0: sl@0: sl@0: -----Original Message----- sl@0: From: Thomas, Paul D. sl@0: Sent: Thursday, December 13, 2001 10:01 AM sl@0: To: Baughman, Edward D. sl@0: Subject: Current Enron TCC Portfolio sl@0: sl@0: sl@0: '); sl@0: 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, sl@0: L.P., effective February 1, 2001, with the surviving entity being El Paso sl@0: Merchant Energy, L.P. We currently have ISDA Master Agreements with both sl@0: counterparties. Please see the attached memo regarding the existing Masters sl@0: and let us know which agreement should be terminated. sl@0: sl@0: Thanks, sl@0: Stephanie sl@0: '); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('kam.keiser@enron.com', 'c..kenne@enron.com', 'RE: What about this too???', ' sl@0: sl@0: -----Original Message----- sl@0: From: Kenne, Dawn C. sl@0: Sent: Wednesday, February 06, 2002 11:50 AM sl@0: To: Keiser, Kam sl@0: Subject: What about this too??? sl@0: sl@0: sl@0: << File: Netco Trader Matrix.xls >> sl@0: '); sl@0: 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. sl@0: sl@0: Thanks sl@0: sl@0: chris sl@0: x31666'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('debra.perlingiere@enron.com', 'jworman@academyofhealth.com', '', 'Have a great weekend! Happy Fathers Day! sl@0: sl@0: sl@0: Debra Perlingiere sl@0: Enron North America Corp. sl@0: 1400 Smith Street, EB 3885 sl@0: Houston, Texas 77002 sl@0: dperlin@enron.com sl@0: Phone 713-853-7658 sl@0: Fax 713-646-3490'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('outlook.team@enron.com', '', 'Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia &', 'CALENDAR ENTRY: APPOINTMENT sl@0: sl@0: Description: sl@0: Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia & Dir Rpts. - 4102 sl@0: sl@0: Date: 1/5/2001 sl@0: Time: 9:00 AM - 10:00 AM (Central Standard Time) sl@0: sl@0: Chairperson: Outlook Migration Team sl@0: sl@0: Detailed Description:'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('diana.seifert@enron.com', 'mark.taylor@enron.com', 'Guest access Chile', 'Hello Mark, sl@0: sl@0: Justin Boyd told me that your can help me with questions regarding Chile. sl@0: We got a request for guest access through MG. sl@0: The company is called Escondida and is a subsidiary of BHP Australia. sl@0: sl@0: Please advise if I can set up a guest account or not. sl@0: F.Y.I.: MG is planning to put a "in w/h Chile" contract for Copper on-line as sl@0: soon as Enron has done the due diligence for this country. sl@0: Thanks ! sl@0: sl@0: sl@0: Best regards sl@0: sl@0: Diana Seifert sl@0: EOL PCG'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('enron_update@concureworkplace.com', 'mark.whitt@enron.com', '<> - 121001', 'The Approval status has changed on the following report: sl@0: sl@0: Status last changed by: Barry L. Tycholiz sl@0: Expense Report Name: 121001 sl@0: Report Total: $198.98 sl@0: Amount Due Employee: $198.98 sl@0: Amount Approved: $198.98 sl@0: Amount Paid: $0.00 sl@0: Approval Status: Approved sl@0: Payment Status: Pending sl@0: sl@0: sl@0: To review this expense report, click on the following link for Concur Expense. sl@0: http://expensexms.enron.com'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('kevin.hyatt@enron.com', '', 'Technical Support', 'Outside the U.S., please refer to the list below: sl@0: sl@0: Australia: sl@0: 1800 678-515 sl@0: support@palm-au.com sl@0: sl@0: Canada: sl@0: 1905 305-6530 sl@0: support@palm.com sl@0: sl@0: New Zealand: sl@0: 0800 446-398 sl@0: support@palm-nz.com sl@0: sl@0: U.K.: sl@0: 0171 867 0108 sl@0: eurosupport@palm.3com.com sl@0: sl@0: Please refer to the Worldwide Customer Support card for a complete technical support contact list.'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('geoff.storey@enron.com', 'dutch.quigley@enron.com', 'RE:', 'duke contact? sl@0: sl@0: -----Original Message----- sl@0: From: Quigley, Dutch sl@0: Sent: Wednesday, October 31, 2001 10:14 AM sl@0: To: Storey, Geoff sl@0: Subject: RE: sl@0: sl@0: bp corp Albert LaMore 281-366-4962 sl@0: sl@0: running the reports now sl@0: sl@0: sl@0: -----Original Message----- sl@0: From: Storey, Geoff sl@0: Sent: Wednesday, October 31, 2001 10:10 AM sl@0: To: Quigley, Dutch sl@0: Subject: RE: sl@0: sl@0: give me a contact over there too sl@0: BP sl@0: sl@0: sl@0: -----Original Message----- sl@0: From: Quigley, Dutch sl@0: Sent: Wednesday, October 31, 2001 9:42 AM sl@0: To: Storey, Geoff sl@0: Subject: sl@0: sl@0: Coral Jeff Whitnah 713-767-5374 sl@0: Relaint Steve McGinn 713-207-4000'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('pete.davis@enron.com', 'pete.davis@enron.com', 'Start Date: 4/22/01; HourAhead hour: 3; ', 'Start Date: 4/22/01; HourAhead hour: 3; No ancillary schedules awarded. sl@0: Variances detected. sl@0: Variances detected in Load schedule. sl@0: sl@0: LOG MESSAGES: sl@0: sl@0: PARSING FILE -->> O:\Portland\WestDesk\California Scheduling\ISO Final sl@0: Schedules\2001042203.txt sl@0: sl@0: ---- Load Schedule ---- sl@0: $$$ Variance found in table tblLoads. sl@0: Details: (Hour: 3 / Preferred: 1.92 / Final: 1.89) sl@0: TRANS_TYPE: FINAL sl@0: LOAD_ID: PGE4 sl@0: MKT_TYPE: 2 sl@0: TRANS_DATE: 4/22/01 sl@0: SC_ID: EPMI sl@0: sl@0: '); sl@0: 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. sl@0: sl@0: John'); sl@0: 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 sl@0: shower). I have had a shitty week--I suspect my silence (not only to you, sl@0: but others) after our phone call is a result of the week. I''m seeing Glen at sl@0: 11:15....talk to you'); sl@0: INSERT INTO email([from],[to],subject,body) VALUES('litebytz@enron.com', '', 'Lite Bytz RSVP', ' sl@0: This week''s Lite Bytz presentation will feature the following TOOLZ speaker: sl@0: sl@0: Richard McDougall sl@0: Solaris 8 sl@0: Thursday, June 7, 2001 sl@0: sl@0: 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. sl@0: sl@0: *Remember: this is now a Brown Bag Event--so bring your lunch and we will provide cookies and drinks. sl@0: sl@0: Click below for more details. sl@0: sl@0: http://home.enron.com:84/messaging/litebytztoolzprint.jpg'); sl@0: COMMIT; sl@0: } sl@0: } {} sl@0: sl@0: ############################################################################### sl@0: # Everything above just builds an interesting test database. The actual sl@0: # tests come after this comment. sl@0: ############################################################################### sl@0: sl@0: do_test fts1c-1.2 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH 'mark' sl@0: } sl@0: } {6 17 25 38 40 42 73 74} sl@0: do_test fts1c-1.3 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH 'susan' sl@0: } sl@0: } {24 40} sl@0: do_test fts1c-1.4 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH 'mark susan' sl@0: } sl@0: } {40} sl@0: do_test fts1c-1.5 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH 'susan mark' sl@0: } sl@0: } {40} sl@0: do_test fts1c-1.6 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH '"mark susan"' sl@0: } sl@0: } {} sl@0: do_test fts1c-1.7 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH 'mark -susan' sl@0: } sl@0: } {6 17 25 38 42 73 74} sl@0: do_test fts1c-1.8 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH '-mark susan' sl@0: } sl@0: } {24} sl@0: do_test fts1c-1.9 { sl@0: execsql { sl@0: SELECT rowid FROM email WHERE email MATCH 'mark OR susan' sl@0: } sl@0: } {6 17 24 25 38 40 42 73 74} sl@0: sl@0: # Some simple tests of the automatic "offsets(email)" column. In the sample sl@0: # data set above, only one message, number 20, contains the words sl@0: # "gas" and "reminder" in both body and subject. sl@0: # sl@0: do_test fts1c-2.1 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE email MATCH 'gas reminder' sl@0: } sl@0: } {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}} sl@0: do_test fts1c-2.2 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE email MATCH 'subject:gas reminder' sl@0: } sl@0: } {20 {2 0 42 3 2 1 54 8 3 1 54 8}} sl@0: do_test fts1c-2.3 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE email MATCH 'body:gas reminder' sl@0: } sl@0: } {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}} sl@0: do_test fts1c-2.4 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE subject MATCH 'gas reminder' sl@0: } sl@0: } {20 {2 0 42 3 2 1 54 8}} sl@0: do_test fts1c-2.5 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE body MATCH 'gas reminder' sl@0: } sl@0: } {20 {3 0 42 3 3 1 54 8 3 0 129 3 3 0 143 3 3 0 240 3}} sl@0: sl@0: # Document 32 contains 5 instances of the world "child". But only sl@0: # 3 of them are paired with "product". Make sure only those instances sl@0: # that match the phrase appear in the offsets(email) list. sl@0: # sl@0: do_test fts1c-3.1 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE body MATCH 'child product' AND +rowid=32 sl@0: } sl@0: } {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}} sl@0: do_test fts1c-3.2 { sl@0: execsql { sl@0: SELECT rowid, offsets(email) FROM email sl@0: WHERE body MATCH '"child product"' sl@0: } sl@0: } {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}} sl@0: sl@0: # Snippet generator tests sl@0: # sl@0: do_test fts1c-4.1 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'subject:gas reminder' sl@0: } sl@0: } {{Alert Posted 10:00 AM November 20,2000: E-GAS Request Reminder}} sl@0: do_test fts1c-4.2 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'christmas candlelight' sl@0: } sl@0: } {{... place.? What do you think about going here Christmas sl@0: eve?? They have an 11:00 a.m. service and a candlelight service at 5:00 p.m., sl@0: among others. ...}} sl@0: sl@0: do_test fts1c-4.3 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'deal sheet potential reuse' sl@0: } sl@0: } {{EOL-Accenture Deal Sheet ... intent sl@0: Review Enron asset base for potential reuse/ licensing sl@0: Contract negotiations ...}} sl@0: do_test fts1c-4.4 { sl@0: execsql { sl@0: SELECT snippet(email,'<<<','>>>',' ') FROM email sl@0: WHERE email MATCH 'deal sheet potential reuse' sl@0: } sl@0: } {{EOL-Accenture <<>> <<>> intent sl@0: Review Enron asset base for <<>> <<>>/ licensing sl@0: Contract negotiations }} sl@0: do_test fts1c-4.5 { sl@0: execsql { sl@0: SELECT snippet(email,'<<<','>>>',' ') FROM email sl@0: WHERE email MATCH 'first things' sl@0: } sl@0: } {{Re: <<>> Polish Deal! Congrats! <<>> seem to be building rapidly now on the }} sl@0: do_test fts1c-4.6 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'chris is here' sl@0: } sl@0: } {{chris.germany@enron.com ... Sounds good to me. I bet this is next to the Warick?? Hotel. ... place.? What do you think about going here Christmas sl@0: eve?? They have an 11:00 a.m. ...}} sl@0: do_test fts1c-4.7 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH '"pursuant to"' sl@0: } sl@0: } {{Erin: sl@0: sl@0: Pursuant to your request, attached are the Schedule to ...}} sl@0: do_test fts1c-4.8 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'ancillary load davis' sl@0: } sl@0: } {{pete.davis@enron.com ... Start Date: 4/22/01; HourAhead hour: 3; No ancillary schedules awarded. sl@0: Variances detected. sl@0: Variances detected in Load schedule. sl@0: sl@0: LOG MESSAGES: sl@0: sl@0: PARSING ...}} sl@0: sl@0: # Combinations of AND and OR operators: sl@0: # sl@0: do_test fts1c-5.1 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'questar enron OR com' sl@0: } sl@0: } {{matt.smith@enron.com ... six reports: sl@0: sl@0: 31 Keystone Receipts sl@0: 15 Questar Pipeline sl@0: 40 Rockies Production sl@0: 22 West_2 ...}} sl@0: do_test fts1c-5.2 { sl@0: execsql { sl@0: SELECT snippet(email) FROM email sl@0: WHERE email MATCH 'enron OR com questar' sl@0: } sl@0: } {{matt.smith@enron.com ... six reports: sl@0: sl@0: 31 Keystone Receipts sl@0: 15 Questar Pipeline sl@0: 40 Rockies Production sl@0: 22 West_2 ...}} sl@0: sl@0: finish_test