Thanks... but no luck.
Installed 4.0.2, started with a backup of my MM3 database and let MM4 convert it a new. Collection criteria and auto-playlist filters are both failing when partial matches are used. Also tried changing Match All and Match Any and got the same results.
When running a complete database optimize I get the following error dialog immediately after starting the optimization.

If I click the Ignore button twice the optimization runs for awhile (I can see the MM.DB-journal file being opened and closed) and then the process just hangs with no file i/o or cpu activity. There is definitely something wrong with the database here.