What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

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

1 Answer 1

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 .