RE: ERROR 3: Error writing file 'UNOPENED' (Errcode: 9)

[Michael Widenius]

>>>>> "Quentin" == Quentin Bennett <quentin.bennett@stripped>
> writes:

Quentin> Hope this helps
Quentin>  <<mysqld.trace>> 

<cut>

Yes!

This was a bug that was depending on how the compiler optimizes |
expressions.

Here is a fix for this:

*** /my/monty/master/mysql-3.22.24/sql/sql_class.cc	Thu Jan 21 03:07:58 1999
--- ./sql_class.cc	Tue Aug  3 15:13:29 1999
***************
*** 365,371 ****
  
  void select_export::send_eof()
  {
!   if (end_io_cache(&cache) | my_close(file,MYF(MY_WME)))
      ::send_error(&thd->net);
    else
      ::send_ok(&thd->net,row_count);
--- 365,374 ----
  
  void select_export::send_eof()
  {
!   int error=end_io_cache(&cache);
!   if (my_close(file,MYF(MY_WME)))
!     error=1;
!   if (error)
      ::send_error(&thd->net);
    else
      ::send_ok(&thd->net,row_count);

Regards,
Monty