[fdo-trac] #340: SDF Provider defect : Not in and not like has wrong behavior with null values

[FDO]

#340: SDF Provider defect : Not in and not like has wrong behavior with null
values
----------------------------+-----------------------------------------------
   Reporter:  bscott        |       Owner:  gregboone
       Type:  defect        |      Status:  new      
   Priority:  major         |   Milestone:  3.4.0    
  Component:  SDF Provider  |     Version:  3.2.0    
   Severity:  3             |    Keywords:           
External_id:                |  
----------------------------+-----------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/340>
FDO <http://fdo.osgeo.org/>
Feature Data Objects