[ 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=10007 29&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
------------------




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=10007 29&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq