Hi,
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?
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=dbi:ODBC:sql_lite e.g. dbi:ODBC:demo
DBI_USER=********
DBI_PASS=********
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/auto/DBI
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.13\" -DXS_VERSION=\"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/auto/DBI
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.13\" -DXS_VERSION=\"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="/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
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=1
PERL_DL_NONLAZY=1 /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=-1)
#
# Failed test (t/02simple.t at line 170)
not ok 35 - Connection with DSN=
# Failed test (t/02simple.t at line 174)
not ok 36 - Connection with DSN= 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
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
ok 11 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 12 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 13 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 14 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 15 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 16 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 17 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 18 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 19 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 20 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 21 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 22 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 23 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 24 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 25 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 26 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 27 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 28 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 29 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 30 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 31 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 32 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 33 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 34 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 35 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 36 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok 37 # skip Microsoft SQL Server tests not supported using MS SQL
Server
ok
35/37 skipped: Microsoft SQL Server tests not supported using MS
SQL Server
t/30Oracle.......1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip Oracle tests not supported using MS SQL Server
ok 4 # skip Oracle tests not supported using MS SQL Server
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=solaris, osvers=2.8, archname=sun4-solaris
uname='sunos adm-rc-25 5.8 generic_108528-12 sun4u sparc
sunw,ultra-1 '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-I/usr/local/include'
ccversion='', gccversion='2.8.1', gccosandvers='solaris2.6'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Aug 30 2002 11:11:43
%ENV:
PERL5LIB="/GAAS/dev/TPG/install/public/perllib:/GAAS/dev/ADG/install/pub
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:
--
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.
--
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.
