SQL quirkiness

[Steve Albin]

On Sunday, October 19, 2008 sunshine at public.kherson.ua (Ruslan Zasukhin) wrote:

>On 10/19/08 2:33 PM, "Ernesto Giannotta" <ernestogiannotta at tiscalinet.it>
>wrote:
>
>Hi Erne,
>
>> sorry for the huge delay but I've experienced a similar situation just
>> yesterday
>> 
>> I was looking for some field data beginning with "strange" (yep! the
>> appropriate word :-) and the app kept crashing and no diagnose or
>> reindex or clone did help (the crash log reported something wrong on
>> dispose string or some like that, sorry I trashed it)
>> 
>> After I added a record to the searched table the problem went away...
>> Sorry, I can't be more helpful than this
>
>Why you can't? 
>
>1) report it into Mantis
>
>2) attach crash log to report
>
>3) remove that new record to get back db that reproduce it,
>    add db + text of SQL query into Mantis also
>
>

I reported this to Mantis after first asking about it on this list.   It is reported fixed in version 3.6.  (Or I suppose now, version 4.0.)   A clone of the database fixed the problem for me.  I don't recall trying to add records when this occured, so I can't tell you if that helped in my case.  I no longer have the database.

<http://www.valentina-db.com/bt/view.php?id=3419>

Steve

-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/