changes to sqlite tests and compatibility