Hi, I suspect this is the same issue as this one: http://code.google.com/p/googleappengine/issues/detail?id=901
We suspect that calling put() on the entities that are not being returned will fix this issue, but are investigating it and working on a fix as well. Thanks, Marzia On Mon, Dec 15, 2008 at 6:52 PM, paptimus <[email protected]> wrote: > > Hi, Marzia. Thank you for your reply. > > It is missing. > For example, I run this query: > > query = models.Ownership.all().filter('user =', > [email protected]),filter('deleted =',False).order('- > created_on').fetch(0, 20) > > These lists are my expecting/getting result. > The getting result contains no 'NG' data but folowing 3 data. > > expecting: > 2008-12-12 10:25:23.397434 > 2008-12-09 18:04:23.439058 > 2008-12-03 15:22:46.754546 > 2008-12-03 15:22:45.251281 > 2008-12-03 15:22:42.594933 > 2008-12-03 15:22:41.149333 > 2008-12-03 15:22:39.559995 > 2008-12-03 15:22:38.116000 > 2008-12-03 15:22:36.511006 > 2008-12-03 15:22:35.117080 > 2008-12-03 15:22:33.679363 > 2008-12-03 15:22:32.119234 > 2008-12-03 15:22:30.461840 > 2008-12-03 15:22:28.936849 > 2008-12-03 15:22:27.518304 > 2008-12-03 15:22:26.039718 > 2008-12-03 15:22:24.665877NG > 2008-12-03 15:22:23.188243 > 2008-12-03 15:22:21.681791NG > 2008-12-03 15:22:20.245579NG > > getting: > 2008-12-12 10:25:23.397434 > 2008-12-09 18:04:23.439058 > 2008-12-03 15:22:46.754546 > 2008-12-03 15:22:45.251281 > 2008-12-03 15:22:42.594933 > 2008-12-03 15:22:41.149333 > 2008-12-03 15:22:39.559995 > 2008-12-03 15:22:38.116000 > 2008-12-03 15:22:36.511006 > 2008-12-03 15:22:35.117080 > 2008-12-03 15:22:33.679363 > 2008-12-03 15:22:32.119234 > 2008-12-03 15:22:30.461840 > 2008-12-03 15:22:28.936849 > 2008-12-03 15:22:27.518304 > 2008-12-03 15:22:26.039718 > 2008-12-03 15:22:23.188243 > 2008-12-03 15:22:18.783426 > 2008-12-03 15:22:17.303290 > 2008-12-03 15:22:13.102364 > > Thanks. > > On 12月16日, 午前5:18, Marzia Niccolai <[email protected]> wrote: > > Hi, > > > > Thanks for the report, but I'm not sure I understand how exactly your > query > > is having an issue. > > > > Can you elaborate on this statement: "The result set is ordered by > > '-created_on', but it is not sequential." What data are you getting? > What > > data are you expecting? Is it misordered or missing? > > > > Also, have you tried adding this index to your index.yaml and uploading > it > > with your application: > > > > - kind: Ownership > > properties: > > - name: user > > - name: deleted > > - name: created_on > > direction: desc > > > > Thanks, > > Marzia > > > > On Mon, Dec 15, 2008 at 11:05 AM, paptimus <[email protected]> wrote: > > > > > I get an additional information. > > > > > I vacuumed the problem index and rebuilt the same index. > > > The number of result set before vacuum_index is not same as one of > > > after that. > > > Obviously, query is same. > > > > > So I think my app get into this situation while rebuilding index. > > > I hope gae team checks my app's index. > > > My app id is 'book-case-2' and kind is 'Ownership'. > > > > > Thanks. > > > > > On 12月16日, 午前1:23, "koji matsui" <[email protected]> wrote: > > > > Hi, djidjadji, thanks for your comment. > > > > > > I tried both query as below: > > > > > > query = models.Ownership.all().filter('user', user),filter('deleted', > > > > False).order('-created_on').fetch(offset, amount) > > > > query = models.Ownership.all().filter('user =', user),filter('deleted > > > > =', False).order('-created_on').fetch(offset, amount) > > > > > > But the definition of index sdk generates is exactly the same. > > > > And lack of data in result set is the same. > > > > > > So, I think this problem happens when server creates the index. > > > > > > Thanks. > > > > > > 2008/12/15 djidjadji <[email protected]>: > > > > > > > A snippet from the manual > > > > > ============== > > > > > filter(property_operator, value) > > > > > > > Adds a property condition filter to the query. Only entities > with > > > > > properties that meet all of the conditions will be returned by the > > > > > query. > > > > > > > Arguments: > > > > > > > property_operator > > > > > A string containing the property name and a comparison > > > > > operator. The name and the operator must be separated by a space, > as > > > > > in: age > The following comparison operators are supported: < <= = > >= > > > > >> (The not-equal (!=) and IN operators are not supported.) > > > > > ============== > > > > > > > You forget the "comparison operator" in your filter statements. > > > > > > > 2008/12/13 paptimus <[email protected]>: > > > > > > >> query = models.Ownership.all().filter('user', > user),filter('deleted', > > > > >> False).order('-created_on').fetch(offset, amount) > > > > > > -- > > > > ----------------- > > > > koji matsui > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
