Thread: [ 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