Did you dump the 24 records on both boxes and compare them?
Maybe someone updated the records on the slave, and now the dates don't
match.
Vico Timmermans wrote:
>I think i stumbled upon a bug that's got something to do with join
>size. Detailed information below.
>
>Using 2 intel-linux platforms with replication the query stated
>below works fine on one machine:
>- mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686)
>- Linux deedee 2.2.16-SMP #1 SMP Wed Aug 16 05:07:06 GMT 2000 i686
>unknown
>and gives reduced results on the other:
>- mysql Ver 11.15 Distrib 3.23.41, for suse-linux (i686)
>- Linux blossom 2.4.10-4GB #1 Fri Sep 28 17:20:21 GMT 2001 i686 unknown
>
>The query states as follows:
>SELECT isp.naam AS provider, MID(log.logtijd,1,10) AS datum,
>acties.adres AS adres, acties.omschrijving AS adres_omschrijving,
>SUM(log.data) AS bytes, SUM(log.duur)/10 AS seconden,
>SUM(log.data)*80/SUM(log.duur) AS kbs, COUNT(*) AS aantal,
>inbelpunten.id, inbelpunten.plaats, inbelpunten.netwerk FROM log, taken,
>deploy , acties , inbelpunten, isp WHERE log.taakID = taken.ID AND
>taken.deployID = deploy.ID AND log.actieID = acties.ID AND
>taken.inbelpuntid=inbelpunten.id AND inbelpunten.ispid=isp.id AND
>log.logtijd >= '2002-03-22' and log.logtijd < DATE_ADD('2002-03-28',
>INTERVAL 1 DAY) AND (deploy.keyword = 'STISDN') AND taken.medium='isdn'
>AND ((log.meldingid = 10) OR (log.meldingid = 11) OR (log.meldingid =
>12)) GROUP BY isp.ID ORDER BY kbs DESC
>
---------------------------------------------------------------------
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
