SDF Provider defect : Not in and not like has wrong behavior with null values

[bscott]

In Oracle,SqlServer,PostGIS,Access and MySql i have this sample table

MYKEY MYSTRCOLUMN 1 aa 2 in row 2 MyStrColumn is null

When we execute these sql statement

Select MYKEY from MYTABLEwhere MYSTRCOLUMN not in ('aa')

or

Select * from MyTable where MyStrColumn not like ('%aa')

it returns no row

With Sdf provider it returns row 2