>SELECT-SQL command have different results in VFP8 and VFP9 Thread #1010955 Message #1010955

It looks like VFP9 bug to me. The query #1 should return only 3 records as in VFP8. Notice that field2 in the result is Null instead of blank for the records that shouldn't be included.
The query #2 correctly returns 3 records.

CREATE CURSOR taba ( ;
		ID C(4), ;
		field1 C(10), ;
		field2 C(1) ;
	)

CREATE CURSOR tabb ( ;
		ID C(6), ;
		field3 C(1) ;
	)

INSERT INTO taba VALUES( "0101",  "desc 1", "") 
INSERT INTO taba VALUES( "0201",  "desc 2", "X")

INSERT INTO tabb VALUES( "010101" ,"1")  
INSERT INTO tabb VALUES( "010102" ,"2")  
INSERT INTO tabb VALUES( "010103" ,"3")  
INSERT INTO tabb VALUES( "020101", "1")  
INSERT INTO tabb VALUES( "020102", "2")  
INSERT INTO tabb VALUES( "020103", "3") 

# 1
select * from tabb ;
	LEFT join taba on left(tabb.id,4)=taba.id ;
		WHERE not empty(taba.field2)
# 2
select * from tabb ;
	LEFT join taba on left(tabb.id,4)=taba.id ;
		WHERE EMPTY(taba.field2)