AryaWu/sqlite
0
1# 2006 September 142#3# The author disclaims copyright to this source code. In place of4# 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. The12# focus of this script is testing the FTS3 module.13#14# $Id: fts3ac.test,v 1.1 2007/08/20 17:38:42 shess Exp $15#16 17set testdir [file dirname $argv0]18source $testdir/tester.tcl19 20# If SQLITE_ENABLE_FTS3 is defined, omit this file.21ifcapable !fts3 {22 finish_test23 return24}25 26# Create a table of sample email data. The data comes from email27# archives of Enron executives that was published as part of the28# litigation against that company.29#30do_test fts3ac-1.1 {31 db eval {32 CREATE VIRTUAL TABLE email USING fts3([from],[to],subject,body);33 BEGIN TRANSACTION;34INSERT 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 36The 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 42Please see example below:43 44Parent''s Settings:45Minimum: 500046Increment: 100047 48Volume on Autohedge transaction Volume Hedged491 - 2499 0502500 - 5499 5000515500 - 6499 6000');52INSERT 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: 53If it''s ok with everyone''s needs, I would like to leave @4pm. If you think 54you will need my assistance past the 4 o''clock hour just let me know; I''ll 55be more than willing to stay.');56INSERT 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 58Employee Name: Christopher F. Calger59Status last changed by: Mollie E. Gustafson Ms60Expense Report Name: CC02.06.0261Report Total: $3,972.9362Amount Due Employee: $3,972.9363 64 65To approve this expense report, click on the following link for Concur Expense.66http://expensexms.enron.com');67INSERT INTO email([from],[to],subject,body) VALUES('jeff.duff@enron.com', 'julie.johnson@enron.com', 'Work request', 'Julie,68 69Could you print off the current work request report by 1:30 today?70 71Gentlemen,72 73I''d like to review this today at 1:30 in our office. Also, could you provide 74me with your activity reports so I can have Julie enter this information.75 76JD');77INSERT 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.... 78http://biz.yahoo.com/rf/010129/n29305829.html');79INSERT 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');80INSERT INTO email([from],[to],subject,body) VALUES('e..carter@enron.com', 't..robinson@enron.com', 'FW: Producers Newsletter 9-24-2001', '81The producer lumber pricing sheet.82 -----Original Message-----83From: Johnson, Jay 84Sent: Tuesday, October 16, 2001 3:42 PM85To: Carter, Karen E.86Subject: FW: Producers Newsletter 9-24-200187 88 89 90 -----Original Message-----91From: Daigre, Sergai 92Sent: Friday, September 21, 2001 8:33 PM93Subject: Producers Newsletter 9-24-200194 95 ');96INSERT 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 97be to offer up the Falcon for their use; however, given the tight time frame 98and your recent visit with Mr. Fox that it would be difficult for either you 99or me to participate.100 101I spoke to Max and he agrees with this approach.102 103I hope this meets with your approval.104 105Regards106Delainey');107INSERT INTO email([from],[to],subject,body) VALUES('lachandra.fenceroy@enron.com', 'lindy.donoho@enron.com', 'FW: Bus Applications Meeting Follow Up', 'Lindy,108 109Here is the original memo we discussed earlier. Please provide any information that you may have.110 111Your cooperation is greatly appreciated.112 113Thanks,114 115lachandra.fenceroy@enron.com116713.853.3884117877.498.3401 Pager118 119 -----Original Message-----120From: Bisbee, Joanne 121Sent: Wednesday, September 26, 2001 7:50 AM122To: Fenceroy, LaChandra123Subject: FW: Bus Applications Meeting Follow Up124 125Lachandra, Please get with David Duff today and see what this is about. Who are our TW accounting business users?126 127 -----Original Message-----128From: Koh, Wendy 129Sent: Tuesday, September 25, 2001 2:41 PM130To: Bisbee, Joanne131Subject: Bus Applications Meeting Follow Up132 133Lisa 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 135Wendy');136INSERT 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.138Dan139 140 -----Original Message-----141From: Fagan, Fran 142Sent: Thursday, December 20, 2001 11:10 AM143To: McCarty, Danny144Subject: worksheets145 146As discussed, attached are your sheets for bonus and merit.147 148Thanks,149 150Fran Fagan151Sr. HR Rep152713.853.5219153 154 155 << File: McCartyMerit.xls >> << File: mccartyBonusCommercial_UnP.xls >> 156 157');158INSERT INTO email([from],[to],subject,body) VALUES('bert.meyers@enron.com', 'shift.dl-portland@enron.com', 'OCTOBER SCHEDULE', 'TEAM,159 160PLEASE 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 162BERT');163INSERT INTO email([from],[to],subject,body) VALUES('errol.mclaughlin@enron.com', 'john.arnold@enron.com, bilal.bajwa@enron.com, john.griffith@enron.com,', 'TRV Notification: (NG - PROPT P/L - 09/27/2001)', 'The report named: NG - PROPT P/L <http://trv.corp.enron.com/linkFromExcel.asp?report_cd=11&report_name=NG+-+PROPT+P/L&category_cd=5&category_name=FINANCIAL&toc_hide=1&sTV1=5&TV1Exp=Y¤t_efct_date=09/27/2001>, published as of 09/27/2001 is now available for viewing on the website.');164INSERT INTO email([from],[to],subject,body) VALUES('patrice.mims@enron.com', 'calvin.eakins@enron.com', 'Re: Small business supply assistance', 'Hi Calvin165 166 167I spoke with Rickey (boy, is he long-winded!!). Gave him the name of our 168credit guy, Russell Diamond.169 170Thank for your help!');171INSERT 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.');172INSERT INTO email([from],[to],subject,body) VALUES('d..steffes@enron.com', 'richard.shapiro@enron.com', 'EES / ENA Government Affairs Staffing & Outside Services', 'Rick --173 174Here is the information on staffing and outside services. Call if you need anything else.175 176Jim177 178 ');179INSERT 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, 180Attached you will find an excel document. The outages contained within are forced or rescheduled outages. Your daily delivery will still contain these outages. 181In 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. 182Greg Elliott 183IIR, Inc. 184713-783-5147 x 3481 185outages@industrialinfo.com 186THE 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 187E-MAIL IN ERROR, PLEASE DELETE IT.188 - OUTAGE.dbf 189 - 111201R.xls 190 - 111201.xls ');191INSERT 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 193You are invited to attend the EWS Brown Bag Lunch Series194 195Featuring: RAY BOWEN, COO196 197Topic: Enron Industrial Markets198 199Thursday, March 15, 200120011:30 am - 12:30 pm201EB 5 C2202 203 204You bring your lunch, Limited Seating205We provide drinks and dessert. RSVP x 3-9610');206INSERT 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 AM212To: "''chris.germany@enron.com''" <chris.germany@enron.com>213cc: 214Subject: About St Pauls215 216 217 218 219 <<About St Pauls.url>> 220? 221?http://www.stpaulshouston.org/about.html 222 223Chris, 224 225I like the looks of this place.? What do you think about going here Christmas 226eve?? They have an 11:00 a.m. service and a candlelight service at 5:00 p.m., 227among others.228 229Let me know.?? ii 230 231 - About St Pauls.url232 233');234INSERT 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');235INSERT 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 Reminder236As discussed in the Winter Operations Meeting on Sept.29,2000, 237E-Gas(Emergency Gas) will not be offered this winter as a service from AGLC. 238Marketers and Poolers can receive gas via Peaking and IBSS nominations(daisy 239chain) from other marketers up to the 6 p.m. Same Day 2 nomination cycle.240');241INSERT INTO email([from],[to],subject,body) VALUES('dutch.quigley@enron.com', 'rwolkwitz@powermerchants.com', '', ' 242 243Here is a goody for you');244INSERT INTO email([from],[to],subject,body) VALUES('ryan.o''rourke@enron.com', 'k..allen@enron.com, randy.bhatia@enron.com, frank.ermis@enron.com,', 'TRV Notification: (West VaR - 11/07/2001)', 'The report named: West VaR <http://trv.corp.enron.com/linkFromExcel.asp?report_cd=36&report_name=West+VaR&category_cd=2&category_name=WEST&toc_hide=1&sTV1=2&TV1Exp=Y¤t_efct_date=11/07/2001>, published as of 11/07/2001 is now available for viewing on the website.');245INSERT 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 IFERC246 247LS HPL LSK IC 30.000 / Enron248');249INSERT INTO email([from],[to],subject,body) VALUES('susan.pereira@enron.com', 'kkw816@aol.com', 'soccer practice', 'Kathy-250 251Is it safe to assume that practice is cancelled for tonight??252 253Susan Pereira');254INSERT 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 ');257INSERT INTO email([from],[to],subject,body) VALUES('m..forney@enron.com', 'george.phillips@enron.com', '', 'George,258Give me a call and we will further discuss opportunities on the 13st floor.259 260Thanks,261JMForney2623-7160');263INSERT INTO email([from],[to],subject,body) VALUES('brad.mckay@enron.com', 'angusmcka@aol.com', 'Re: (no subject)', 'not yet');264INSERT 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 266adam26735227268 269 270 -----Original Message-----271From: Royed, Jeff 272Sent: Tuesday, September 25, 2001 11:37 AM273To: Bayer, Adam274Subject: Curve Fetch File275 276Let me know if it works. It may be required to have a certain version of Oracle for it to work properly.277 278 279 280Jeff Royed281Enron 282Energy Operations283Phone: 713-853-5295');284INSERT INTO email([from],[to],subject,body) VALUES('matt.smith@enron.com', 'yan.wang@enron.com', 'Report Formats', 'Yan,285 286The merged reports look great. I believe the only orientation changes are to 287"unmerge" the following six reports: 288 28931 Keystone Receipts29015 Questar Pipeline29140 Rockies Production29222 West_229323 West_329425 CIG_WIC295 296The orientation of the individual reports should be correct. Thanks.297 298Mat299 300PS. Just a reminder to add the "*" by the title of calculated points.');301INSERT 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 30210:08 AM ---------------------------303 304 305"Karkour, Randa" <Randa.Karkour@COMPAQ.com> on 09/07/2000 09:01:04 AM306To: "''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 309Mankarious (E-mail)" <Mankarious@aol.com>310cc: 311 312Subject: Egyptian Festival313 314 315 <<Egyptian Festival.url>>316 317 http://www.egyptianfestival.com/318 319 - Egyptian Festival.url320');321INSERT 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 323Thanks324---------------------- Forwarded by Errol McLaughlin/Corp/Enron on 12/20/2000 32508:39 AM ---------------------------326 327 328 329 From: William Kelly @ ECT 12/20/2000 08:31 AM330 331 332To: Kam Keiser/HOU/ECT@ECT, Darron C Giron/HOU/ECT@ECT, David 333Baumbach/HOU/ECT@ECT, Errol McLaughlin/Corp/Enron@ENRON334cc: Kimat Singla/HOU/ECT@ECT, Kulvinder Fowler/NA/Enron@ENRON, Kyle R 335Lilly/HOU/ECT@ECT, Jeff Royed/Corp/Enron@ENRON, Alejandra 336Chavez/NA/Enron@ENRON, Crystal Hyde/HOU/ECT@ECT 337 338Subject: New EAST books339 340We have new book names in TAGG for our intramonth portfolios and it is 341extremely important that any deal booked to the East is communicated quickly 342to someone on my team. I know it will take some time for the new names to 343sink in and I do not want us to miss any positions or P&L. 344 345Thanks for your help on this.346 347New:348Scott Neal : East Northeast349Dick Jenkins: East Marketeast350 351WK 352');353INSERT 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 354affect any Inactive Child.355 356An inactive Child with links to Parent products will not have their 357calculated prices updated until the Child product is Activated.358 359When the Child Product is activated, the price will be recalculated and 360updated BEFORE it is displayed on the web.361 362This means that if you are inputting a basis price on a Child product, you 363will not see the final, calculated price until you Activate the product, at 364which time the customer will also see it.365 366If you have any questions, please contact the Help Desk on:367 368Americas: 713 853 4357369Europe: + 44 (0) 20 7783 7783370Asia/Australia: +61 2 9229 2300371 372Dave');373INSERT 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 375I saw it. Very interesting.376 377Vince378 379 380 381 382 383"John H Herbert" <jhh1@email.msn.com> on 07/28/2000 08:38:08 AM384To: "Vince J Kaminski" <Vince_J_Kaminski@enron.com>385cc: 386Subject: Light reading - see pieces beginning on page 7387 388 389Cheers and have a nice weekend,390 391 392JHHerbert393 394 395 396 397 - gd000728.pdf398 399 400 401');402INSERT 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 ');403INSERT 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 405Thanks for your understanding in this matter.406 407T.Jae Black408East Power Trading409Assistant to Kevin Presto410off. 713-853-5800411fax 713-646-8272412cell 713-539-4760');413INSERT INTO email([from],[to],subject,body) VALUES('eric.bass@enron.com', 'dale.neuner@enron.com', '5 X 24', 'Dale,414 415Have you heard anything more on the 5 X 24s? We would like to get this 416product out ASAP.417 418 419Thanks,420 421Eric');422INSERT 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] 424Dear 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 447We respect your privacy and are a Certified Participant of the BBBOnLine448 Privacy Program. To be removed from future offers,click here. 449SmartReminders.com is a permission based service. To unsubscribe click here . ');450INSERT 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 451speak. He was the one who got into several bad deals and PPA''s in California 452for CIN, thus he left on a bad note. Let me know if you need more detail 453than that, I felt this was the type of info you were looking for. Thanks!454Ben');455INSERT INTO email([from],[to],subject,body) VALUES('enron_update@concureworkplace.com', 'michelle.cash@enron.com', 'Expense Report Receipts Not Received', 'Employee Name: Michelle Cash456Report Name: Houston Cellular 8-11-01457Report Date: 12/13/01458Report ID: 594D37C9ED2111D5B452459Submitted On: 12/13/01460 461You are only allowed 2 reports with receipts outstanding. Your expense reports will not be paid until you meet this requirement.');462INSERT 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 464Sue Mara465Enron Corp.466Tel: (415) 782-7802467Fax:(415) 782-7854468----- 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 474Sue, did you see this emergency motion the CAISO filed today? Apparently475they are requesting that FERC discontinue market-based rates immediately and476grant refunds plus interest on the difference between cost-based rates and477market revenues received back to May 2000. They are requesting the478commission act within 14 days. Have you heard anything about what they are479doing?480 481Marcie482 483http://www.caiso.com/docs/2001/06/08/200106081005526469.pdf 484');485INSERT INTO email([from],[to],subject,body) VALUES('fletcher.sturm@enron.com', 'eloy.escobar@enron.com', 'Re: General Brinks Position Meeting', 'Eloy,486 487Who is General Brinks?488 489Fletch');490INSERT 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 492Here are the documents that Peter has prepared for Mark Frevert. 493 494Nailia495---------------------- Forwarded by Nailia Dindarova/LON/ECT on 25/06/2001 49616:36 ---------------------------497 498 499Nailia Dindarova50025/06/2001 15:36501To: Michael Brown/Enron@EUEnronXGate502cc: Ross Sankey/Enron@EUEnronXGate, Eric Shaw/ENRON@EUEnronXGate, Peter 503Styles/LON/ECT@ECT 504 505Subject: Documents for Mark Frevert (on EU developments and lessons from 506California)507 508Michael,509 510 511These are the documents that Peter promised to give to you for Mark Frevert. 512He has now handed them to him in person but asked me to transmit them 513electronically to you, as well as Eric and Ross.514 515Nailia516 517 518 519 520 521');522INSERT INTO email([from],[to],subject,body) VALUES('peggy.a.kostial@accenture.com', 'dave.samuels@enron.com', 'EOL-Accenture Deal Sheet', 'Dave -523 524Attached are our comments and suggested changes. Please call to review.525 526On the time line for completion, we have four critical steps to complete:527 Finalize market analysis to refine business case, specifically528 projected revenue stream529 Complete counterparty surveying, including targeting 3 CPs for letters530 of intent531 Review Enron asset base for potential reuse/ licensing532 Contract negotiations533 534Joe will come back to us with an updated time line, but it is my535expectation that we are still on the same schedule (we just begun week536three) with possibly a week or so slippage.....contract negotiations will537probably be the critical path.538 539We will send our cut at the actual time line here shortly. Thanks,540 541Peggy542 543(See attached file: accenture-dealpoints v2.doc)544 - accenture-dealpoints v2.doc ');545INSERT 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 54603:49 PM ---------------------------547 548 549Thomas A Martin55010/11/2000 03:55 PM551To: Patrick Wade/HOU/ECT@ECT552cc: 553Subject: Re: Guadalupe Power Partners LP 554 555The deal is physically served at Oasis Waha or Oasis Katy and is priced at 556either HSC, Waha or Katytailgate GD at buyers option three days prior to 557NYMEX close.558 559');560INSERT 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 561AM ---------------------------562 563 564agoddard@nisource.com on 03/08/2001 09:16:57 AM565To: " - *Koch, Kent" <kkoch@nisource.com>, " - 566*Millar, Debra" <dmillar@nisource.com>, " - *Burke, Lynn" 567<lburke@nisource.com>568cc: " - *Heckathorn, Tom" <theckathorn@nisource.com> 569Subject: Columbia Distribution''s Capacity Available for Release - Sum570 571 572Attached is Columbia Distribution''s notice of capacity available for release573for574the summer of 2001 (Apr. 2001 through Oct. 2001).575 576Please note that the deadline for bids is 3:00pm EST on March 20, 2001.577 578If you have any questions, feel free to contact any of the representatives579listed580at the bottom of the attachment.581 582Aaron Goddard583 584 585 586 587 - 2001Summer.doc588');589INSERT 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. 590Copies will be distributed to Legal and Credit.');591INSERT 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');592INSERT 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 : 593713-668-3712...... my cell # is 281-381-7332594 595the kid');596INSERT INTO email([from],[to],subject,body) VALUES('cooper.richey@enron.com', 'trycooper@hotmail.com', 'FW: Contact Info', '597 598-----Original Message-----599From: Punja, Karim 600Sent: Thursday, December 13, 2001 2:35 PM601To: Richey, Cooper602Subject: Contact Info603 604 605Cooper,606 607Its been a real pleasure working with you (even though it was for only a small amount of time)608I hope we can stay in touch.609 610Home# 234-0249611email: kpunja@hotmail.com612 613Take Care, 614 615Karim.616 ');617INSERT 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 619I haven''t talked to many of you via email recently but I do want to give you620my new address for your email file:621 622 bjm30@earthlink.net623 624I hope all is well.625 626Brian McGuinn');627INSERT 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 629Shelley');630INSERT 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 Conference631 632San Antonio, Texas May 2-4, 2001 Westin Riverwalk633 634 See attached memo for more details!!635 636 637? Registration for the law conference this year will be handled through an 638Online RSVP Form on the Enron Law Conference Website at 639http://lawconference.corp.enron.com. The website is still under construction 640and 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 643is operational. 644 645? Please complete the Online RSVP Form as soon as it is available and submit 646it no later than Friday, March 30th. 647 648 649 650 651');652INSERT 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 653and let him know - we are coming on saturday - i just havent had a chance to 654call you guys back -- looking forward to it -- i probably need the 655directions again though');656INSERT INTO email([from],[to],subject,body) VALUES('darron.giron@enron.com', 'bryce.baxter@enron.com', 'Re: Feedback for Audrey Cook', 'Bryce,657 658I''ll get it done today. 659 660DG 3-9573661 662 663 664 665 666 From: Bryce Baxter 06/12/2000 07:15 PM667 668 669To: Darron C Giron/HOU/ECT@ECT670cc: 671Subject: Feedback for Audrey Cook672 673You were identified as a reviewer for Audrey Cook. If possible, could you 674complete her feedback by end of business Wednesday? It will really help me 675in the PRC process to have your input. Thanks.676 677');678INSERT INTO email([from],[to],subject,body) VALUES('casey.evans@enron.com', 'stephanie.sever@enron.com', 'Gas EOL ID', 'Stephanie,679 680In 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 682PWR-NG-LT-SPP: Mike Carson683PWR-NG-LT-SERC: Jeff King684 685If you need to know their power desk to map their ID to their gas books, those desks are as follows:686 687EPMI-LT-SPP: Mike Carson688EPMI-LT-SERC: Jeff King689 690I will be in training this afternoon, but will be back when class is over. Let me know if you have any questions.691 692Thanks for your help!693Casey');694INSERT 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 697ds698 699 700 701 702 ');703INSERT INTO email([from],[to],subject,body) VALUES('mcominsky@aol.com', 'cpatman@bracepatt.com, james_derrick@enron.com', 'Jurisprudence Luncheon', 'Carrin & Jim --704 705It was an honor and a pleasure to meet both of you yesterday. I know we will706have fun working together on this very special event.707 708Jeff 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 please710advise me if you would like them sent to you? I can email the MS Excel files711or I can fax the hard copies to you. Please advise what is most convenient.712 713I plan to be in town through the holidays and can be reached by phone, email,714or cell phone at any time. My cell phone number is 713/705-4829.715 716Thanks again for your interest in the ADL''s work. Martin.717 718Martin B. Cominsky719Director, Southwest Region720Anti-Defamation League721713/627-3490, ext. 122722713/627-2011 (fax)723MCominsky@aol.com');724INSERT 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 725Raimer to be Bush''s secretary of HHS? Just curious about that infamous UTMB 726rumor mill. Hope things are well, happy holidays.727PL');728INSERT INTO email([from],[to],subject,body) VALUES('marie.heard@enron.com', 'ehamilton@fna.com', 'ISDA Master Agreement', 'Erin:729 730Pursuant 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 732Marie733 734Marie Heard735Senior Legal Specialist736Enron North America Corp.737Phone: (713) 853-3907738Fax: (713) 646-3490739marie.heard@enron.com740 741 ');742INSERT 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 ');747INSERT 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', '748Please contact me if you have any questions regarding last weeks prices.749 750Thank you,751Karolyn Criado7523-9441753 754 755 756 757');758INSERT 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 760In 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 762We also need to continue to explore a JEA buy-out.763 764Thanks.');765INSERT INTO email([from],[to],subject,body) VALUES('stacy.dickson@enron.com', 'gregg.penman@enron.com', 'RE: Constellation TC 5-7-01', 'Gregg, 766 767I am at home with a sick baby. (Lots of fun!) I will call you about this 768tomorrow.769 770Stacy');771INSERT 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/');774INSERT INTO email([from],[to],subject,body) VALUES('k..allen@enron.com', 'jacqestc@aol.com', '', 'Jacques,775 776I 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)).777This is assuming we wrap this up on Tuesday. 778 779Please email to confirm that their changes are ok so I can set up a meeting on Tuesday to reach closure.780 781Phillip');782INSERT INTO email([from],[to],subject,body) VALUES('kourtney.nelson@enron.com', 'mike.swerzbin@enron.com', 'Adjusted L/R Balance', 'Mike,783 784I placed the adjusted L/R Balance on the Enronwest site. It is under the "Staff/Kourtney Nelson". There are two links: 785 7861) "Adj L_R" is the same data/format from the weekly strategy meeting. 7872) "New Gen 2001_2002" link has all of the supply side info that is used to calculate the L/R balance788 -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 790Both 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 792Please let me know if you have any questions or feedback,793 794Kourtney795 796 797 798Kourtney Nelson799Fundamental Analysis 800Enron North America801(503) 464-8280802kourtney.nelson@enron.com');803INSERT INTO email([from],[to],subject,body) VALUES('d..thomas@enron.com', 'naveed.ahmed@enron.com', 'FW: Current Enron TCC Portfolio', '804 805-----Original Message-----806From: Grace, Rebecca M. 807Sent: Monday, December 17, 2001 9:44 AM808To: Thomas, Paul D.809Cc: Cashion, Jim; Allen, Thresa A.; May, Tom810Subject: RE: Current Enron TCC Portfolio811 812 813Paul,814 815I reviewed NY''s list. I agree with all of their contracts numbers and mw amounts.816 817Call if you have any more questions.818 819Rebecca820 821 822 823 -----Original Message-----824From: Thomas, Paul D. 825Sent: Monday, December 17, 2001 9:08 AM826To: Grace, Rebecca M.827Subject: FW: Current Enron TCC Portfolio828 829 << File: enrontccs.xls >> 830Rebecca,831Let me know if you see any differences.832 833Paul834X 3-0403835-----Original Message-----836From: Thomas, Paul D. 837Sent: Monday, December 17, 2001 9:04 AM838To: Ahmed, Naveed839Subject: FW: Current Enron TCC Portfolio840 841 842 843 844-----Original Message-----845From: Thomas, Paul D. 846Sent: Thursday, December 13, 2001 10:01 AM847To: Baughman, Edward D.848Subject: Current Enron TCC Portfolio849 850 851');852INSERT 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, 853L.P., effective February 1, 2001, with the surviving entity being El Paso 854Merchant Energy, L.P. We currently have ISDA Master Agreements with both 855counterparties. Please see the attached memo regarding the existing Masters 856and let us know which agreement should be terminated.857 858Thanks,859Stephanie860');861INSERT INTO email([from],[to],subject,body) VALUES('kam.keiser@enron.com', 'c..kenne@enron.com', 'RE: What about this too???', ' 862 863 -----Original Message-----864From: Kenne, Dawn C. 865Sent: Wednesday, February 06, 2002 11:50 AM866To: Keiser, Kam867Subject: What about this too???868 869 870 << File: Netco Trader Matrix.xls >> 871 ');872INSERT 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 874Thanks875 876chris877x31666');878INSERT INTO email([from],[to],subject,body) VALUES('debra.perlingiere@enron.com', 'jworman@academyofhealth.com', '', 'Have a great weekend! Happy Fathers Day!879 880 881Debra Perlingiere882Enron North America Corp.8831400 Smith Street, EB 3885884Houston, Texas 77002885dperlin@enron.com886Phone 713-853-7658887Fax 713-646-3490');888INSERT INTO email([from],[to],subject,body) VALUES('outlook.team@enron.com', '', 'Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia &', 'CALENDAR ENTRY: APPOINTMENT889 890Description:891 Demo by Martha Janousek of Dashboard & Pipeline Profile / Julia & Dir Rpts. - 4102892 893Date: 1/5/2001894Time: 9:00 AM - 10:00 AM (Central Standard Time)895 896Chairperson: Outlook Migration Team897 898Detailed Description:');899INSERT INTO email([from],[to],subject,body) VALUES('diana.seifert@enron.com', 'mark.taylor@enron.com', 'Guest access Chile', 'Hello Mark,900 901Justin Boyd told me that your can help me with questions regarding Chile.902We got a request for guest access through MG.903The company is called Escondida and is a subsidiary of BHP Australia.904 905Please advise if I can set up a guest account or not.906F.Y.I.: MG is planning to put a "in w/h Chile" contract for Copper on-line as 907soon as Enron has done the due diligence for this country.908Thanks !909 910 911Best regards912 913Diana Seifert914EOL PCG');915INSERT 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 917Status last changed by: Barry L. Tycholiz918Expense Report Name: 121001919Report Total: $198.98920Amount Due Employee: $198.98921Amount Approved: $198.98922Amount Paid: $0.00923Approval Status: Approved924Payment Status: Pending925 926 927To review this expense report, click on the following link for Concur Expense.928http://expensexms.enron.com');929INSERT INTO email([from],[to],subject,body) VALUES('kevin.hyatt@enron.com', '', 'Technical Support', 'Outside the U.S., please refer to the list below:930 931Australia:9321800 678-515933support@palm-au.com934 935Canada:9361905 305-6530937support@palm.com938 939New Zealand:9400800 446-398941support@palm-nz.com942 943U.K.:9440171 867 0108945eurosupport@palm.3com.com946 947Please refer to the Worldwide Customer Support card for a complete technical support contact list.');948INSERT INTO email([from],[to],subject,body) VALUES('geoff.storey@enron.com', 'dutch.quigley@enron.com', 'RE:', 'duke contact?949 950 -----Original Message-----951From: Quigley, Dutch 952Sent: Wednesday, October 31, 2001 10:14 AM953To: Storey, Geoff954Subject: RE: 955 956bp corp Albert LaMore 281-366-4962957 958running the reports now959 960 961 -----Original Message-----962From: Storey, Geoff 963Sent: Wednesday, October 31, 2001 10:10 AM964To: Quigley, Dutch965Subject: RE: 966 967give me a contact over there too968BP969 970 971 -----Original Message-----972From: Quigley, Dutch 973Sent: Wednesday, October 31, 2001 9:42 AM974To: Storey, Geoff975Subject: 976 977Coral Jeff Whitnah 713-767-5374978Relaint Steve McGinn 713-207-4000');979INSERT 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. 980Variances detected.981Variances detected in Load schedule.982 983 LOG MESSAGES:984 985PARSING FILE -->> O:\Portland\WestDesk\California Scheduling\ISO Final 986Schedules\2001042203.txt987 988---- Load Schedule ----989$$$ Variance found in table tblLoads.990 Details: (Hour: 3 / Preferred: 1.92 / Final: 1.89)991 TRANS_TYPE: FINAL992 LOAD_ID: PGE4993 MKT_TYPE: 2994 TRANS_DATE: 4/22/01995 SC_ID: EPMI996 997');998INSERT 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 1000John');1001INSERT 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 1002shower). I have had a shitty week--I suspect my silence (not only to you, 1003but others) after our phone call is a result of the week. I''m seeing Glen at 100411:15....talk to you');1005INSERT INTO email([from],[to],subject,body) VALUES('litebytz@enron.com', '', 'Lite Bytz RSVP', '1006This week''s Lite Bytz presentation will feature the following TOOLZ speaker:1007 1008Richard McDougall1009Solaris 81010Thursday, June 7, 20011011 1012If 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 1016Click below for more details.1017 1018http://home.enron.com:84/messaging/litebytztoolzprint.jpg');1019 COMMIT;1020 }1021} {}1022 1023###############################################################################1024# Everything above just builds an interesting test database. The actual1025# tests come after this comment.1026###############################################################################1027 1028do_test fts3ac-1.2 {1029 execsql {1030 SELECT rowid FROM email WHERE email MATCH 'mark'1031 }1032} {6 17 25 38 40 42 73 74}1033do_test fts3ac-1.3 {1034 execsql {1035 SELECT rowid FROM email WHERE email MATCH 'susan'1036 }1037} {24 40}1038do_test fts3ac-1.4 {1039 execsql {1040 SELECT rowid FROM email WHERE email MATCH 'mark susan'1041 }1042} {40}1043do_test fts3ac-1.5 {1044 execsql {1045 SELECT rowid FROM email WHERE email MATCH 'susan mark'1046 }1047} {40}1048do_test fts3ac-1.6 {1049 execsql {1050 SELECT rowid FROM email WHERE email MATCH '"mark susan"'1051 }1052} {}1053do_test fts3ac-1.7 {1054 execsql {1055 SELECT rowid FROM email WHERE email MATCH 'mark -susan'1056 }1057} {6 17 25 38 42 73 74}1058do_test fts3ac-1.8 {1059 execsql {1060 SELECT rowid FROM email WHERE email MATCH '-mark susan'1061 }1062} {24}1063do_test fts3ac-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 sample1070# data set above, only one message, number 20, contains the words1071# "gas" and "reminder" in both body and subject.1072#1073do_test fts3ac-2.1 {1074 execsql {1075 SELECT rowid, offsets(email) FROM email1076 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}}1079do_test fts3ac-2.2 {1080 execsql {1081 SELECT rowid, offsets(email) FROM email1082 WHERE email MATCH 'subject:gas reminder'1083 }1084} {20 {2 0 42 3 2 1 54 8 3 1 54 8}}1085do_test fts3ac-2.3 {1086 execsql {1087 SELECT rowid, offsets(email) FROM email1088 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}}1091do_test fts3ac-2.4 {1092 execsql {1093 SELECT rowid, offsets(email) FROM email1094 WHERE subject MATCH 'gas reminder'1095 }1096} {20 {2 0 42 3 2 1 54 8}}1097do_test fts3ac-2.5 {1098 execsql {1099 SELECT rowid, offsets(email) FROM email1100 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 only1105# 3 of them are paired with "product". Make sure only those instances1106# that match the phrase appear in the offsets(email) list.1107#1108do_test fts3ac-3.1 {1109 execsql {1110 SELECT rowid, offsets(email) FROM email1111 WHERE body MATCH 'child product' AND +rowid=321112 }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}}1114do_test fts3ac-3.2 {1115 execsql {1116 SELECT rowid, offsets(email) FROM email1117 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 tests1122#1123do_test fts3ac-4.1 {1124 execsql {1125 SELECT snippet(email) FROM email1126 WHERE email MATCH 'subject:gas reminder'1127 }1128} {{Alert Posted 10:00 AM November 20,2000: E-<b>GAS</b> Request <b>Reminder</b>}}1129do_test fts3ac-4.2 {1130 execsql {1131 SELECT snippet(email) FROM email1132 WHERE email MATCH 'christmas candlelight'1133 }1134} {{<b>...</b>here <b>Christmas</b> 1135eve?? They have an 11:00 a.m. service and a <b>candlelight</b> service<b>...</b>}}1136 1137do_test fts3ac-4.3 {1138 execsql {1139 SELECT snippet(email) FROM email1140 WHERE email MATCH 'deal sheet potential reuse'1141 }1142} {{EOL-Accenture <b>Deal</b> <b>Sheet</b><b>...</b>asset base for <b>potential</b> <b>reuse</b>/ licensing1143 Contract negotiations<b>...</b>}}1144do_test fts3ac-4.4 {1145 execsql {1146 SELECT snippet(email,'<<<','>>>',' ') FROM email1147 WHERE email MATCH 'deal sheet potential reuse'1148 }1149} {{EOL-Accenture <<<Deal>>> <<<Sheet>>> asset base for <<<potential>>> <<<reuse>>>/ licensing1150 Contract negotiations }}1151do_test fts3ac-4.5 {1152 execsql {1153 SELECT snippet(email,'<<<','>>>',' ') FROM email1154 WHERE email MATCH 'first things'1155 }1156} {{Re: <<<First>>> Polish Deal! Congrats! <<<Things>>> seem to be building rapidly now }}1157do_test fts3ac-4.6 {1158 execsql {1159 SELECT snippet(email) FROM email1160 WHERE email MATCH 'chris is here'1161 }1162} {{<b>...</b><b>chris</b>.germany@enron.com'" <<b>chris</b><b>...</b>bet this <b>is</b> next to<b>...</b>about going <b>here</b> Christmas 1163eve<b>...</b>}}1164do_test fts3ac-4.7 {1165 execsql {1166 SELECT snippet(email) FROM email1167 WHERE email MATCH '"pursuant to"'1168 }1169} {{Erin:1170 1171<b>Pursuant</b> <b>to</b> your request, attached are the Schedule to the ISDA Master Agreement, together<b>...</b>}}1172do_test fts3ac-4.8 {1173 execsql {1174 SELECT snippet(email) FROM email1175 WHERE email MATCH 'ancillary load davis'1176 }1177} {{pete.<b>davis</b>@enron.com<b>...</b>3; No <b>ancillary</b> schedules awarded<b>...</b>detected in <b>Load</b> schedule.1178 1179 LOG<b>...</b>}}1180 1181# Combinations of AND and OR operators:1182#1183do_test fts3ac-5.1 {1184 execsql {1185 SELECT snippet(email) FROM email1186 WHERE email MATCH 'questar enron OR com'1187 }1188} {{matt.smith@<b>enron</b>.<b>com</b><b>...</b>31 Keystone Receipts118915 <b>Questar</b> Pipeline119040 Rockies<b>...</b>}}1191 1192do_test fts3ac-5.2 {1193 execsql {1194 SELECT snippet(email) FROM email1195 WHERE email MATCH 'enron OR com questar'1196 }1197} {{matt.smith@<b>enron</b>.<b>com</b><b>...</b>31 Keystone Receipts119815 <b>Questar</b> Pipeline119940 Rockies<b>...</b>}}1200