| 1 |
SET NAMES utf8; |
| 2 |
call mtr.add_suppression("Invalid .old.. table or database name"); |
| 3 |
# |
| 4 |
# Bug #19929435 DROP DATABASE HANGS WITH MALFORMED TABLE |
| 5 |
# |
| 6 |
set session default_storage_engine=innodb; |
| 7 |
create database `b`; |
| 8 |
use `b`; |
| 9 |
create table `#mysql50#q.q` select 1; |
| 10 |
ERROR 42000: Incorrect table name '#mysql50#q.q' |
| 11 |
create table `#mysql50#q·q` select 1; |
| 12 |
drop database `b`; |
| 13 |
# |
| 14 |
# MDEV-27336 Crash on DROP DATABASE due to out-of-bounds result |
| 15 |
# from InnoDB SUBSTR() function |
| 16 |
# |
| 17 |
USE test; |
| 18 |
CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB; |
| 19 |
CREATE TABLE t2(a INT PRIMARY KEY REFERENCES t1(a)) ENGINE=InnoDB; |
| 20 |
CREATE DATABASE somewhat_longer_name_to_cause_trouble; |
| 21 |
DROP DATABASE somewhat_longer_name_to_cause_trouble; |
| 22 |
DROP TABLE t2,t1; |