Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ken Collins <ken AT metaskills.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] [unixODBC][Driver Manager]Function sequence error (SQL-HY010)
  • Date: Sun, 4 Mar 2012 08:27:29 -0500


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: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] 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) <Wayne.Bower AT lsi.com>:
>> 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: freetds-bounces AT lists.ibiblio.org
>> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
>> Sent: Saturday, March 03, 2012 3:16 PM
>> To: freetds AT lists.ibiblio.org
>> Subject: Re: [freetds] [unixODBC][Driver Manager]Function sequence error
>> (SQL-HY010)
>>
>> On Fri, 2 Mar 2012 16:43:39 -0500
>> "Bower, Wayne (Wayne)" <Wayne.Bower AT lsi.com> 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
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page