# 2006 September 14

#

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

# a legal notice, here is a blessing:

#

#    May you do good and not evil.

#    May you find forgiveness for yourself and forgive others.

#    May you share freely, never taking more than you give.

#

#*************************************************************************

# This file implements regression tests for SQLite library.  The

# focus of this script is testing the FTS2 module.

#

# $Id: fts2c.test,v 1.1 2006/10/19 23:36:26 shess Exp $

#

set testdir [file dirname $argv0]

source $testdir/tester.tcl

# If SQLITE_ENABLE_FTS2 is defined, omit this file.

ifcapable !fts2 {

  finish_test

  return

}

# Create a table of sample email data.   The data comes from email

# archives of Enron executives that was published as part of the

# litigation against that company.

#

do_test fts2c-1.1 {

  db eval {

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

    BEGIN TRANSACTION;

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.

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

?	If the transaction volume on the child is less than half of the parent''s minimum volume no hedge will occur.

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

?	For all other volumes, the same rounding rules will apply based on the volume increment on the parent product.

Please see example below:

Parent''s Settings:

Minimum: 	5000

Increment:  1000

Volume on Autohedge transaction			Volume Hedged

1      - 2499							0

2500 - 5499							5000

5500 - 6499							6000');

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:  

If it''s ok with everyone''s needs, I would like to leave @4pm. If you think 

you will need my assistance past the 4 o''clock hour just let me know;  I''ll 

be more than willing to stay.');

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:

Employee Name: Christopher F. Calger

Status last changed by: Mollie E. Gustafson Ms

Expense Report Name: CC02.06.02

Report Total: $3,972.93

Amount Due Employee: $3,972.93

To approve this expense report, click on the following link for Concur Expense.

http://expensexms.enron.com');

INSERT INTO email([from],[to],subject,body) VALUES('jeff.duff@enron.com', 'julie.johnson@enron.com', 'Work request', 'Julie,

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

Gentlemen,

I''d like to review this today at 1:30 in our office.  Also, could you provide 

me with your activity reports so I can have Julie enter this information.

JD');

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

http://biz.yahoo.com/rf/010129/n29305829.html');

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');

INSERT INTO email([from],[to],subject,body) VALUES('e..carter@enron.com', 't..robinson@enron.com', 'FW: Producers Newsletter 9-24-2001', '

The producer lumber pricing sheet.

 -----Original Message-----

From: 	Johnson, Jay  

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

To:	Carter, Karen E.

Subject:	FW: Producers Newsletter 9-24-2001

 -----Original Message-----

From: 	Daigre, Sergai  

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

Subject:	Producers Newsletter 9-24-2001

 ');

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 

be to offer up the Falcon for their use; however, given the tight time frame 

and your recent visit with Mr. Fox that it would be difficult for either you 

or me to participate.

I spoke to Max and he agrees with this approach.

I hope this meets with your approval.

Regards

Delainey');

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

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

Your cooperation is greatly appreciated.

Thanks,

lachandra.fenceroy@enron.com

713.853.3884

877.498.3401 Pager

 -----Original Message-----

From: 	Bisbee, Joanne  

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

To:	Fenceroy, LaChandra

Subject:	FW: Bus Applications Meeting Follow Up

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

 -----Original Message-----

From: 	Koh, Wendy  

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

To:	Bisbee, Joanne

Subject:	Bus Applications Meeting Follow Up

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.

Wendy');

INSERT INTO email([from],[to],subject,body) VALUES('danny.mccarty@enron.com', 'fran.fagan@enron.com', 'RE: worksheets', 'Fran,

    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.

Dan

 -----Original Message-----

From: 	Fagan, Fran  

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

To:	McCarty, Danny

Subject:	worksheets

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

Thanks,

Fran Fagan

Sr. HR Rep

713.853.5219

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

');

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

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.

BERT');

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.');

INSERT INTO email([from],[to],subject,body) VALUES('patrice.mims@enron.com', 'calvin.eakins@enron.com', 'Re: Small business supply assistance', 'Hi Calvin

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

credit guy, Russell Diamond.

Thank for your help!');

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.');

INSERT INTO email([from],[to],subject,body) VALUES('d..steffes@enron.com', 'richard.shapiro@enron.com', 'EES / ENA Government Affairs Staffing & Outside Services', 'Rick --

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

Jim

 ');

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, 

Attached you will find an excel document. The outages contained within are forced or rescheduled outages. Your daily delivery will still contain these outages. 

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. 

Greg Elliott 

IIR, Inc. 

713-783-5147 x 3481 

outages@industrialinfo.com 

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 

E-MAIL IN ERROR, PLEASE DELETE IT.

 - OUTAGE.dbf 

 - 111201R.xls 

 - 111201.xls ');

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 !

You are invited to attend the EWS Brown Bag Lunch Series

Featuring:   RAY BOWEN, COO

Topic:  Enron Industrial Markets

Thursday, March 15, 2001

11:30 am - 12:30 pm

EB 5 C2

You bring your lunch,           Limited Seating

We provide drinks and dessert.          RSVP  x 3-9610');

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.

"Immer, Ingrid" <Ingrid.Immer@Williams.com> on 12/21/2000 11:48:47 AM

To: "''chris.germany@enron.com''" <chris.germany@enron.com>

cc:  

Subject: About St Pauls

 <<About St Pauls.url>>  

? 

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

Chris, 

I like the looks of this place.? What do you think about going here Christmas 

eve?? They have an 11:00 a.m. service and a candlelight service at 5:00 p.m., 

among others.

Let me know.?? ii 

 - About St Pauls.url

');

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');

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

As discussed in the Winter Operations Meeting on Sept.29,2000, 

E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC.  

Marketers and Poolers can receive gas via Peaking and IBSS nominations(daisy 

chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle.

');

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

Here is a goody for you');

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.');

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

LS HPL LSK IC       30.000 / Enron

');

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

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

Susan Pereira');

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.

 ');

INSERT INTO email([from],[to],subject,body) VALUES('m..forney@enron.com', 'george.phillips@enron.com', '', 'George,

Give me a call and we will further discuss opportunities on the 13st floor.

Thanks,

JMForney

3-7160');

INSERT INTO email([from],[to],subject,body) VALUES('brad.mckay@enron.com', 'angusmcka@aol.com', 'Re: (no subject)', 'not yet');

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.

adam

35227

 -----Original Message-----

From: 	Royed, Jeff  

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

To:	Bayer, Adam

Subject:	Curve Fetch File

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

Jeff Royed

Enron 

Energy Operations

Phone: 713-853-5295');

INSERT INTO email([from],[to],subject,body) VALUES('matt.smith@enron.com', 'yan.wang@enron.com', 'Report Formats', 'Yan,

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

"unmerge" the following six reports:  

31 Keystone Receipts

15 Questar Pipeline

40 Rockies Production

22 West_2

23 West_3

25 CIG_WIC

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

Mat

PS.  Just a reminder to add the "*" by the title of calculated points.');

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 

10:08 AM ---------------------------

"Karkour, Randa" <Randa.Karkour@COMPAQ.com> on 09/07/2000 09:01:04 AM

To: "''Agheb (E-mail)" <Agheb@aol.com>, "Leila Mankarious (E-mail)" 

<Leila_Mankarious@mhhs.org>, "''Marymankarious (E-mail)" 

<marymankarious@aol.com>, "Michelle lokay (E-mail)" <mlokay@enron.com>, "Ramy 

Mankarious (E-mail)" <Mankarious@aol.com>

cc:  

Subject: Egyptian Festival

 <<Egyptian Festival.url>>

 http://www.egyptianfestival.com/

 - Egyptian Festival.url

');

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

Thanks

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

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

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

To: Kam Keiser/HOU/ECT@ECT, Darron C Giron/HOU/ECT@ECT, David 

Baumbach/HOU/ECT@ECT, Errol McLaughlin/Corp/Enron@ENRON

cc: Kimat Singla/HOU/ECT@ECT, Kulvinder Fowler/NA/Enron@ENRON, Kyle R 

Lilly/HOU/ECT@ECT, Jeff Royed/Corp/Enron@ENRON, Alejandra 

Chavez/NA/Enron@ENRON, Crystal Hyde/HOU/ECT@ECT 

Subject: New EAST books

We have new book names in TAGG for our intramonth portfolios and it is 

extremely important that any deal booked to the East is communicated quickly 

to someone on my team.  I know it will take some time for the new names to 

sink in and I do not want us to miss any positions or P&L.  

Thanks for your help on this.

New:

Scott Neal :         East Northeast

Dick Jenkins:     East Marketeast

WK 

');

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 

affect any Inactive Child.

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

calculated prices updated until the Child product is Activated.

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

updated BEFORE it is displayed on the web.

This means that if you are inputting a basis price on a Child product, you 

will not see the final, calculated price until you Activate the product, at 

which time the customer will also see it.

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

Americas: 713 853 4357

Europe: + 44 (0) 20 7783 7783

Asia/Australia: +61 2 9229 2300

Dave');

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,

I saw it. Very interesting.

Vince

"John H Herbert" <jhh1@email.msn.com> on 07/28/2000 08:38:08 AM

To: "Vince J Kaminski" <Vince_J_Kaminski@enron.com>

cc:  

Subject: Light reading - see pieces beginning on page 7

Cheers and have a nice weekend,

JHHerbert

 - gd000728.pdf

');

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 ');

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.

Thanks for your understanding in this matter.

T.Jae Black

East Power Trading

Assistant to Kevin Presto

off. 713-853-5800

fax 713-646-8272

cell 713-539-4760');

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

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

product out ASAP.

Thanks,

Eric');

INSERT INTO email([from],[to],subject,body) VALUES('messenger@smartreminders.com', 'm..tholt@enron.com', '10% Coupon - PrintPal Printer Cartridges - 100% Guaranteed', '[IMAGE]

[IMAGE][IMAGE][IMAGE] 

Dear  SmartReminders Member,

       [IMAGE]         [IMAGE]        [IMAGE]     [IMAGE]    [IMAGE]    [IMAGE]        [IMAGE]      [IMAGE]     	

We respect  your privacy and are a Certified Participant of the BBBOnLine

 Privacy Program.  To be removed from future offers,click  here. 

SmartReminders.com  is a permission based service. To unsubscribe click  here .  ');

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 

speak.  He was the one who got into several bad deals and PPA''s in California 

for CIN, thus he left on a bad note.  Let me know if you need more detail 

than that, I felt this was the type of info you were looking for.  Thanks!

Ben');

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

Report Name:   Houston Cellular 8-11-01

Report Date:   12/13/01

Report ID:     594D37C9ED2111D5B452

Submitted On:  12/13/01

You are only allowed 2 reports with receipts outstanding.  Your expense reports will not be paid until you meet this requirement.');

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.

Sue Mara

Enron Corp.

Tel: (415) 782-7802

Fax:(415) 782-7854

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

	"Milner, Marcie" <MMilner@coral-energy.com> 06/08/2001 11:13 AM 	   To: "''smara@enron.com''" <smara@enron.com>  cc:   Subject: CAISO Emergency Motion	

Sue, did you see this emergency motion the CAISO filed today?  Apparently

they are requesting that FERC discontinue market-based rates immediately and

grant refunds plus interest on the difference between cost-based rates and

market revenues received back to May 2000.  They are requesting the

commission act within 14 days.  Have you heard anything about what they are

doing?

Marcie

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

');

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

Who is General Brinks?

Fletch');

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,

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

Nailia

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

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

Nailia Dindarova

25/06/2001 15:36

To: Michael Brown/Enron@EUEnronXGate

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

Styles/LON/ECT@ECT 

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

California)

Michael,

These are the documents that Peter promised to give to you for Mark Frevert. 

He has now handed them to him in person but asked me to transmit them 

electronically to you, as well as Eric and Ross.

Nailia

');

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

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

On the time line for completion, we have four critical steps to complete:

     Finalize market analysis to refine business case, specifically

     projected revenue stream