Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

When answering this question, I wrote up this SQL answer, which works fine from my machine.

However, on SE data, it always picks the same winner. Is it possible that SE Data fixes rand() to a specific number? If so, why is that?

share|improve this question
up vote 8 down vote accepted

The data explorer caches results; if you run identical queries, it will only call the database once, and deliver the cached result on subsequent queries.

share|improve this answer
    
That explains it, perhaps SE Data could explain a warning for queries using rand() – Andomar Jul 28 '11 at 9:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .