FreeTDS Development Group

["Kall, Bruce A." <kall AT mayo.edu>]

Has there been any progress in 0.64 on the error with
stored procedures that return more than one result set?

Bruce


> > From: Thompson, Bill D (London)
> > > Sent: Wednesday, April 13, 2005 10:34 AM
> > >
> > > Bruce,
> >
> > > > > Is this true?
> >
> > > No. Not as far as I know.
>
>
> Au contraire, mon ami.  I'm afraid it is.  
>
> ISTR buffering has been broken for a while.  I just updated
> src/dblib/unittests/t0002.c to demonstrate.  If the test is broken,
> please say how.  
>
> Right now, dbclrbuf() fails an assertion if there are no rows buffered.
> It shouldn't.  But if you move dbclrbuf() after the dbnextrow() loop,
> you just get a different kind of error:
>
> 	Failed.  Expected i to be 11, was 10  
>
> Unfortunately, the buffering logic is a bear.  
>
> --jkl
>
> > -----Original Message-----
> > > From: Kall, Bruce A.
> > > Sent: 13 April 2005 15:26
> > >
> > > Is this true?
> >
> > > > > Apparently FreeTDS has issues with stored procs that return more
>
> than
>
> > > one result set.
> > >
> > > I appear to be having this problem as a stored procedure returning
>
> more 
>
> > > than one result set results in the following error:
> >
> > > > > dblib.c:303: buffer_add_row: Assertion `row_size <=
>
> buf->element_size'
>
> > > failed.
> > >
> > > Executing Sybase stored procedures that one return one result set run 
> > > just fine.  I'm running it through php and freetds 0.62.  I've tried 
> > > early versions of 0.63 to no avail.


ZIGLIO, Frediano, VF-IT wrote:
> Just some progress about current CVS status.
>
> Current CVS pass all test under mssql2k (see
> http://freetds.sourceforge.net/out/test/out.html) without errors.
>
> DBD-ODBC 1.13 works quite well
>
> Failed Test     Stat Wstat Total Fail  Failed  List of Failed
> ------------------------------------------------------------------------
> -------
> t/20SqlServer.t    0    11    37    7  18.92%  27 35-37
> 5 subtests skipped.
> Failed 1/9 test scripts, 88.89% okay. 4/137 subtests failed, 97.08%
> okay.
>
> (only lack of cursors, using Sybase it give 100%)
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds