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

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

---

 Comments and Workarounds

---

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.

---

 Resolution

---

Fixed Problem on 8/12/2008 in version 2.01 build 5

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial