|
Server : Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 System : Linux server.jackjohnson.com 2.6.32-279.5.2.el6.x86_64 #1 SMP Fri Aug 24 01:07:11 UTC 2012 x86_64 User : jackjohn ( 502) PHP Version : 5.3.17 Disable Function : NONE Directory : /usr/share/mysql-test/r/ |
Upload File : |
drop database if exists mysqltest1; create schema foo; show create schema foo; Database Create Database foo CREATE DATABASE `foo` /*!40100 DEFAULT CHARACTER SET latin1 */ show schemas; Database information_schema foo mtr mysql test drop schema foo; # # Bug#54360 Deadlock DROP/ALTER/CREATE DATABASE with open HANDLER # CREATE DATABASE db1; CREATE TABLE db1.t1 (a INT); INSERT INTO db1.t1 VALUES (1), (2); # Connection con1 HANDLER db1.t1 OPEN; # Connection default # Sending: DROP DATABASE db1; # Connection con2 # Waiting for 'DROP DATABASE db1' to sync in. # Connection con1 CREATE DATABASE db2; ALTER DATABASE db2 DEFAULT CHARACTER SET utf8; DROP DATABASE db2; # Connection default # Reaping: DROP DATABASE db1