dannote / mod-ndb

Automatically exported from code.google.com/p/mod-ndb
0 stars 0 forks source link

Filters don't work #22

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
When last tested, filters did not seem to work as intended and documented.

Original issue reported on code.google.com by john.david.duncan on 22 Apr 2007 at 5:52

GoogleCodeExporter commented 9 years ago

Original comment by john.david.duncan on 28 Apr 2007 at 6:08

GoogleCodeExporter commented 9 years ago
The handling of filters was made simpler and cleaner in 330.
Filters were not being evaluated in case of a table scan -- this was fixed in 
rev 331.
Currently, filters are working for integers, not working for strings, and I 
have not tested decimal or float.

Original comment by john.david.duncan on 20 Aug 2007 at 6:35

GoogleCodeExporter commented 9 years ago
Successful test with decimal, in ver 340:

$ curl -i http://localhost:3080/ndb/test/dfilter?d2=3.14
HTTP/1.1 404 Not Found
Date: Mon, 20 Aug 2007 22:07:37 GMT
Server: Apache/1.3.33 (Darwin) NDB/5.1.20-beta
Transfer-Encoding: chunked
Content-Type: text/plain

No data could be found.
$ curl -i http://localhost:3080/ndb/test/dfilter?d2=3.1416
HTTP/1.1 200 OK
Date: Mon, 20 Aug 2007 22:07:41 GMT
Server: Apache/1.3.33 (Darwin) NDB/5.1.20-beta
Content-Length: 95
ETag: 0b4117f0bbb2cd15d2d706eb944767b0
Content-Type: text/plain

[
  { "i":1 , "d1":3.14 , "d2":3.1416 , "d3":3.1 , "d4":3.141592653589793000000000000000 } 
]

Original comment by john.david.duncan on 20 Aug 2007 at 10:09

GoogleCodeExporter commented 9 years ago
As of revision 350 the following filters are tested and working:
 CHAR =
 VARCHAR = 
 int < 
 decimal < 
 CHAR like & notlike
 VARCHAR like & not like 

Original comment by john.david.duncan on 23 Aug 2007 at 3:59

GoogleCodeExporter commented 9 years ago
All the remains to do is a good set of test cases 

Original comment by john.david.duncan on 6 Sep 2007 at 3:51

GoogleCodeExporter commented 9 years ago

Original comment by john.david.duncan on 25 Sep 2007 at 6:02