Re: [unixODBC][Driver Manager]Function sequence error (SQL-HY010)

On that topic, is there now a branch/tag structure that port maintainers can now follow too? For instance something like a 091-stable branch that may eventually be tagged 092 or something. I realized I might have some of these answers if I cloned the repo but wanted to ask as I have not setup a gitorious account yet and the web interfaces was lacking any clues.

 - Ken


On Mar 4, 2012, at 8:20 AM, Bower, Wayne (Wayne) wrote:

> Sorry for my ignorance.  I followed the URL you provided below and it wasn't clear how to download the patch.  I found freetds/freetds:Branch-0_91 and used the Download Branch-0_91 as tar.gz link to download freetds-freetds-Branch-0_91.tar.gz, but this doesn't contain the typical configure script.  Not sure if I need to do something to generate the configure script or I didn't download the correct code in the first place.
> 
> I also see that the fix is in the nightly snapshot available at freetds.org, but I guess that isn't considered stable.  Is that what you meant by downloading the latest patched version?  Once again, I'm sorry for my ignorance.
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
> Sent: Saturday, March 03, 2012 5:37 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] [unixODBC][Driver Manager]Function sequence error (SQL-HY010)
> 
> Another fix is to download the latest patched version.... tomorrow,
> just committed :)
> 
> Added a test too. Patch at
> http://gitorious.org/freetds/freetds/commit/75525262a814c78d8a546d2f558895cad9938f2b
> 
> Frediano
> 
> 2012/3/3 Bower, Wayne (Wayne) <[email protected]>:
>> The problem appears to be restricted only to procedures with output parameters.  We have not encountered the problem with any procedure that only has input parameters.
>> 
>> We can only avoid the problem by either not using 'SET NOCOUNT ON' or moving 'SET NOCOUNT ON' to a later point in the procedure.  This is demonstrated by the different examples in the test case.  Also note that having output parameters and 'SET NOCOUNT ON' as the first statement does not guarantee failure as shown with the example that begins with print "\nCreate $proc with input, output, select, init SET NOCOUNT\n";
>> 
>> Please let me know if you need more information.
>> 
>> -----Original Message-----
>> From: [email protected] [mailto:[email protected]] On Behalf Of James K. Lowden
>> Sent: Saturday, March 03, 2012 3:16 PM
>> To: [email protected]
>> Subject: Re: [freetds] [unixODBC][Driver Manager]Function sequence error (SQL-HY010)
>> 
>> On Fri, 2 Mar 2012 16:43:39 -0500
>> "Bower, Wayne (Wayne)" <[email protected]> wrote:
>> 
>>> Essentially the issue appears to be related to using 'SET NOCOUNT ON'
>>> in a stored procedure. The script creates a procedure and executes
>>> it.  The cases that fail issue the message '[unixODBC][Driver Manager]
>>> Function sequence error (SQL-HY010)'.  To avoid the failure I have to
>>> either remove 'SET NOCOUNT ON' or move later in the procedure.  Keep
>>> in mind that this is just a test case to reveal the issue.  In our
>>> actual code we always start each procedure with 'SET NOCOUNT ON' and
>>> do much more than shown in this test case.
>> 
>> Is the problem restricted to procedures that pass parameters?  If not,
>> does bsqldb exhibit the same symptoms?  If so, could you provide just
>> the SQL?
>> 
>> If parameters are required to provoke the problem, I would alter
>> src/odbc/unittests/rpc.c to induce it.  It tried the attached patch;
>> it did not alter the outcome of the test.
>> 
>> HTH.
>> 
>> --jkl
>> 
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds