MySQL Bugs: #74921: [ERROR] Invalid (old?) table or database name 'a@b'

Bug #74921	[ERROR] Invalid (old?) table or database name 'a@b'
Submitted:	19 Nov 2014 1:32	Modified:	20 Nov 2014 2:59
Reporter:	Roel Van de Paar (OCA)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S2 (Serious)
Version:	5.6.20	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	opt

Description:
Version: '5.6.20'  socket: '/sda/mysql-5.6.20-linux-glibc2.5-x86_64/socket.sock'  port: 17231  MySQL Community Server (GPL)
2014-11-19 10:20:23 3417 [ERROR] Invalid (old?) table or database name 'a@b'

I have seen this at exactly the same time as a crash. I expect that with some testcase tweaking it may be able to sig11 mysqld with this.

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE DATABASE `#mysql50#a@b`;
SHOW DATABASES LIKE "TEST%";

Hello Roel,

Thank you for the report.
This is duplicate of Bug #73920.

// with 5.6.23

[test]> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.23                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.23-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | Linux                                                   |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

[test]> CREATE DATABASE `#mysql50#a@b`;
Query OK, 1 row affected (0.00 sec)

[test]> SHOW DATABASES LIKE "TEST%";
Empty set (0.00 sec)

[test]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| #mysql50#a@b       |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

[test]> CREATE DATABASE `#mysql50#mysqltest-1`;
Query OK, 1 row affected (0.00 sec)

[test]> show databases;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| #mysql50#a@b         |
| mysql                |
| #mysql50#mysqltest-1 |
| performance_schema   |
| test                 |
+----------------------+
6 rows in set (0.00 sec)

// Extracted from 

2014-11-21 12:44:27 6982 [ERROR] Invalid (old?) table or database name 'a@b'
2014-11-21 12:44:33 6982 [ERROR] Invalid (old?) table or database name 'a@b'
2014-11-21 12:44:47 6982 [ERROR] Invalid (old?) table or database name 'a@b'
2014-11-21 12:44:47 6982 [ERROR] Invalid (old?) table or database name 'mysqltest-1'

Thanks,
Umesh

Agreed