0

The following simpledb query returns 51 results:

select * from logger where time > '2011-07-29 17:45:10.540284+00:00'

This query returns 20534 results:

select * from logger where time < '2011-07-29 17:50:08.615626'

These two queries both return 0 results!!?:

select * from logger where time between '2011-07-29 17:45:10.540284+00:00' and '2011-07-29 17:50:08.615626'

select * from logger where time > '2011-07-29 17:45:10.540284+00:00' and time < '2011-07-29 17:50:08.615626'

What am I missing here?

josh
  • 9,038
  • 8
  • 31
  • 37

1 Answers1

2

But are any of your 51 results returned from the first query actually within the time span you are searching? If they are all later than 17:50:08.615626 then your queries are performing as expected.

I am also suspicious of the fact that you are being inconsistent in how you are representing the time. You should really be using ISO 8601 timestamps if you want consistent lexicographic matching of times with SDB.

The other option is that the queries are taking longer than the query timeout to run, are you checking for errors?

Finally - perhaps SDB is having a bad day and the query is just a bit slow - in those circumstances you can find you get 0 results but DO get a next token - and the actual results follow in the next batch.

Does any of that help?

Roger
  • 15,793
  • 4
  • 51
  • 73
  • Oh right -- I totally missed checking that any of my entries were in the original range. Yeah, as it turns out, there aren't any (although I'm pretty sure there was at one point, maybe I somehow nuked it). – josh Jul 30 '11 at 19:14