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: "James K. Lowden" <jklowden AT schemamania.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] SELECT '' and TDS 7.0
  • Date: Tue, 14 Jan 2003 22:55:11 -0500

On Tue, 14 Jan 2003 15:08:57 -0700, Craig Davison <cd AT securityfocus.com>
wrote:
> I noticed some wierd behaviour with freetds 0.60.1 (and 0.53, 0.52).
> When using TDS 7.0, SELECT '' returns NULL. However, with TDS4.2, it
> returns '' as expected.
>
> With sqsh (megatron is set up for 7.0 in /etc/freetds/freetds.conf):
> [8] megatron..1> select ''
> [8] megatron..2> go
>
>
> NULL
>
> (1 row affected)
>
> Again (megatron42 is set up for 4.2):
> [9] megatron42..1> select ''
> [9] megatron42..2> go
>
> -
>
>
> (1 row affected)

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.


--jkl






Archive powered by MHonArc 2.6.24.

Top of Page