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)