[628] in Tooltime
Bug in History Search field
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Mon Dec 1 15:41:44 1997
Date: Mon, 1 Dec 1997 15:41:41 -0500
To: tooltime@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Hi there,
There is a field called mit_history_search field which should always
contain the first 2000 characters of the mit_history field. This is
necessary in order to be able to do any kind of search on the history
field...in this case on the first 2000 characters, since the mit_history
field itself is not searchable.
However, it turns out that that is not working, as it seems that many
(2228) of the logs have an _empty_ mit_history_search field even though
their mit_history field is not empty. This means these logs can not be
found using the History Only Search. This is an important bug.
David/Peter, could you take a look at this?
SQL> select count(*) from mit_logs where mit_history IS NOT NULL
and mit_history_search IS NULL;
COUNT(*)
----------
2288
Thanks,
-Debi
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
