Re: [Firebird-devel] Clause SQL freeze the database

[Daniel R. <da...@ac...>]

Hi,

First, could you post in plain text, instead of HTML.  Also, can you
omit your VCF file the next time you send to the list.

At October 20, 2003, 15:32, Cristiano A. Costa wrote:
> Solution:
 
[...snip SQL statement...]

> In SQL clause, the condition "observacoes 
> CONTAINING usuarios.id || ';'"  freeze the firebird Server.

What is the data type for usuarios.id?

Also, can you mention what are the indexes that you have defined for
those tables.  And, can you show the generated plan.

> My question, have a error in SQL clause or a bug in the Firebird 1.5 RC6?

Once you give more information, as stated above, it would be easier to
help you.

-- 
Best regards,
 Daniel Rail
 Senior System Engineer
 ACCRA Group Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)