Hi,

I have a new test case for the cache corruption.

How-to-repeat :

CREATE TABLE `online` ( `pseudo` char(35) NOT NULL default '', `date` int(10) unsigned NOT NULL default '0', `cat` tinyint(4) unsigned NOT NULL default '0', `forum` tinyint(3) unsigned NOT NULL default '0', `search` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`pseudo`), KEY `date` (`date`), KEY `forum` (`forum`) ) TYPE=HEAP; reset query cache; SELECT COUNT(*) FROM online WHERE forum=1; SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefrtest7 WHERE numeropost='39938' ORDER BY numreponse ASC LIMIT 0,40; REPLACE INTO online (pseudo,date,cat,forum) VALUES ('Funkelly',1008688851,1,1); SELECT haut,bas FROM forumpubhardwarefrtest WHERE cat='7'; SELECT haut,bas FROM forumpubhardwarefrtest WHERE cat='7'; flush query cache; SELECT haut,bas FROM forumpubhardwarefrtest WHERE cat='7'; SELECT haut,bas FROM forumpubhardwarefrtest WHERE cat='7';

You can see the corruption here :

Not cached :

haut bas \ntagi1 = "http://ds.ad2-one.com/hserver/SITE=HARDWAREFR/AREA=FORUM.OTHERS/CO=FR/LANG= FR/AAMSZ=468X60/POS=TOP/ACC_RANDOM=" + ord + "\ntagj1 = "http://ds.ad2-one.com/jnserver/SITE=HARDWAREFR/AREA=FORUM.OTHERS/CO=FR/LANG =FR/AAMSZ=468X60/POS=TOP/ACC_RANDOM=" + ord + \ndocument.write("<IFRAME src=" + tagi1 + " noresize scrolling=\\"no\\" hspace=\\"0\\" vspace=\\"0\\" frameborder=\\"0\\" marginheig\n<NOSCRIPT><A href="http://ds.ad2-one.com/accipiter/adclick/SITE=HARDWAREFR/CO=FR/LANG=FR/ AREA=FORUM.OTHERS/AAMSZ=468X60/POS=TOP/ACC_RANDOM=995496626?"><IMG src="http://ds.ad2-one.com/accipiter/nserver/SITE=HARDWAREFR/CO=FR/LANG=FR/A REA=FORUM.OTHERS/AAMSZ=468X60/\n</center>_RAND<BR><BR><A href="http://www.hit-parade.com/hp.asp?site=p576" target="_blank"><FONT face="Arial, Helvetica" size="2" class="size2a"><IMG src="http://logp.hit-parade.com/logohp1.gif?site=p576" width="77" height="15" border="0" alt="Hit-Parade"></FONT\n\t<NOSCRIPT><A HREF="http://www.weborama.com">Mesure d'audience et statistiques</A><BR><A HREF="http://www.weborama.fr">Classement\n\t<noscript><a href="http://www.xiti.com/xiti.asp?s=28067" TARGET="_top"><img width="39" height="25" border="0" align="absbottom" src="http://logv5.xiti.com/hit.xiti?s=28067&p=&" alt="Mesurez votre audience"></a></noscript>

Cached :

haut bas \ntagi1 = "http://ds.ad2-one.com/hserver/SITE=HARDWAREFR/AREA=FORUM.OTHERS/CO=FR/LANG= FR/AAMSZ=468X60/POS=TOP/ACC_RANDOM=" + ord + "\ntagj1 = "http://ds.ad2-one.com/jnserver/SITE=HARDWAREFR/AREA=FORUM.OTHERS/CO=FR/LANG =FR/AAMSZ=468X60/POS=TOP/ACC_RANDOM=" + ord + \ndocument.write("<IFRAME src=" + tagi1 + " noresize scrolling=\\"no\\" hspace=\\"0\\" vspace=\\"0\\" frameboru¥@u¥@" marginheight=\\n<NOSCRIPT><A href="http://ds.ad2-one.com/accipiter/adclick/SITE=HARDWAREFR/CO=FR/LANG=FR/ AREA=FORUM.OTHERS/AAMSZ=468X60/POS=TOP/ACC_RANDOM=995496626?"><IMG src="http://ds.ad2-one.com/accipiter/nserver/SITE=HARDWAREFR/CO=FR/LANG=FR/A REA=FORUM.OTHERS/AAMSZ=468X60/\n</center>_RAND<BR><BR><A href="http://www.hit-parade.com/hp.asp?site=p576" target="_blank"><FONT face="Arial, Helvetica" size="2" class="size2a"><IMG src="http://logp.hit-parade.com/logohp1.gif?site=p576" width="77" height="15" border="0" alt="Hit-Parade"></FONT\n\t<NOSCRIPT><A HREF="http://www.weborama.com">Mesure d'audience et statistiques</A><BR><A HREF="http://www.weborama.fr">Classement\n\t<noscript><a href="http://www.xiti.com/xiti.asp?s=28067" TARGET="_top"><img width="39" height="25" border="0" align="absbottom" src="http://logv5.xiti.com/hit.xiti?s=28067&p=&" alt="Mesurez votre audience"></a></noscript>

I uploaded the forumpubhardwarefrtest table in support.mysql.com/pub/mysql/secret/newcrash.tar.gz I also reuploaded the threadhardwarefrtest7 table in support.mysql.com/pub/mysql/secret/crash.tar.gz

Best regards,

Jocelyn Fournier Presence-PC www.presence-pc.com