Debian Codegraph @

mysql-test/suite/innodb/t/dropdb.test

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