FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Wed, 6 Nov 2002 14:30:18 -0500, "David Clark" <dclark AT rastardm.com>
wrote:
>
> Thanks, I'll apply the patch.  

OK.  I didn't test it; I just whipped it up from the CVS records.  Let us
know if you need anything further.  If it works, I might patch the 0.60.1
release (and make 0.60.2).  

> the actual table(s)
> involved in the query I was talking about don't use NULL-able bit
> fields. However, the query includes a LEFT OUTER JOIN so some of the bit
> fields do appear in the query results as allowing NULLs.  I guess I
> could do an ISNULL or a COALESCE on them, but I can't say for certain
> how many of my queries would be like this...

Ah.  I hadn't thought of that.  Makes perfect sense.  I doubt I'd want to
rework the SQL either.  

Thanks for the problem report, David.  

Regards, 

--jkl