Debian Codegraph @

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

raw
1 select connection_id() into @conid;
2
3 ====================================================================
4 Testing index for columns ID
5 ====================================================================
6 ############ Explain for Query ####################################
7 explain select ID
8 from performance_schema.processlist
9 where ID = "impossible";
10 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
11 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
12 ############ Explain for Query ####################################
13 explain select ID
14 from performance_schema.processlist
15 where ID > "impossible";
16 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
17 1 SIMPLE processlist NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
18 ############ Explain for Query ####################################
19 explain select ID
20 from performance_schema.processlist
21 where ID < "2";
22 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
23 1 SIMPLE processlist NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
24 ############ Explain for Query ####################################
25 explain select ID
26 from performance_schema.processlist
27 where ID = @conid;
28 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
29 1 SIMPLE processlist NULL const PRIMARY PRIMARY 8 const # 100.00 NULL
30 ############# Explain End #########################################
31 flush status;
32 select ID
33 from performance_schema.processlist
34 where ID = @conid;
35 ID
36 #
37 OK: handler_read_key incremented