1 # 2006 September 14

     2 #

     3 # The author disclaims copyright to this source code.  In place of

     4 # a legal notice, here is a blessing:

     5 #

     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.

     9 #

    10 #*************************************************************************

    11 # This file implements regression tests for SQLite library.  The

    12 # focus of this script is testing the FTS1 module.

    13 #

    14 # $Id: fts1c.test,v 1.11 2006/10/04 17:35:28 drh Exp $

    15 #

    16 

    17 set testdir [file dirname $argv0]

    18 source $testdir/tester.tcl

    19 

    20 # If SQLITE_ENABLE_FTS1 is defined, omit this file.

    21 ifcapable !fts1 {

    22   finish_test

    23   return

    24 }

    25 

    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.

    29 #

    30 do_test fts1c-1.1 {

    31   db eval {

    32     CREATE VIRTUAL TABLE email USING fts1([from],[to],subject,body);

    33     BEGIN TRANSACTION;

    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.

    35 

    36 The volume on the hedge will now respect the minimum volume and volume increment settings on the parent product. See rules below: 

    37 

    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.

    41 

    42 Please see example below:

    43 

    44 Parent''s Settings:

    45 Minimum: 	5000

    46 Increment:  1000

    47 

    48 Volume on Autohedge transaction			Volume Hedged

    49 1      - 2499							0

    50 2500 - 5499							5000

    51 5500 - 6499							6000');

    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:

    57 

    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

    63 

    64 

    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,

    68 

    69 Could you print off the current work request report by 1:30 today?

    70 

    71 Gentlemen,

    72 

    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.

    75 

    76 JD');

    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-----

    83 From: 	Johnson, Jay  

    84 Sent:	Tuesday, October 16, 2001 3:42 PM

    85 To:	Carter, Karen E.

    86 Subject:	FW: Producers Newsletter 9-24-2001

    87 

    88 

    89 

    90  -----Original Message-----

    91 From: 	Daigre, Sergai  

    92 Sent:	Friday, September 21, 2001 8:33 PM

    93 Subject:	Producers Newsletter 9-24-2001

    94 

    95  ');

    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 

    99 or me to participate.

   100 

   101 I spoke to Max and he agrees with this approach.

   102 

   103 I hope this meets with your approval.

   104 

   105 Regards

   106 Delainey');

   107 INSERT INTO email([from],[to],subject,body) VALUES('lachandra.fenceroy@enron.com', 'lindy.donoho@enron.com', 'FW: Bus Applications Meeting Follow Up', 'Lindy,

   108 

   109 Here is the original memo we discussed earlier.  Please provide any information that you may have.

   110 

   111 Your cooperation is greatly appreciated.

   112 

   113 Thanks,

   114 

   115 lachandra.fenceroy@enron.com

   116 713.853.3884

   117 877.498.3401 Pager

   118 

   119  -----Original Message-----

   120 From: 	Bisbee, Joanne  

   121 Sent:	Wednesday, September 26, 2001 7:50 AM

   122 To:	Fenceroy, LaChandra

   123 Subject:	FW: Bus Applications Meeting Follow Up

   124 

   125 Lachandra, Please get with David Duff today and see what this is about.  Who are our TW accounting business users?

   126 

   127  -----Original Message-----

   128 From: 	Koh, Wendy  

   129 Sent:	Tuesday, September 25, 2001 2:41 PM

   130 To:	Bisbee, Joanne

   131 Subject:	Bus Applications Meeting Follow Up

   132 

   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.

   134 

   135 Wendy');

   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.

   138 Dan

   139 

   140  -----Original Message-----

   141 From: 	Fagan, Fran  

   142 Sent:	Thursday, December 20, 2001 11:10 AM

   143 To:	McCarty, Danny

   144 Subject:	worksheets

   145 

   146 As discussed, attached are your sheets for bonus and merit.

   147 

   148 Thanks,

   149 

   150 Fran Fagan

   151 Sr. HR Rep

   152 713.853.5219

   153 

   154 

   155  << File: McCartyMerit.xls >>  << File: mccartyBonusCommercial_UnP.xls >> 

   156 

   157 ');

   158 INSERT INTO email([from],[to],subject,body) VALUES('bert.meyers@enron.com', 'shift.dl-portland@enron.com', 'OCTOBER SCHEDULE', 'TEAM,

   159 

   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.

   161 

   162 BERT');

   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&current_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

   165 

   166 

   167 I spoke with Rickey (boy, is he long-winded!!).  Gave him the name of our 

   168 credit guy, Russell Diamond.

   169 

   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 --

   173 

   174 Here is the information on staffing and outside services.  Call if you need anything else.

   175 

   176 Jim

   177 

   178  ');

   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. 

   182 Greg Elliott 

   183 IIR, Inc. 

   184 713-783-5147 x 3481 

   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.

   188  - OUTAGE.dbf 

   189  - 111201R.xls 

   190  - 111201.xls ');

   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 !

   192 

   193 You are invited to attend the EWS Brown Bag Lunch Series

   194 

   195 Featuring:   RAY BOWEN, COO

   196 

   197 Topic:  Enron Industrial Markets

   198 

   199 Thursday, March 15, 2001

   200 11:30 am - 12:30 pm

   201 EB 5 C2

   202 

   203 

   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.

   207 

   208 

   209 

   210 

   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>

   213 cc:  

   214 Subject: About St Pauls

   215 

   216 

   217 

   218 

   219  <<About St Pauls.url>>  

   220 ? 

   221 ?http://www.stpaulshouston.org/about.html 

   222 

   223 Chris, 

   224 

   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., 

   227 among others.

   228 

   229 Let me know.?? ii 

   230 

   231  - About St Pauls.url

   232 

   233 ');

   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.

   240 ');

   241 INSERT INTO email([from],[to],subject,body) VALUES('dutch.quigley@enron.com', 'rwolkwitz@powermerchants.com', '', ' 

   242 

   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&current_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

   246 

   247 LS HPL LSK IC       30.000 / Enron

   248 ');

   249 INSERT INTO email([from],[to],subject,body) VALUES('susan.pereira@enron.com', 'kkw816@aol.com', 'soccer practice', 'Kathy-

   250 

   251 Is it safe to assume that practice is cancelled for tonight??

   252 

   253 Susan Pereira');

   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.

   255 

   256  ');

   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.

   259 

   260 Thanks,

   261 JMForney

   262 3-7160');

   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.

   265 

   266 adam

   267 35227

   268 

   269 

   270  -----Original Message-----

   271 From: 	Royed, Jeff  

   272 Sent:	Tuesday, September 25, 2001 11:37 AM

   273 To:	Bayer, Adam

   274 Subject:	Curve Fetch File

   275 

   276 Let me know if it works.   It may be required to have a certain version of Oracle for it to work properly.

   277 

   278  

   279 

   280 Jeff Royed

   281 Enron 

   282 Energy Operations

   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,

   285 

   286 The merged reports look great.  I believe the only orientation changes are to 

   287 "unmerge" the following six reports:  

   288 

   289 31 Keystone Receipts

   290 15 Questar Pipeline

   291 40 Rockies Production

   292 22 West_2

   293 23 West_3

   294 25 CIG_WIC

   295 

   296 The orientation of the individual reports should be correct.  Thanks.

   297 

   298 Mat

   299 

   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 ---------------------------

   303 

   304 

   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>

   310 cc:  

   311 

   312 Subject: Egyptian Festival

   313 

   314 

   315  <<Egyptian Festival.url>>

   316 

   317  http://www.egyptianfestival.com/

   318 

   319  - Egyptian Festival.url

   320 ');

   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..................................

   322 

   323 Thanks

   324 ---------------------- Forwarded by Errol McLaughlin/Corp/Enron on 12/20/2000 

   325 08:39 AM ---------------------------

   326    

   327 	

   328 	

   329 	From:  William Kelly @ ECT                           12/20/2000 08:31 AM

   330 	

   331 

   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 

   337 

   338 Subject: New EAST books

   339 

   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.  

   344 

   345 Thanks for your help on this.

   346 

   347 New:

   348 Scott Neal :         East Northeast

   349 Dick Jenkins:     East Marketeast

   350 

   351 WK 

   352 ');

   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.

   355 

   356 An inactive Child with links to Parent products will not have their 

   357 calculated prices updated until the Child product is Activated.

   358 

   359 When the Child Product is activated, the price will be recalculated and 

   360 updated BEFORE it is displayed on the web.

   361 

   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.

   365 

   366 If you have any questions, please contact the Help Desk on:

   367 

   368 Americas: 713 853 4357

   369 Europe: + 44 (0) 20 7783 7783

   370 Asia/Australia: +61 2 9229 2300

   371 

   372 Dave');

   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,

   374 

   375 I saw it. Very interesting.

   376 

   377 Vince

   378 

   379 

   380 

   381 

   382 

   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>

   385 cc:  

   386 Subject: Light reading - see pieces beginning on page 7

   387 

   388 

   389 Cheers and have a nice weekend,

   390 

   391 

   392 JHHerbert

   393 

   394 

   395 

   396 

   397  - gd000728.pdf

   398 

   399 

   400 

   401 ');

   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.

   404 

   405 Thanks for your understanding in this matter.

   406 

   407 T.Jae Black

   408 East Power Trading

   409 Assistant to Kevin Presto

   410 off. 713-853-5800

   411 fax 713-646-8272

   412 cell 713-539-4760');

   413 INSERT INTO email([from],[to],subject,body) VALUES('eric.bass@enron.com', 'dale.neuner@enron.com', '5 X 24', 'Dale,

   414 

   415 Have you heard anything more on the 5 X 24s?  We would like to get this 

   416 product out ASAP.

   417 

   418 

   419 Thanks,

   420 

   421 Eric');

   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]     	

   426 

   427 

   428   

   429  

   430  

   431  

   432  

   433  

   434  

   435  

   436  

   437  

   438  

   439  

   440  

   441  

   442  

   443  

   444  

   445  

   446 

   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!

   454 Ben');

   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

   460 

   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.

   463 

   464 Sue Mara

   465 Enron Corp.

   466 Tel: (415) 782-7802

   467 Fax:(415) 782-7854

   468 ----- Forwarded by Susan J Mara/NA/Enron on 06/08/2001 12:24 PM -----

   469 

   470 

   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	

   472 

   473 

   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

   479 doing?

   480 

   481 Marcie

   482 

   483 http://www.caiso.com/docs/2001/06/08/200106081005526469.pdf 

   484 ');

   485 INSERT INTO email([from],[to],subject,body) VALUES('fletcher.sturm@enron.com', 'eloy.escobar@enron.com', 'Re: General Brinks Position Meeting', 'Eloy,

   486 

   487 Who is General Brinks?

   488 

   489 Fletch');

   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,

   491 

   492 Here are the documents that Peter has prepared for Mark Frevert. 

   493 

   494 Nailia

   495 ---------------------- Forwarded by Nailia Dindarova/LON/ECT on 25/06/2001 

   496 16:36 ---------------------------

   497 

   498 

   499 Nailia Dindarova

   500 25/06/2001 15:36

   501 To: Michael Brown/Enron@EUEnronXGate

   502 cc: Ross Sankey/Enron@EUEnronXGate, Eric Shaw/ENRON@EUEnronXGate, Peter 

   503 Styles/LON/ECT@ECT 

   504 

   505 Subject: Documents for Mark Frevert (on EU developments and lessons from 

   506 California)

   507 

   508 Michael,

   509 

   510 

   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.

   514 

   515 Nailia

   516 

   517 

   518 

   519 

   520 

   521 ');

   522 INSERT INTO email([from],[to],subject,body) VALUES('peggy.a.kostial@accenture.com', 'dave.samuels@enron.com', 'EOL-Accenture Deal Sheet', 'Dave -

   523 

   524 Attached are our comments and suggested changes. Please call to review.

   525 

   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

   530      of intent

   531      Review Enron asset base for potential reuse/ licensing

   532      Contract negotiations

   533 

   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.

   538 

   539 We will send our cut at the actual time line here shortly. Thanks,

   540 

   541 Peggy

   542 

   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 ---------------------------

   547 

   548 

   549 Thomas A Martin

   550 10/11/2000 03:55 PM

   551 To: Patrick Wade/HOU/ECT@ECT

   552 cc:  

   553 Subject: Re: Guadalupe Power Partners LP  

   554 

   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 

   557 NYMEX  close.

   558 

   559 ');

   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 ---------------------------

   562 

   563 

   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

   570 

   571 

   572 Attached is Columbia Distribution''s notice of capacity available for release

   573 for

   574 the summer of 2001 (Apr. 2001 through Oct. 2001).

   575 

   576 Please note that the deadline for bids is 3:00pm EST on March 20, 2001.

   577 

   578 If you have any questions, feel free to contact any of the representatives

   579 listed

   580 at the bottom of the attachment.

   581 

   582 Aaron Goddard

   583 

   584 

   585 

   586 

   587  - 2001Summer.doc

   588 ');

   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

   594 

   595 the kid');

   596 INSERT INTO email([from],[to],subject,body) VALUES('cooper.richey@enron.com', 'trycooper@hotmail.com', 'FW: Contact Info', '

   597 

   598 -----Original Message-----

   599 From: Punja, Karim 

   600 Sent: Thursday, December 13, 2001 2:35 PM

   601 To: Richey, Cooper

   602 Subject: Contact Info

   603 

   604 

   605 Cooper,

   606 

   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.

   609 

   610 Home# 234-0249

   611 email: kpunja@hotmail.com

   612 

   613 Take Care, 

   614 

   615 Karim.

   616   ');

   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.

   618 

   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:

   621 

   622     bjm30@earthlink.net

   623 

   624 I hope all is well.

   625 

   626 Brian McGuinn');

   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.

   628 

   629 Shelley');

   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

   631 

   632 San Antonio, Texas    May 2-4, 2001    Westin Riverwalk

   633 

   634                    See attached memo for more details!!

   635 

   636 

   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.  

   641 

   642 ? We will send you another e-mail to confirm when the Law Conference Website 

   643 is operational. 

   644 

   645 ? Please complete the Online RSVP Form as soon as it is available  and submit 

   646 it no later than Friday, March 30th.  

   647 

   648 

   649 

   650 

   651 ');

   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,

   657 

   658 I''ll get it done today.  

   659 

   660 DG    3-9573

   661 

   662 

   663    

   664 	

   665 	

   666 	From:  Bryce Baxter                           06/12/2000 07:15 PM

   667 	

   668 

   669 To: Darron C Giron/HOU/ECT@ECT

   670 cc:  

   671 Subject: Feedback for Audrey Cook

   672 

   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.

   676 

   677 ');

   678 INSERT INTO email([from],[to],subject,body) VALUES('casey.evans@enron.com', 'stephanie.sever@enron.com', 'Gas EOL ID', 'Stephanie,

   679 

   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:

   681 

   682 PWR-NG-LT-SPP:  Mike Carson

   683 PWR-NG-LT-SERC:  Jeff King

   684 

   685 If you need to know their power desk to map their ID to their gas books, those desks are as follows:

   686 

   687 EPMI-LT-SPP:  Mike Carson

   688 EPMI-LT-SERC:  Jeff King

   689 

   690 I will be in training this afternoon, but will be back when class is over.  Let me know if you have any questions.

   691 

   692 Thanks for your help!

   693 Casey');

   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.

   695 

   696 

   697 ds

   698 

   699 

   700   

   701 

   702  ');

   703 INSERT INTO email([from],[to],subject,body) VALUES('mcominsky@aol.com', 'cpatman@bracepatt.com, james_derrick@enron.com', 'Jurisprudence Luncheon', 'Carrin & Jim --

   704 

   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.

   707 

   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.

   712 

   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.

   715 

   716 Thanks again for your interest in the ADL''s work.  Martin.

   717 

   718 Martin B. Cominsky

   719 Director, Southwest Region

   720 Anti-Defamation League

   721 713/627-3490, ext. 122

   722 713/627-2011 (fax)

   723 MCominsky@aol.com');

   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.

   727 PL');

   728 INSERT INTO email([from],[to],subject,body) VALUES('marie.heard@enron.com', 'ehamilton@fna.com', 'ISDA Master Agreement', 'Erin:

   729 

   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.

   731 

   732 Marie

   733 

   734 Marie Heard

   735 Senior Legal Specialist

   736 Enron North America Corp.

   737 Phone:  (713) 853-3907

   738 Fax:  (713) 646-3490

   739 marie.heard@enron.com

   740 

   741 				 ');

   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.

   743 

   744            

   745 

   746                                                                      ');

   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.

   749 

   750 Thank you,

   751 Karolyn Criado

   752 3-9441

   753 

   754 

   755  

   756 

   757 ');

   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.

   759 

   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.

   761 

   762 We also need to continue to explore a JEA buy-out.

   763 

   764 Thanks.');

   765 INSERT INTO email([from],[to],subject,body) VALUES('stacy.dickson@enron.com', 'gregg.penman@enron.com', 'RE: Constellation TC 5-7-01', 'Gregg, 

   766 

   767 I am at home with a sick baby.  (Lots of fun!)  I will call you about this 

   768 tomorrow.

   769 

   770 Stacy');

   771 INSERT INTO email([from],[to],subject,body) VALUES('joe.quenet@enron.com', 'dfincher@utilicorp.com', '', 'hey big guy.....check this out.....

   772 

   773  w ww.gorelieberman-2000.com/');

   774 INSERT INTO email([from],[to],subject,body) VALUES('k..allen@enron.com', 'jacqestc@aol.com', '', 'Jacques,

   775 

   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.  

   778 

   779 Please email to confirm that their changes are ok so I can set up a meeting on Tuesday to reach closure.

   780 

   781 Phillip');

   782 INSERT INTO email([from],[to],subject,body) VALUES('kourtney.nelson@enron.com', 'mike.swerzbin@enron.com', 'Adjusted L/R Balance', 'Mike,

   783 

   784 I placed the adjusted L/R Balance on the Enronwest site.  It is under the "Staff/Kourtney Nelson".  There are two links:  

   785 

   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.  

   789 

   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.

   791 

   792 Please let me know if you have any questions or feedback,

   793 

   794 Kourtney

   795 

   796 

   797 

   798 Kourtney Nelson

   799 Fundamental Analysis 

   800 Enron North America

   801 (503) 464-8280

   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', '

   804 

   805 -----Original Message-----

   806 From: Grace, Rebecca M. 

   807 Sent: Monday, December 17, 2001 9:44 AM

   808 To: Thomas, Paul D.

   809 Cc: Cashion, Jim; Allen, Thresa A.; May, Tom

   810 Subject: RE: Current Enron TCC Portfolio

   811 

   812 

   813 Paul,

   814 

   815 I reviewed NY''s list.  I agree with all of their contracts numbers and mw amounts.

   816 

   817 Call if you have any more questions.

   818 

   819 Rebecca

   820 

   821 

   822 

   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

   828 

   829  << File: enrontccs.xls >> 

   830 Rebecca,

   831 Let me know if you see any differences.

   832 

   833 Paul

   834 X 3-0403

   835 -----Original Message-----

   836 From: Thomas, Paul D. 

   837 Sent: Monday, December 17, 2001 9:04 AM

   838 To: Ahmed, Naveed

   839 Subject: FW: Current Enron TCC Portfolio

   840 

   841 

   842 

   843 

   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

   849 

   850 

   851 ');

   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.

   857 

   858 Thanks,

   859 Stephanie

   860 ');

   861 INSERT INTO email([from],[to],subject,body) VALUES('kam.keiser@enron.com', 'c..kenne@enron.com', 'RE: What about this too???', ' 

   862 

   863  -----Original Message-----

   864 From: 	Kenne, Dawn C.  

   865 Sent:	Wednesday, February 06, 2002 11:50 AM

   866 To:	Keiser, Kam

   867 Subject:	What about this too???

   868 

   869 

   870  << File: Netco Trader Matrix.xls >> 

   871  ');

   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.

   873 

   874 Thanks

   875 

   876 chris

   877 x31666');

   878 INSERT INTO email([from],[to],subject,body) VALUES('debra.perlingiere@enron.com', 'jworman@academyofhealth.com', '', 'Have a great weekend!   Happy Fathers Day!

   879 

   880 

   881 Debra Perlingiere

   882 Enron North America Corp.

   883 1400 Smith Street, EB 3885

   884 Houston, Texas 77002

   885 dperlin@enron.com

   886 Phone 713-853-7658

   887 Fax  713-646-3490');

   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

   889 

   890 Description:

   891 	Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia  & Dir Rpts. - 4102

   892 

   893 Date:		1/5/2001

   894 Time:		9:00 AM - 10:00 AM (Central Standard Time)

   895 

   896 Chairperson:	Outlook Migration Team

   897 

   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,

   900 

   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.

   904 

   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.

   908 Thanks !

   909 

   910 

   911 Best regards

   912 

   913 Diana Seifert

   914 EOL PCG');

   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:

   916 

   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

   922 Amount Paid: $0.00

   923 Approval Status: Approved

   924 Payment Status: Pending

   925 

   926 

   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:

   930 

   931 Australia:

   932 1800 678-515

   933 support@palm-au.com

   934 

   935 Canada:

   936 1905 305-6530

   937 support@palm.com

   938 

   939 New Zealand:

   940 0800 446-398

   941 support@palm-nz.com

   942 

   943 U.K.:

   944 0171 867 0108

   945 eurosupport@palm.3com.com

   946 

   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?

   949 

   950  -----Original Message-----

   951 From: 	Quigley, Dutch  

   952 Sent:	Wednesday, October 31, 2001 10:14 AM

   953 To:	Storey, Geoff

   954 Subject:	RE: 

   955 

   956 bp corp	Albert LaMore	281-366-4962

   957 

   958 running the reports now

   959 

   960 

   961  -----Original Message-----

   962 From: 	Storey, Geoff  

   963 Sent:	Wednesday, October 31, 2001 10:10 AM

   964 To:	Quigley, Dutch

   965 Subject:	RE: 

   966 

   967 give me a contact over there too

   968 BP

   969 

   970 

   971  -----Original Message-----

   972 From: 	Quigley, Dutch  

   973 Sent:	Wednesday, October 31, 2001 9:42 AM

   974 To:	Storey, Geoff

   975 Subject:	

   976 

   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.  

   980 Variances detected.

   981 Variances detected in Load schedule.

   982 

   983     LOG MESSAGES:

   984 

   985 PARSING FILE -->> O:\Portland\WestDesk\California Scheduling\ISO Final 

   986 Schedules\2001042203.txt

   987 

   988 ---- Load Schedule ----

   989 $$$ Variance found in table tblLoads.

   990      Details: (Hour: 3 / Preferred:   1.92 / Final:   1.89)

   991   TRANS_TYPE: FINAL

   992   LOAD_ID: PGE4

   993   MKT_TYPE: 2

   994   TRANS_DATE: 4/22/01

   995   SC_ID: EPMI

   996 

   997 ');

   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. 

   999 

  1000 John');

  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:

  1007 

  1008 Richard McDougall

  1009 Solaris 8

  1010 Thursday, June 7, 2001

  1011 

  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.

  1013 

  1014 *Remember: this is now a Brown Bag Event--so bring your lunch and we will provide cookies and drinks.

  1015 

  1016 Click below for more details.

  1017 

  1018 http://home.enron.com:84/messaging/litebytztoolzprint.jpg');

  1019     COMMIT;

  1020   }

  1021 } {}

  1022 

  1023 ###############################################################################

  1024 # Everything above just builds an interesting test database.  The actual

  1025 # tests come after this comment.

  1026 ###############################################################################

  1027 

  1028 do_test fts1c-1.2 {

  1029   execsql {

  1030     SELECT rowid FROM email WHERE email MATCH 'mark'

  1031   }

  1032 } {6 17 25 38 40 42 73 74}

  1033 do_test fts1c-1.3 {

  1034   execsql {

  1035     SELECT rowid FROM email WHERE email MATCH 'susan'

  1036   }

  1037 } {24 40}

  1038 do_test fts1c-1.4 {

  1039   execsql {

  1040     SELECT rowid FROM email WHERE email MATCH 'mark susan'

  1041   }

  1042 } {40}

  1043 do_test fts1c-1.5 {

  1044   execsql {

  1045     SELECT rowid FROM email WHERE email MATCH 'susan mark'

  1046   }

  1047 } {40}

  1048 do_test fts1c-1.6 {

  1049   execsql {

  1050     SELECT rowid FROM email WHERE email MATCH '"mark susan"'

  1051   }

  1052 } {}

  1053 do_test fts1c-1.7 {

  1054   execsql {

  1055     SELECT rowid FROM email WHERE email MATCH 'mark -susan'

  1056   }

  1057 } {6 17 25 38 42 73 74}

  1058 do_test fts1c-1.8 {

  1059   execsql {

  1060     SELECT rowid FROM email WHERE email MATCH '-mark susan'

  1061   }

  1062 } {24}

  1063 do_test fts1c-1.9 {

  1064   execsql {

  1065     SELECT rowid FROM email WHERE email MATCH 'mark OR susan'

  1066   }

  1067 } {6 17 24 25 38 40 42 73 74}

  1068 

  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.

  1072 #

  1073 do_test fts1c-2.1 {

  1074   execsql {

  1075     SELECT rowid, offsets(email) FROM email

  1076      WHERE email MATCH 'gas reminder'

  1077   }

  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}}

  1079 do_test fts1c-2.2 {

  1080   execsql {

  1081     SELECT rowid, offsets(email) FROM email

  1082      WHERE email MATCH 'subject:gas reminder'

  1083   }

  1084 } {20 {2 0 42 3 2 1 54 8 3 1 54 8}}

  1085 do_test fts1c-2.3 {

  1086   execsql {

  1087     SELECT rowid, offsets(email) FROM email

  1088      WHERE email MATCH 'body:gas reminder'

  1089   }

  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}}

  1091 do_test fts1c-2.4 {

  1092   execsql {

  1093     SELECT rowid, offsets(email) FROM email

  1094      WHERE subject MATCH 'gas reminder'

  1095   }

  1096 } {20 {2 0 42 3 2 1 54 8}}

  1097 do_test fts1c-2.5 {

  1098   execsql {

  1099     SELECT rowid, offsets(email) FROM email

  1100      WHERE body MATCH 'gas reminder'

  1101   }

  1102 } {20 {3 0 42 3 3 1 54 8 3 0 129 3 3 0 143 3 3 0 240 3}}

  1103 

  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.

  1107 #

  1108 do_test fts1c-3.1 {

  1109   execsql {

  1110     SELECT rowid, offsets(email) FROM email

  1111      WHERE body MATCH 'child product' AND +rowid=32

  1112   }

  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}}

  1114 do_test fts1c-3.2 {

  1115   execsql {

  1116     SELECT rowid, offsets(email) FROM email

  1117      WHERE body MATCH '"child product"'

  1118   }

  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}}

  1120 

  1121 # Snippet generator tests

  1122 #

  1123 do_test fts1c-4.1 {

  1124   execsql {

  1125     SELECT snippet(email) FROM email

  1126      WHERE email MATCH 'subject:gas reminder'

  1127   }

  1128 } {{Alert Posted 10:00 AM November 20,2000: E-<b>GAS</b> Request <b>Reminder</b>}}

  1129 do_test fts1c-4.2 {

  1130   execsql {

  1131     SELECT snippet(email) FROM email

  1132      WHERE email MATCH 'christmas candlelight'

  1133   }

  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.,