New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

A delete query for a table named "'transaction'" locks indefinitely #724

Open

ZakTaccardi opened this issue Nov 29, 2016 · 1 comment

Assignees

Labels

ZakTaccardi commented Nov 29, 2016

 val TABLE = "'transaction'" //notice the single quote escaping, because "transaction" is a sqlite reserved keyword
val QUERY_DELETE_ALL = DeleteQuery.builder().table(TABLE).build()

storIo.delete()
                .byQuery(QUERY_DELETE_ALL)
                .prepare()
                .executeAsBlocking()

I had to rename the table to be "transactions" to workaround the issue.

The text was updated successfully, but these errors were encountered:

Member

artem-zinnatullin commented Nov 29, 2016

Well, I guess SQLite just forbids deletion of this table, no? :) Can you please try to remove it using underlying SQLiteOpenHelper directly?

artem-zinnatullin added the question label

artem-zinnatullin self-assigned this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment