DBI::SQL_DATETIME - Invalid data type (SQL-HY004)
"Bower, Wayne (Wayne)" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
I attached a test case showing a failure to recognize the DBI::SQL_DATETIME type using perl 5.14.1, DBI 1.616, DBD::ODBC 1.33 with freeTDS 0.91 and unixODBC on Linux. The 1st attachment (test_sql_types.pl) is the script that demonstrates the problem. And the 2nd attachment (test_sql_types.log) is from DBI_TRACE=15=test_sql_types_dbi.log ./test_sql_types.pl >test_sql_types.log 2>&1 And the 3rd attachment (test_sql_types_dbi.log) is the DBI_TRACE output. The script creates a procedure with input parameters of different types and executes it resulting in the following error: DBD::ODBC::st bind_param failed: [FreeTDS][SQL Server]Invalid data type (SQL-HY004) If I specify DBI::SQL_DATETIME as the type it fails with this error, but if I change the type to DBI::SQL_TIMESTAMP it works. It also works if I do not specify the type. In fact we have changed to not specifying the type because this seems to work well for any parameter type. I'm not sure if you would consider this a bug or if I overlooked something in the documentation about the SQL_DATETIME data type. The DBD::ODBC developer already reviewed this and believes the issue to be with FreeTDS if it is one. Thank you, Wayne Bower _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
test_sql_types.pl
(application/octet-stream, 2.9 KB)
#!/tools/cfr/perl/5.14.1/bin/perl
use strict;
use DBI;
select STDERR; $| = 1;
select STDOUT; $| = 1;
our ($ERROR_CODE, $ERROR_STRING, $WARNING_STRING);
my $db = 'Test_Perl_DBI';
# my $host = 'pausql02.lsi.com\\dev;Port=1433';
# my $driv = '/tools/cfr/tdsodbc/0.64/lib/libtdsodbc.so';
# my $src = "DBI:ODBC:Database=$db;Server=$host;Driver=$driv;TDS_Version=8.0";
my $host = 'pausql02.lsi.com\\dev';
my $driv = '/tools/cfr/tdsodbc/0.91/lib/libtdsodbc.so';
my $src = "DBI:ODBC:Database=$db;Server=$host;Driver=$driv;TDS_Version=7.2";
my $user = 'test';
my $pass = 'test';
my $dbh;
for (my $i = 0 ; $i < 3 ; $i++) {
$dbh =
DBI->connect ($src, $user, $pass,
{
PrintError => 0,
RaiseError => 0,
AutoCommit => 0,
}
) and last;
warn "Attempt #$i failed to connect - $DBI::errstr\n";
sleep 1;
}
if ($dbh) {
$dbh->{RaiseError} = 1;
}
else {
exit 1;
}
my ($i, $sp, $sth, $rv);
my $proc = 'TMP_SP_Test_ODBC';
print "\nCreate $proc to test input param types\n";
eval {
$dbh->do (
"CREATE PROCEDURE [$proc]" . '
@IBIT bit,
@ITINT tinyint,
@ICHAR char,
@ISINT smallint,
@IINT int,
@IBINT bigint,
@IFLOAT float,
@IREAL real,
@ICHAR10 char,
@IVCHAR10 varchar,
@IDATETIME datetime
AS
SET NOCOUNT ON
RETURN 9
'
)
};
if ($@ || $dbh->err) {
die "Failed to create $proc\n",
"$@\n",
"$DBI::errstr\n";
}
print "exec $proc using SQL_DATETIME causes Invalid data type (SQL-HY004)\n";
$rv = undef;
$sp = "? = call $proc (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
if ($sth = $dbh->prepare ("{ $sp }")) {
$i = 1;
$sth->bind_param_inout ($i++, \$rv, 4);
$sth->bind_param ($i++, 1, DBI::SQL_BIT);
$sth->bind_param ($i++, 200, DBI::SQL_TINYINT);
$sth->bind_param ($i++, 'A', DBI::SQL_CHAR);
$sth->bind_param ($i++, 30000, DBI::SQL_SMALLINT);
$sth->bind_param ($i++, 2000000000, DBI::SQL_INTEGER);
$sth->bind_param ($i++, 99999999999, DBI::SQL_BIGINT);
$sth->bind_param ($i++, 55.55, DBI::SQL_FLOAT);
$sth->bind_param ($i++, 123.123, DBI::SQL_REAL);
$sth->bind_param ($i++, 'c10', DBI::SQL_CHAR);
$sth->bind_param ($i++, 'vc10', DBI::SQL_VARCHAR);
$sth->bind_param ($i++, '2011-10-10 10:10:10', DBI::SQL_DATETIME)
or
warn "Error: execute $proc bind_param failed\n",
"err=$DBI::err\n",
"errstr=$DBI::errstr\n";
eval { $sth->execute; };
if ($@) {
warn "Error: execute $proc failed\n",
"err=$DBI::err\n",
"errstr=$DBI::errstr\n";
}
}
else {
warn "Error: Prepare $proc failed\n",
"err=$DBI::err\n",
"errstr=$DBI::errstr\n";
}
$sth->finish;
print "$proc rv=<$rv>\n";
print "Drop $proc\n";
eval { $dbh->do ("DROP PROCEDURE $proc") };
eval { $dbh->commit; };
if ($@) {
die "Commit failed - $DBI::errstr\n";
exit 1;
}
$dbh->disconnect;
test_sql_types.log
(application/octet-stream, 3.1 KB)
0x2a00 DBI::db::get_info 0x10000 DBI::db::take_imp_data 0x10c00 DBI::db::disconnect 0x2000 DBI::db::selectrow_array 0x2200 DBI::db::tables 0x0430 DBI::db::quote_identifier 0x0000 DBI::db::clone 0x0430 DBI::db::quote 0x2200 DBI::db::type_info 0xaa00 DBI::db::statistics_info 0x2000 DBI::db::selectrow_arrayref 0x0400 DBI::db::begin_work 0x2800 DBI::db::last_insert_id 0xaa00 DBI::db::foreign_key_info 0x2200 DBI::db::primary_key 0x0c80 DBI::db::commit 0x0404 DBI::db::ping 0x2000 DBI::db::selectall_arrayref 0x2a00 DBI::db::type_info_all 0x3200 DBI::db::do 0x2000 DBI::db::selectcol_arrayref 0xa200 DBI::db::prepare_cached 0x0004 DBI::db::rows 0x0c80 DBI::db::rollback 0xaa00 DBI::db::column_info 0xaa00 DBI::db::table_info 0xaa00 DBI::db::primary_key_info 0xa200 DBI::db::prepare 0x0000 DBI::db::preparse 0x0004 DBI::db::connected 0x0200 DBI::db::data_sources 0x2000 DBI::db::selectall_hashref 0x2000 DBI::db::selectrow_hashref 0x0000 DBI::dr::default_user 0x0800 DBI::dr::data_sources 0x0004 DBI::dr::dbixs_revision 0x0800 DBI::dr::disconnect_all 0x8000 DBI::dr::connect_cached 0x8000 DBI::dr::connect 0x0000 DBI::st::more_results 0x0000 DBI::st::blob_read 0x0000 DBI::st::fetchall_hashref 0x0000 DBI::st::bind_param_inout_array 0x0000 DBI::st::finish 0x0004 DBI::st::rows 0x5040 DBI::st::execute_for_fetch 0x0000 DBI::st::fetchrow_hashref 0x0000 DBI::st::_get_fbav 0x0000 DBI::st::_set_fbav 0x0000 DBI::st::fetchrow 0x0000 DBI::st::fetch 0x5040 DBI::st::execute_array 0x0000 DBI::st::dump_results 0x0000 DBI::st::bind_param_array 0x0000 DBI::st::fetchrow_array 0x1040 DBI::st::execute 0x0000 DBI::st::bind_col 0x0000 DBI::st::fetchall_arrayref 0x0000 DBI::st::fetchrow_arrayref 0x0000 DBI::st::bind_param_inout 0x0000 DBI::st::bind_columns 0x0800 DBI::st::cancel 0x0000 DBI::st::blob_copy_to_file 0x0000 DBI::st::bind_param 0x0404 DBI::common::parse_trace_flag 0x0004 DBI::common::errstr 0x0004 DBI::common::trace_msg 0x0004 DBI::common::err 0x0004 DBI::common::CLEAR 0x0004 DBI::common::state 0x0000 DBI::common::_not_impl 0x0004 DBI::common::NEXTKEY 0x0004 DBI::common::trace 0x0004 DBI::common::debug 0x0404 DBI::common::parse_trace_flags 0x0000 DBI::common::private_attribute_info 0x0000 DBI::common::swap_inner_handle 0x0004 DBI::common::EXISTS 0x0404 DBI::common::visit_child_handles 0x0404 DBI::common::FETCH 0x0004 DBI::common::FIRSTKEY 0x0010 DBI::common::set_err 0x10004 DBI::common::DESTROY 0x0004 DBI::common::dump_handle 0x0404 DBI::common::FETCH_many 0x0100 DBI::common::can 0x041c DBI::common::STORE 0x0004 DBI::common::private_data 0x0006 DBI::common::func Create TMP_SP_Test_ODBC to test input param types exec TMP_SP_Test_ODBC using SQL_DATETIME causes Invalid data type (SQL-HY004) DBD::ODBC::st bind_param failed: [FreeTDS][SQL Server]Invalid data type (SQL-HY004) at ./test_sql_types.pl line 91. Issuing rollback() due to DESTROY without explicit disconnect() of DBD::ODBC::db handle Database=Test_Perl_DBI;Server=pausql02.lsi.com\dev;Driver=/tools/cfr/tdsodbc/0.91/lib/libtdsodbc.so;TDS_Version=7.2 at ./test_sql_types.pl line 91.
test_sql_types_dbi.log
(application/octet-stream, 33.7 KB)
DBI 1.616-ithread default trace level set to 0x0/15 (pid 19935 pi 659010) at DBI.pm line 278 via test_sql_types.pl line 4
install_method DBI::db::get_info , flags 0x2a00,
usage: min 2, max 2, '$info_type'
install_method DBI::db::take_imp_data, flags 0x10000,
usage: min 1, max 1, ''
install_method DBI::db::disconnect , flags 0x10c00,
usage: min 1, max 1, ''
install_method DBI::db::selectrow_array, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::tables , flags 0x2200,
usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ]'
install_method DBI::db::quote_identifier, flags 0x0430,
usage: min 2, max 6, '$name [, ...] [, \%attr ]'
install_method DBI::db::clone ,
usage: min 1, max 2, '[\%attr]'
install_method DBI::db::quote , flags 0x0430,
usage: min 2, max 3, '$string [, $data_type ]'
install_method DBI::db::type_info , flags 0x2200,
usage: min 1, max 2, '$data_type'
install_method DBI::db::statistics_info, flags 0xaa00,
usage: min 6, max 7, '$catalog, $schema, $table, $unique_only, $quick, [, \%attr ]'
install_method DBI::db::selectrow_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::begin_work , flags 0x0400,
usage: min 1, max 2, '[ \%attr ]'
install_method DBI::db::last_insert_id, flags 0x2800,
usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name [, \%attr ]'
install_method DBI::db::foreign_key_info, flags 0xaa00,
usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table, $fk_catalog, $fk_schema, $fk_table [, \%attr ]'
install_method DBI::db::primary_key , flags 0x2200,
usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
install_method DBI::db::commit , flags 0x0c80,
usage: min 1, max 1, ''
install_method DBI::db::ping , flags 0x0404,
usage: min 1, max 1, ''
install_method DBI::db::selectall_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::type_info_all, flags 0x2a00,
usage: min 1, max 1, ''
install_method DBI::db::do , flags 0x3200,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::selectcol_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::db::prepare_cached, flags 0xa200,
usage: min 2, max 4, '$statement [, \%attr [, $if_active ] ]'
install_method DBI::db::rows , flags 0x0004
install_method DBI::db::rollback , flags 0x0c80,
usage: min 1, max 1, ''
install_method DBI::db::column_info , flags 0xaa00,
usage: min 5, max 6, '$catalog, $schema, $table, $column [, \%attr ]'
install_method DBI::db::table_info , flags 0xaa00,
usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ]'
install_method DBI::db::primary_key_info, flags 0xaa00,
usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
install_method DBI::db::prepare , flags 0xa200,
usage: min 2, max 3, '$statement [, \%attr]'
install_method DBI::db::preparse
install_method DBI::db::connected , flags 0x0004,
usage: min 1, max 0, ''
install_method DBI::db::data_sources, flags 0x0200,
usage: min 1, max 2, '[\%attr]'
install_method DBI::db::selectall_hashref, flags 0x2000,
usage: min 3, max 0, '$statement, $keyfield [, \%attr [, @bind_params ] ]'
install_method DBI::db::selectrow_hashref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
install_method DBI::dr::default_user,
usage: min 3, max 4, '$user, $pass [, \%attr]'
install_method DBI::dr::data_sources, flags 0x0800,
usage: min 1, max 2, '[\%attr]'
install_method DBI::dr::dbixs_revision, flags 0x0004
install_method DBI::dr::disconnect_all, flags 0x0800,
usage: min 1, max 1, ''
install_method DBI::dr::connect_cached, flags 0x8000, H 3,
usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]'
install_method DBI::dr::connect , flags 0x8000, H 3,
usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]'
install_method DBI::st::more_results,
usage: min 1, max 1, ''
install_method DBI::st::blob_read ,
usage: min 4, max 5, '$field, $offset, $len [, \$buf [, $bufoffset]]'
install_method DBI::st::fetchall_hashref,
usage: min 2, max 2, '$key_field'
install_method DBI::st::bind_param_inout_array,
usage: min 4, max 5, '$parameter, \@var, $maxlen, [, \%attr]'
install_method DBI::st::finish ,
usage: min 1, max 1, ''
install_method DBI::st::rows , flags 0x0004
install_method DBI::st::execute_for_fetch, flags 0x5040,
usage: min 2, max 3, '$fetch_sub [, $tuple_status]'
install_method DBI::st::fetchrow_hashref
install_method DBI::st::_get_fbav
install_method DBI::st::_set_fbav , T 6
install_method DBI::st::fetchrow
install_method DBI::st::fetch
install_method DBI::st::execute_array, flags 0x5040,
usage: min 2, max 0, '\%attribs [, @args]'
install_method DBI::st::dump_results,
usage: min 1, max 5, '$maxfieldlen, $linesep, $fieldsep, $filehandle'
install_method DBI::st::bind_param_array,
usage: min 3, max 4, '$parameter, $var [, \%attr]'
install_method DBI::st::fetchrow_array
install_method DBI::st::execute , flags 0x1040,
usage: min 1, max 0, '[@args]'
install_method DBI::st::bind_col ,
usage: min 3, max 4, '$column, \$var [, \%attr]'
install_method DBI::st::fetchall_arrayref,
usage: min 1, max 3, '[ $slice [, $max_rows]]'
install_method DBI::st::fetchrow_arrayref
install_method DBI::st::bind_param_inout,
usage: min 4, max 5, '$parameter, \$var, $maxlen, [, \%attr]'
install_method DBI::st::bind_columns,
usage: min 2, max 0, '\$var1 [, \$var2, ...]'
install_method DBI::st::cancel , flags 0x0800,
usage: min 1, max 1, ''
install_method DBI::st::blob_copy_to_file,
usage: min 3, max 3, '$field, $filename_or_handleref'
install_method DBI::st::bind_param ,
usage: min 3, max 4, '$parameter, $var [, \%attr]'
install_method DBI::common::parse_trace_flag, flags 0x0404, T 8,
usage: min 2, max 2, '$name'
install_method DBI::common::errstr , flags 0x0004
install_method DBI::common::trace_msg, flags 0x0004, T 8,
usage: min 2, max 3, '$message_text [, $min_level ]'
install_method DBI::common::err , flags 0x0004
install_method DBI::common::CLEAR , flags 0x0004
install_method DBI::common::state , flags 0x0004
install_method DBI::common::_not_impl
install_method DBI::common::NEXTKEY , flags 0x0004
install_method DBI::common::trace , flags 0x0004,
usage: min 1, max 3, '[$trace_level, [$filename]]'
install_method DBI::common::debug , flags 0x0004,
usage: min 1, max 2, '[$debug_level]'
install_method DBI::common::parse_trace_flags, flags 0x0404, T 8,
usage: min 2, max 2, '$flags'
install_method DBI::common::private_attribute_info
install_method DBI::common::swap_inner_handle,
usage: min 2, max 3, '$h [, $allow_reparent ]'
install_method DBI::common::EXISTS , flags 0x0004
install_method DBI::common::visit_child_handles, flags 0x0404, T 4,
usage: min 2, max 3, '$coderef [, $info ]'
install_method DBI::common::FETCH , flags 0x0404
install_method DBI::common::FIRSTKEY, flags 0x0004
install_method DBI::common::set_err , flags 0x0010,
usage: min 3, max 6, '$err, $errmsg [, $state, $method, $rv]'
install_method DBI::common::DESTROY , flags 0x10004
install_method DBI::common::dump_handle, flags 0x0004,
usage: min 1, max 3, '[$message [, $level]]'
install_method DBI::common::FETCH_many, flags 0x0404
install_method DBI::common::can , flags 0x0100
install_method DBI::common::STORE , flags 0x041c
install_method DBI::common::private_data, flags 0x0004,
usage: min 1, max 1, ''
install_method DBI::common::func , flags 0x0006
-> DBI->connect(DBI:ODBC:Database=Test_Perl_DBI;Server=pausql02.lsi.com\dev;Driver=/tools/cfr/tdsodbc/0.91/lib/libtdsodbc.so;TDS_Version=7.2, test_perl_adm, ****, HASH(0x65c868))
-> DBI->install_driver(ODBC) for linux perl=5.014001 pid=19935 ruid=15717 euid=15717
install_driver: DBD::ODBC version 1.33 loaded from /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBD/ODBC.pm
New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0x8e6c78)=>DBI::dr=HASH(0x8e6d08), DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 168, 0) thr#659010
dbih_setup_attrib(DBI::dr=HASH(0x8e6d08), Err, Null!) SCALAR(0x77fb00) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8e6d08), State, Null!) SCALAR(0x77fa70) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8e6d08), Errstr, Null!) SCALAR(0x77fad0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8e6d08), TraceLevel, Null!) 0 (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8e6d08), FetchHashKeyName, Null!) 'NAME' (already defined)
install_method DBI::st::odbc_lob_read
<- install_driver= DBI::dr=HASH(0x8e6c78)
>> connect DISPATCH (DBI::dr=HASH(0x8e6c78) rc2/3 @5 g2 ima8001 pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 665
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x8e6c78)~0x8e6d08 'Database=Test_Perl_DBI;Server=pausql02.lsi.com\dev;Driver=/tools/cfr/tdsodbc/0.91/lib/libtdsodbc.so;TDS_Version=7.2' 'test_perl_adm' **** HASH(0x7979e8)) thr#659010
New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x8e6d08), id=undef)
dbih_setup_handle(DBI::db=HASH(0x8e7548)=>DBI::db=HASH(0x8e7440), DBD::ODBC::db, 7fd688, Null!)
dbih_make_com(DBI::dr=HASH(0x8e6d08), 77e6f0, DBD::ODBC::db, 576, 0) thr#659010
dbih_setup_attrib(DBI::db=HASH(0x8e7440), Err, DBI::dr=HASH(0x8e6d08)) SCALAR(0x7fd9a0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), State, DBI::dr=HASH(0x8e6d08)) SCALAR(0x7fda60) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), Errstr, DBI::dr=HASH(0x8e6d08)) SCALAR(0x7fda00) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), TraceLevel, DBI::dr=HASH(0x8e6d08)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), FetchHashKeyName, DBI::dr=HASH(0x8e6d08)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), HandleSetErr, DBI::dr=HASH(0x8e6d08)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), HandleError, DBI::dr=HASH(0x8e6d08)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), ReadOnly, DBI::dr=HASH(0x8e6d08)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8e7440), Profile, DBI::dr=HASH(0x8e6d08)) undef (not defined)
<- connect= ( DBI::db=HASH(0x8e7548) ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 665
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc2/1 @3 g2 ima41c pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 717
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'RaiseError' 0) thr#659010
!!DBD::ODBC unsupported attribute passed (RaiseError)
STORE DBI::db=HASH(0x8e7440) 'RaiseError' => 0
<- STORE= ( 1 ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 717
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc2/1 @3 g2 ima41c pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 717
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'PrintError' 0) thr#659010
!!DBD::ODBC unsupported attribute passed (PrintError)
STORE DBI::db=HASH(0x8e7440) 'PrintError' => 0
<- STORE= ( 1 ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 717
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc2/1 @3 g2 ima41c pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 717
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'AutoCommit' 0) thr#659010
<- STORE= ( 1 ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 717
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc2/1 @3 g2 ima41c pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 720 via at ./test_sql_types.pl line 24
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'Username' 'test_perl_adm') thr#659010
!!DBD::ODBC unsupported attribute passed (Username)
STORE DBI::db=HASH(0x8e7440) 'Username' => 'test_perl_adm'
<- STORE= ( 1 ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 720 via at ./test_sql_types.pl line 24
>> connected DISPATCH (DBI::db=HASH(0x8e7548) rc1/1 @5 g2 ima5 pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 727
-> connected in DBD::_::db for DBD::ODBC::db (DBI::db=HASH(0x8e7548)~0x8e7440 'DBI:ODBC:Database=Test_Perl_DBI;Server=pausql02.lsi.com\dev;Driver=/tools/cfr/tdsodbc/0.91/lib/libtdsodbc.so;TDS_Version=7.2' 'test_perl_adm' 'Tp3rl%DB!@' HASH(0x65c868)) thr#659010
<- connected= ( undef ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 727
<- connect= DBI::db=HASH(0x8e7548)
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc2/1 @3 g2 ima41c pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 736 via at ./test_sql_types.pl line 24
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'dbi_connect_closure' CODE(0x8dee98)) thr#659010
!!DBD::ODBC unsupported attribute passed (dbi_connect_closure)
STORE DBI::db=HASH(0x8e7440) 'dbi_connect_closure' => CODE(0x8dee98)
<- STORE= ( 1 ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 736 via at ./test_sql_types.pl line 24
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc2/1 @3 g2 ima41c pid#19935) at ./test_sql_types.pl line 36
-> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'RaiseError' 1) thr#659010
!!DBD::ODBC unsupported attribute passed (RaiseError)
STORE DBI::db=HASH(0x8e7440) 'RaiseError' => 1
<- STORE= ( 1 ) [1 items] at ./test_sql_types.pl line 36
>> do DISPATCH (DBI::db=HASH(0x8e7548) rc1/1 @2 g2 ima3201 pid#19935) at ./test_sql_types.pl line 50 via at ./test_sql_types.pl line 49
-> do for DBD::ODBC::db (DBI::db=HASH(0x8e7548)~0x8e7440 'CREATE PROCEDURE [TMP_SP_Test_ODBC]
@IBIT bit,
@ITINT tinyint,
@ICHAR char,
@ISINT smallint,
@IINT int,
@IBINT bigint,
@IFLOAT float,
@IREAL real,
@ICHAR10 char,
@IVCHAR10 varchar,
@IDATETIME datetime
AS
SET NOCOUNT ON
RETURN 9
') thr#659010
>> STORE DISPATCH (DBI::db=HASH(0x8e7440) rc1/2 @3 g2 ima41c pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBD/ODBC.pm line 376 via at ./test_sql_types.pl line 50
1 -> STORE for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER 'Statement' 'CREATE PROCEDURE [TMP_SP_Test_ODBC]
@IBIT bit,
@ITINT tinyint,
@ICHAR char,
@ISINT smallint,
@IINT int,
@IBINT bigint,
@IFLOAT float,
@IREAL real,
@ICHAR10 char,
@IVCHAR10 varchar,
@IDATETIME datetime
AS
SET NOCOUNT ON
RETURN 9
') thr#659010
!!DBD::ODBC unsupported attribute passed (Statement)
STORE DBI::db=HASH(0x8e7440) 'Statement' => 'CREATE PROCEDURE [TMP_SP_Test_ODBC]
@IBIT bit,
@ITINT tinyint,
@ICHAR char,
@ISINT smallint,
@IINT int,
@IBINT bigint,
@IFLOAT float,
@IREAL real,
@ICHAR10 char,
@IVCHAR10 varchar,
@IDATETIME datetime
AS
SET NOCOUNT ON
RETURN 9
'
1 <- STORE= ( 1 ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBD/ODBC.pm line 376 via at ./test_sql_types.pl line 50
SQLExecDirect CREATE PROCEDURE [TMP_SP_Test_ODBC]
@IBIT bit,
@ITINT tinyint,
@ICHAR char,
@ISINT smallint,
@IINT int,
@IBINT bigint,
@IFLOAT float,
@IREAL real,
@ICHAR10 char,
@IVCHAR10 varchar,
@IDATETIME datetime
AS
SET NOCOUNT ON
RETURN 9
SQLExecDirect = 100
<- do= ( -1 ) [1 items] at ./test_sql_types.pl line 50 via at ./test_sql_types.pl line 49
>> err DISPATCH (DBI::db=HASH(0x8e7548) rc1/1 @1 g2 ima4 pid#19935) at ./test_sql_types.pl line 69
-> err in DBD::_::common for DBD::ODBC::db (DBI::db=HASH(0x8e7548)~0x8e7440) thr#659010
<- err= ( undef ) [1 items] at ./test_sql_types.pl line 69
>> prepare DISPATCH (DBI::db=HASH(0x8e7548) rc1/1 @2 g2 imaa201 pid#19935) at ./test_sql_types.pl line 78
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x8e7548)~0x8e7440 '{ ? = call TMP_SP_Test_ODBC (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }') thr#659010
New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x8e7440), id=undef)
dbih_setup_handle(DBI::st=HASH(0x8ea0c8)=>DBI::st=HASH(0x8ea008), DBD::ODBC::st, 7fdaf0, Null!)
dbih_make_com(DBI::db=HASH(0x8e7440), 8e5d00, DBD::ODBC::st, 408, 0) thr#659010
dbih_setup_attrib(DBI::st=HASH(0x8ea008), Err, DBI::db=HASH(0x8e7440)) SCALAR(0x7fd9a0) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), State, DBI::db=HASH(0x8e7440)) SCALAR(0x7fda60) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), Errstr, DBI::db=HASH(0x8e7440)) SCALAR(0x7fda00) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), TraceLevel, DBI::db=HASH(0x8e7440)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), FetchHashKeyName, DBI::db=HASH(0x8e7440)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), HandleSetErr, DBI::db=HASH(0x8e7440)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), HandleError, DBI::db=HASH(0x8e7440)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), ReadOnly, DBI::db=HASH(0x8e7440)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8ea008), Profile, DBI::db=HASH(0x8e7440)) undef (not defined)
initializing sth query timeout to -1
ignore named placeholders = 0
creating new parameter key 1
creating new parameter key 2
creating new parameter key 3
creating new parameter key 4
creating new parameter key 5
creating new parameter key 6
creating new parameter key 7
creating new parameter key 8
creating new parameter key 9
creating new parameter key 10
creating new parameter key 11
creating new parameter key 12
dbd_preparse scanned 12 distinct placeholders
SQLPrepare { ? = call TMP_SP_Test_ODBC (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
SQLPrepare = 0
<- prepare= ( DBI::st=HASH(0x8ea0c8) ) [1 items] at ./test_sql_types.pl line 78
>> bind_param_inout DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 80
-> bind_param_inout for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 1 SCALAR(0x786ba8) 4) thr#659010
+dbd_bind_ph(7fdb20, name=1, value=undef, attribs=, sql_type=0(unknown), is_inout=1, maxlen=4
-dbd_bind_ph=rebind_param
+rebind_param 1 undef (size svCUR=-1/SvLEN=-1/max=4) svtype 0, value type:1 sql type:0
+get_param_type(7fdb20,1)
SQLDescribeParam not supported, sv is not OK, defaulting to 12
-get_param_type
bind 1 undef value_len=0 maxlen=31 null=1)
bind 1 value_type:1 VARCHAR cs=31 dd=1 bl=31
SQLBindParameter: idx=1: io_type=2, name=1, value_type=1 (SQL_C_CHAR), SQLType=12 (VARCHAR), column_size=31, d_digits=1, value_ptr=9382c0, buffer_length=31, ind=-1, param_size=0
-rebind_param
<- bind_param_inout= ( 1 ) [1 items] at ./test_sql_types.pl line 80
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 81
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 2 1 -7) thr#659010
+dbd_bind_ph(7fdb20, name=2, value=1, attribs=, sql_type=-7(BIT), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 2 1 (size svCUR=9348264/SvLEN=1/max=0) svtype 2, value type:1 sql type:0
+get_param_type(7fdb20,2)
SQLDescribeParam not supported, sv=1 bytes, defaulting to 12
Overriding sql type with requested type -7
-get_param_type
bind 2 1 value_len=1 maxlen=15 null=0)
bind 2 value_type:1 BIT cs=1 dd=0 bl=1
SQLBindParameter: idx=2: io_type=1, name=2, value_type=1 (SQL_C_CHAR), SQLType=-7 (BIT), column_size=1, d_digits=0, value_ptr=9381e0, buffer_length=1, ind=1, param_size=0
Param value = 1
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 81
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 82
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 3 200 -6) thr#659010
+dbd_bind_ph(7fdb20, name=3, value=200, attribs=, sql_type=-6(TINYINT), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 3 200 (size svCUR=9348288/SvLEN=1/max=0) svtype 2, value type:1 sql type:0
+get_param_type(7fdb20,3)
SQLDescribeParam not supported, sv=3 bytes, defaulting to 12
Overriding sql type with requested type -6
-get_param_type
bind 3 200 value_len=3 maxlen=15 null=0)
bind 3 value_type:1 TINYINT cs=3 dd=0 bl=3
SQLBindParameter: idx=3: io_type=1, name=3, value_type=1 (SQL_C_CHAR), SQLType=-6 (TINYINT), column_size=3, d_digits=0, value_ptr=935920, buffer_length=3, ind=3, param_size=0
Param value = 200
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 82
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 83
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 4 'A' 1) thr#659010
+dbd_bind_ph(7fdb20, name=4, value='A', attribs=, sql_type=1(CHAR), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 4 'A' (size svCUR=1/SvLEN=16/max=0) svtype 4, value type:1 sql type:0
+get_param_type(7fdb20,4)
SQLDescribeParam not supported, sv=1 bytes, defaulting to 12
Overriding sql type with requested type 1
-get_param_type
bind 4 'A' value_len=1 maxlen=15 null=0)
bind 4 value_type:1 CHAR cs=1 dd=0 bl=1
SQLBindParameter: idx=4: io_type=1, name=4, value_type=1 (SQL_C_CHAR), SQLType=1 (CHAR), column_size=1, d_digits=0, value_ptr=9381c0, buffer_length=1, ind=1, param_size=0
Param value = A
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 83
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 84
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 5 30000 5) thr#659010
+dbd_bind_ph(7fdb20, name=5, value=30000, attribs=, sql_type=5(SMALLINT), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 5 30000 (size svCUR=9348336/SvLEN=1/max=0) svtype 2, value type:1 sql type:0
+get_param_type(7fdb20,5)
SQLDescribeParam not supported, sv=5 bytes, defaulting to 12
Overriding sql type with requested type 5
-get_param_type
bind 5 30000 value_len=5 maxlen=15 null=0)
bind 5 value_type:1 SMALLINT cs=5 dd=0 bl=5
SQLBindParameter: idx=5: io_type=1, name=5, value_type=1 (SQL_C_CHAR), SQLType=5 (SMALLINT), column_size=5, d_digits=0, value_ptr=937f50, buffer_length=5, ind=5, param_size=0
Param value = 30000
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 84
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 85
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 6 2000000000 4) thr#659010
+dbd_bind_ph(7fdb20, name=6, value=2000000000, attribs=, sql_type=4(INTEGER), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 6 2000000000 (size svCUR=9348360/SvLEN=1/max=0) svtype 2, value type:1 sql type:0
+get_param_type(7fdb20,6)
SQLDescribeParam not supported, sv=10 bytes, defaulting to 12
Overriding sql type with requested type 4
-get_param_type
bind 6 2000000000 value_len=10 maxlen=15 null=0)
bind 6 value_type:1 INTEGER cs=10 dd=0 bl=10
SQLBindParameter: idx=6: io_type=1, name=6, value_type=1 (SQL_C_CHAR), SQLType=4 (INTEGER), column_size=10, d_digits=0, value_ptr=938a40, buffer_length=10, ind=10, param_size=0
Param value = 2000000000
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 85
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 86
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 7 99999999999 -5) thr#659010
+dbd_bind_ph(7fdb20, name=7, value=99999999999, attribs=, sql_type=-5(BIGINT), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 7 99999999999 (size svCUR=9348384/SvLEN=1/max=0) svtype 2, value type:1 sql type:0
+get_param_type(7fdb20,7)
SQLDescribeParam not supported, sv=11 bytes, defaulting to 12
Overriding sql type with requested type -5
-get_param_type
bind 7 99999999999 value_len=11 maxlen=15 null=0)
bind 7 value_type:1 BIGINT cs=11 dd=0 bl=11
SQLBindParameter: idx=7: io_type=1, name=7, value_type=1 (SQL_C_CHAR), SQLType=-5 (BIGINT), column_size=11, d_digits=0, value_ptr=9384c0, buffer_length=11, ind=11, param_size=0
Param value = 99999999999
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 86
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 87
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 8 55.55 6) thr#659010
+dbd_bind_ph(7fdb20, name=8, value=55.55, attribs=, sql_type=6(FLOAT), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 8 55.55 (size svCUR=584115552/SvLEN=794181637/max=0) svtype 3, value type:1 sql type:0
+get_param_type(7fdb20,8)
SQLDescribeParam not supported, sv=5 bytes, defaulting to 12
Overriding sql type with requested type 6
-get_param_type
bind 8 55.55 value_len=5 maxlen=39 null=0)
bind 8 value_type:1 FLOAT cs=5 dd=0 bl=5
SQLBindParameter: idx=8: io_type=1, name=8, value_type=1 (SQL_C_CHAR), SQLType=6 (FLOAT), column_size=5, d_digits=0, value_ptr=8d82a0, buffer_length=5, ind=5, param_size=0
Param value = 55.55
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 87
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 88
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 9 123.123 7) thr#659010
+dbd_bind_ph(7fdb20, name=9, value=123.123, attribs=, sql_type=7(REAL), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 9 123.123 (size svCUR=584115552/SvLEN=794181637/max=0) svtype 3, value type:1 sql type:0
+get_param_type(7fdb20,9)
SQLDescribeParam not supported, sv=7 bytes, defaulting to 12
Overriding sql type with requested type 7
-get_param_type
bind 9 123.123 value_len=7 maxlen=39 null=0)
bind 9 value_type:1 REAL cs=7 dd=0 bl=7
SQLBindParameter: idx=9: io_type=1, name=9, value_type=1 (SQL_C_CHAR), SQLType=7 (REAL), column_size=7, d_digits=0, value_ptr=938680, buffer_length=7, ind=7, param_size=0
Param value = 123.123
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 88
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 89
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 10 'c10' 1) thr#659010
+dbd_bind_ph(7fdb20, name=10, value='c10', attribs=, sql_type=1(CHAR), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 10 'c10' (size svCUR=3/SvLEN=16/max=0) svtype 4, value type:1 sql type:0
+get_param_type(7fdb20,10)
SQLDescribeParam not supported, sv=3 bytes, defaulting to 12
Overriding sql type with requested type 1
-get_param_type
bind 10 'c10' value_len=3 maxlen=15 null=0)
bind 10 value_type:1 CHAR cs=3 dd=0 bl=3
SQLBindParameter: idx=10: io_type=1, name=10, value_type=1 (SQL_C_CHAR), SQLType=1 (CHAR), column_size=3, d_digits=0, value_ptr=937f30, buffer_length=3, ind=3, param_size=0
Param value = c10
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 89
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 90
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 11 'vc10' 12) thr#659010
+dbd_bind_ph(7fdb20, name=11, value='vc10', attribs=, sql_type=12(VARCHAR), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 11 'vc10' (size svCUR=4/SvLEN=16/max=0) svtype 4, value type:1 sql type:0
+get_param_type(7fdb20,11)
SQLDescribeParam not supported, sv=4 bytes, defaulting to 12
Overriding sql type with requested type 12
-get_param_type
bind 11 'vc10' value_len=4 maxlen=15 null=0)
bind 11 value_type:1 VARCHAR cs=80 dd=0 bl=4
SQLBindParameter: idx=11: io_type=1, name=11, value_type=1 (SQL_C_CHAR), SQLType=12 (VARCHAR), column_size=80, d_digits=0, value_ptr=9389a0, buffer_length=4, ind=4, param_size=0
Param value = vc10
-rebind_param
<- bind_param= ( 1 ) [1 items] at ./test_sql_types.pl line 90
>> bind_param DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/2 @4 g2 ima1 pid#19935) at ./test_sql_types.pl line 91
-> bind_param for DBD::ODBC::st (DBI::st=HASH(0x8ea0c8)~0x8ea008 12 '2011-10-10 10:10:10' 9) thr#659010
+dbd_bind_ph(7fdb20, name=12, value='2011-10-10 10:10:10', attribs=, sql_type=9(DATE), is_inout=0, maxlen=0
-dbd_bind_ph=rebind_param
+rebind_param 12 '2011-10-10 10:10:10' (size svCUR=19/SvLEN=24/max=0) svtype 4, value type:1 sql type:0
+get_param_type(7fdb20,12)
SQLDescribeParam not supported, sv=19 bytes, defaulting to 12
Overriding sql type with requested type 9
-get_param_type
bind 12 '2011-10-10 10:...' value_len=19 maxlen=23 null=0)
bind 12 value_type:1 DATE cs=19 dd=0 bl=19
SQLBindParameter: idx=12: io_type=1, name=12, value_type=1 (SQL_C_CHAR), SQLType=9 (DATE), column_size=19, d_digits=0, value_ptr=9384e0, buffer_length=19, ind=19, param_size=0
Param value = 2011-10-10 10:10:10
!!dbd_error2(err_rc=-1, what=rebind_param/SQLBindParameter, handles=(8eb270,8eb860,935ed0)
!SQLError(8eb270,8eb860,935ed0) = (HY004, 0, [FreeTDS][SQL Server]Invalid data type)
!! ERROR: 1 '[FreeTDS][SQL Server]Invalid data type (SQL-HY004)' (err#1)
<- bind_param= ( '' ) [1 items] at ./test_sql_types.pl line 91
>> DESTROY DISPATCH (DBI::db=HASH(0x8e7548) rc1/1 @1 g2 ima10004 pid#19935) at ./test_sql_types.pl line 91 via at ./test_sql_types.pl line 91
<> DESTROY(DBI::db=HASH(0x8e7548)) ignored for outer handle (inner DBI::db=HASH(0x8e7440) has ref cnt 3)
>> DESTROY DISPATCH (DBI::st=HASH(0x8ea0c8) rc1/1 @1 g2 ima10004 pid#19935) at ./test_sql_types.pl line 91 via at ./test_sql_types.pl line 91
<> DESTROY(DBI::st=HASH(0x8ea0c8)) ignored for outer handle (inner DBI::st=HASH(0x8ea008) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x8ea008) rc1/1 @1 g2 ima10004 pid#19935) at ./test_sql_types.pl line 91 via at ./test_sql_types.pl line 91
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x8ea008)~INNER) thr#659010
SQLFreeStmt=0.
ERROR: 1 '[FreeTDS][SQL Server]Invalid data type (SQL-HY004)' (err#1)
<- DESTROY= ( undef ) [1 items] at ./test_sql_types.pl line 91 via at ./test_sql_types.pl line 91
DESTROY (dbih_clearcom) (sth 0x8ea008, com 0x935160, imp DBD::ODBC::st):
FLAGS 0x100091: COMSET Warn RaiseError PrintWarn
ERR 1
ERRSTR '[FreeTDS][SQL Server]Invalid data type (SQL-HY004)'
PARENT DBI::db=HASH(0x8e7440)
KIDS 0 (0 Active)
NUM_OF_FIELDS -1
NUM_OF_PARAMS 12
dbih_clearcom 0x8ea008 (com 0x935160, type 3) done.
>> DESTROY DISPATCH (DBI::db=HASH(0x8e7440) rc1/1 @1 g2 ima10004 pid#19935) at ./test_sql_types.pl line 91 via at ./test_sql_types.pl line 91
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x8e7440)~INNER) thr#659010
DBD::ODBC Disconnected!
ERROR: 1 '[FreeTDS][SQL Server]Invalid data type (SQL-HY004)' (err#0)
<- DESTROY= ( undef ) [1 items] at ./test_sql_types.pl line 91 via at ./test_sql_types.pl line 91
DESTROY (dbih_clearcom) (dbh 0x8e7440, com 0x8e5d00, imp DBD::ODBC::db):
FLAGS 0x180091: COMSET Warn RaiseError PrintWarn
ERR 1
ERRSTR '[FreeTDS][SQL Server]Invalid data type (SQL-HY004)'
PARENT DBI::dr=HASH(0x8e6d08)
KIDS 0 (0 Active)
dbih_clearcom 0x8e7440 (com 0x8e5d00, type 2) done.
-- DBI::END ($@: , $!: )
>> disconnect_all DISPATCH (DBI::dr=HASH(0x8e6c78) rc1/3 @1 g2 ima801 pid#19935) at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 744 via at ./test_sql_types.pl line 91
!! ERROR: 1 CLEARED by call to disconnect_all method
-> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x8e6c78)~0x8e6d08) thr#659010
<- disconnect_all= ( '' ) [1 items] at /tools/cfr/perl/5.14.1/lib/site_perl/5.14.1/x86_64-linux-thread-multi-ld/DBI.pm line 744 via at ./test_sql_types.pl line 91
! >> DESTROY DISPATCH (DBI::dr=HASH(0x8e6d08) rc1/1 @1 g2 ima10004 pid#19935) during global destruction
! -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x8e6d08)~INNER) thr#659010
! <- DESTROY= ( undef ) [1 items] during global destruction
DESTROY (dbih_clearcom) (drh 0x8e6c78, com 0x77e6f0, imp global destruction):
FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit
PARENT undef
KIDS 0 (0 Active)
dbih_clearcom 0x8e6c78 (com 0x77e6f0, type 1) done.
! >> DESTROY DISPATCH (DBI::dr=HASH(0x8e6c78) rc1/1 @1 g2 ima10004 pid#19935) during global destruction
! <> DESTROY for DBI::dr=HASH(0x8e6c78) ignored (inner handle gone)