This queue is for tickets about the DBIx-Class-VirtualColumns CPAN distribution.

Report information
The Basics
Id:
68863
Status:
open
Priority:
Low/Low

People
Owner:
Nobody in particular
Requestors:
nicolas [...] oudard.org
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



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
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...
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
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).


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.