FreeTDS Development Group

[Jaye Mathisen <mrcpu AT internetcds.com>]

Building the 0.46 FreeTDS release with TDS 4.2, and the 0.19 release of
DBD::Sybase.

OS is FreeBSD 3.2.

One of the tests causes a coredump, t/main.t, 6 succeeds, 7 fails and
cores perl.


Doing some simple tests on a production 6.5 MSQL database shows
some data corruption problems.

The fields names are retrieved OK, but the data is corrupted.  Name should
be just "Jaye Mathisen", date fields are missing things like the year,
etc.

There are some of the unknown marker messages at the very beginning,
unknown property 7 and 13.

sqsh1.7 with these libraries also has problems.

An older version of FreeTDS with sqsh-1.4 works fine.


It is trivial to reproduce.  I can grab tcpdumps if you want.



output:

    syb_db_login() -> checking for chained transactions
    syb_db_login() -> chained transactions are  supported
    <- connect= DBI::db=HASH(0x8151dc8) at DBI.pm line 382.
    -> STORE for DBD::Sybase::db (DBI::db=HASH(0x8151e10)~INNER
'PrintError' 1)
    <- STORE= 1 at DBI.pm line 407.
    -> STORE for DBD::Sybase::db (DBI::db=HASH(0x8151e10)~INNER
'AutoCommit' 1)
    <- STORE= 1 at DBI.pm line 407.
    <- connect= DBI::db=HASH(0x8151dc8)
    -> do for DBD::Sybase::db (DBI::db=HASH(0x8151dc8)~0x8151e10 'use
plat')
2   -> prepare for DBD::Sybase::db (DBI::db=HASH(0x8151e10)~INNER 'use
plat' undef)
2   <- prepare= DBI::st=HASH(0x8151ef4) at Sybase.pm line 115.
    -> execute for DBD::Sybase::st (DBI::st=HASH(0x8151ef4)~0x8151d44)
    syb_st_execute() -> ct_send() OK
ct_execute() final retcode = 15
    <- execute= -1 at Sybase.pm line 116.
    -> err in DBD::_::common for DBD::Sybase::st
(DBI::st=HASH(0x8151ef4)~0x8151d44)
    <- err= undef at Sybase.pm line 117.
    -> rows for DBD::Sybase::st (DBI::st=HASH(0x8151ef4)~0x8151d44)
    <- rows= -1 at Sybase.pm line 118.
    -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x8151d44)~INNER
'syb_more_results')
    <- FETCH= undef at Sybase.pm line 119.
    <- do= -1 at x.pl line 29.
ok 2
    -> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x8151d44)~INNER)
    syb_st_destroy: called...
    syb_st_destroy(): cmd dropped: 1
    <- DESTROY= undef at x.pl line 34.
    -> prepare for DBD::Sybase::db (DBI::db=HASH(0x8151dc8)~0x8151e10
'select * from customer where username='mrcpu'')
    <- prepare= DBI::st=HASH(0x8151f3c) at x.pl line 36.
ok 3
    -> execute for DBD::Sybase::st (DBI::st=HASH(0x8151f3c)~0x8151d44)
    syb_st_execute() -> ct_send() OK
    st_next_result() -> ct_results(4) == 1
    ct_res_info() returns 51 columns
describe() retcode = 1
    <- execute= -1 at x.pl line 39.
ok 4
    -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x8151d44)~INNER
'NUM_OF_FIELDS')
    <- FETCH= 51 at x.pl line 41.
Fields: 51
    -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x8151d44)~INNER 'NAME')
    <- FETCH= [ 'id' 'name' 'guarantor' 'taxrate' 'taxrate2' 'date'
'active' 'taxid' 'staffnum' 'timestamp' 'attn' 'addr1' 'addr2' 'city'
'state' 'zip' 'phone' 'fax' 'username' 'password' 'email' 'stmtmethod'
'emailrcpt' 'laststmt' 'nextstmt' 'custbillday' 'nostatement'
'nolatenotice' 'nodeactivate' 'latedate' 'deactivatedate' 'stacktype'
'machtype' 'referralid' 'referral' 'comment' 'cctype' 'ccnumber' 'ccdate'
'cuskey' 'birthday' 'timeleft' 'blockuser' 'shellid' 'websignup'
'ponumber' 'routenumber' 'damount' 'dtype' 'salesid' 'lastusername' ] at
x.pl line 42.
Names: id name guarantor taxrate taxrate2 date active taxid staffnum
timestamp attn addr1 addr2 city state zip phone fax username password
email stmtmethod emailrcpt laststmt nextstmt custbillday nostatement
nolatenotice nodeactivate latedate deactivatedate stacktype machtype
referralid referral comment cctype ccnumber ccdate cuskey birthday
timeleft blockuser shellid websignup ponumber routenumber damount dtype
salesid lastusername
    -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x8151d44)~INNER
'NULLABLE')
    <- FETCH= [ '' 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ] at x.pl line 43.
Null:   1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
    -> fetchrow for DBD::Sybase::st (DBI::st=HASH(0x8151f3c)~0x8151d44)
    <- fetchrow= ( 10196 'Jaye Mathisen.customer where username='m' 0 '..'
'id.:' 'Feb 05 1' 'Y' undef 5 0 ' ................... ...................'
'3321 Bellinger Lane.........................................' '
...........................................................'
'Medford.............' 'OR.......................' '97501...=='
'5417799176.}

1' ' ....._

=hea' 'mrcpu.........................'
'pac43lg4nj......................................'
'mrcpu AT cdsnet.net.E.....#.Changed database context to
'plat'..DB01.............' 'EMAIL...............' 'Y' 'Aug 04 1' 'Sep 01
1' 1 'N' 'N' 'Y' 'Aug 21 1' undef undef undef 0 undef undef undef undef
undef undef 'Jul 17 1' undef undef 1 undef undef undef undef undef undef
undef ) [51 items] at x.pl line 45.
10196 Jaye Mathisencustomer where username='m   id: Feb 05 1 Y  5    3321
Bellinger Lane   Medford OR 9750== 5417799176}

1 _

=hea mrcpu pac43lg4nj mrcpu AT cdsnet.netE#Changed database context to
'plat'.DB01 EMAIL Y Aug 04 1 Sep 01 1 1 N N Y Aug 21 1           Jul 17 1
1       
    -> fetchrow for DBD::Sybase::st (DBI::st=HASH(0x8151f3c)~0x8151d44)
    st_next_result() -> ct_results(14) == 1
ct_execute() final retcode = 15
    syb_st_fetch() -> st_next_results() == 14
    <- fetchrow= ( ) [0 items] at x.pl line 45.
    -> rows for DBD::Sybase::st (DBI::st=HASH(0x8151f3c)~0x8151d44)
    <- rows= 1 at x.pl line 52.
ok 5
    -> disconnect for DBD::Sybase::db (DBI::db=HASH(0x8151dc8)~0x8151e10)
    syb_db_disconnect() -> ct_close()
    <- disconnect= 1 at x.pl line 62.
    -> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x8151d44)~INNER)
    syb_st_destroy: called...
    syb_st_destroy(): cmd dropped: 1
    <- DESTROY= undef at unknown location!
    -> DESTROY for DBD::Sybase::db (DBI::db=HASH(0x8151e10)~INNER)
    <- DESTROY= undef at unknown location!
    -> DBI::END
    -> disconnect_all for DBD::Sybase::drr=HASH(0x8151e58)~INNER)
    <- DESTROY= undef during global destruction.
    -> DESTROY in DBD::_witch::dr (DBI::dr=HASH(0x80b9a34)~INNER)
    <- DESTROY= undef during global destruction.