Hi.
On Fri 2002-07-26 at 11:00:31 -0400, [EMAIL PROTECTED] wrote:
> >
> >Hi Benjamin, Arjen
> >
> >I did some testing again. I have 75,000,000 rows table, after using group
> >by I got 62,300,000 rows.
> >If I use *nix -u sort, I got 74800,00 rows.
> >
> >I compared the two results, I feel I trust my *nix result. Some lines just
> >miss in "group by' result, look like no reason at all.
> >I think this is a bug.
> >If you like to see my two result, I can attach to you.
Well, my answer to this you can find in my former mail, already:
[...]
> >> Please try to find some rows which "disappear". For example, dump
> >> the result from the query (62,000,000 rows) to a file like you
> >> have done for the 76,500,000 rows and find out which rows got
> >> removed (e.g. sorting the files and using "comm" on the
> >> 76,000,000 and 62,000,000 version).
Greetings,
Benjamin.
PS: No, I do not think, that I would like a dump 75,000,000 rows send
to me. ;-)
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
