Skip to Content.
Sympa Menu

freetds - Re: [freetds] Duplicate rows returned with one particular query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Duplicate rows returned with one particular query
  • Date: Wed, 16 May 2007 18:11:31 -0400

Jeff Dahl wrote:
> Luke Benstead wrote:
> > It looks as though I'm not the only one who has experienced this:
> >
> > https://lists.ibiblio.org/sympa/arc/freetds/2006q1/019851.html
> > http://archives.devshed.com/forums/development-94/warning-return-as-copy-of-last-result-row-was-warning-1897372.html
> >
> I believe this was fixed with v0.64.

Indeed. It's definitely solved in the current snapshot:

$ echo 'select max(a) as foo from (select cast(null as int) as a) as test'
| bsqlodbc -S$S -U$U -P$P
foo
----------
NULL
bsqlodbc: error 8153: 01003: [FreeTDS][SQL Server]Warning: Null value is
eliminated by an aggregate or other SET operation.

I wrote bsqlodbc because so many ODBC questions arise in complex
environments with FreeTDS somewhere in the middle. Try your query with
it. If if fails, you have a FreeTDS problem. If it succeeds, you *might*
have a FreeTDS problem, but it manifests itself at higher elevations.

HTH.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page