FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

From: Kall, Bruce A.
Sent: Monday, May 16, 2005 9:00 AM

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

Your message is in reply to a db-lib buffering issue.  Frankly I don't
remember offhand what was wrong with it, but I know it's fixed.  

Your question seems to relate to an ODBC issue, whereby ODBC has
difficulties with stored procedures containing a sequence like:

        SELECT <something>
        RAISERROR <about something>
        SELECT <something else>

0.62.3 drops the RAISERROR output. Later versions concatenate the result
sets.  I'm not sure what the current status is.  I know Frediano has
been working on it.  

--jkl


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


-----------------------------------------
The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s) 
named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.