[629] in Tooltime
Re: Bug in History Search field
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Mon Dec 1 17:06:32 1997
In-Reply-To: <v03020903b0a8cffe6fbd@[18.81.0.229]>
Date: Mon, 1 Dec 1997 17:06:09 -0500
To: wade@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Steve,
David just called to say he found a line had been commented out which would
update the mit_history_search field for either new or existing logs (I
can't remember which). We can uncomment it, but it may be commented out
for a reason. We wouldn't want to reintroduce a new bug. Steve, do you
know why it is commented out?
-Debi
>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
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
