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

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