Debian Codegraph @

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

raw
1 --disable_query_log
2 eval INSTALL PLUGIN mock SONAME '$MOCK_PLUGIN';
3 --enable_query_log
4
5 --echo #
6 --echo # Bug#30625270: ADD SECONDARY_ENGINE_COST_THRESHOLD NOT MET IN TRACE
7 --echo # RESPONSE WHEN OFFLOAD FAILS
8 --echo #
9
10 CREATE TABLE t(x INT) SECONDARY_ENGINE = MOCK;
11 INSERT INTO t VALUES (1), (2), (3);
12 ALTER TABLE t SECONDARY_LOAD;
13 ANALYZE TABLE t;
14 SET optimizer_trace = 'enabled=on';
15 SELECT /*+ SET_VAR(secondary_engine_cost_threshold=100000) */
16 * FROM t ORDER BY x;
17 SET optimizer_trace = 'enabled=off';
18 SELECT JSON_PRETTY(JSON_REMOVE(TRACE->'$**.secondary_engine_not_used',
19 '$[0].cost')) AS trace
20 FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
21 DROP TABLE t;
22
23 --disable_query_log
24 UNINSTALL PLUGIN mock;
25 --enable_query_log