DBD::ODBC test

Main

PERL_DL_NONLAZY=1 /usr/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: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)
# 
ok 35 - Connection with DSN=
ok 36 - Connection with DSN= and uid and pwd are set
ok
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
ok 10 - Column test for table_info 0
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
ok
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 # skip SQLDescribeParam not supported using Microsoft SQL Server
# 
ok 4 # skip SQLDescribeParam not supported using Microsoft SQL Server
# 
ok 5 # skip SQLDescribeParam not supported using Microsoft SQL Server
# 
ok
        3/5 skipped: SQLDescribeParam not supported using Microsoft SQL Server
t/09multi........1..7
ok 1 - use strict;
ok 2 - use DBI;
ok 3 - use ODBCTEST;
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
ok
t/20SqlServer....1..37
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 - errors on data comparison
ok 4 - temporary table handling
ok 5 - bind param in out with insert result set
ok 6 - test output params accurate
ok 7 - verify select data
ok 8 - timestamp handling
ok 9 - procedure outputs results as result set
ok 10 - procedure outputs results as result set2
ok 11 - procedure outputs results as result set 3
ok 12 - setting force_rebind
ok 13 - resetting force_rebind
ok 14 - testing force rebind after procedure call
ok 15 - force rebind test part 2
ok 16 - force rebind test part 3
ok 17 - force rebind test part 4
ok 18 - forced rebind final
ok 19 - Select data available
ok 20 - output param not yet available
ok 21 - output param not yet available2
ok 22 - Output param data available
ok 23 - Output param data available 2
ok 24 - select data done
ok 25 - valid output data
ok 26 - test procedure with no input params
ok 27 - test odbc_async_exec attribute NOT set
===> state: 01000 msg: DBCC execution completed. If DBCC printed error messages, contact your system administrator. nativeerr: 2528
ok 28 - dbcc messages being returned
ok 29 - reset async exec
ok 30 - test setting odbc_exec_direct
===> state: 01000 msg: START nativeerr: 0
ok 31 - Valid select results with print statements
===> state: 01000 msg: END nativeerr: 0
ok 32 - ensure 2 error messages from two print statements
ok 33 - validate error messages being retrieved
===> state: 24000 msg: Invalid cursor state nativeerr: 0
ok 34 - Multiple concurrent statements should fail
ok 35 - Multiple concurrent statements succeed (odbc_cursortype set)
ok 36 - passed timeout on query using odbc_query_timeout using do with bind params
ok 37 - passed timeout on query using odbc_query_timeout using do without bind params
ok
t/30Oracle.......1..4
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 # skip Oracle tests not supported using Microsoft SQL Server
ok 4 # skip Oracle tests not supported using Microsoft SQL Server
ok
        2/4 skipped: Oracle tests not supported using Microsoft SQL Server
All tests successful, 5 subtests skipped.
Files=9, Tests=137, 10 wallclock secs ( 0.21 cusr +  3.54 csys =  3.75 CPU)

Main