[freetds] 1st select fails, 2nd works
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Thu Jul 15 04:16:04 EDT 2004
>
> 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
More information about the FreeTDS
mailing list