Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1000729 ] NULL value is auto convert into empty value when "left join"

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000729 ] NULL value is auto convert into empty value when "left join"
Date: 2006-09-03 03:44:14
Message-ID: 20060903034414.4EA3D86C58C@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000729, was opened at 2006-09-03 03:44
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000729&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: NULL value is auto convert into empty value when "left join"

Initial Comment:
server 8.1.4
client: visual foxpro 8 + pgslodbc08.02.0100

table: test1
t1_key   t1_desc 
------------------
1         null


table: test2
t2_key  
------------------
<empty>



I execute a sql 
sqlexec("select test1.t1_key, test1.t1_desc, test2.t2_key from test1
left join test2 on test1.t1_key=test2.t2_key")

I get error result:
t1_key     t1_desc    t2_key
------------------------------
1          null       0


correct result should be
t1_key     t1_desc    t2_key
------------------------------
1          null       null

null value is auto convert into empty value


----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000729&group_id=1000125

pgsql-odbc by date

Next:From: meDate: 2006-09-03 22:25:02
Subject: odbc on windows 2003 64bit?
Previous:From: Mark Morgan LloydDate: 2006-09-02 16:27:47
Subject: Re: Dependency problems with 8.02.0100 (was Latest ODBC driver?)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group