Reported By: Andrew Hill Reported On: 8/2/2012 For: Version 2.09 Build 1
# 3613Optimized CONTAINS Conditions with Leading Asterisk (*) Wildcard Can Cause Incorrect Results The following query returns incorrect results.
SELECT * FROM Meridians WHERE RichEditNotes CONTAINS '*Migr*'
ResolutionFixed Problem on 8/6/2012 in version 2.10 build 1
Products AffectedElevateDB 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 LCL Standard with Source ElevateDB PHP Standard ElevateDB PHP Standard with Source ElevateDB PHP Trial ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial