[freetds] SQLFetch broken in HEAD?
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Thu Jul 6 02:50:00 EDT 2006
>
> From: Frediano Ziglio
> Sent: Tuesday, July 04, 2006 4:25 PM
> > Il giorno mar, 04/07/2006 alle 11.46 -0400, James K. Lowden ha
> scritto:
> > > ZIGLIO, Frediano, VF-IT wrote:
> > > > >
> > > > > > > > > I added a new unit test, src/odbc/unittests/rpc.c.
> > >
> > > I don't understand why SQLFetch returns SQL_NO_DATA_FOUND
> the first
> time
> > > it's called. How is that "correct behavior for ODBC"?
> What else am
> I
> > > supposed to do to get the data?
> > >
> >
> > This is procedure body
> >
> > select @null_input = max(convert(varchar(30), name)) from systypes
> > select @first_type = min(convert(varchar(30), name)) from systypes
> > select name from sysobjects where 0=1
> > select distinct convert(varchar(30), name) as 'type' from systypes
> > where name in ('int', 'char', 'text')
> > select @nrows = @@rowcount
> > select distinct convert(varchar(30), name) as name from sysobjects
> where type = 'S'
> > return 42
> >
> > first select return nothing (just an ignored DONEINPROC)
> > second select return nothing
> > third select (select name from sysobjects where 0=1)
> returns no row so
> > SQLFetch return NO_DATA
>
> First, my apologies. I didn't realize I needed to call
> SQLMoreResults.
> SQLFetch is OK. I committed a better version of my test.
>
No problem...
> Second, I believe result set processing is seriously broken.
> Please see
> my next message for details.
>
http://freetds.sourceforge.net/out/test/test103.html
I don't understand where the empty recordset came... perhaps it's return
?? Quite strange...
freddy77
More information about the FreeTDS
mailing list