Build 29 - Development
Alright, another development build. This one mostly takes care of some schema, JOIN and CONSTRAINT errors that were found in build 28. * * * * * * * * Build # 29, 6/22/2007 * * * * * * * * THIS IS A DEVELOPMENT BUILD! PLEASE TAKE CARE AND BACKUP YOUR DATA. ***** NOTES ***** Wildcard search in FTS indexes is broken for multiple columns in the FTS index. The workaround is to turn off optimization: (SET OPTIMIZATION OFF;) This will not work: select * from ftsTest where contains((c1,c2), '"mik*"'); This will work: select * from ftsTest where contains((c1,c2), '"mike"'); Single column FTS indexes work fine. This will work: select * from ftsTest where contains(c1, '"mik*"'); **************** ISSUES AND FIXES **************** Bug #125: Error is [Database Schema] parse - Fixed Bug #126: FTS Query for * generates exception - Fixed Bug #128: Where clause not evaluating correctly when in left join query - Fixed Bug #131: Multi result in subclause query - = should not be used, IN should be used when more than one result is expected from subquery Bug #108: DROP constraint failing - Fixed Bug #115: Duplicate ID received from @@IDENTITY callback - Fixed OTHER NON TICKETED ITEMS ************************ Script generator in the DataBuilder generated wrong INSERT clauses. Double and Float values was inserted in the script incorrectly.