make test fails for DBD::ODBC on Solaris 5.8 with openlink driver
am 30.06.2006 11:02:07 von Duncan.BaillieHi,
I have perl 5.8.0 and Solaris 5.8 with the single tier ODBC driver for
connecting to SQL Server from OpenLink Software, along with their iODBC
driver manager.
This combination will make, but fails the tests. I don't think the
t/02simple are too much to worry about but can anyone help with the
failures on t/03dbatt.t and t/09multi.t?=20
I am unsure how much importance to attach to the failures and I
naturally don't want to put something into production I don't have full
confidence in.
Any help appreciated.
Duncan Baillie
ldnuxsrv017.DBD-ODBC-1.13: /usr/local/perl/5.8.0/bin/perl Makefile.PL
Useless use of private variable in void context at Makefile.PL line 431.
Configuring DBD::ODBC ...
>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.
Using DBI 1.51 (for perl 5.008 on sun4-solaris) installed in
/usr/local/perl/5.8.0/lib/site_perl/5.8.0/sun4-solaris/auto/ DBI/
Using ODBC in /home/baildun/openlink2/odbcsdk
Umm, this looks like a unixodbc type of driver manager.
We expect to find the sql.h, sqlext.h and (which were
supplied with unixODBC) in $ODBCHOME/include directory alongside
the /home/baildun/openlink2/odbcsdk/lib/libodbc.a
/home/baildun/openlink2/odbcsdk/lib/libodbc.so library. in $ODBCHOME/lib
Injecting selected odbc driver into cc command
Injecting selected odbc driver into cc command
Using DBI 1.51 (for perl 5.008 on sun4-solaris) installed in
/usr/local/perl/5.8.0/lib/site_perl/5.8.0/sun4-solaris/auto/ DBI/
Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=3Ddbi:ODBC:sql_lite e.g. dbi:ODBC:demo
DBI_USER=3D********
DBI_PASS=3D********
ldnuxsrv017.DBD-ODBC-1.13: make
cp Changes blib/lib/DBD/ODBC/Changes.pm
cp ODBC.pm blib/lib/DBD/ODBC.pm
/usr/local/perl/5.8.0/bin/perl -p -e "s/~DRIVER~/ODBC/g"
/usr/local/perl/5.8.0/lib/site_perl/5.8.0/sun4-solaris/auto/ DBI/Driver.x
st > ODBC.xsi
/usr/local/perl/5.8.0/bin/perl
/usr/local/perl/5.8.0/lib/5.8.0/ExtUtils/xsubpp -typemap
/usr/local/perl/5.8.0/lib/5.8.0/ExtUtils/typemap ODBC.xs > ODBC.xsc &&
mv ODBC.xsc ODBC.c
Warning: duplicate function definition 'data_sources' detected in
ODBC.xs, line 202
gcc -c -I/home/baildun/openlink2/odbcsdk/include -I.
-I/usr/local/perl/5.8.0/lib/site_perl/5.8.0/sun4-solaris/aut o/DBI
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 -O
-DVERSION=3D\"1.13\" -DXS_VERSION=3D\"1.13\" -fPIC
"-I/usr/local/perl/5.8.0/lib/5.8.0/sun4-solaris/CORE"
-I/home/baildun/openlink2/odbcsdk/include ODBC.c
gcc -c -I/home/baildun/openlink2/odbcsdk/include -I.
-I/usr/local/perl/5.8.0/lib/site_perl/5.8.0/sun4-solaris/aut o/DBI
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=3D64 -O
-DVERSION=3D\"1.13\" -DXS_VERSION=3D\"1.13\" -fPIC
"-I/usr/local/perl/5.8.0/lib/5.8.0/sun4-solaris/CORE"
-I/home/baildun/openlink2/odbcsdk/include dbdimp.c
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.so
LD_RUN_PATH=3D"/home/baildun/openlink2/odbcsdk/lib" gcc -G
-L/usr/local/lib ODBC.o dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.so
-L/home/baildun/openlink2/odbcsdk/lib -lodbc =20
chmod 755 blib/arch/auto/DBD/ODBC/ODBC.so
cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs
chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
Manifying blib/man3/DBD::ODBC.3
ldnuxsrv017.DBD-ODBC-1.13: make test TEST_VERBOSE=3D1
PERL_DL_NONLAZY=3D1 /usr/local/perl/5.8.0/bin/perl
"-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib',
'blib/arch')" t/*.t
t/01base.........1..5
ok 1 - require DBI;
ok 2 - import DBI
ok 3 - DBI->internal is DBI::dr
ok 4 - Install ODBC driver OK
ok 5 - Version is not empty
ok
t/02simple.......1..36
ok 1 - use DBI;
ok 2 - use ODBCTEST;
ok 3 - Set Auto commit
ok 4 - Auto commit retrieved to what was set
ok 5 - create test table
ok 6 - test table exists
ok 7 - insert test data
ok 8 - select test data
ok 9 - Set Long Read len
ok 10 - Set Long Truncok 1
ok 11 - Set Print Error
ok 12 - Select Long data
ok 13 - Set Long Truncok 0
ok 14 - Select Long Data failure
ok 15 - prepare select from table
ok 16 - Execute select
ok 17 - Col count matches correct col count
ok 18 - Set RaiseError 0
ok 19 - Set PrintError 0
ok 20 - Error reported on bad query
ok 21 - date check select
ok 22 - date check execute
ok 23 - date check rows
ok 24 - group by query prepare
ok 25 - group by query execute
ok 26 - group by query returned rows
ok 27 - data sources test
ok 28 - test ping method
ok 29 - Attrib odbc_ignore_named_placeholders 0 to start
ok 30 - Attrib odbc_ignore_named_placeholders set to 1
ok 31 - test connecting twice to the same database
ok 32 - database name is returned successfully
ok 33 - automatically finish when execute run again
ok 34 - INVALID DSN Test: [iODBC][Driver Manager]Data source name not
found and no default driver specified. Driver could not be loaded
(SQL-IM002)(DBD: db_login/SQLConnect err=3D-1)
#=20
# Failed test (t/02simple.t at line 170)
not ok 35 - Connection with DSN=3D
# Failed test (t/02simple.t at line 174)
not ok 36 - Connection with DSN=3D and uid and pwd are set
# Looks like you failed 2 tests of 36.
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 35-36
Failed 2/36 tests, 94.44% okay
t/03dbatt........1..24
ok 1 - use DBI;
ok 2 - use ODBCTEST;
ok 3 - Set Long Read Len
ok 4 - AutoCommit set on dbh
ok 5 - commitTest with AutoCommit
ok 6 - AutoCommit turned off
ok 7 - commitTest with AutoCommit off
ok 8 - Ensure autocommit back on
ok 9 - sth {NAME} returns ref to array isa ARRAY
not ok 10 - Column test for table_info 0
# Failed test (t/03dbatt.t at line 76)
# got: 'TABLE_QUALIFIER'
# expected: 'TABLE_CAT'
# Failed test (t/03dbatt.t at line 76)
# got: 'TABLE_OWNER'
# expected: 'TABLE_SCHEM'
not ok 11 - Column test for table_info 1
ok 12 - Column test for table_info 2
ok 13 - Column test for table_info 3
ok 14 - Column test for table_info 4
ok 15 - must be some tables out there?
ok 16 - tables returnes array
ok 17 - column info returns more than one row for test table
ok 18 - primary key count
ok 19 - prepare update statement returns valid sth=20
ok 20 - update statement has 0 columns returned
ok 21 - update statement has 0 columns returned 2
ok 22 - Verify odbc_query_timeout set ok
ok 23 - verify dbh setting for query_timeout passed to sth
ok 24 - verify sth query_timeout can be overridden
# Looks like you failed 2 tests of 24.
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 10-11
Failed 2/24 tests, 91.67% okay
t/05meth.........1..8
ok 1 - use DBI;
ok 2 - delete prepared statement
ok 3 - Number of rows > 0
ok 4 - Number of rows from DBI matches sth
ok 5 - finished and rolled back
ok 6 - no error
ok 7 - ?
ok 8 - ??
ok
t/07bind.........1..11
ok 1 - use ODBCTEST;
ok 2 - Create tables
ok 3 - Table insert test
ok 4 - Ensure long readlen set correctly
ok 5 - Select tests
ok 6 - Insert with bind tests
ok 7 - select long test data
ok 8 - update long test data
ok 9 - select long test data again
ok 10 - ParamValues test integer
ok 11 - Paramvalues test string
ok
t/08bind2........1..5
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 - insert \#1 various test data no dates, no long data
ok 4 - insert \#2 various test data no dates, with long data
ok 5 - insert \#3 various test data data with dates
ok
t/09multi........1..7
ok 1 - use strict;
ok 2 - use DBI;
ok 3 - use ODBCTEST;
# Failed test (t/09multi.t at line 73)
# got: '1'
# expected: '2'
not ok 4 - count number of result sets
ok 5 - Multiple result sets with different column counts (less then
more)
ok 6 - Multiple result sets with different column counts (more then
less)
ok 7 - Multiple result sets with multiple cols, then second result set
with one col
# Looks like you failed 1 tests of 7.
dubious
Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
Failed 1/7 tests, 85.71% okay
t/20SqlServer....1..37
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 4 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 5 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 6 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 7 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 8 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 9 # skip Microsoft SQL Server tests not supported using MS SQL Server
ok 10 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 11 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 12 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 13 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 14 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 15 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 16 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 17 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 18 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 19 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 20 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 21 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 22 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 23 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 24 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 25 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 26 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 27 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 28 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 29 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 30 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 31 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 32 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 33 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 34 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 35 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 36 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok 37 # skip Microsoft SQL Server tests not supported using MS SQL
Server=20
ok
35/37 skipped: Microsoft SQL Server tests not supported using MS
SQL Server=20
t/30Oracle.......1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip Oracle tests not supported using MS SQL Server=20
ok 4 # skip Oracle tests not supported using MS SQL Server=20
ok
2/4 skipped: various reasons
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ ------------
-------
t/02simple.t 2 512 36 2 5.56% 35-36
t/03dbatt.t 2 512 24 2 8.33% 10-11
t/09multi.t 1 256 7 1 14.29% 4
37 subtests skipped.
Failed 3/9 test scripts, 66.67% okay. 5/137 subtests failed, 96.35%
okay.
make: *** [test_dynamic] Error 29
ldnuxsrv017.DBD-ODBC-1.13:
ldnuxsrv017.DBD-ODBC-1.13: /usr/local/perl/5.8.0/bin/perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=3Dsolaris, osvers=3D2.8, archname=3Dsun4-solaris
uname=3D'sunos adm-rc-25 5.8 generic_108528-12 sun4u sparc
sunw,ultra-1 '
config_args=3D''
hint=3Drecommended, useposix=3Dtrue, d_sigaction=3Ddefine
usethreads=3Dundef use5005threads=3Dundef useithreads=3Dundef
usemultiplicity=3Dundef
useperlio=3Ddefine d_sfio=3Dundef uselargefiles=3Ddefine =
usesocks=3Dundef
use64bitint=3Dundef use64bitall=3Dundef uselongdouble=3Dundef
usemymalloc=3Dn, bincompat5005=3Dundef
Compiler:
cc=3D'gcc', ccflags =3D'-I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64',
optimize=3D'-O',
cppflags=3D'-I/usr/local/include'
ccversion=3D'', gccversion=3D'2.8.1', gccosandvers=3D'solaris2.6'
intsize=3D4, longsize=3D4, ptrsize=3D4, doublesize=3D8, =
byteorder=3D4321
d_longlong=3Ddefine, longlongsize=3D8, d_longdbl=3Ddefine, =
longdblsize=3D16
ivtype=3D'long', ivsize=3D4, nvtype=3D'double', nvsize=3D8, =
Off_t=3D'off_t',
lseeksize=3D8
alignbytes=3D8, prototype=3Ddefine
Linker and Libraries:
ld=3D'gcc', ldflags =3D' -L/usr/local/lib '
libpth=3D/usr/local/lib /usr/lib /usr/ccs/lib
libs=3D-lsocket -lnsl -ldl -lm -lc
perllibs=3D-lsocket -lnsl -ldl -lm -lc
libc=3D/lib/libc.so, so=3Dso, useshrplib=3Dfalse, =
libperl=3Dlibperl.a
gnulibc_version=3D''
Dynamic Linking:
dlsrc=3Ddl_dlopen.xs, dlext=3Dso, d_dlsymun=3Dundef, ccdlflags=3D' '
cccdlflags=3D'-fPIC', lddlflags=3D'-G -L/usr/local/lib'
Characteristics of this binary (from libperl):=20
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Aug 30 2002 11:11:43
%ENV:
=20
PERL5LIB=3D"/GAAS/dev/TPG/install/public/perllib:/GAAS/dev/A DG/install/pu=
b
lic/perllib:/GAAS/dev/ATG/install/public/perllib:"
@INC:
/GAAS/dev/TPG/install/public/perllib
/GAAS/dev/ADG/install/public/perllib
/GAAS/dev/ATG/install/public/perllib
/usr/local/perl/5.8.0/lib/5.8.0/sun4-solaris
/usr/local/perl/5.8.0/lib/5.8.0
/usr/local/perl/5.8.0/lib/site_perl/5.8.0/sun4-solaris
/usr/local/perl/5.8.0/lib/site_perl/5.8.0
/usr/local/perl/5.8.0/lib/site_perl
.
ldnuxsrv017.DBD-ODBC-1.13:=20
=20
--=20
=20
This message and any attachments are confidential, proprietary, and may =
be privileged. If this message was misdirected, Barclays Global =
Investors (BGI) does not waive any confidentiality or privilege. If you =
are not the intended recipient, please notify us immediately and destroy =
the message without disclosing its contents to anyone. Any =
distribution, use or copying of this e-mail or the information it =
contains by other than an intended recipient is unauthorized. The views =
and opinions expressed in this e-mail message are the author's own and =
may not reflect the views and opinions of BGI, unless the author is =
authorized by BGI to express such views or opinions on its behalf. All =
email sent to or from this address is subject to electronic storage and =
review by BGI. Although BGI operates anti-virus programs, it does not =
accept responsibility for any damage whatsoever caused by viruses being =
passed.=20
=20
--=20
=20
Barclays Global Investors Limited is authorized and regulated by The =
Financial Services Authority. Registered in England. Registered =
No:796793. Registered Office: 1 Churchill Place, London E14 5HP.