Added SQL_SELECT::cleanup() to make it easier to reuse SQL_SELECT item's for sub selects. Needed for proper fix for bug #2479.
Added 'select_to_file' class to be able to merge identical code for select_export and select_dump

Fixed bug in optimizer where it didn't choose right table order in some cases

into eagle.mysql.r18.ru:/home/vva/work/BUG_2310/mysql-4.1

into bar.intranet.mysql.r18.ru:/usr/home/bar/mysql-4.1

into serg.mylan:/usr/home/serg/Abk/mysql-4.1

into gw.mysql.r18.ru:/usr/home/ram/work/4.1.b2182

into pcgem.rdg.cyberkinetica.com:/usr/home/acurtis/work/wl1280-fix

(same as ChangeSet@1.1538.36.1, 2003-06-12 12:41:29+02:00, serg@serg.mylan, "FT2 bug in mi_delete fixed")
BUG#2417

into sanja.is.com.ua:/home/bell/mysql/bk/work-insert-4.1

test fixed

into sanja.is.com.ua:/home/bell/mysql/bk/work-exists-4.1

into sanja.is.com.ua:/home/bell/mysql/bk/work-ft_derived-4.1

check of memory allocation operation was added

into sanja.is.com.ua:/home/bell/mysql/bk/work-sub-4.1

into sanja.is.com.ua:/home/bell/mysql/bk/work-sub-4.1

into sanja.is.com.ua:/home/bell/mysql/bk/work-drop-4.1

into mysql.com:/space/my/mysql-4.1-build

   call to /usr/bin/awk - replaced this with the proper autoconf variable
   instead (makelist is now generated out of makelist.sh during the compile
   phase)

into sinisa.nasamreza.org:/mnt/work/mysql-4.1

into bar.intranet.mysql.r18.ru:/usr/home/bar/mysql-4.1

  http://bugs.mysql.com/bug.php?id=2386
  Index.xml file larger than 1024*16
  Fix for the above bug.

Blame me!

  http://bugs.mysql.com/bug.php?id=2218
  updating utf-8 text field generate nonsense chars
  Fix for the above bug.

  Unnesessary copying was fixed

open a file that already existed. The problem was that end_io_cache()
was called even if init_io_cache() was not. This affected both
OUTFILE and DUMPFILE (both fixed). Sometimes wrongly aligned pointer was freed,
sometimes mysqld core dumped.

Other problem was that select_dump::send_error removed the dumpfile,
even if it was created by an earlier run, or by some other program, if
the file permissions just permitted it. Fixed it so that the file will
only be deleted, if an error occurred, but the file was created by mysqld
just a moment ago, in that thread.

On the other hand, select_export did not handle the corresponding garbage
file at all. Both fixed.

After these fixes, a big part of the select_export::prepare and select_dump::prepare
code became identical. Merged the code into a new function called create_file(),
which is now called by the two latter functions.

Regards,
Jani

with --disable-quote

Added --compatible=ansi mode.

Fixed a non-reported bug in compatible mode; there was a check for
/*!41000 */ at this part of the code, while it obviously should have been
/*!40100 */. So the mysqldump compatiple mode made for 4.0.1 will not work
until 4.10 or later server is released :P Fixed into 4.0.2.

Bug#2080