Need to set null for sqflite database instance when close database. Otherwise it will always return the old instance.

[haidang750]

In close() function of database.dart file, need to set null for current database before closing it like this:
Future close() async {
final db = await instance.database;
_database = null;
await db.close();
}

[haidang750]

You can find this issue by: tekartik/sqflite#223

[haidang750]

@stephanmantel please help me

[stephanmantel]

Hi, thanks for your interest in Floor and fr filing this issue, I shall take a look at it

[haidang750]

thank you very much, my case is switching between different sqflite .db files, so I need to close the current before open the new one, but I got the error Unhandled Exception: DatabaseException(error database_closed) after close