1call mtr.add_suppression("This is a warning from test plugin");
2call mtr.add_suppression("This is an error from test plugin");
3------ Setup ------------------------------------------------
4CREATE DATABASE mydb;
5------ Run plugin ------------------------------------------------
6INSTALL PLUGIN test_sql_cmds_1 SONAME 'TEST_SQL_CMDS_1';
7------ Stop plugin -----------------------------------------------
8UNINSTALL PLUGIN test_sql_cmds_1;
9------ Check output from tested service --------------------------------------
10======================================================
11COM_QUERY-----------------------------------------------------------------
12SELECT id,info FROM information_schema.processlist
13-----------------------------------------------------------------
14info
15num_cols: 2
16server status: 34
17warn count: 0
18-----------------------------------------------------------------
19SELECT * FROM information_schema.global_variables WHERE variable_name LIKE 'INNODB_READ_IO_THREADS'
20-----------------------------------------------------------------
21info
22num_cols: 2
23server status: 34
24warn count: 1
25ERROR 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1
26error after bad SQL: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'garbage' at line 1
27srv_session_close.
28======================================================
29current_db before init_db : (null)
30current_db after init_db  : mysql
31======================================================
32COM_KILL
33session is dead? 0
34session is dead now? 1053
35======================================================
36test_query_kill
37session is dead? 0
38Executing select sleep(10)
39run KILL QUERY
40Killed run_command return value: 0
41thread shutdown: 0 (no)
42thread error: 0
43thread error msg:
44session is dead (after)? 0
45OK
46======================================================
47COM_QUERY with priv
48create user as root: 0
49now try as ordinary user
50ERROR 1227 Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
51create user supposed to fail: 1227 Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
52drop user as root: 0
53------- Cleanup --------------------------------------
54DROP DATABASE mydb;
55