Debian Codegraph @

mysql-test/suite/perfschema/r/idx_ees_by_user_by_error.result

raw
1 create user foo@localhost;
2 grant ALL on *.* to foo@localhost;
3
4 ====================================================================
5 Testing index for columns USER, ERROR_NUMBER
6 ====================================================================
7 ############ Explain for Query ####################################
8 explain select SUM_ERROR_RAISED
9 from performance_schema.events_errors_summary_by_user_by_error
10 where USER = "impossible";
11 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
12 1 SIMPLE events_errors_summary_by_user_by_error NULL ref USER USER 129 const # 100.00 NULL
13 ############ Explain for Query ####################################
14 explain select SUM_ERROR_RAISED
15 from performance_schema.events_errors_summary_by_user_by_error
16 where USER > "impossible";
17 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
18 1 SIMPLE events_errors_summary_by_user_by_error NULL ALL USER NULL NULL NULL # 33.33 Using where
19 ############ Explain for Query ####################################
20 explain select SUM_ERROR_RAISED
21 from performance_schema.events_errors_summary_by_user_by_error
22 where USER < "2";
23 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
24 1 SIMPLE events_errors_summary_by_user_by_error NULL ALL USER NULL NULL NULL # 33.33 Using where
25 ############ Explain for Query ####################################
26 explain select SUM_ERROR_RAISED
27 from performance_schema.events_errors_summary_by_user_by_error
28 where USER = "foo";
29 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
30 1 SIMPLE events_errors_summary_by_user_by_error NULL ref USER USER 129 const # 100.00 NULL
31 ############ Explain for Query ####################################
32 explain select SUM_ERROR_RAISED
33 from performance_schema.events_errors_summary_by_user_by_error
34 where USER = "impossible"
35 and ERROR_NUMBER = "impossible";
36 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
37 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
38 ############ Explain for Query ####################################
39 explain select SUM_ERROR_RAISED
40 from performance_schema.events_errors_summary_by_user_by_error
41 where USER = "foo"
42 and ERROR_NUMBER = "impossible";
43 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
44 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
45 ############ Explain for Query ####################################
46 explain select SUM_ERROR_RAISED
47 from performance_schema.events_errors_summary_by_user_by_error
48 where USER = "foo"
49 and ERROR_NUMBER > "impossible";
50 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
51 1 SIMPLE events_errors_summary_by_user_by_error NULL ref USER USER 129 const # 33.33 Using where
52 ############ Explain for Query ####################################
53 explain select SUM_ERROR_RAISED
54 from performance_schema.events_errors_summary_by_user_by_error
55 where USER = "foo"
56 and ERROR_NUMBER < "2";
57 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
58 1 SIMPLE events_errors_summary_by_user_by_error NULL ref USER USER 129 const # 33.33 Using where
59 ############ Explain for Query ####################################
60 explain select SUM_ERROR_RAISED
61 from performance_schema.events_errors_summary_by_user_by_error
62 where USER = "foo"
63 and ERROR_NUMBER = "1146";
64 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
65 1 SIMPLE events_errors_summary_by_user_by_error NULL const USER USER 134 const,const # 100.00 NULL
66 ############# Explain End #########################################
67 flush status;
68 select SUM_ERROR_RAISED
69 from performance_schema.events_errors_summary_by_user_by_error
70 where USER = "foo"
71 and ERROR_NUMBER = "1146";
72 SUM_ERROR_RAISED
73 #
74 OK: handler_read_key incremented
75 drop user foo@localhost;