| Subject: | Various issues with MySQL V 5 under WinXP SP2 |
D:\perl-modules\Rose-DB-Object-0.63>nmake test
Microsoft (R) Program Maintenance Utility Version 6.00.9782.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.
D:\Perl\bin\perl.exe "-MExtUtils::Command::MM" "-
e" "test_harness(0, 'blib\lib', 'blib\arch')" t/*.t
t/00-warning.......................
##
## WARNING: Almost all the tests in this module distribution need to
connect
## to a database in order to run. The tests need full privileges on
this
## database: the ability to create and drop tables, insert, update,
and delete
## rows, create schemas, sequences, functions, triggers, the works.
##
## By default, the tests will try to connect to the database
named "test"
## running on "localhost" using the default superuser username for each
## database type and an empty password.
##
## If you have setup your database in a secure manner, these connection
## attempts will fail, and the tests will be skipped. If you want to
override
## these values, set the following environment variables before
running tests.
## (The current values are shown in parentheses.)
##
## Postgres:
##
## RDBO_PG_DSN (dbi:Pg:dbname=test;host=localhost)
## RDBO_PG_USER (postgres)
## RDBO_PG_PASS (<none>)
##
## MySQL:
##
## RDBO_MYSQL_DSN (dbi:mysql:database=test;host=localhost)
## RDBO_MYSQL_USER (root)
## RDBO_MYSQL_PASS (Set by me on command line)
##
## Informix:
##
## RDBO_INFORMIX_DSN (dbi:Informix:test@test)
## RDBO_INFORMIX_USER (<none>)
## RDBO_INFORMIX_PASS (<none>)
##
## SQLite: To disable the SQLite tests, set this environment varible
##
## RDBO_NO_SQLITE (<undef>)
##
## Press return to continue (or wait 60 seconds)
t/00-warning.......................ok
t/column-triggers..................ok 1/259DBD::mysql::st execute
failed: Incorrect datetime value: '11/22/2003' for column 'ended' at
row 1
at D:\perl-modules\Rose-DB-Object-0.63\blib\lib/Rose/DB/Object.pm
line 823.
insert() - DBD::mysql::st execute failed: Incorrect datetime
value: '11/22/2003' for column 'ended' at row 1 at D:\perl-
modules\Rose-DB-Obje
ct-0.63\blib\lib/Rose/DB/Object.pm line 823.
at t/column-triggers.t line 292
# Looks like you planned 259 tests but only ran 226.
# Looks like your test died just after 226.
t/column-triggers..................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 227-259
Failed 33/259 tests, 87.26% okay (less 132 skipped tests: 94
okay, 36.29%)
t/db-migration.....................ok
32/33 skipped: migration tests
t/db-object-auto...................ok 1/266DBD::mysql::db do failed:
Invalid default value for 'bits' at t/db-object-auto.t line 824.
DBD::mysql::db do failed: Invalid default value for 'bits' at t/db-
object-auto.t line 824.
BEGIN failed--compilation aborted at t/db-object-auto.t line 1057.
t/db-object-auto...................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3-266
Failed 264/266 tests, 0.75% okay
t/db-object-cached.................ok 1/407DBD::mysql::db do failed:
Invalid default value for 'bits' at t/db-object-cached.t line 947.
DBD::mysql::db do failed: Invalid default value for 'bits' at t/db-
object-cached.t line 947.
BEGIN failed--compilation aborted at t/db-object-cached.t line 1161.
t/db-object-cached.................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-407
Failed 406/407 tests, 0.25% okay
t/db-object-convention.............ok
t/db-object-foreign-key-auto.......ok
191/257 skipped: various reasons
t/db-object-foreign-key............ok 1/187DBD::mysql::db do failed:
Invalid default value for 'bits' at t/db-object-foreign-key.t line 800.
DBD::mysql::db do failed: Invalid default value for 'bits' at t/db-
object-foreign-key.t line 800.
BEGIN failed--compilation aborted at t/db-object-foreign-key.t line
1214.
t/db-object-foreign-key............dubious
Test returned status 9 (wstat 2304, 0x900)
DIED. FAILED tests 2-187
Failed 186/187 tests, 0.53% okay
t/db-object-loader-2...............ok
68/86 skipped: various reasons
t/db-object-loader-3...............ok
48/61 skipped: various reasons
t/db-object-loader-4...............ok
68/86 skipped: various reasons
t/db-object-loader-5...............ok
132/161 skipped: various reasons
t/db-object-loader-6...............ok
134/161 skipped: various reasons
t/db-object-loader.................ok
69/84 skipped: various reasons
t/db-object-manager-bulk-ops.......ok
123/208 skipped: various reasons
t/db-object-manager................ok
1425/2887 skipped: various reasons
t/db-object-mapper.................ok 1/315DBD::mysql::db do failed:
Invalid default value for 'bitz' at t/db-object-mapper.t line 906.
DBD::mysql::db do failed: Invalid default value for 'bitz' at t/db-
object-mapper.t line 906.
BEGIN failed--compilation aborted at t/db-object-mapper.t line 1224.
t/db-object-mapper.................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-315
Failed 314/315 tests, 0.32% okay
t/db-object-metadata...............ok
t/db-object-relationship-auto-2....ok
72/92 skipped: various reasons
t/db-object-relationship-auto......ok
72/92 skipped: various reasons
t/db-object-relationship...........ok 1/1443DBD::mysql::db do failed:
Invalid default value for 'bits' at t/db-object-relationship.t line 59
19.
DBD::mysql::db do failed: Invalid default value for 'bits' at t/db-
object-relationship.t line 5919.
BEGIN failed--compilation aborted at t/db-object-relationship.t line
6805.
t/db-object-relationship...........dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3-1443
Failed 1441/1443 tests, 0.14% okay
t/db-object-std-cached.............ok 1/241DBD::mysql::db do failed:
Invalid default value for 'bits' at t/db-object-std-cached.t line 628.
DBD::mysql::db do failed: Invalid default value for 'bits' at t/db-
object-std-cached.t line 628.
BEGIN failed--compilation aborted at t/db-object-std-cached.t line 817.
t/db-object-std-cached.............dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-241
Failed 240/241 tests, 0.41% okay
t/db-object-std....................ok 1/185DBD::mysql::db do failed:
Invalid default value for 'bits' at t/db-object-std.t line 565.
DBD::mysql::db do failed: Invalid default value for 'bits' at t/db-
object-std.t line 565.
BEGIN failed--compilation aborted at t/db-object-std.t line 754.
t/db-object-std....................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3-185
Failed 183/185 tests, 1.08% okay
t/db-object........................ok 1/344DBD::mysql::db do failed:
Invalid default value for 'bitz' at t/db-object.t line 941.
DBD::mysql::db do failed: Invalid default value for 'bitz' at t/db-
object.t line 941.
BEGIN failed--compilation aborted at t/db-object.t line 1324.
t/db-object........................dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3-344
Failed 342/344 tests, 0.58% okay
t/deep-joins.......................ok
1196/1496 skipped: various reasons
t/lazy-columns.....................ok
45/80 skipped: various reasons
t/makemethods-db...................ok
24/51 skipped: various reasons
t/makemethods......................ok
29/125 skipped: various reasons
t/multi-pk-sequences...............ok
48/50 skipped: various reasons
t/pod..............................ok
t/schema-override..................ok
7/8 skipped: pg tests
t/spot-check-01....................ok
48/82 skipped: various reasons
t/spot-check-02....................ok
24/32 skipped: various reasons
t/spot-check-03....................ok
t/spot-check-04....................ok
4/6 skipped: various reasons
t/spot-check-05....................ok
Failed Test Stat Wstat Total Fail Failed List of
Failed
-----------------------------------------------------------------------
--------
t/column-triggers.t 255 65280 259 66 25.48% 227-259
t/db-object-auto.t 2 512 266 528 198.50% 3-266
t/db-object-cached.t 2 512 407 812 199.51% 2-407
t/db-object-foreign-key.t 9 2304 187 372 198.93% 2-187
t/db-object-mapper.t 2 512 315 628 199.37% 2-315
t/db-object-relationship.t 2 512 1443 2882 199.72% 3-1443
t/db-object-std-cached.t 2 512 241 480 199.17% 2-241
t/db-object-std.t 2 512 185 366 197.84% 3-185
t/db-object.t 2 512 344 684 198.84% 3-344
3991 subtests skipped.
Failed 9/36 test scripts, 75.00% okay. 3409/10044 subtests failed,
66.06% okay.
NMAKE : fatal error U1077: 'D:\Perl\bin\perl.exe' : return code '0xff'
Stop.
(2)
Perl 5.8.7