List:General Discussion« Previous MessageNext Message »
From:Aman Raheja Date:February 6 2003 11:03pm
Subject:Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
View as plain text  
HINT:
I have used PERL to generate random numbers and then do a SELECT on the
auto_increment field in the mysql table, thus generating random picks from
my tables;
I'll be glad to bet informed of better ways around, though :)

Thanks
Aman Raheja
AGF Inc.

----- Original Message -----
From: "Tue Tønning" <tt@stripped>
To: <mysql@stripped>
Sent: Wednesday, February 05, 2003 1:38 PM
Subject: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)


> Hey,
>
> I have discovered a strange error in the mysql versions mentioned in subj.
>
> Example.
> A table with 10 entries ...i want to draw 3 randomly
> => "select fieldName from tableName order by RAND() limit 3"
>
> this have worked for the last year or so.....but after upgrading our
redhat
> 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the
> same 3 entires.
>
> using a Seed doesnt make it perfect either (i know that the manual says
that
> RAND() isnt perfect - but now it doesnt work at all).
>
> A quick search on google says me that im not the only one having the
> problem. I can also see on some Danish messageboards that other have the
> same problems with the new version.
>
> So my question is .....What to do ?
> I cant imagine that you have removed the functionality of RAND from mysql
> again ?
> i know its only been in there since early ~3.23....
>
> I work professionally as a webdevolper (CEO of a firm) and we need to find
a
> solution to this problem badly.
>
> I hope you can guide me to a solution. Cause i would hate to change all
the
> sql calls in the projects we have coded the last 1½ year.... and it would
be
> nice to know if we would be able to use RAND() in the future.
>
> Ohh, yeah - we code in PHP......and i have talked today with 3 other
> webdevelopment companies that have been struggeling with the same error
> after upgrading.
>
> Med venlig hilsen / Best regards
>
> Tue Tønning
> --------------------
> AT-Orbital I/S
> Helsingforsgade 27, 1
> DK-8200 Aarhus N
> Denmark
> Phone +45 8942 5860
> Web   www.atorbital.com
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread131699@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-amanmysql=hotmail.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Thread
RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)Tue T√łnning5 Feb
  • Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)Aman Raheja7 Feb
  • Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)Sergei Golubchik11 Feb