Debian Codegraph @

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

raw
1 #
2 # Verify that query results are the same with and without indexes.
3 #
4 --source include/have_debug_sync.inc
5 --source include/no_protocol.inc
6
7 let $table = "prepared_statements_instances";
8
9 --echo TABLE: $table
10 --echo INDEXES: PK (OBJECT_INSTANCE_BEGIN), KEY (STATEMENT_ID), KEY (STATEMENT_NAME),
11 --echo KEY (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME), KEY (OWNER_THREAD_ID, OWNER_EVENT_ID)
12
13 --source ../include/idx_compare_setup.inc
14
15 --connection default
16
17 # Get target object_instance_begin, statement_id, owner_thread_id and owner_event_id
18
19 #--disable_query_log
20 eval SELECT object_instance_begin, statement_id, owner_thread_id, owner_event_id
21 INTO @object_instance_begin, @target_statement_id, @target_thread_id, @target_event_id
22 FROM performance_schema.prepared_statements_instances
23 WHERE STATEMENT_NAME = 'st2' LIMIT 1;
24 #--enable_query_log
25
26 --echo
27 --echo ## Test OBJECT_INSTANCE_BEGIN
28 let $key_group = 12;
29 --source ../include/idx_compare_load.inc
30
31 --echo
32 --echo ## Test STATEMENT_ID
33 let $key_group = 14;
34 let $id_column = STATEMENT_ID;
35 SET @target_id = @target_statement_id;
36 --source ../include/idx_compare_load.inc
37
38 --echo
39 --echo ## Test STATEMENT_NAME
40 let $key_group = 13;
41 let $name_column = STATEMENT_NAME;
42 let $target_name = st2;
43 --source ../include/idx_compare_load.inc
44
45 --echo
46 --echo ## Test OWNER_THREAD_ID, OWNER_EVENT_ID
47 let $key_group = 1.1;
48 --source ../include/idx_compare_load.inc
49
50 --echo
51 --echo ## Test OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME
52 let $key_group = 10.1;
53 let $target_type = PROCEDURE;
54 let $target_schema = test;
55 let $target_name = SampleProc1;
56 --source ../include/idx_compare_load.inc
57
58
59 --source ../include/idx_compare_cleanup.inc