FreeTDS Development Group

["Carl Edwards" <edwards AT vitesse.com>]

Hello,

I'm running 0.62.4 with DBI 1.42 against a MSSQL server (8.0.x).

Can anyone explain why running the same SELECT statement returns
different results the second time?

The first run of the perl script shows only 1 element is returned
but when the same SQL is rerun I get the expected 8 columns?

I've attached a zip file containing the freetds-pid-log.txt
and dbi-pid-log.txt for the two identical runs.

Any ideas about what might be happening would be appreciated,
or how I could restructure my DBI calls to minimize problems.

Thank You,
-Carl Edwards
                                                       

Here is a snippet of the diff of the two freetds logs:

121 ! st_next_result() -> ct_results(4043) == 1    121 ! st_next_result() -> 
ct_results(4040) == 1
122 ! ct_res_info() returns 1 columns              122 ! ct_res_info() 
returns 8 columns

123 ! ct_describe(0): type = 2, maxlen = 4         123 ! ct_describe(0): type 
= 1, maxlen = 50
124 ! describe() -> col 0, type 2, realtype 2      124 ! describe() -> col 0, 
type 1, realtype 1

130 ! 1 <- FETCH= [ 'COL(1)' ] ...                 144 ! 1 <- FETCH= [ 
'FileName' 'UploadedDate' ...

132 ! dbih_setup_fbav for 1 fields => 0x45fcc0     146 ! dbih_setup_fbav for 
8 fields => 0x4b6080

Attachment: freetds.zip
Description: freetds.zip