Bug #73920 [ERROR] Invalid (old?) table or database name 'xyz'

• Submitted: 15 Sep 2014 10:34
• Modified: 7 Oct 2016 6:20
• Reporter: Roel Van de Paar
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S2 (Serious)
• Version: 5.6.20, 5.6.22, 5.7.6, 5.6.23
• OS: Any
• CPU Architecture: Any

[15 Sep 2014 10:34] Roel Van de Paar

Description:
mysql> CREATE DATABASE `#mysql50#mysqltest-1`;
Query OK, 1 row affected (0.00 sec)

Yet:

2014-09-16 06:28:15 26624 [ERROR] Invalid (old?) table or database name 'mysqltest-1'

And yet:

mysql> SHOW DATABASES;
+----------------------+
| Database             |
+----------------------+
| #mysql50#mysqltest-1 |
...

How to repeat:
CREATE DATABASE `#mysql50#mysqltest-1`;

Suggested fix:
Error log error fix?

[15 Sep 2014 10:51] MySQL Verification Team

Hello Roel,

Thank you for the bug report and test case.

Thanks,
Umesh

[15 Sep 2014 10:53] MySQL Verification Team

// 5.7.6

2014-09-17T01:39:12.283674Z 26 [ERROR] Invalid (old?) table or database name 'mysqltest-1

// 5.6.22

2014-09-17 07:17:03 28215 [ERROR] Invalid (old?) table or database name 'mysqltest-1'
2014-09-17 07:17:03 28215 [ERROR] Invalid (old?) table or database name 'mysqltest-2'

execute "SHOW DATABASES", after DDL.

[19 Nov 2014 5:42] MySQL Verification Team

Bug #74921 marked as duplicate of this one.

[19 Nov 2014 7:41] MySQL Verification Team

regarding Roels challenge to me, I filed:
http://bugs.mysql.com/bug.php?id=74645

[16 Feb 2015 6:04] MySQL Verification Team

Bug #75909 Marked as duplicate of this one.

[29 Dec 2015 0:01] Roel Van de Paar

Any updates?

DROP DATABASE test;CREATE DATABASE test;USE test;
create table `#mysql50#t1-1`(a int)engine=InnoDB;
SHOW TRIGGERS LIKE 't1';

[29 Dec 2015 0:01] Roel Van de Paar

Seen in many QA runs.

[7 Jan 2016 12:52] Ståle Deraas

Posted by developer:
 
Roel, see http://dev.mysql.com/worklog/task/?id=8186

[7 Oct 2016 6:20] Roel Van de Paar

Thanks Ståle!

Here's another one;

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE `#mysql50#@` (a varchar(1)) ENGINE=InnoDB;
SHOW TABLES;

Then shutdown and look at error log;

2016-10-07 16:58:02 3422 [ERROR] Invalid (old?) table or database name '@'

[10 May 2017 10:32] MySQL Verification Team

Bug #86264 marked as duplicate of this one