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 (a] enron.com', 'traders.eol (a] enron.com, traders.eol (a] 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 (a] enron.com', 'laynie.east (a] enron.com, lisa.king (a] enron.com, lisa.best (a] 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 (a] concureworkplace.com', 'louise.kitchen (a] 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 (a] enron.com', 'julie.johnson (a] 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 (a] enron.com', 'gary.l.carrier (a] usa.dupont.com, scott.joyce (a] 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 (a] enron.com', 'paul.simons (a] 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 (a] enron.com', 't..robinson (a] 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 (a] enron.com', 'kenneth.lay (a] 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 (a] enron.com', 'lindy.donoho (a] 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 (a] 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 (a] enron.com', 'fran.fagan (a] 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 (a] enron.com', 'shift.dl-portland (a] 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 (a] enron.com', 'john.arnold (a] enron.com, bilal.bajwa (a] enron.com, john.griffith (a] enron.com,', 'TRV Notification: (NG - PROPT P/L - 09/27/2001)', 'The report named: NG - PROPT P/L <http://trv.corp.enron.com/linkFromExcel.asp?report_cd=11&report_name=NG+-+PROPT+P/L&category_cd=5&category_name=FINANCIAL&toc_hide=1&sTV1=5&TV1Exp=Y¤t_efct_date=09/27/2001>, published as of 09/27/2001 is now available for viewing on the website.'); 164 INSERT INTO email([from],[to],subject,body) VALUES('patrice.mims (a] enron.com', 'calvin.eakins (a] 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 (a] enron.com>', 'stephanie.panus (a] 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 (a] enron.com', 'richard.shapiro (a] 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 (a] industrialinfo.com', 'pcopello (a] 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 (a] 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 (a] enron.com', 'all_ena_egm_eim (a] 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 (a] enron.com', 'ingrid.immer (a] 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 (a] Williams.com> on 12/21/2000 11:48:47 AM 212 To: "''chris.germany (a] enron.com''" <chris.germany (a] 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 (a] cpuc.ca.gov', 'skatz (a] sempratrading.com, kmccrea (a] sablaw.com, thompson (a] 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 (a] aglresources.com', 'dscott4 (a] enron.com, lcampbel (a] 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 (a] enron.com', 'rwolkwitz (a] powermerchants.com', '', ' 242 243 Here is a goody for you'); 244 INSERT INTO email([from],[to],subject,body) VALUES('ryan.o''rourke (a] enron.com', 'k..allen (a] enron.com, randy.bhatia (a] enron.com, frank.ermis (a] enron.com,', 'TRV Notification: (West VaR - 11/07/2001)', 'The report named: West VaR <http://trv.corp.enron.com/linkFromExcel.asp?report_cd=36&report_name=West+VaR&category_cd=2&category_name=WEST&toc_hide=1&sTV1=2&TV1Exp=Y¤t_efct_date=11/07/2001>, published as of 11/07/2001 is now available for viewing on the website.'); 245 INSERT INTO email([from],[to],subject,body) VALUES('mjones7 (a] txu.com', 'cstone1 (a] txu.com, ggreen2 (a] txu.com, timpowell (a] 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 (a] enron.com', 'kkw816 (a] 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 (a] enron.com', 'barry.tycholiz (a] 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 (a] enron.com', 'george.phillips (a] 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 (a] enron.com', 'angusmcka (a] aol.com', 'Re: (no subject)', 'not yet'); 264 INSERT INTO email([from],[to],subject,body) VALUES('adam.bayer (a] enron.com', 'jonathan.mckay (a] 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 (a] enron.com', 'yan.wang (a] 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 (a] enron.com', 'jimboman (a] 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 (a] COMPAQ.com> on 09/07/2000 09:01:04 AM 306 To: "''Agheb (E-mail)" <Agheb (a] aol.com>, "Leila Mankarious (E-mail)" 307 <Leila_Mankarious (a] mhhs.org>, "''Marymankarious (E-mail)" 308 <marymankarious (a] aol.com>, "Michelle lokay (E-mail)" <mlokay (a] enron.com>, "Ramy 309 Mankarious (E-mail)" <Mankarious (a] 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 (a] enron.com', 'sherry.dawson (a] 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 (a] enron.com', 'eol.wide (a] 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 (a] enron.com', 'jhh1 (a] 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 (a] email.msn.com> on 07/28/2000 08:38:08 AM 384 To: "Vince J Kaminski" <Vince_J_Kaminski (a] 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 (a] enron.com', 'mmmarcantel (a] equiva.com', 'RE:', 'i will try to line up a pig for you '); 403 INSERT INTO email([from],[to],subject,body) VALUES('jae.black (a] enron.com', 'claudette.harvey (a] enron.com, chaun.roberts (a] enron.com, judy.martinez (a] 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 (a] enron.com', 'dale.neuner (a] 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 (a] smartreminders.com', 'm..tholt (a] 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 (a] enron.com', 'mark.bernstein (a] 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 (a] concureworkplace.com', 'michelle.cash (a] 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 (a] enron.com', 'ray.alvarez (a] enron.com, mark.palmer (a] enron.com, karen.denne (a] 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 (a] coral-energy.com> 06/08/2001 11:13 AM To: "''smara (a] enron.com''" <smara (a] 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 (a] enron.com', 'eloy.escobar (a] 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 (a] enron.com', 'richard.shapiro (a] 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 (a] accenture.com', 'dave.samuels (a] 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 (a] enron.com', 'thomas.martin (a] 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 (a] enron.com', 'dan.junek (a] enron.com, chris.germany (a] 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 (a] nisource.com on 03/08/2001 09:16:57 AM 565 To: " - *Koch, Kent" <kkoch (a] nisource.com>, " - 566 *Millar, Debra" <dmillar (a] nisource.com>, " - *Burke, Lynn" 567 <lburke (a] nisource.com> 568 cc: " - *Heckathorn, Tom" <theckathorn (a] 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 (a] enron.com', 'tim.belden (a] enron.com, dana.davis (a] enron.com, genia.fitzgerald (a] 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 (a] dwt.com', 'jack.speer (a] alcoa.com, crow (a] millernash.com, michaelearly (a] earthlink.net,', 'Oral Argument Request', ' - Oral Argument Request.doc'); 592 INSERT INTO email([from],[to],subject,body) VALUES('mike.carson (a] enron.com', 'rlmichaelis (a] 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 (a] enron.com', 'trycooper (a] 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 (a] hotmail.com 612 613 Take Care, 614 615 Karim. 616 '); 617 INSERT INTO email([from],[to],subject,body) VALUES('bjm30 (a] earthlink.net', 'mcguinn.k (a] enron.com, mcguinn.ian (a] enron.com, mcguinn.stephen (a] 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 (a] earthlink.net 623 624 I hope all is well. 625 626 Brian McGuinn'); 627 INSERT INTO email([from],[to],subject,body) VALUES('shelley.corman (a] enron.com', 'steve.hotte (a] 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 (a] enron.com', 'john.schwartzenburg (a] enron.com, scott.dieball (a] enron.com, recipients (a] 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 (a] enron.com', 'heath.b.taylor (a] 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 (a] enron.com', 'bryce.baxter (a] 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 (a] enron.com', 'stephanie.sever (a] 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 (a] enron.com', 'david.roensch (a] enron.com, kimberly.watson (a] enron.com, michelle.lokay (a] 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 (a] aol.com', 'cpatman (a] bracepatt.com, james_derrick (a] 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 (a] aol.com'); 724 INSERT INTO email([from],[to],subject,body) VALUES('phillip.love (a] enron.com', 'todagost (a] utmb.edu, gbsonnta (a] 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 (a] enron.com', 'ehamilton (a] 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 (a] enron.com 740 741 '); 742 INSERT INTO email([from],[to],subject,body) VALUES('andrea.ring (a] enron.com', 'beverly.beaty (a] 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 (a] enron.com', 'j..bonin (a] enron.com, felicia.case (a] enron.com, b..clapp (a] 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 (a] enron.com', 'edward.baughman (a] enron.com, billy.braddock (a] 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 (a] enron.com', 'gregg.penman (a] 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 (a] enron.com', 'dfincher (a] 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 (a] enron.com', 'jacqestc (a] 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 (a] enron.com', 'mike.swerzbin (a] 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 (a] enron.com'); 803 INSERT INTO email([from],[to],subject,body) VALUES('d..thomas (a] enron.com', 'naveed.ahmed (a] 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 (a] enron.com', 'william.bradford (a] enron.com, debbie.brackett (a] 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 (a] enron.com', 'c..kenne (a] 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 (a] enron.com', 'joe.parks (a] 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 (a] enron.com', 'jworman (a] 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 (a] enron.com 886 Phone 713-853-7658 887 Fax 713-646-3490'); 888 INSERT INTO email([from],[to],subject,body) VALUES('outlook.team (a] 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 (a] enron.com', 'mark.taylor (a] 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 (a] concureworkplace.com', 'mark.whitt (a] 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 (a] enron.com', '', 'Technical Support', 'Outside the U.S., please refer to the list below: 930 931 Australia: 932 1800 678-515 933 support (a] palm-au.com 934 935 Canada: 936 1905 305-6530 937 support (a] palm.com 938 939 New Zealand: 940 0800 446-398 941 support (a] palm-nz.com 942 943 U.K.: 944 0171 867 0108 945 eurosupport (a] 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 (a] enron.com', 'dutch.quigley (a] 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 (a] enron.com', 'pete.davis (a] 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 (a] enron.com', 'john.zufferli (a] 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 (a] enron.com', 'lschiffm (a] 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 (a] 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 (a] 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., 1136 among others. <b>...</b>}} 1137 1138 do_test fts1c-4.3 { 1139 execsql { 1140 SELECT snippet(email) FROM email 1141 WHERE email MATCH 'deal sheet potential reuse' 1142 } 1143 } {{EOL-Accenture <b>Deal</b> <b>Sheet</b> <b>...</b> intent 1144 Review Enron asset base for <b>potential</b> <b>reuse</b>/ licensing 1145 Contract negotiations <b>...</b>}} 1146 do_test fts1c-4.4 { 1147 execsql { 1148 SELECT snippet(email,'<<<','>>>',' ') FROM email 1149 WHERE email MATCH 'deal sheet potential reuse' 1150 } 1151 } {{EOL-Accenture <<<Deal>>> <<<Sheet>>> intent 1152 Review Enron asset base for <<<potential>>> <<<reuse>>>/ licensing 1153 Contract negotiations }} 1154 do_test fts1c-4.5 { 1155 execsql { 1156 SELECT snippet(email,'<<<','>>>',' ') FROM email 1157 WHERE email MATCH 'first things' 1158 } 1159 } {{Re: <<<First>>> Polish Deal! Congrats! <<<Things>>> seem to be building rapidly now on the }} 1160 do_test fts1c-4.6 { 1161 execsql { 1162 SELECT snippet(email) FROM email 1163 WHERE email MATCH 'chris is here' 1164 } 1165 } {{<b>chris</b>.germany (a] enron.com <b>...</b> Sounds good to me. I bet this <b>is</b> next to the Warick?? Hotel. <b>...</b> place.? What do you think about going <b>here</b> Christmas 1166 eve?? They have an 11:00 a.m. <b>...</b>}} 1167 do_test fts1c-4.7 { 1168 execsql { 1169 SELECT snippet(email) FROM email 1170 WHERE email MATCH '"pursuant to"' 1171 } 1172 } {{Erin: 1173 1174 <b>Pursuant</b> <b>to</b> your request, attached are the Schedule to <b>...</b>}} 1175 do_test fts1c-4.8 { 1176 execsql { 1177 SELECT snippet(email) FROM email 1178 WHERE email MATCH 'ancillary load davis' 1179 } 1180 } {{pete.<b>davis</b>@enron.com <b>...</b> Start Date: 4/22/01; HourAhead hour: 3; No <b>ancillary</b> schedules awarded. 1181 Variances detected. 1182 Variances detected in <b>Load</b> schedule. 1183 1184 LOG MESSAGES: 1185 1186 PARSING <b>...</b>}} 1187 1188 # Combinations of AND and OR operators: 1189 # 1190 do_test fts1c-5.1 { 1191 execsql { 1192 SELECT snippet(email) FROM email 1193 WHERE email MATCH 'questar enron OR com' 1194 } 1195 } {{matt.smith@<b>enron</b>.<b>com</b> <b>...</b> six reports: 1196 1197 31 Keystone Receipts 1198 15 <b>Questar</b> Pipeline 1199 40 Rockies Production 1200 22 West_2 <b>...</b>}} 1201 do_test fts1c-5.2 { 1202 execsql { 1203 SELECT snippet(email) FROM email 1204 WHERE email MATCH 'enron OR com questar' 1205 } 1206 } {{matt.smith@<b>enron</b>.<b>com</b> <b>...</b> six reports: 1207 1208 31 Keystone Receipts 1209 15 <b>Questar</b> Pipeline 1210 40 Rockies Production 1211 22 West_2 <b>...</b>}} 1212 1213 finish_test 1214
