MySQL Bugs: #42348: Table name '@' cannot be dropped (test "mysqlcheck")

Bug #42348	Table name '@' cannot be dropped (test "mysqlcheck")
Submitted:	26 Jan 2009 15:06	Modified:	8 Jul 2009 9:29
Reporter:	Joerg Bruehe	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	6.0.9	OS:	Linux (PPC)
Assigned to:		CPU Architecture:	Any

Description:
In current 6.0 (2009-Jan-23), test "mysqlcheck" fails with this symptom:

=====
main.mysqlcheck                [ fail ]

mysqltest: At line 129: query 'DROP TABLE `@`' failed: 1051: Unknown table '@'

The result from queries just before the failure was:
< snip >
v1
show tables;
Tables_in_test
t1
v1
v-1
drop view v1, `v-1`;
drop table t1;
SET NAMES utf8;
CREATE TABLE `#mysql50#@` (a INT);
SHOW TABLES;
Tables_in_test
�~@��
SET NAMES DEFAULT;
mysqlcheck --fix-table-names --databases test
SET NAMES utf8;
SHOW TABLES;
Tables_in_test
�~@��
DROP TABLE `@`;

More results from queries before failure can be found in /MySQL/REPO/V60/work-6.0/mysql-test/var/log/mysqlcheck.log

Stopping All Servers
=====

I ran a build followed by "make test-force" using identical sources on my Linux/PPC and Linux/Athlon,
on the PPC both test runs (normal and PS) failed with the above output
while on the Athlon both runs succeeded.

I suspect this might be caused by the PPC being a big-endian machine, while the Athlon is a mainline x86 (little-endian).
Both machines use gcc:
  gcc (Debian 4.3.2-1.1) 4.3.2        (PPC)
  gcc (GCC) 4.2.1 (SUSE Linux)        (Athlon)

How to repeat:
Build + test on a PPC machine.

Set the wrong field :-(

Sorry, the version info about gcc on the PPC machine is wrong:
The binary was compiled using
  gcc (GCC) 4.1.3 20080704 (prerelease) (Debian 4.1.2-24)

(A Debian upgrade after the build had switched it to 4.3,
but I don't use that for builds of 6.0 because of bug 40065)

According to XRef2, this does not happen any more.

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=&test_ou...