Debian Codegraph @

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

raw
1 #
2 # Make sure http://bugs.mysql.com/34053 remains fixed.
3 #
4
5
6 SET default_storage_engine=InnoDB;
7
8 # we do not really care about what gets printed, we are only
9 # interested in getting success or failure according to our
10 # expectations
11 -- disable_query_log
12 -- disable_result_log
13
14 CREATE USER 'shane'@'localhost' IDENTIFIED BY '12345';
15 FLUSH PRIVILEGES;
16
17 -- connect (con1,localhost,shane,12345,)
18
19 -- connection con1
20 -- error ER_SPECIFIC_ACCESS_DENIED_ERROR
21 SET GLOBAL innodb_status_output=ON;
22 -- error ER_SPECIFIC_ACCESS_DENIED_ERROR
23 SET GLOBAL innodb_status_output_locks=ON;
24
25 CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;
26 DROP TABLE innodb_monitor;
27 CREATE TABLE innodb_mem_validate (a INT) ENGINE=INNODB;
28 DROP TABLE innodb_mem_validate;
29 CREATE TABLE innodb_sql (a INT) ENGINE=INNODB;
30 DROP TABLE innodb_sql;
31 CREATE TABLE innodb_monitorx (a INT) ENGINE=INNODB;
32 DROP TABLE innodb_monitorx;
33 CREATE TABLE innodb_monito (a INT) ENGINE=INNODB;
34 DROP TABLE innodb_monito;
35 CREATE TABLE xinnodb_monitor (a INT) ENGINE=INNODB;
36 DROP TABLE xinnodb_monitor;
37 CREATE TABLE nnodb_monitor (a INT) ENGINE=INNODB;
38 DROP TABLE nnodb_monitor;
39
40 -- connection default
41 SET GLOBAL innodb_status_output=ON;
42 SET GLOBAL innodb_status_output_locks=ON;
43
44 -- connection con1
45 -- error ER_SPECIFIC_ACCESS_DENIED_ERROR
46 SET GLOBAL innodb_status_output=OFF;
47 -- error ER_SPECIFIC_ACCESS_DENIED_ERROR
48 SET GLOBAL innodb_status_output_locks=OFF;
49
50 -- connection default
51 SET GLOBAL innodb_status_output=OFF;
52 SET GLOBAL innodb_status_output_locks=OFF;
53 DROP USER 'shane'@'localhost';
54
55 -- disconnect con1