"and this 2 queries return one result!" i mean queries in first message
On Jun 27, 1:19 pm, buger <leons...@gmail.com> wrote: > Oohh, it's more interesting problem than i though. I rebuild my > indexes, and this 2 queries return one result! > Let's look: > > SELECT * FROM Video WHERE artist = Key > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') > > This query returns 5 objects, and 4 of them have status value is equal > to "2" > > SELECT * FROM Video WHERE artist = Key > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > status = 2 > This query return only 1 object. Ooops, what is it? :) > > my appid is "musicvideobuger" > > On Jun 26, 2:26 pm, "Nick Johnson (Google)" <nick.john...@google.com> > wrote: > > > Hi buger, > > > Is this in production, or on the dev_appserver? In production, your > > app does not appear to have the necessary indexes to execute the > > second query. > > > -Nick Johnson > > > On Thu, Jun 25, 2009 at 11:38 PM, buger<leons...@gmail.com> wrote: > > > > SELECT * FROM Video WHERE artist = Key > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > > > status = 2 > > > This query gives me 4 results > > > > But this gives only 1 result!, i'm just added order > > > SELECT * FROM Video WHERE artist = Key > > > ('ag9tdXNpY3ZpZGVvYnVnZXJyFwsSBkFydGlzdCILYXNpZ3VyIHLDs3MM') AND > > > status = 2 ORDER BY created_at desc > > > > created_at is DateTime property, and all this objects have it > > > -- > > Nick Johnson, App Engine Developer Programs Engineer > > Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration > > Number: 368047 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---