Debian Codegraph @

mysql-test/suite/perfschema/include/idx_compare_cleanup.inc

raw
1 --echo
2 --echo ===== CLEAN UP =====
3
4 --echo ## Default connection
5 --connection con2
6 DEALLOCATE PREPARE st1;
7 DEALLOCATE PREPARE st2;
8 DEALLOCATE PREPARE st3;
9 DEALLOCATE PREPARE st4;
10 DROP PROCEDURE SampleProc1;
11 --connection default
12 --disable_query_log
13 SET @pfs_columns = NULL;
14 --enable_query_log
15 DROP PROCEDURE index_test;
16 --disable_warnings
17 DROP TABLE IF EXISTS test.indexes_off;
18 DROP TABLE IF EXISTS test.indexes_on;
19 --enable_warnings
20 DROP TABLE test.t1;
21 DROP TABLE test.t2;
22 DROP TABLE test.t3;
23 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user1@localhost;
24 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user2@localhost;
25 REVOKE ALL PRIVILEGES, GRANT OPTION FROM user3@localhost;
26 DROP USER user1@localhost;
27 DROP USER user2@localhost;
28 DROP USER user3@localhost;
29 --disconnect con1
30 --disconnect con2
31 --disconnect con3
32
33 UPDATE performance_schema.threads SET INSTRUMENTED = 'YES';