Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_sql_cmds_1.result

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