[Dbix-class] test failures in DBIx::Class v0.06999_03
Carl Franks
fireartist at gmail.com
Tue Jun 27 10:37:48 CEST 2006
I set the env variables DATA_DUMPER_TEST, DBICTEST_FORK_STRESS,
DBICTEST_THREAD_STRESS, DBICTEST_MYSQL_DSN, DBICTEST_MYSQL_USER and
DBICTEST_MYSQL_PASS
and got failures for:
t\71mysql.t
t\89dbicadmin.t
I'm running windows, with perl built with mingw gcc (no cygwin installed).
Here's my system info:
======================
Microsoft Windows XP [Version 5.1.2600]
>mysql --version
mysql Ver 14.7 Distrib 4.1.15, for Win32 (ia32)
>perl -v
This is perl, v5.8.8 built for MSWin32-x86-multi-thread
>pmversion DBI
DBI 1.50
>pmversion DBD::mysql
DBD::mysql 3.0002
>pmversion DBD::SQLite
DBD::SQLite 1.12
Here's the output of "Build test"
=================================
>Build test
t\02pod.........................ok
t\03podcoverage.................ok
46/83 skipped: No real methods
t\04dont_break_c3...............ok
t\05components..................ok
t\18inserterror.................ok
t\19quotes......................ok
t\20setuperrors.................ok
t\26dumper......................ok
t\30dbicplain...................ok
t\31stats.......................ok
t\32connect_code_ref............ok
t\40resultsetmanager............ok
t\41orrible.....................ok
t\42toplimit....................ok
t\50fork........................skipped
all skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
(note: creates and drops a table named artist!)
t\51threads.....................skipped
all skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
(note: creates and drops a table named artist!)
t\52cycle.......................ok
t\53delete_related..............ok
t\60core........................ok
t\64db..........................ok
t\65multipk.....................ok
t\66relationship................ok
1/54 skipped: relationship checking needs fixing
t\67pager.......................ok
t\68inflate.....................ok
t\68inflate_has_a...............ok
t\68inflate_serialize...........ok
t\69update......................ok
t\70auto........................ok
t\71mysql.......................NOK 5
# Failed test 'columns_info_for - column data types'
# in t\71mysql.t at line 71.
# Structures begin differing at:
# $got->{charfield}{data_type} = 'VARCHAR'
# $expected->{charfield}{data_type} = 'CHAR'
# Looks like you failed 1 test of 5.
t\71mysql.......................dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 5
Failed 1/5 tests, 80.00% okay
t\72pg..........................skipped
all skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
(note: creates and drops tables named artist and casecheck!)
t\73oracle......................skipped
all skipped: Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this tes
t. Warning: This test drops and creates tables called 'artist', 'cd' and 'track'
t\745db2........................skipped
all skipped: Set $ENV{DBICTEST_DB2_DSN}, _USER and _PASS to run this tes
t
t\746db2_400....................skipped
all skipped: Set $ENV{DBICTEST_DB2_400_DSN}, _USER and _PASS to run this
test
t\74mssql.......................skipped
all skipped: Set $ENV{DBICTEST_MSSQL_DSN}, _USER and _PASS to run this t
est
t\75limit.......................ok
t\76joins.......................ok
t\77join_count..................ok
t\78self_referencial............ok
t\80unique......................ok
t\81transactions................ok
t\82cascade_copy................ok
t\83cache.......................ok
t\84serialize...................ok
t\85utf8........................ok
t\86might_have..................ok
t\86sqlt........................ok
t\87ordered.....................ok
t\88result_set_column...........ok
t\89dbicadmin...................Can't use string ("[dbi:SQLite:dbname=t/var/DBIx
Cla") as an ARRAY ref while "strict refs" in use at script/dbicadmin line 54.
t\89dbicadmin...................NOK 1
# Failed test 'insert count'
# in t\89dbicadmin.t at line 26.
Can't call method "name" on an undefined value at t\89dbicadmin.t line 29.
# Looks like you planned 5 tests but only ran 1.
# Looks like you failed 1 test of 1 run.
# Looks like your test died just after 1.
t\89dbicadmin...................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t\89inflate_datetime............ok
t\90ensure_class_loaded.........ok
t\90join_torture................ok
t\91debug.......................ok
t\92storage.....................ok
t\cdbi-sweet-t\08pager..........ok
t\cdbi-t\01-columns.............ok
1/24 skipped: No column objects
t\cdbi-t\02-Film................ok
5/96 skipped: various reasons
t\cdbi-t\03-subclassing.........ok
t\cdbi-t\04-lazy................ok
t\cdbi-t\06-hasa................ok
t\cdbi-t\09-has_many............ok
t\cdbi-t\11-triggers............ok
t\cdbi-t\12-filter..............ok
t\cdbi-t\13-constraint..........ok
2/23 skipped: No column objects
t\cdbi-t\14-might_have..........ok
t\cdbi-t\15-accessor............ok 1/53DBD::SQLite::db prepare_cached failed: no
such column: sheep(1) at dbdimp.c line 269 at C:\Documents and Settings\cafrank
s\Desktop\DBIx-Class-0.06999_03\blib\lib/DBIx/Class/Storage/DBI.pm line 754.
t\cdbi-t\15-accessor............ok
t\cdbi-t\16-reserved............ok
t\cdbi-t\18-has_a...............ok
9/41 skipped: Non-standard CDBI relationships not supported by compat
t\cdbi-t\19-set_sql.............ok
t\cdbi-t\21-iterator............ok
t\cdbi-t\22-self_referential....ok
t\cdbi-t\30-pager...............ok
t\cdbi-t\98-failure.............ok 1/7closing dbh with active statement handles
t\cdbi-t\98-failure.............ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t\71mysql.t 1 256 5 1 20.00% 5
t\89dbicadmin.t 255 65280 5 9 180.00% 1-5
7 tests and 64 subtests skipped.
Failed 2/73 test scripts, 97.26% okay. 6/1466 subtests failed, 99.59% okay.
btw, I also got warnings from the Build stage, because of bad L<links>
in the pod.
Warnings from "Build"
=====================
>Build
HTMLifying blib\script\dbicadmin -> blib\binhtml\bin\dbicadmin.html
Build: blib\script\dbicadmin: cannot resolve L<JSON> in paragraph 47.
HTMLifying blib\lib\DBIx\Class\Storage\Statistics.pm -> blib\libhtml\site\lib\DB
Ix\Class\Storage\Statistics.html
Build: blib\lib\DBIx\Class\Storage\Statistics.pm: cannot resolve L<DBIX_CLASS_ST
ORAGE_DBI_DEBUG> in paragraph 16.
HTMLifying blib\lib\DBIx\Class\Schema.pm -> blib\libhtml\site\lib\DBIx\Class\Sch
ema.html
Build: blib\lib\DBIx\Class\Schema.pm: cannot resolve L<use> in paragraph 74.
HTMLifying blib\lib\DBIx\Class\Manual\Cookbook.pod -> blib\libhtml\site\lib\DBIx
\Class\Manual\Cookbook.html
Build: blib\lib\DBIx\Class\Manual\Cookbook.pod: cannot resolve L<SchemaIntro.pod
> in paragraph 136.
HTMLifying blib\lib\DBIx\Class\ResultSet.pm -> blib\libhtml\site\lib\DBIx\Class\
ResultSet.html
Build: blib\lib\DBIx\Class\ResultSet.pm: cannot resolve L<+select> in paragraph
461.
HTMLifying blib\lib\DBIx\Class\Storage\DBI.pm -> blib\libhtml\site\lib\DBIx\Clas
s\Storage\DBI.html
Build: blib\lib\DBIx\Class\Storage\DBI.pm: cannot resolve L<DBIX_CLASS_STORAGE_D
BI_DEBUG> in paragraph 62.
Also, after specifically setting DBICTEST_FORK_STRESS and
DBICTEST_THREAD_STRESS, it was disappointing that the tests were still
skipped because I don't have access to a PG database.
Could those tests be changed to check for all of the X_DSN settings,
and use the first it comes across?
Carl
More information about the Dbix-class
mailing list