1 files changed, 29 insertions, 35 deletions
diff --git a/third_party/sqlite/src/test/fts3ac.test b/third_party/sqlite/src/test/fts3ac.test
index 84da924..72e5410 100644
--- a/third_party/sqlite/src/test/fts3ac.test
+++ b/third_party/sqlite/src/test/fts3ac.test
@@ -1131,36 +1131,39 @@ do_test fts3ac-4.2 {
     SELECT snippet(email) FROM email
      WHERE email MATCH 'christmas candlelight'
   }
-} {{<b>...</b>here <b>Christmas</b> 
-eve?? They have an 11:00 a.m. service and a <b>candlelight</b> service<b>...</b>}}
+} {{<b>...</b> place.? What do you think about going here <b>Christmas</b> 
+eve?? They have an 11:00 a.m. service and a <b>candlelight</b> service at 5:00 p.m., 
+among others. <b>...</b>}}
 
 do_test fts3ac-4.3 {
   execsql {
     SELECT snippet(email) FROM email
      WHERE email MATCH 'deal sheet potential reuse'
   }
-} {{EOL-Accenture <b>Deal</b> <b>Sheet</b><b>...</b>asset base for <b>potential</b> <b>reuse</b>/ licensing
-     Contract negotiations<b>...</b>}}
+} {{EOL-Accenture <b>Deal</b> <b>Sheet</b> <b>...</b> intent
+     Review Enron asset base for <b>potential</b> <b>reuse</b>/ licensing
+     Contract negotiations <b>...</b>}}
 do_test fts3ac-4.4 {
   execsql {
     SELECT snippet(email,'<<<','>>>',' ') FROM email
      WHERE email MATCH 'deal sheet potential reuse'
   }
-} {{EOL-Accenture <<<Deal>>> <<<Sheet>>> asset base for <<<potential>>> <<<reuse>>>/ licensing
-     Contract negotiations }}
+} {{EOL-Accenture <<<Deal>>> <<<Sheet>>>  intent
+     Review Enron asset base for <<<potential>>> <<<reuse>>>/ licensing
+     Contract negotiations  }}
 do_test fts3ac-4.5 {
   execsql {
     SELECT snippet(email,'<<<','>>>',' ') FROM email
      WHERE email MATCH 'first things'
   }
-} {{Re: <<<First>>> Polish Deal! Congrats!  <<<Things>>> seem to be building rapidly now }}
+} {{Re: <<<First>>> Polish Deal!  Congrats!  <<<Things>>> seem to be building rapidly now on the  }}
 do_test fts3ac-4.6 {
   execsql {
     SELECT snippet(email) FROM email
      WHERE email MATCH 'chris is here'
   }
-} {{<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 
-eve<b>...</b>}}
+} {{<b>chris</b>.germany@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 
+eve?? They have an 11:00 a.m. <b>...</b>}}
 do_test fts3ac-4.7 {
   execsql {
     SELECT snippet(email) FROM email
@@ -1168,15 +1171,19 @@ do_test fts3ac-4.7 {
   }
 } {{Erin:
 
-<b>Pursuant</b> <b>to</b> your request, attached are the Schedule to the ISDA Master Agreement, together<b>...</b>}}
+<b>Pursuant</b> <b>to</b> your request, attached are the Schedule to <b>...</b>}}
 do_test fts3ac-4.8 {
   execsql {
     SELECT snippet(email) FROM email
      WHERE email MATCH 'ancillary load davis'
   }
-} {{pete.<b>davis</b>@enron.com<b>...</b>3;  No <b>ancillary</b> schedules awarded<b>...</b>detected in <b>Load</b> schedule.
+} {{pete.<b>davis</b>@enron.com <b>...</b> Start Date: 4/22/01; HourAhead hour: 3;  No <b>ancillary</b> schedules awarded.  
+Variances detected.
+Variances detected in <b>Load</b> schedule.
+
+    LOG MESSAGES:
 
-    LOG<b>...</b>}}
+PARSING <b>...</b>}}
 
 # Combinations of AND and OR operators:
 #
@@ -1185,35 +1192,22 @@ do_test fts3ac-5.1 {
     SELECT snippet(email) FROM email
      WHERE email MATCH 'questar enron OR com'
   }
-} {{matt.smith@<b>enron</b>.<b>com</b><b>...</b>31 Keystone Receipts
-15 <b>Questar</b> Pipeline
-40 Rockies<b>...</b>}}
+} {{matt.smith@<b>enron</b>.<b>com</b> <b>...</b> six reports:  
 
+31 Keystone Receipts
+15 <b>Questar</b> Pipeline
+40 Rockies Production
+22 West_2 <b>...</b>}}
 do_test fts3ac-5.2 {
   execsql {
     SELECT snippet(email) FROM email
      WHERE email MATCH 'enron OR com questar'
   }
-} {{matt.smith@<b>enron</b>.<b>com</b><b>...</b>31 Keystone Receipts
-15 <b>Questar</b> Pipeline
-40 Rockies<b>...</b>}}
+} {{matt.smith@<b>enron</b>.<b>com</b> <b>...</b> six reports:  
 
-#-------------------------------------------------------------------------
-# Test a problem reported on the mailing list.
-#
-do_test fts3ac-6.1 {
-  execsql {
-    CREATE VIRTUAL TABLE ft USING fts3(one, two);
-    INSERT INTO ft VALUES('', 'foo');
-    INSERT INTO ft VALUES('foo', 'foo');
-    SELECT offsets(ft) FROM ft WHERE ft MATCH 'foo';
-  }
-} {{1 0 0 3} {0 0 0 3 1 0 0 3}}
-do_test fts3ac-6.2 {
-  execsql {
-    DELETE FROM ft WHERE one = 'foo';
-    SELECT offsets(ft) FROM ft WHERE ft MATCH 'foo';
-  }
-} {{1 0 0 3}}
+31 Keystone Receipts
+15 <b>Questar</b> Pipeline
+40 Rockies Production
+22 West_2 <b>...</b>}}
 
 finish_test