> Probably cause your table ends up being bigger than: > SHOW VARIABLES LIKE 'tmp_table%';
I don't think so. As I stated before (sorry I didn't include my first post), I have : tmp_table_size = 512M max_heap_table_size=512M >From my calculation, I would have ~2000 rows in the result of my query, and that would definitively not make 512M ! Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]