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