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.