Le mardi 24 janvier 2006 à 09:19 +0100, Martijn Tonies a écrit : >> CREATE TABLE `tp_participation` ( >> `uid` int(11) NOT NULL default '0', >> `challenge_id` int(11) NOT NULL default '0', >> `response` text collate latin1_general_ci NOT NULL, >> `points` int(11) default NULL, >> UNIQUE KEY `tp_id_part` (`uid`,`challenge_id`), >> KEY `tp_idx_part_solution` (`challenge_id`,`response`(4)) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; > > select * from tp_participation where challenge_id=20 > > > 10 records. > > > > select challenge_id from tp_participation where challenge_id=20 > > > _two_ records with the value "20". > > What are the results if you drop all constraints and indices? >
Thank you a lot for your answer. The bug is there: if I drop the index 'tp_idx_part_solution', the result of the count is OK. I recreated this index and the cound drop to "2" again. Fabien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
