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.
