Subject: | DBD::DBM failure |
Show quoted text
> prove -bv t/25-sql.t
t/25-sql.t ..
1..54
ok 1 - The object isa Test::Database::Driver
# Testing driver CSV 0.72, DBD::CSV 0.28
ok 2 - CSV tdd_csv_daxim_1 isa Test::Database::Handle
ok 3 - The object isa DBI::db
ok 4 - CSV(tdd_csv_daxim_1): CREATE TABLE users (id INTEGER, name
VARCHAR(64))
ok 5 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (1, 'book')
ok 6 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (2, 'echo')
ok 7 - CSV(tdd_csv_daxim_1): SELECT id, name FROM users
ok 8 - CSV(tdd_csv_daxim_1): DROP TABLE users
ok 9 - CSV tdd_csv_daxim_1 isa Test::Database::Handle
ok 10 - Got db tdd_csv_daxim_1 again
ok 11 - The object isa DBI::db
ok 12 - CSV(tdd_csv_daxim_1): CREATE TABLE users (id INTEGER, name
VARCHAR(64))
ok 13 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (1,
'book')
ok 14 - CSV(tdd_csv_daxim_1): INSERT INTO users (id, name) VALUES (2,
'echo')
ok 15 - CSV(tdd_csv_daxim_1): SELECT id, name FROM users
ok 16 - CSV(tdd_csv_daxim_1): DROP TABLE users
ok 17 - Database tdd_csv_daxim_1 still there
ok 18 - Database tdd_csv_daxim_1 was dropped
# Testing driver DBM 0.03, DBD::DBM 0.03
ok 19 - The object isa Test::Database::Driver
ok 20 - DBM tdd_dbm_daxim_1 isa Test::Database::Handle
ok 21 - The object isa DBI::db
DBD::DBM::db do failed:
Execution ERROR: Table 'users' already exists..
[for Statement "CREATE TABLE users (id INTEGER, name VARCHAR(64))"] at
t/25-sql.t line 56.
not ok 22 - DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER, name
VARCHAR(64))
# Failed test 'DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER,
name VARCHAR(64))'
# at t/25-sql.t line 56.
DBD::DBM::db do failed: Use of uninitialized value in array element at
/home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297.
[for Statement "INSERT INTO users (id, name) VALUES (1, 'book')"] at
t/25-sql.t line 56.
not ok 23 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES
(1, 'book')
# Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name)
VALUES (1, 'book')'
# at t/25-sql.t line 56.
DBD::DBM::db do failed: Use of uninitialized value in array element at
/home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297.
[for Statement "INSERT INTO users (id, name) VALUES (2, 'echo')"] at
t/25-sql.t line 56.
not ok 24 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES
(2, 'echo')
# Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name)
VALUES (2, 'echo')'
# at t/25-sql.t line 56.
DBD::DBM::db selectall_arrayref failed: Can't call method "column" on an
undefined value at
/home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement/Term.pm line 190.
[for Statement "SELECT id, name FROM users"] at t/25-sql.t line 59.
not ok 25 - DBM(tdd_dbm_daxim_1): SELECT id, name FROM users
# Failed test 'DBM(tdd_dbm_daxim_1): SELECT id, name FROM users'
# at t/25-sql.t line 60.
# Structures begin differing at:
# $got = undef
# $expected = ARRAY(0x1549400)
ok 26 - DBM(tdd_dbm_daxim_1): DROP TABLE users
ok 27 - DBM tdd_dbm_daxim_1 isa Test::Database::Handle
ok 28 - Got db tdd_dbm_daxim_1 again
ok 29 - The object isa DBI::db
DBD::DBM::db do failed:
Execution ERROR: Table 'users' already exists..
[for Statement "CREATE TABLE users (id INTEGER, name VARCHAR(64))"] at
t/25-sql.t line 56.
not ok 30 - DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER, name
VARCHAR(64))
# Failed test 'DBM(tdd_dbm_daxim_1): CREATE TABLE users (id INTEGER,
name VARCHAR(64))'
# at t/25-sql.t line 56.
DBD::DBM::db do failed: Use of uninitialized value in array element at
/home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297.
[for Statement "INSERT INTO users (id, name) VALUES (1, 'book')"] at
t/25-sql.t line 56.
not ok 31 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES
(1, 'book')
# Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name)
VALUES (1, 'book')'
# at t/25-sql.t line 56.
DBD::DBM::db do failed: Use of uninitialized value in array element at
/home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement.pm line 297.
[for Statement "INSERT INTO users (id, name) VALUES (2, 'echo')"] at
t/25-sql.t line 56.
not ok 32 - DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name) VALUES
(2, 'echo')
# Failed test 'DBM(tdd_dbm_daxim_1): INSERT INTO users (id, name)
VALUES (2, 'echo')'
# at t/25-sql.t line 56.
DBD::DBM::db selectall_arrayref failed: Can't call method "column" on an
undefined value at
/home/daxim/local/lib/perl5/site_perl/5.10.1/SQL/Statement/Term.pm line 190.
[for Statement "SELECT id, name FROM users"] at t/25-sql.t line 59.
not ok 33 - DBM(tdd_dbm_daxim_1): SELECT id, name FROM users
# Failed test 'DBM(tdd_dbm_daxim_1): SELECT id, name FROM users'
# at t/25-sql.t line 60.
# Structures begin differing at:
# $got = undef
# $expected = ARRAY(0x1529f88)
ok 34 - DBM(tdd_dbm_daxim_1): DROP TABLE users
ok 35 - Database tdd_dbm_daxim_1 still there
ok 36 - Database tdd_dbm_daxim_1 was dropped
# Testing driver SQLite 3.6.22, DBD::SQLite 1.29
ok 37 - The object isa Test::Database::Driver
ok 38 - SQLite tdd_sqlite_daxim_1 isa Test::Database::Handle
ok 39 - The object isa DBI::db
ok 40 - SQLite(tdd_sqlite_daxim_1): CREATE TABLE users (id INTEGER, name
VARCHAR(64))
ok 41 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES
(1, 'book')
ok 42 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES
(2, 'echo')
ok 43 - SQLite(tdd_sqlite_daxim_1): SELECT id, name FROM users
ok 44 - SQLite(tdd_sqlite_daxim_1): DROP TABLE users
ok 45 - SQLite tdd_sqlite_daxim_1 isa Test::Database::Handle
ok 46 - Got db tdd_sqlite_daxim_1 again
ok 47 - The object isa DBI::db
ok 48 - SQLite(tdd_sqlite_daxim_1): CREATE TABLE users (id INTEGER, name
VARCHAR(64))
ok 49 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES
(1, 'book')
ok 50 - SQLite(tdd_sqlite_daxim_1): INSERT INTO users (id, name) VALUES
(2, 'echo')
ok 51 - SQLite(tdd_sqlite_daxim_1): SELECT id, name FROM users
ok 52 - SQLite(tdd_sqlite_daxim_1): DROP TABLE users
ok 53 - Database tdd_sqlite_daxim_1 still there
ok 54 - Database tdd_sqlite_daxim_1 was dropped
# Looks like you failed 8 tests of 54.
Dubious, test returned 8 (wstat 2048, 0x800)
Failed 8/54 subtests
Test Summary Report
-------------------
t/25-sql.t (Wstat: 2048 Tests: 54 Failed: 8)
Failed tests: 22-25, 30-33
Non-zero exit status: 8
Files=1, Tests=54, 1 wallclock secs ( 0.10 usr 0.01 sys + 0.42 cusr
0.07 csys = 0.60 CPU)
Result: FAIL
Show quoted text> perl -V
Summary of my perl5 (revision 5 version 10 subversion 1) configuration:
Platform:
osname=linux, osvers=2.6.27.29-0.1-default,
archname=x86_64-linux-thread-multi-ld
uname='linux galahad 2.6.27.29-0.1-default #1 smp 2009-08-15
17:53:59 +0200 x86_64 x86_64 x86_64 gnulinux '
config_args='-Accflags=-fPIC -DDEBUGGING -DPERL_USE_SAFE_PUTENV
-Dcf_email=daxim@cpan.org -Dhtml1dir=/home/daxim/local/share/doc/perl5
-Dhtml3dir=/home/daxim/local/share/doc/perl5 -Dnoextensions=ODBM_File
-Dman1dir=/home/daxim/local/share/man/man1
-Dman3dir=/home/daxim/local/share/man/man3 -Dperladmin=daxim@cpan.org
-Dprefix=/home/daxim/local -Dusemorebits -Dusethreads -des'
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=define, uselongdouble=define
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fPIC -DDEBUGGING
-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2 -g',
cppflags='-D_REENTRANT -D_GNU_SOURCE -fPIC -DDEBUGGING
-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
ccversion='', gccversion='4.3.2 [gcc-4_3-branch revision 141291]',
gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='long double', nvsize=16,
Off_t='off_t', lseeksize=8
alignbytes=16, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64 /usr/local/lib64
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lcrypt -lutil -lpthread -lc
-lgdbm_compat
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.9.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.9'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib
-fstack-protector'
Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING MULTIPLICITY PERL_DONT_CREATE_GVSV
PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
PERL_TRACK_MEMPOOL USE_64_BIT_ALL USE_64_BIT_INT
USE_ITHREADS USE_LARGE_FILES USE_LONG_DOUBLE
USE_PERLIO USE_REENTRANT_API
Built under linux
Compiled at Oct 16 2009 18:50:04
%ENV:
PERL_EXTUTILS_AUTOINSTALL="--default-deps"
@INC:
/home/daxim/local/lib/perl5/5.10.1/x86_64-linux-thread-multi-ld
/home/daxim/local/lib/perl5/5.10.1
/home/daxim/local/lib/perl5/site_perl/5.10.1/x86_64-linux-thread-multi-ld
/home/daxim/local/lib/perl5/site_perl/5.10.1
.