Continued implementation of WL#1324 (table name to filename encoding)

The intermediate (not temporary) files of the new table
during ALTER TABLE was visible for SHOW TABLES. These
intermediate files are copies of the original table with
the changes done by ALTER TABLE. After all the data is
copied over from the original table, these files are renamed 
to the original tables file names. So they are not temporary 
files. They persist after ALTER TABLE, but just with another 
name.

In 5.0 the intermediate files are invisible for SHOW TABLES
because all file names beginning with "#sql" were suppressed.

This failed since 5.1.6 because even temporary table names were
converted when making file names from them. The prefix became
converted to "@0023sql". Converting the prefix during SHOW TABLES
would suppress the listing of user tables that start with "#sql".

The solution of the problem is to continue the implementation of
the table name to file name conversion feature. One requirement
is to suppress the conversion for temporary table names.

This change is straightforward for real temporary tables as there
is a function that creates temporary file names.

But the generated path names are located in TMPDIR and have no
relation to the internal table name. This cannot be used for
ALTER TABLE. Its intermediate files need to be in the same
directory as the old table files. And it is necessary to be
able to deduce the same path from the same table name repeatedly.

Consequently the intermediate table files must be handled like normal
tables. Their internal names shall start with tmp_file_prefix
(#sql) and they shall not be converted like normal table names.

I added a flags parameter to all relevant functions that are
called from ALTER TABLE. It is used to suppress the conversion
for the intermediate table files.

The outcome is that the suppression of #sql in SHOW TABLES
works again. It does not suppress user tables as these are
converted to @0023sql on file level.

This patch does also fix ALTER TABLE ... RENAME, which could not 
rename a table with non-ASCII characters in its name.

It does also fix the problem that a user could create a table like
`#sql-xxxx-yyyy`, where xxxx is mysqld's pid and yyyy is the thread
ID of some other thread, which prevented this thread from running 
ALTER TABLE.

Some of the above problems are mentioned in Bug 1405, which can
be closed with this patch.

This patch does also contain some minor fixes for other forgotten
conversions. Still known problems are reported as bugs 21370,
21373, and 21387.

into  chilla.local:/home/mydev/mysql-5.1-aid

into  chilla.local:/home/mydev/mysql-5.1-amerge

Bug #20902 Alter table invalid schema version with statement-based binlogging
(latter caused by the above)

into  devsrv-b.mysql.com:/data0/knielsen/tmp-5.1

Small post-patch fixes

into  bodhi.local:/opt/local/work/mysql-5.1-runtime-merge-with-5.0

into  devsrv-b.mysql.com:/data0/knielsen/tmp-5.1

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

- keep accounting for aoutstanding drop trigger requests
- also lock table object in suma while doing that (should be impossible right now though since dict serializes all requests)

Disable test cases ndb_alter_table3, ndb_autodiscover3, ndb_dd_advance,
and ndb_multi in statement-based binlogging mode until bug can be fixed.

into  bodhi.netgear:/opt/local/work/mysql-5.1-runtime-merge-with-5.0

into  chilla.local:/home/mydev/mysql-5.1-amerge

into  govinda.patg.net:/home/patg/mysql-build/mysql-5.1-merge1

into  ymer.(none):/usr/local/mysql/tmp-5.1

into  bodhi.netgear:/opt/local/work/mysql-5.1-runtime-merge

removed alter table partition error test since it cannot be made predictable... name will change of created file

Fix random failures in test 'wait_timeout' that depend on exact timing.

1. Force a reconnect initially if necessary, as otherwise slow startup
might have caused a connection timeout before the test can even start.

2. Explicitly disconnect the first connection to remove confusion about
which connection aborts from timeout, causing test failure.

into  chilla.local:/home/mydev/mysql-5.1-amerge

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

into  bodhi.netgear:/opt/local/work/mysql-5.1-runtime-merge-with-5.0

into  bodhi.netgear:/opt/local/work/mysql-5.1-runtime-merge

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

into trift2.:/M51/bug20216-5.1

into  chilla.local:/home/mydev/mysql-5.1-ateam

into trift2.:/M51/merge-5.1

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

- missing order by

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

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

- don't invalidate tables that are in state RETRIEVING

into  chilla.local:/home/mydev/mysql-5.1-ateam