Fix ambigious table error for INSERT..SELECT..UPDATE

into mysql.com:/home/psergey/mysql-4.1-bug8218

into mysql.com:/home/svoj/devel/mysql/mysql-4.1

into poseidon.ndb.mysql.com:/home/tomas/mysql-4.1

Fix for crash when using a double quote in boolean fulltext query.

  Alter handling for UNION syntax
  Tests for UNION and parentheses

into hundin.mysql.fi:/home/heikki/mysql-4.1

  Backport the column prefix memory corruption fix from 5.0

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

into deer.(none):/home/hf/work/mysql-4.1.clean

Remove TMP_TABLE_PARAM::copy_funcs_it. TMP_TABLE_PARAM is a member of JOIN which is 
copied via memcpy, and List_iterator_fast TMP_TABLE_PARAM::copy_funcs_it ends up 
pointing to the wrong List.

new static archive_inited variable, so that archive_db_end() will do something only if archive_db_init() was run before
(protection against destroying uninited mutex in the case where mysqld fails early at startup (before archive_db_init() was called)
and then calls archive_db_end() to clean up).

into deer.(none):/home/hf/work/mysql-4.1.clean

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

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

into rurik.mysql.com:/home/igor/dev/mysql-4.1-0

  Adjustment of the result file after the revision of the fix for bug #7520.

into rurik.mysql.com:/home/igor/dev/mysql-4.0-0

  After revision of the fix for bug #7520.
table.cc:
  Revised the fix for bug #7520.
  Made it compliant with 5.0 code where the bug does not exist.

into mysql.com:/M41/mysql-4.1

into mysql.com:/M40/mysql-4.0

into mysql.com:/home/mydev/mysql-4.1-bug8306

into rurik.mysql.com:/home/igor/dev/mysql-4.1-0

  Adjusted results of the test case for bug #7520 for 4.1.

into rurik.mysql.com:/home/igor/dev/mysql-4.0-0

into rurik.mysql.com:/home/igor/dev/mysql-4.1-0

  Added a test case for bug #7520.
table.cc:
  Fixed bug #7520.
  The bug was caused by a wrong calculation of the field max_key_length for
  a TABLE structure when there was an index on a blob field.

Set of fixes requested by Kent in IRC. Tested (except the windows changes since I am trusting Kent...). No windows compiles here folks...

into mysql.com:/home/jimw/my/mysql-4.0-clean