Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 --echo #
4 --echo # Bug #27566937 SERVER STARTUP CRASH AFTER SHUTDOWN IF TABLES
5 --echo # CREATED USING JUNK CHARACTER-DEBUG
6 --echo #
7
8 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11 SET NAMES utf8mb4 ;
12 # set character_set_database = utf8mb4;
13
14 --disable_warnings
15 DROP DATABASE IF EXISTS `mytest`;
16 CREATE DATABASE `mytest`;
17 USE `mytest`;
18 --enable_warnings
19 /*!40101 SET @saved_cs_client = @@character_set_client */;
20 SET character_set_client = utf8mb4 ;
21 CREATE TABLE `???]?yt???c??.?t??*?nb???%fk2???1??\?` (c1 int
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
23 /*!40101 SET character_set_client = @saved_cs_client */;
24
25 CREATE TABLE `mytest` (c1 int);
26
27 --source include/restart_mysqld.inc
28
29 USE mytest;
30 SELECT COUNT(*) FROM mytest;
31 SELECT COUNT(*) FROM `???]?yt???c??.?t??*?nb???%fk2???1??\?`;
32
33 DROP DATABASE IF EXISTS `mytest`;
34
35 # There is an issue where the server throws out error while creating the table
36 # in the next test case.
37 # Remove the following exit once this issue is fixed.
38 --exit
39
40 --disable_warnings
41 DROP DATABASE IF EXISTS `???]?yt???c?^S^F?.?t??*?nb???%f^_k2???^^1?^D?\^Y?`;
42 CREATE DATABASE `???]?yt???c?^S^F?.?t??*?nb???%f^_k2???^^1?^D?\^Y?`;
43 USE `???]?yt???c?^S^F?.?t??*?nb???%f^_k2???^^1?^D?\^Y?`;
44 --enable_warnings
45 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
46 /*!40103 SET TIME_ZONE='+00:00' */;
47 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
48 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
49 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
50 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
51
52 /*!40101 SET @saved_cs_client = @@character_set_client */;
53 SET character_set_client = utf8mb4 ;
54 CREATE TABLE `???]?yt???c??.?t??*?nb???%fk2???1??\?` (c1 int)
55 ENGINE=InnoDB;
56 /*!40101 SET character_set_client = @saved_cs_client */;
57
58 --source include/restart_mysqld.inc
59
60 use `???]?yt???c?^S^F?.?t??*?nb???%f^_k2???^^1?^D?\^Y?`;
61 SELECT COUNT(*) FROM `???]?yt???c??.?t??*?nb???%fk2???1??\?`;
62
63 DROP DATABASE IF EXISTS `???]?yt???c?^S^F?.?t??*?nb???%f^_k2???^^1?^D?\^Y?`;