search

Grinnz / Mojo-SQLite

Mojo::SQLite - A tiny Mojolicious wrapper for SQLite
https://metacpan.org/pod/Mojo::SQLite
Other
27 stars 12 forks source link

Rollback/commit with unfinished SELECT statement doesn't work correctly #1

Closed Grinnz closed 9 years ago

Grinnz commented 9 years ago

For instance:

my $results;
{
  my $tx = $db->begin;
  $results = $db->query('SELECT * from foo');
}
# Database is still locked here
Grinnz commented 9 years ago

This is actually because the active statement handle is holding a lock, not the transaction.