FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

All,

I've done the following test, using latest snapshot freetds + sqsh 1.7
(ct-library), TDSVER set to 70 accessing SQL 2000

1> create table bill_null_test(col1 int not null, col2 int null, col3
char(4) null)
2>
3> go
1> insert bill values ( 1, null, null)
2> go
1> select col1, col2, col3, '' isitnull from bill_null_test
2> go
 col1        col2        col3 isitnull
 ----------- ----------- ---- --------
           1        NULL NULL

doesn't this prove that a null value prints as 'NULL' whereas select ''
prints as spaces ?

Bill


> -----Original Message-----
> From: James K. Lowden [SMTP:jklowden AT schemamania.org]
> Sent: 27 January 2003 00:02
> To:   freetds AT lists.ibiblio.org
> Subject:      Re: [freetds] SELECT '' and TDS 7.0
> 
> On Sun, 26 Jan 2003 16:31:24 -0700, Craig Davison <cd AT securityfocus.com>
> wrote:
> > On Tue, Jan 14, 2003 at 10:55:11PM -0500, James K. Lowden wrote:
> > > Looks like a ct-lib issue; tsql doesn't behave that way.  We should
> > > fix it before 0.61 release.  I'm not sure I'll have time until next
> > > week, though.
> > 
> > In the meantime, do you have a patch against 0.60 available for this?
> > 
> No, sorry.  I've added it to our TODO and will look at it when I can. 
> Mayhap someone else will beat me to it.
> 
> I won't touch the 0.60 branch, regardless.  I'll just make sure 0.60.1
> doesn't include the same bug.  
> 
> Regards, 
> 
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds