Debian Codegraph @

mysql-test/suite/perfschema/t/idx_compare_table_handles.test

raw
1 #
2 # Verify that query results are the same with and without indexes.
3 #
4 --source include/have_debug_sync.inc
5
6 let $table = "table_handles";
7 let $target_type = TABLE;
8 let $target_schema = test;
9 let $target_name = t1;
10
11 --echo TABLE: $table
12 --echo INDEXES: PK (OBJECT_INSTANCE_BEGIN), KEY (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME), KEY (OWNER_THREAD_ID, OWNER_EVENT_ID)
13
14 --source ../include/idx_compare_setup.inc
15
16 --disable_query_log
17
18 # Get an object_instance_begin
19
20 --connection con1
21 # Get MDL read lock
22 LOCK TABLE t1 READ;
23
24 --connection con2
25
26 # User1 has a READ LOCK
27 # User2 waiting for WRITE LOCK
28 --send LOCK TABLE t1 write;
29
30 --connection default
31
32 # Wait for the LOCK TABLE t1 write to block
33 let $wait_condition=
34 select count(*) = 1 from performance_schema.events_waits_current
35 where event_name = 'wait/lock/metadata/sql/mdl'
36 and object_name = 't1';
37 --source include/wait_condition.inc
38
39 --connection default
40
41 eval SELECT object_instance_begin, owner_event_id
42 INTO @object_instance_begin, @target_event_id
43 FROM performance_schema.table_handles
44 WHERE external_lock = 'READ EXTERNAL'
45 AND owner_thread_id = $con1_thread_id
46 LIMIT 1;
47
48 --enable_query_log
49
50 #DEBUG SELECT @object_instance_begin, @owner_event_id;
51
52 --echo
53 --echo ## Test OBJECT_INSTANCE_BEGIN
54 let $key_group = 12;
55 --source ../include/idx_compare_load.inc
56
57 --echo
58 --echo ## Test OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
59 let $key_group = 10;
60 --source ../include/idx_compare_load.inc
61
62 --echo
63 --echo ## Test OWNER_THREAD_ID, OWNER_EVENT_ID
64 --disable_query_log
65 eval SET @target_thread_id = $con1_thread_id;
66 --enable_query_log
67 let $key_group = 1.1;
68 --source ../include/idx_compare_load.inc
69
70 --connection con1
71
72 # User1 releases a READ LOCK
73 # User2 granted a WRITE LOCK
74 UNLOCK TABLES;
75
76 --connection con2
77
78 # Complete LOCK TABLE t1 write
79 --reap
80 UNLOCK TABLES;
81
82 --connection default
83
84 --source ../include/idx_compare_cleanup.inc