Are you sure all 4 entities *have* an "id" field. I've been bitten by that when I added a new field. if you mention a field that an entity is missing anywhere in the GQL, then that entity will not show up in your query results.
On Nov 30, 2009, at 1:28 PM, Eric Rannaud wrote: > After over 12h of build time, an index over 500,000 entities (200MB of > data) finished building right after I submitted a message for > moderation, asking for help (did somebody at Google do something ?). > (App: 911pagers). > > However, the index that was built is incorrect. Indeed, the same GQL > query (e.g. in the admin console) returns different result depending > on whether it has an "order by" statement or not. > > SELECT * FROM MessageS where number = '[004548018]' > SELECT * FROM MessageS where number = '[004548018]' order by id > asc > > The first query returns 4 results, the second query only 2. > > The index in question is: > <datastore-index kind="MessageS" ancestor="false" source="auto"> > <property name="number" direction="asc"/> > <property name="id" direction="asc"/> > </datastore-index> > > I will delete the index and force a rebuild, but I'll give 6 hours to > Google people to look at it if they want to debug something. You can > contact me directly if needed. > > Thanks. > > -- > > 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. > > -- 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.
