Comment 5 for bug 523593

And after I have disabled table elimination, it has been running for half an hour without crashes.

Hakan, could you please try running with this patch? Do you still observe the crash? (we need to patch the source as table_elimination has @@optimizer_switch flag only in debug builds)

=== modified file 'sql/sql_select.cc'
--- sql/sql_select.cc 2010-01-15 15:27:55 +0000
+++ sql/sql_select.cc 2010-02-18 09:58:30 +0000
@@ -2705,7 +2705,7 @@ make_join_statistics(JOIN *join, TABLE_L

   join->const_table_map= 0;
   join->const_tables= const_count;
- eliminate_tables(join);
+ // eliminate_tables(join);
   const_count= join->const_tables;
   found_const_table_map= join->const_table_map;