Bug #106151 for DBD-SQLite: SAVEPOINT bug

Wed Jul 29 22:51:18 2015 felipe [...] felipegasper.com - Ticket created

Subject:	SAVEPOINT bug
Date:	Wed, 29 Jul 2015 21:50:44 -0500
To:	bug-DBD-SQLite [...] rt.cpan.org
From:	Felipe Gasper <felipe [...] felipegasper.com>

=========== #!/usr/bin/perl use DBI; { my $dbh = DBI->connect('dbi:SQLite::memory:'); $dbh->do('SAVEPOINT haha'); $dbh->selectall_arrayref('SELECT * FROM sqlite_master'); $dbh->do('RELEASE haha'); } =========== ^^ The above yields the following when run: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::SQLite::db handle :memory: at - line 6. It happens with on-disk DBs as well as in-memory ones. It does NOT happen if I switch from savepoints to regular transactions. -FG

Tue Aug 04 07:19:36 2015 ishigaki [...] cpan.org - Correspondence added

On Thu Jul 30 11:51:18 2015, felipe@felipegasper.com wrote: Show quoted text

> =========== > #!/usr/bin/perl > > use DBI; > > { > my $dbh = DBI->connect('dbi:SQLite::memory:'); > > $dbh->do('SAVEPOINT haha'); > > $dbh->selectall_arrayref('SELECT * FROM sqlite_master'); > > $dbh->do('RELEASE haha'); > } > =========== > > ^^ The above yields the following when run: > > Issuing rollback() due to DESTROY without explicit disconnect() of > DBD::SQLite::db handle :memory: at - line 6. > > It happens with on-disk DBs as well as in-memory ones. > > It does NOT happen if I switch from savepoints to regular transactions. > > -FG

Thanks. Fixed with https://github.com/DBD-SQLite/DBD-SQLite/commit/f7dde96931042ebf1eebba4cb1e43ebd94782818

Tue Aug 04 07:19:39 2015 The RT System itself - Status changed from 'new' to 'open'

Tue Aug 04 07:19:42 2015 ishigaki [...] cpan.org - Status changed from 'open' to 'patched'

Tue Aug 04 14:18:53 2015 felipe [...] felipegasper.com - Correspondence added

Subject:	Re: [rt.cpan.org #106151] SAVEPOINT bug
Date:	Tue, 4 Aug 2015 14:18:35 -0400
To:	bug-DBD-SQLite [...] rt.cpan.org
From:	Felipe Gasper <felipe [...] felipegasper.com>

Thank you! :) -FG On 4 Aug 2015 7:19 AM, Kenichi Ishigaki via RT wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=106151 > > > On Thu Jul 30 11:51:18 2015, felipe@felipegasper.com wrote:

>> =========== >> #!/usr/bin/perl >> >> use DBI; >> >> { >> my $dbh = DBI->connect('dbi:SQLite::memory:'); >> >> $dbh->do('SAVEPOINT haha'); >> >> $dbh->selectall_arrayref('SELECT * FROM sqlite_master'); >> >> $dbh->do('RELEASE haha'); >> } >> =========== >> >> ^^ The above yields the following when run: >> >> Issuing rollback() due to DESTROY without explicit disconnect() of >> DBD::SQLite::db handle :memory: at - line 6. >> >> It happens with on-disk DBs as well as in-memory ones. >> >> It does NOT happen if I switch from savepoints to regular transactions. >> >> -FG

> > Thanks. Fixed with https://github.com/DBD-SQLite/DBD-SQLite/commit/f7dde96931042ebf1eebba4cb1e43ebd94782818 >

Wed Feb 10 10:08:20 2016 ishigaki [...] cpan.org - Correspondence added

Closed as 1.50 was shipped. Thanks.

Wed Feb 10 10:08:29 2016 ishigaki [...] cpan.org - Status changed from 'patched' to 'resolved'