freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Geoff Montee <geoff.montee AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] empty strings select as null bug
- Date: Thu, 11 Jun 2015 00:17:30 -0700
On Wed, Jun 10, 2015 at 10:39 PM, LacaK <lacak AT zoznam.sk> wrote:
>
> I am using for testing NULL dbdata(), which should return nil for NULL data.
> (In my case I know, that column exists)
>
> From Sybase documentation:
> "A NULL BYTE pointer is returned if there is no such column or if the data
> has a null value. To make sure that the data is really a null value, you
> should always check for a return of 0 from *dbdatlen*."
>
> From Microsoft documentation:
> "A NULL BYTE pointer is returned if there is no such column or if the data
> has a null value. To make sure that the data is really a null value, check
> for a return of 0 from *dbdatlen*."
>
> So you can use: dbdata()==nil && dbdatlen()==0
>
I decided to go with your test:
https://github.com/GeoffMontee/tds_fdw/blob/b5f678cded099f9231473c520cf1dbe8363a470a/src/tds_fdw.c#L1855
I think Jeff's bug is fixed.
It's really good to know that dbdatlen() can return 0 in the case of
an empty string.
Thanks for your help, everyone!
Geoff
-
[freetds] empty strings select as null bug,
Jeffrey Shaw, 06/10/2015
-
Re: [freetds] empty strings select as null bug,
Geoff Montee, 06/10/2015
-
Re: [freetds] empty strings select as null bug,
James K. Lowden, 06/10/2015
- Re: [freetds] empty strings select as null bug, Geoff Montee, 06/10/2015
-
Re: [freetds] empty strings select as null bug,
LacaK, 06/11/2015
-
Re: [freetds] empty strings select as null bug,
Geoff Montee, 06/11/2015
- Re: [freetds] empty strings select as null bug, Jeffrey Shaw, 06/11/2015
- Re: [freetds] empty strings select as null bug, Jeffrey Shaw, 06/11/2015
-
Re: [freetds] empty strings select as null bug,
Geoff Montee, 06/11/2015
-
Re: [freetds] empty strings select as null bug,
James K. Lowden, 06/10/2015
-
Re: [freetds] empty strings select as null bug,
Geoff Montee, 06/10/2015
Archive powered by MHonArc 2.6.24.