If the latter query uses recently built index, then you probably hit the same bug as me:
http://groups.google.com/group/google-appengine-python/browse_thread/thread/036a2ccae21798f8/89659e76acbd8a54 the only recourse is to re-put all entities of that kind. On Jul 1, 8:27 pm, Philip Tucker <[email protected]> wrote: > I have a bug where 2 different queries select a row, but the > combination of the 2 queries doesn't. This occurs both from the Data > Viewer console and from Java. > > These both return row > agx3b3Jkd2lzZWdhbWVyFQsSDVR1cm5TdW1tYXJ5VjEY0M5ODA: > > SELECT * FROM TurnSummaryV1 where userKey = > KEY('agx3b3Jkd2lzZWdhbWVyDgsSBk15VXNlchjJwQwM') > SELECT * FROM TurnSummaryV1 where score > 0 and state = 'VALID' and > type = 'PLAY' order by score desc > > But this doesn't return it: > > SELECT * FROM TurnSummaryV1 where score > 0 and state = 'VALID' and > type = 'PLAY' and userKey = > KEY('agx3b3Jkd2lzZWdhbWVyDgsSBk15VXNlchjJwQwM') order by score desc > > All the queries succeed, and the latter returns most of the proper > results. Do I have any recourse other than dropping and re-adding the > index? From what I've read the vacuum process is kind of a pain with a > Java app. -- 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.
