Debian Codegraph @

mysql-test/suite/secondary_engine/t/uninstall.test

raw
1 --echo #
2 --echo # Bug#28624707: MYSQL TRYING TO OFFLOAD QUERIES TO SECONDARY ENGINE
3 --echo # AFTER PLUGIN UNINSTALL
4 --echo #
5
6 --disable_query_log
7 eval INSTALL PLUGIN mock SONAME '$MOCK_PLUGIN';
8 --enable_query_log
9
10 SELECT PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='MOCK';
11
12 CREATE TABLE t(x INT) SECONDARY_ENGINE MOCK;
13 INSERT INTO t VALUES (1);
14 ALTER TABLE t SECONDARY_LOAD;
15
16 --echo # Should use the secondary engine.
17 FLUSH STATUS;
18 SELECT * FROM t;
19 SHOW STATUS LIKE 'Secondary_engine_execution_count';
20
21 --echo # The plugin cannot be unloaded because there are still references
22 --echo # to it (from the table cache). Will give a warning about that.
23 UNINSTALL PLUGIN mock;
24 SELECT PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='MOCK';
25
26 --echo # Should not use the secondary engine.
27 FLUSH STATUS;
28 SELECT * FROM t;
29 SHOW STATUS LIKE 'Secondary_engine_execution_count';
30
31 # Cleanup. The plugin is no longer referenced and will be uninstalled.
32 DROP TABLE t;
33 SELECT PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME='MOCK';