Debian Codegraph @

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

raw
1 select PROCESSLIST_ID from performance_schema.session_account_connect_attrs limit 1
2 into @plid;
3
4 ====================================================================
5 Testing index for columns PROCESSLIST_ID, ATTR_NAME
6 ====================================================================
7 ############ Explain for Query ####################################
8 explain select ORDINAL_POSITION
9 from performance_schema.session_account_connect_attrs
10 where PROCESSLIST_ID = "impossible";
11 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
12 1 SIMPLE session_account_connect_attrs NULL ref PRIMARY PRIMARY 8 const # 100.00 Using where
13 ############ Explain for Query ####################################
14 explain select ORDINAL_POSITION
15 from performance_schema.session_account_connect_attrs
16 where PROCESSLIST_ID > "impossible";
17 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
18 1 SIMPLE session_account_connect_attrs NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
19 ############ Explain for Query ####################################
20 explain select ORDINAL_POSITION
21 from performance_schema.session_account_connect_attrs
22 where PROCESSLIST_ID < "2";
23 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
24 1 SIMPLE session_account_connect_attrs NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
25 ############ Explain for Query ####################################
26 explain select ORDINAL_POSITION
27 from performance_schema.session_account_connect_attrs
28 where PROCESSLIST_ID = @plid;
29 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
30 1 SIMPLE session_account_connect_attrs NULL ref PRIMARY PRIMARY 8 const # 100.00 NULL
31 ############ Explain for Query ####################################
32 explain select ORDINAL_POSITION
33 from performance_schema.session_account_connect_attrs
34 where PROCESSLIST_ID = "impossible"
35 and ATTR_NAME = "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 ORDINAL_POSITION
40 from performance_schema.session_account_connect_attrs
41 where PROCESSLIST_ID = @plid
42 and ATTR_NAME = "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 ORDINAL_POSITION
47 from performance_schema.session_account_connect_attrs
48 where PROCESSLIST_ID = @plid
49 and ATTR_NAME > "impossible";
50 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
51 1 SIMPLE session_account_connect_attrs NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
52 ############ Explain for Query ####################################
53 explain select ORDINAL_POSITION
54 from performance_schema.session_account_connect_attrs
55 where PROCESSLIST_ID = @plid
56 and ATTR_NAME < "2";
57 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
58 1 SIMPLE session_account_connect_attrs NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
59 ############ Explain for Query ####################################
60 explain select ORDINAL_POSITION
61 from performance_schema.session_account_connect_attrs
62 where PROCESSLIST_ID = @plid
63 and ATTR_NAME = "_os";
64 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
65 1 SIMPLE session_account_connect_attrs NULL const PRIMARY PRIMARY 138 const,const # 100.00 NULL
66 ############# Explain End #########################################
67 flush status;
68 select ORDINAL_POSITION
69 from performance_schema.session_account_connect_attrs
70 where PROCESSLIST_ID = @plid
71 and ATTR_NAME = "_os";
72 ORDINAL_POSITION
73 #
74 OK: handler_read_key incremented