Bug #68863 for DBIx-Class-VirtualColumns: Test do not pass anymore

Thu Jun 16 06:57:52 2011 nicolas [...] oudard.org - Ticket created

Subject:	Test do not pass anymore
Date:	Thu, 16 Jun 2011 12:57:24 +0200
To:	bug-DBIx-Class-VirtualColumns [...] rt.cpan.org
From:	Nicolas Oudard <nicolas [...] oudard.org>

Hi, I try to use DBIx::Class::VirtualColumns but I have a problem when I try to pass tests. t/006_relation.t ..... 1/3 # Failed test 'Create row with relation that has loaded VC but has no VCs defined' # at t/006_relation.t line 37. # DBIx::Class::ResultSet::create(): DBI Exception: DBD::SQLite::db begin_work failed: Already in a transaction at t/006_relation.t line 29 # Looks like you failed 1 test of 3. I don't know if it is on your side or not. Do you have a solution ? Thank you, Nicolas

Tue Sep 04 11:47:37 2012 karl.forner [...] gmail.com - Correspondence added

From:

karl.forner [...] gmail.com

Same on my side, and also tested in a completely independent ubuntu virtualbox image. After some digging, it seems that it is related with the DBIx::class create that handles the creation of the related row. I tried to remove all the VirtualColumns from the tables but it does not change anything. It seems related with sqlite and nested transactions...

Tue Sep 04 11:47:38 2012 The RT System itself - Status changed from 'new' to 'open'

Fri Jan 04 18:42:47 2013 nonsolosoft [...] diff.org - Correspondence added

From:

nonsolosoft [...] diff.org

Il Gio 16 Giu 2011 06:57:52, nicolas@oudard.org ha scritto: Show quoted text

> Hi, > > I try to use DBIx::Class::VirtualColumns but I have a problem when I

try to Show quoted text

> pass tests.

Same here with BSD. Both using FreeBSD 9.x and perl 5.16.2 and DragonFlyBSD using perl 5.14. Best regards, \ferz

Fri Jul 05 04:47:20 2013 ribasushi [...] leporine.io - Correspondence added

On Thu Jun 16 06:57:52 2011, nicolas@oudard.org wrote: Show quoted text

> Hi, > > I try to use DBIx::Class::VirtualColumns but I have a problem when I try to > pass tests. > > t/006_relation.t ..... 1/3 > # Failed test 'Create row with relation that has loaded VC but has no VCs > defined' > # at t/006_relation.t line 37. > # DBIx::Class::ResultSet::create(): DBI Exception: DBD::SQLite::db > begin_work failed: Already in a transaction at t/006_relation.t line 29 > # Looks like you failed 1 test of 3. > > I don't know if it is on your side or not. Do you have a solution ?

The solution is to change the split-regex found here https://metacpan.org/source/MAROS/DBIx-Class-VirtualColumns-1.03/t/lib/VCTest.pm#L42 to /\s*\;\s*/ This is due to older versions of DBD::SQLite not properly parsing multi-line begin/commit keywords. Another option is to require DBD::SQLite 1.39, but this is lame, especially given that it requires a C compiler (thus hard to update).