#mysql50# mixes up with table names in the table cache and on disk

CREATE TABLE `t`(id INT, c1 BINARY(10)) ENGINE=MEMORY;

INSERT INTO `t` VALUES(1, REPEAT(0x41,10));

SELECT id, HEX(c1) FROM `t`;

DROP TABLE IF EXISTS `#mysql50#t`;

CREATE TABLE `#mysql50#t`(id INT, c1 BINARY(1)) ENGINE=MEMORY;

INSERT INTO `#mysql50#t` VALUES(2, 0x42);

SELECT id, HEX(c1) FROM `#mysql50#t` WHERE id=2;

SELECT id, HEX(c1) FROM `t` ORDER BY id;

DROP TABLE IF EXISTS `t`, `#mysql50#t`;

SELECT id, HEX(c1) FROM `t` ORDER BY id;

id      HEX(c1)

1       41414141414141414141

2       42A5A5A5A5A5A5A5A5A5