Hand merged from 4.0.

1.) Added a new option to mysql_lock_tables() for ignoring FLUSH TABLES.
Used the new option in create_table_from_items().
It is necessary to prevent the SELECT table from being reopend.
It would get new storage assigned for its fields, while the
SELECT part of the command would still use the old (freed) storage.
2.) Protected the CREATE TABLE and CREATE TABLE ... SELECT commands
against a global read lock. This prevents a deadlock in
CREATE TABLE ... SELECT in conjunction with FLUSH TABLES WITH READ LOCK
and avoids the creation of new tables during a global read lock.
3.) Replaced set_protect_against_global_read_lock() and
unset_protect_against_global_read_lock() by
wait_if_global_read_lock() and start_waiting_global_read_lock()
in the INSERT DELAYED handling.

  Post-review modifications for the fix of bug #7894.

  Added test cases for bug #7894.
sql_select.cc:
  Fixed bug #7894: GROUP BY queries with ROLLUP returned
  wrong results for expressions containing group by columns.
  The fix ensured correct results by replacement of all
  occurrences of group by fields in non-aggregate expressions
  for corresponding ref objects and preventing creation of
  fields in temporary tables for expression containing group
  by fields.

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

into neptunus.(none):/home/msvensson/mysql/mysql-4.1

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

into mysql.com:/M40/mysql-4.0

into mysql.com:/M41/mysql-4.1

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

into neptunus.(none):/home/msvensson/mysql/mysql-4.1

Added some more ifdefs for "#pragma interface"

Added a missing "make clean" to the RPM "spec" file which had caused the original 4.1.12 RPMs to be broken.
(bug#10674, bug#10681)

into mysql.com:/home/my/mysql-4.1

Faster detection of wrong table names (like PRN) on windows

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

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

into zim.(none):/home/brian/mysql/mysql-4.1

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

into ua141d10.elisa.omakaista.fi:/home/my/bk/mysql-4.1

into mdk10.(none):/home/reggie/bk/41test2

into xiphis.org:/usr/home/antony/work2/p3-bug7241.5

  Only acquire necessary write lock for multi-delete