Skip to Content.
Sympa Menu

freetds - RE: [freetds] SELECT '' and TDS 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] SELECT '' and TDS 7.0
  • Date: Mon, 27 Jan 2003 14:58:04 -0000

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





Archive powered by MHonArc 2.6.24.

Top of Page