Describe the bug
When opening a SQLite database that has already been used for SK once, I get an error: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (index SKMemoryIndex already exists)
To Reproduce
Steps to reproduce the behavior:
- Connect to a file-based SQLite db with SQLiteMemoryStore connectAsync, use it to store documents etc.
- After closing the database, connect to the same database again, which fails with an exception.
Expected behavior
I expect the database to be reopened and to be able to access my stored embedded documents.
Screenshots
If applicable, add screenshots to help explain your problem.
Platform
- OS: Windows
- IDE: IntelliJ
- Language: Java
- Source: java-0.2.8-alpha
Additional context
The error is caused by a missing IF NOT EXISTS for the index creation in com.microsoft.semantickernel.connectors.memory.sqlite.Database.createTableAsync(...)
Describe the bug
When opening a SQLite database that has already been used for SK once, I get an error: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (index SKMemoryIndex already exists)
To Reproduce
Steps to reproduce the behavior:
Expected behavior
I expect the database to be reopened and to be able to access my stored embedded documents.
Screenshots
If applicable, add screenshots to help explain your problem.
Platform
Additional context
The error is caused by a missing IF NOT EXISTS for the index creation in com.microsoft.semantickernel.connectors.memory.sqlite.Database.createTableAsync(...)