Skip to Content.
Sympa Menu

freetds - RE: [freetds] 1st select fails, 2nd works

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] 1st select fails, 2nd works
  • Date: Thu, 15 Jul 2004 10:16:04 +0200

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page