The following query does not return any results :

 SELECT * FROM Product
 WHERE (uid > 7694) OR (TRUE AND (Name CONTAINS 'anti*'))

while the following does return results :

 SELECT * FROM Product
 WHERE (uid > 7694) OR ((Name CONTAINS 'anti*'))

and so does the following :

 SELECT * FROM Product
 WHERE (TRUE AND (Name CONTAINS 'anti*'))

Is that to be expected ?

BTW, there are no records with (uid > 7694).

Samuel,

<< The following query does not return any results : >>

Yes, the issue is with the wilcard search and the OR combined.  In such a
case, EDB is performing a row scan and the row-by-row evaluation of wildcard
searches for CONTAINS isn't working correctly.

A fix will be available within the next week.

--
Tim Young
Elevate Software
www.elevatesoft.com