[fdo-trac] #644: Sqlite filtering on date returns wrong results

[FDO]

#644: Sqlite filtering on date returns wrong results
-----------------------------+----------------------------------------------
 Reporter:  bscott           |         Owner:  traianstanev
     Type:  defect           |        Status:  new         
 Priority:  major            |     Milestone:  3.5.0       
Component:  SQLite Provider  |       Version:  3.5.0       
 Severity:  3                |    Resolution:              
 Keywords:                   |   External_id:              
-----------------------------+----------------------------------------------
Comment (by bscott):

 Still got problem formating text in trac :(

 All test using TIMESTAMP works fine :
 Select KEY_1 from POINT where DATE_1 = TIMESTAMP '2007-01-01 00:00:00'
   ok
 Select KEY_1 from POINT where DATE_1 > TIMESTAMP '2007-04-09 00:00:00'
   ok
 Select KEY_1 from POINT where DATE_1 >= TIMESTAMP '2007-04-09 00:00:00'
   ok
 Select KEY_1 from POINT where DATE_1 < TIMESTAMP '2007-01-02 00:00:00'
   ok
 Select KEY_1 from POINT where DATE_1 <= TIMESTAMP '2007-01-02 00:00:00'
   ok

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/644#comment:2>
FDO <http://fdo.osgeo.org/>
Feature Data Objects