Hi Jeff,
i tried .45_18 but still get the same results
here is the ouput from:
perl Makefile.PL
make
make test
make test TEST_VERBOSE=1
Hope u can help.
regards
Darren Edgerton
-----Original Message-----
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 October 2002 12:53 PM
To: Darren Edgerton; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: DBD-ODBC core dumps (atexit)
Try upgrading to .45_18. You'll need an ODBC v3 compliant driver manager.
0.43 was the last (or near the last) version which built against
Check out http://search.cpan.org/author/JURL/DBD-ODBC/Changes
This was fixed in .45_12.
Regards,
Jeff
>
> Hi Jeff,
>
> i am having a problem with the DBD::ODBC module and i have
> noticed a number
> of posts
> on mailing lists for the same thing ... and thought i might go straight to
> the source
>
> i have:-
> Perl 5.6.1
> AIX 4.3.3
> DBI-1.30
> DBD::ODBC-0.43
>
>
> ---- very simple DBI script ----
> #!/usr/local/bin/perl
>
> use DBI;
> use DBD::ODBC;
>
> my $dbh = DBI->connect('dbi:ODBC:raider','myuserid','mypasswd');
> $dbh->disconnect();
> ---------------------------------
>
> when i run this script it exits with error message:
> "Illegal Instruction(coredump)"
>
> i have had an AIX 'guru' do some debugging for me and he can see
> that it is
> getting a NULL
> pointer inside the exit (atexit) function ???
>
> the other posts that i have seen relate to differing databases on
> differing
> Os's the
> common link is DBD::ODBC
>
> do you have any clues as to how i get around this ????
>
>
>
> regards
> Darren Edgerton
>
> ===================================================================
> Darren Edgerton
> IT Operations Manager
> Reece Australia Limited
> Ph: +613 9274 0000 Fax: +613 9274 0199
> Email: [EMAIL PROTECTED] Web: http://www.reece.com.au
> ===================================================================
>
>
>
Script command is started on Thu Oct 10 14:25:43 CDT 2002.
[root@redbrick] /tmp/DBD-ODBC-0.45_18>perl Makefile.PL
DynaLoader.pm loaded (/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl ., /usr/local/lib /lib /usr/lib /usr/ccs/lib /usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
dl_load_file(/usr/local/lib/perl5/5.6.1/aix/auto/File/Glob/Glob.so,0):
Configuring DBD::ODBC ...
>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.
Using DBI 1.30 installed in /usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI
Using ODBC in /redbrick/app/client_products
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 /redbrick/app/client_products/lib/libodbc.a library. in $ODBCHOME/lib
Use of uninitialized value in pattern match (m//) at Makefile.PL line 221.
Warning: LD_LIBRARY_PATH doesn't include /redbrick/app/client_products
Using DBI 1.30 installed in /usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI
Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=dbi:ODBC:raider e.g. dbi:ODBC:demo
DBI_USER=reece
DBI_PASS=reece
[root@redbrick] /tmp/DBD-ODBC-0.45_18>make
cc -c -I. -I/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DDEBUGGING -I/usr/local/include -q32
-D_LARGE_FILES -qlonglong -g -DVERSION=\"0.45_18\" -DXS_VERSION=\"0.45_18\"
-I/usr/local/lib/perl5/5.6.1/aix/CORE -I/redbrick/app/client_products/include ODBC.c
"dbdimp.h", line 41.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.h", line 42.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.h", line 87.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.h", line 88.9: 1506-342 (W) "/*" detected in comment.
cc -c -I. -I/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -DDEBUGGING -I/usr/local/include -q32
-D_LARGE_FILES -qlonglong -g -DVERSION=\"0.45_18\" -DXS_VERSION=\"0.45_18\"
-I/usr/local/lib/perl5/5.6.1/aix/CORE -I/redbrick/app/client_products/include dbdimp.c
"dbdimp.h", line 41.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.h", line 42.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.h", line 87.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.h", line 88.9: 1506-342 (W) "/*" detected in comment.
"dbdimp.c", line 2578.66: 1506-342 (W) "/*" detected in comment.
Running Mkbootstrap for DBD::ODBC ()
DynaLoader.pm loaded (/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl ., /usr/local/lib /lib /usr/lib /usr/ccs/lib /usr/lib)
chmod 644 ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.so
LD_RUN_PATH="/redbrick/app/client_products/lib" ld -bhalt:4 -bM:SRE
-bI:/usr/local/lib/perl5/5.6.1/aix/CORE/perl.exp -bE:ODBC.exp -b noentry -lC -lc
-L/usr/local/lib ODBC.o dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.so
-L/redbrick/app/client_products/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
Target "makemakerdflt" is up to date.
[root@redbrick] /tmp/DBD-ODBC-0.45_18>make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.1/aix -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness
qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/01base............DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl ., /usr/local/lib /lib /usr/lib /usr/ccs/lib /usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/01base............ok 1/5
t/01base............ok 2/5
t/01base............ok 3/5
t/01base............ok 4/5
t/01base............ok 5/5
t/01base............ok
t/02simple..........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
t/02simple..........ok 1/17DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/02simple..........ok 2/17Unable to find a suitable test type for field COL_C at
t/ODBCTEST.pm line 63.
t/02simple..........dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3-17
Failed 15/17 tests, 11.76% okay
t/03dbatt...........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
t/03dbatt...........ok 1/16DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/03dbatt...........ok 2/16DBD::ODBC::db do failed: [unixODBC][Red Brick][ODBC
Driver][Warehouse]** ERROR ** (92) The table 'PERL_DBD_TEST' is not present in the
database. (SQL-HY000)(DBD: Execute immediate failed err=-1) at t/03dbatt.t line 112.
Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 38.
Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 39.
t/03dbatt...........NOK 3
t/03dbatt...........ok 4/16
t/03dbatt...........ok 5/16
t/03dbatt...........ok
6/16DBD::ODBC::db do failed: [unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR **
(92) The table 'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD:
Execute immediate failed err=-1) at t/03dbatt.t line 112.
Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 47.
Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 48.
t/03dbatt...........ok 7/16
t/03dbatt...........ok 8/16
t/03dbatt...........ok 9/16
t/03dbatt...........ok 10/16
t/03dbatt...........ok 11/16
t/03dbatt...........ok 12/16
t/03dbatt...........NOK 13
t/03dbatt...........ok 14/16
t/03dbatt...........NOK 15
t/03dbatt...........ok 16/16
t/03dbatt...........dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3, 13, 15
Failed 3/16 tests, 81.25% okay
t/05meth............DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
t/05meth............ok 1/6DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/05meth............ok 2/6DBD::ODBC::db prepare failed: [unixODBC][Red Brick][ODBC
Driver][Warehouse]** ERROR ** (92) The table 'PERL_DBD_TEST' is not present in the
database. (SQL-HY000)(DBD: st_prepare/SQLPrepare err=-1) at t/05meth.t line 29.
Can't call method "execute" on an undefined value at t/05meth.t line 30.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect().
t/05meth............dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3-6
Failed 4/6 tests, 33.33% okay
t/07bind............DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
t/07bind............ok 1/10DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/07bind............ok 2/10Unable to find a suitable test type for field COL_C at
t/ODBCTEST.pm line 63.
t/07bind............dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3-10
Failed 8/10 tests, 20.00% okay
t/08bind2...........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
[unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92) The table
'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD: st_prepare/SQLPrepare
err=-1) at t/ODBCTEST.pm line 186.
These are tests which rely upon the driver to tell what the parameter type is for the
column. This means you need to ensure you tell your driver the type of the column in
bind_col().
t/08bind2...........NOK 1[unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92)
The table 'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD:
st_prepare/SQLPrepare err=-1) at t/ODBCTEST.pm line 186.
t/08bind2...........NOK 2[unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92)
The table 'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD:
st_prepare/SQLPrepare err=-1) at t/ODBCTEST.pm line 186.
t/08bind2...........NOK 3
t/08bind2...........dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 1-3
Failed 3/3 tests, 0.00% okay
t/09multi...........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/09multi...........dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
t/20SqlServer.......DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
dl_load_file(/usr/local/lib/perl5/5.6.1/aix/auto/Data/Dumper/Dumper.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/20SqlServer.......dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
t/30Oracle..........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
t/30Oracle..........dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
Failed Test Status Wstat Total Fail Failed List of Failed
--------------------------------------------------------------------------------
t/02simple.t 0 132 17 15 88.24% 3-17
t/03dbatt.t 0 132 16 3 18.75% 3, 13, 15
t/05meth.t 0 132 6 4 66.67% 3-6
t/07bind.t 0 132 10 8 80.00% 3-10
t/08bind2.t 0 132 3 3 100.00% 1-3
t/09multi.t 0 132 ?? ?? % ??
t/20SqlServer.t 0 132 ?? ?? % ??
t/30Oracle.t 0 132 ?? ?? % ??
Failed 8/9 test scripts, 11.11% okay. 33/57 subtests failed, 42.11% okay.
make: 1254-004 The error code from the last command is 2.
Stop.
[root@redbrick] /tmp/DBD-ODBC-0.45_18>make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/lib/perl5/5.6.1/aix -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness
qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t
t/01base............DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl ., /usr/local/lib /lib /usr/lib /usr/ccs/lib /usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/02simple..........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
1..17
ok 1
Test 2: connecting to the database
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
ok 2
Test 3: create test table
Unable to find a suitable test type for field COL_C at t/ODBCTEST.pm line 63.
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3-17
Failed 15/17 tests, 11.76% okay
t/03dbatt...........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
1..16
ok 1
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
ok 2
DBD::ODBC::db do failed: [unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92)
The table 'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD: Execute
immediate failed err=-1) at t/03dbatt.t line 112.
Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 38.
Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 39.
not ok 3
ok 4
ok 5
ok 6
DBD::ODBC::db do failed: [unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92)
The table 'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD: Execute
immediate failed err=-1) at t/03dbatt.t line 112.
Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 47.
Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 48.
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
not ok 13
ok 14
not ok 15
ok 16
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3, 13, 15
Failed 3/16 tests, 81.25% okay
t/05meth............DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
1..6
ok 1
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
ok 2
DBD::ODBC::db prepare failed: [unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR **
(92) The table 'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD:
st_prepare/SQLPrepare err=-1) at t/05meth.t line 29.
Can't call method "execute" on an undefined value at t/05meth.t line 30.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect().
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3-6
Failed 4/6 tests, 33.33% okay
t/07bind............DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
1..10
ok 1
Test 2: connecting to the database
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
ok 2
Test 3: create test table
Unable to find a suitable test type for field COL_C at t/ODBCTEST.pm line 63.
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 3-10
Failed 8/10 tests, 20.00% okay
t/08bind2...........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
1..3
Test 1: insert various test data, without having this test tell the driver the type
that is being bound to a column. This tests the use of SQLDescribeParam to
obtain
the column type on the insert. This is experimental and will most likely
fail.
[unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92) The table
'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD: st_prepare/SQLPrepare
err=-1) at t/ODBCTEST.pm line 186.
These are tests which rely upon the driver to tell what the parameter type is for the
column. This means you need to ensure you tell your driver the type of the column in
bind_col().
not ok 1
[unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92) The table
'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD: st_prepare/SQLPrepare
err=-1) at t/ODBCTEST.pm line 186.
not ok 2
[unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR ** (92) The table
'PERL_DBD_TEST' is not present in the database. (SQL-HY000)(DBD: st_prepare/SQLPrepare
err=-1) at t/ODBCTEST.pm line 186.
not ok 3
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
DIED. FAILED tests 1-3
Failed 3/3 tests, 0.00% okay
t/09multi...........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
1..0 # Skipped multiple statements not supported using Red Brick Warehouse
DBD::ODBC::db prepare failed: [unixODBC][Red Brick][ODBC Driver][Warehouse]** ERROR **
(87) Invalid syntax '...COL_A FROM PERL_DBD_TEST <==>SELECT'. (SQL-HY000)(DBD:
st_prepare/SQLPrepare err=-1) at t/09multi.t line 45.
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
t/20SqlServer.......DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
dl_load_file(/usr/local/lib/perl5/5.6.1/aix/auto/Data/Dumper/Dumper.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
1..0 # Skipped: Microsoft SQL Server tests not supported using Red Brick Warehouse
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
t/30Oracle..........DynaLoader bind mode is 'non-lazy'
DynaLoader.pm loaded (blib/arch blib/lib /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/aix
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl/5.6.1/aix
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .
/usr/local/lib/perl5/5.6.1/aix /usr/local/lib/perl5/5.6.1
/usr/local/lib/perl5/site_perl/5.6.1/aix /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl . ../t, /usr/local/lib /lib /usr/lib /usr/ccs/lib
/usr/lib)
DynaLoader::bootstrap for DBI (auto/DBI/DBI.so)
dl_load_file(/usr/local/lib/perl5/site_perl/5.6.1/aix/auto/DBI/DBI.so,0):
DynaLoader::bootstrap for DBD::ODBC (auto/DBD/ODBC/ODBC.so)
dl_load_file(blib/arch/auto/DBD/ODBC/ODBC.so,0):
1..0 # Skipped: Oracle tests not supported using Red Brick Warehouse
dubious
Test returned status 0 (wstat 132, 0x84)
test program seems to have generated a core
Failed Test Status Wstat Total Fail Failed List of Failed
--------------------------------------------------------------------------------
t/02simple.t 0 132 17 15 88.24% 3-17
t/03dbatt.t 0 132 16 3 18.75% 3, 13, 15
t/05meth.t 0 132 6 4 66.67% 3-6
t/07bind.t 0 132 10 8 80.00% 3-10
t/08bind2.t 0 132 3 3 100.00% 1-3
t/09multi.t 0 132 ?? ?? % ??
t/20SqlServer.t 0 132 ?? ?? % ??
t/30Oracle.t 0 132 ?? ?? % ??
Failed 8/9 test scripts, 11.11% okay. 33/57 subtests failed, 42.11% okay.
make: 1254-004 The error code from the last command is 2.
Stop.
[root@redbrick] /tmp/DBD-ODBC-0.45_18>
Script command is complete on Thu Oct 10 14:26:19 CDT 2002.
