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