Re: [Gusdev-gusdev] Boolean query error

[Steve F. <st...@pc...>]

Arnaud-

let me try to better understand what you mean.

your subject line is 'boolean query error'.  is this problem limited to 
boolean queries?  i don't know exactly how they work, but i would guess 
that each query is run individually and then the set operations are 
applied to the results which reside in cache tables.  do you know if 
that is true?  if so, then the problem resolves down to how we handle 
timed out queries, ie, that we should expunge them from the table that 
points to the cached results.

steve

Arnaud Kerhornou wrote:

>Hi Jonathan
>
>We've found an error with the boolean queries.
>It happens when a query goes over timeout. The statement is reclaimed
>(see code in reclaimLongRunningStatements() method of the Connection
>class) and the cache table is not created.
>But this cache table is expected to exist and we get a "table or view
>does not exist" exception.
>So every time someone is trying to do the same query again the code
>tries to query the cache table and as a consequence, it doesn't return
>any result.
>
>I don't know if I've made myself clear but I can give you the errput if
>you want.
>
>Do you know how to fix this ? Would it be possible to insert a rollback
>statement in the code when the statement is reclaimed ?
>
>cheers
>Arnaud
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>  
>