FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> On Wed, 14 Jul 2004 <edwards AT vitesse.com> wrote:
> > 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?
> 
> http://www.freetds.org/faq.html#syb_result_type
> 
> Meet the new FAQ. :-)
> 
> You're almost certainly seeing spurious CS_STATUS_RESULT 
> result types. 
> Try  perldoc DBD::Sybase, looking for syb_result_type.  
> 
> We might have fixed this in current CVS, that is, we might be 
> correctly
> suppressing the spurious results.  The fix hasn't been widely 
> tested yet,
> though, and slightly broke row buffering in db-lib.  
> 

Fixes for test backported. row buffering it's a bit broken in all
version... problems came from text code (0.53 version)...

freddy77