Running:
Ubuntu
Linux jaxnetutility 2.6.31-14-generic-pae #48-Ubuntu SMP Fri Oct 16 15:22:42
UTC 2009 i686 GNU/Linux
Perl 5.10
unixODBC 2.2.11
/var/cache/apt/archives/freetds-common_0.82-6_all.deb
/var/cache/apt/archives/freetds-dev_0.82-6_i386.deb
/var/cache/apt/archives/tdsodbc_0.82-6_i386.deb
I get the following....
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(1,
'blib/lib', 'blib/arch')" t/*.t
t/01base.t ...................
1..6
ok 1 - require DBI;
ok 2 - import DBI
ok 3 - DBI->internal is DBI::dr
ok 4 - install ODBC
ok 5 - Install ODBC driver OK
ok 6 - Version is not empty
ok
t/02simple.t .................
1..65
ok 1 - use DBI;
ok 2 - use ODBCTEST;
ok 3 - ReadOnly set
ok 4 - ReadOnly cleared
ok 5 - dbc private_attribute_info result
ok 6 - dbc private_attribute_info is hashref
ok 7 - dbc private_attribute_info has some attributes
#
# Perl 5.10.0
# osname=linux, osvers=2.6.24-23-server, archname=i486-linux-gnu-thread-multi
# Using DBI 1.616
# Using DBD::ODBC 1.31
# Using DBMS_NAME 'Microsoft SQL Server'
# Using DBMS_VER '09.00.4266'
# Using DRIVER_NAME 'libtdsodbc.so'
# Using DRIVER_VER '0.82'
# odbc_has_unicode 0
ok 8 - stmt private_attribute_info result
ok 9 - stmt private_attribute_info is hashref
ok 10 - stmt private_attribute_info has some attributes
ok 11 - Set Auto commit off
ok 12 - Auto commit off retrieved
ok 13 - Set Auto commit on
ok 14 - Auto commit on restored
ok 15 - create test table
ok 16 - test table exists
ok 17 - insert test data
ok 18 - NUM_OF_FIELDS
ok 19 - NAME returns right number of columns
ok 20 - column name for column 1
ok 21 - column name for column 2
ok 22 - column name for column 3
ok 23 - column name for column 4
ok 24 - long strings compare
ok 25 - long strings compare 255
ok 26 - select test data
ok 27 - Get LongReadLen starting value
ok 28 - LongReadLen is numeric
ok 29 - Set LongReadLen
ok 30 - Read changed LongReadLen back
ok 31 - Get LongTruncOk starting value
ok 32 - Set LongTruncOk on
ok 33 - LongTruncOk on
ok 34 - Set Print Error
ok 35 - Select Long data, LongTruncOk
ok 36 - err not set on LongTruncOk handle
ok 37 - Truncated column to LongReadLen
ok 38 - Set Long TruncOk 0
ok 39 - Select Long Data failure
ok 40 - error set on truncated handle
ok 41 - errstr set on truncated handle
ok 42 - state set on truncated handle
ok 43 - prepare select from table
ok 44 - Execute select
ok 45 - NUM_OF_FIELDS = ColAttributes(SQL_COLUMN_COUNT)
ok 46 - Col count matches correct col count
ok 47 - Set RaiseError 0
ok 48 - Set PrintError 0
ok 49 - Error reported on bad query
ok 50 - date check select
ok 51 - date check execute
ok 52 - date check rows
ok 53 - group by query prepare
ok 54 - group by query execute
ok 55 - group by query returned rows
ok 56 - data sources test
ok 57 - test ping method
ok 58 - Attrib odbc_ignore_named_placeholders 0 to start
ok 59 - Attrib odbc_ignore_named_placeholders set to 1
ok 60 - test connecting twice to the same database
ok 61 - database name is returned successfully
ok 62 - automatically finish when execute run again
ok 63 - INVALID DSN Test: [unixODBC][Driver Manager]Data source name not found,
and no default driver specified (SQL-IM002)
#
ok 64 - Connection with DSN=dbi:ODBC:DSN=ORION
ok 65 - Connection with DSN=dbi:ODBC:DSN=ORION and UID and PWD are set
ok
t/03dbatt.t ..................
1..29
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?
#
# N.B. Some drivers (postgres/cache) may return ODBC 2.0 column names for the
SQLTables result-set e.g. TABLE_QUALIFIER instead of T ABLE_CAT
ok 16 - tables returns 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 default dbh odbc_query_timeout = 0
ok 23 - verify default sth odbc_query_timeout = 0
ok 24 - Verify odbc_query_timeout set ok
ok 25 - verify dbh setting for query_timeout passed to sth
ok 26 - verify sth query_timeout can be overridden
ok 27 - verify default for odbc_column_display_size
ok 28 - set odbc_column_display_size
ok 29 - verify changed odbc_column_display_size
ok
t/05meth.t ...................
1..13
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 9 - Active
ok 10 - ping
ok 11 - disconnect
ok 12 - Active
ok 13 - ping
ok
t/07bind.t ...................
1..25
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 returns a hash ref
ok 11 - ParamValues test integer
ok 12 - Paramvalues test string
ok 13 - ParamValues returns a hash ref
ok 14 - p1 exists
ok 15 - p2 exists
ok 16 - p1 is a hash reference
ok 17 - p2 is a hash reference
ok 18 - p1 TYPE exists
ok 19 - p2 TYPE exists
ok 20 - numeric SQL type on p1
ok 21 - numeric SQL type on p2
ok 22 - insert with numbered placeholders
ok 23 - ...inserted one row
ok 24 - insert with named placeholders
ok 25 - ...inserted one row
ok
t/08bind2.t ..................
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
t/09multi.t ..................
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/10handler.t ................
1..11
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 - Error handler called
ok 4 - Error handler called - state seen
ok 5 - Error handler called - message seen
ok 6 - Error handler called - native seen
ok 7 - Error handler called - error passed on
ok 8 - Error handler called - error propagated
ok 9 - Handler cancelled
ok 10 - Handler filtered all messages
ok 11 - eval complete
ok
t/12blob.t ...................
1..24
ok 1 - use ODBCTEST;
ok 2 - default putdata_start
ok 3 - GetTypeInfo
ok 4 - table DBD_ODBC_drop_me created
ok 5 - prepare for insert
ok 6 - insert clob
ok 7 - select test data back
ok 8 - sizes of insert/select compare
ok 9 - data read back compares
ok 10 - delete records from test table
ok 11 - retrieved putdata_start = set value
ok 12 - prepare for insert
ok 13 - insert clob
ok 14 - select test data back
ok 15 - sizes of insert/select compare
ok 16 - data read back compares
ok 17 - delete records from test table
ok 18 - retrieved putdata_start = set value
ok 19 - prepare for insert
ok 20 - insert clob
ok 21 - select test data back
not ok 22 - sizes of insert/select compare
ok 23 # skip sizes do not match
# Failed test 'sizes of insert/select compare'
# at t/12blob.t line 144.
# got: '32256'
# expected: '60000'
ok 24 - delete records from test table
# Looks like you failed 1 test of 24.
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/24 subtests
(less 1 skipped subtest: 22 okay)
t/20SqlServer.t ..............
1..65
ok 1 - use ODBCTEST;
ok 2 - use Data::Dumper;
ok 3 - got DBMS name: Microsoft SQL Server
ok 4 - got DBMS version: 09.00.4266
ok 5 - got DBMS major version: 09
ok 6 - got Driver Name: libtdsodbc.so
ok 7 - create PERL_DBD_TABLE1 and insert test data
ok 8 - fetchrow for varchar(max)
ok 9 - data received from varchar(max)
ok 10 - all data (1000) received from varchar(max)
ok 11 - create PERL_DBD_TABLE1 and insert test data
ok 12 - fetchrow for varbinary(max)
ok 13 - data received from varbinary(max)
ok 14 - all data (1000) received from varbinary(max)
ok 15 - create PERL_DBD_TABLE1 and insert test data
ok 16 - fetchrow for nvarchar(max)
ok 17 - data received from nvarchar(max)
ok 18 - all data (1000) received from nvarchar(max)
ok 19 - create perl_dbd_proc1 procedure
ok 20 - create perl_dbd_proc2 procedure
ok 21 - prepare for PERL_DBD_PROC1
ok 22 - execute for PERL_DBD_PROC1
ok 23 - NUM_OF_FIELDS for PERL_DBD_PROC1
ok 24 - numeric fields
ok 25 - prepare for PERL_DBD_PROC2
ok 26 - execute for PERL_DBD_PROC2
ok 27 - NUM_OF_FIELDS for PERL_DBD_PROC2
ok 28 - numeric fields
ok 29 - errors on data comparison
ok 30 - temporary table handling
ok 31 - bind param in out with insert result set
ok 32 - test output params accurate
ok 33 - verify select data
ok 34 - timestamp handling
ok 35 - procedure outputs results as result set
ok 36 - procedure outputs results as result set2
ok 37 - procedure outputs results as result set 3
ok 38 - setting force_rebind
ok 39 - resetting force_rebind
ok 40 - testing force rebind after procedure call
ok 41 - force rebind test part 2
ok 42 - force rebind test part 3
ok 43 - force rebind test part 4
ok 44 - forced rebind final
ok 45 - Select data available
ok 46 - output param not yet available
ok 47 - output param not yet available2
ok 48 - Output param data available
ok 49 - Output param data available 2
ok 50 - select data done
ok 51 - valid output data
ok 52 - test procedure with no input params
not ok 53 - test odbc_async_exec attribute set
# Failed test 'test odbc_async_exec attribute set'
# at t/20SqlServer.t line 614.
# got: '0'
# expected: '1'
ok 54 - dbcc messages being returned
ok 55 - reset async exec
ok 56 - test setting odbc_exec_direct
ok 57 - Valid select results with print statements
ok 58 - ensure 2 error messages from two print statements
ok 59 - validate error messages being retrieved
ok 60 - Connected with MARS_Connection
ok 61 - Multiple concurrent statements should fail
