make test t/40listfields errors

Hi All,

i have huge problems with DBD::mysql. make works good but make test failed
with some errors (t/40listfields). So, particular functions to get column
types of a table doesn't work on my system. I tried to compile perl 5.8.3,
mysql 4.0.18, DBI 1.41 and DBD::mysql 2.9003 with one compiler (gcc 2.95.2)
as described in INSTALL.html (know problems) of DBD::mysql. I also tried
binary versions of mysql. No success.
If i use DBD::oracle to determine column types of a table in an Oracle
database, everything looks good. But with DBD::mysql i only get 12 for any
column type. This is also the error message from make test with verbose:
"Expected types 4 and 12, got 12 and 12".

What can i do?

Thanks, Falk.


Output:

bash-2.04# perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/local/mysql/include/mysql
libs (mysql_config)
= -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.42 (for perl 5.008003 on i686-linux) installed in
/usr/local/lib/perl5/site_perl/5.8.3/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
bash-2.04# make
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/local/lib/perl5/site_perl/5.8.3/i686-linux/auto/DBI -I/usr/loc
al/mysql/include/mysql -fno-strict-aliasing -I/usr/local/include -D_LARGEFIL
E_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DVERSION=\"2.9003\" -DXS_VERSION=\"2.
9003\" -fpic "-I/usr/local/lib/perl5/5.8.3/i686-linux/CORE" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/usr/local/lib/perl5/site_perl/5.8.3/i686-linux/auto/DBI/Dri ver.xst >
mysql.xsi
/usr/bin/perl /usr/local/lib/perl5/5.8.3/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.3/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 192
Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
cc -c -I/usr/local/lib/perl5/site_perl/5.8.3/i686-linux/auto/DBI -I/usr/loc
al/mysql/include/mysql -fno-strict-aliasing -I/usr/local/include -D_LARGEFIL
E_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DVERSION=\"2.9003\" -DXS_VERSION=\"2.
9003\" -fpic "-I/usr/local/lib/perl5/5.8.3/i686-linux/CORE" mysql.cRunning
Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/local/mysql/lib/mysql:/usr/local/lib" /usr/bin/perl myld
cc -shared -L/usr/local/lib dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/mysql/lib/mysql -lmysqlclie
nt -lz -lcrypt -lnsl -lm
chmod 755 blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
bash-2.04# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........ok
t/10dsnlist........ok
t/20createdrop.....ok
t/30insertfetch....ok
t/40bindparam......ok
t/40blobs..........ok
t/40listfields.....Use of uninitialized value in numeric eq (==) at
t/40listfields.t line 132.
t/40listfields.....FAILED tests 10-11
Failed 2/18 tests, 88.89% okay
t/40nulls..........ok
t/40numrows........ok
t/50chopblanks.....ok
t/50commit.........ok
t/60leaks..........skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not
installed
t/ak-dbd...........ok
t/akmisc...........ok 73/351Use of uninitialized value in array element at
t/akmisc.t line 667.
Use of uninitialized value in array element at t/akmisc.t line 667.
Use of uninitialized value in array element at t/akmisc.t line 667.
Use of uninitialized value in array element at t/akmisc.t line 667.
t/akmisc...........ok 342/351Use of uninitialized value in numeric eq (==)
at t/akmisc.t line 770.
t/akmisc...........FAILED tests 23, 27, 51, 76-77
Failed 5/351 tests, 98.58% okay
t/dbdadmin.........ok
t/insertid.........ok
t/mysql............FAILED tests 9, 11, 30, 51-53
Failed 6/68 tests, 91.18% okay
t/mysql2...........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ----------------
---
t/40listfields.t 18 2 11.11% 10-11
t/akmisc.t 351 5 1.42% 23 27 51 76-77
t/mysql.t 68 6 8.82% 9 11 30 51-53
1 test skipped.
Failed 3/18 test scripts, 83.33% okay. 13/767 subtests failed, 98.31% okay.
make: *** [test_dynamic] Error 29



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org