![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Tue, Aug 12 2008 7:54 PM | Permanent Link |
Samuel | 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). |
Wed, Aug 13 2008 10:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |