--disable_query_log eval INSTALL PLUGIN mock SONAME '$MOCK_PLUGIN'; --enable_query_log --echo # --echo # Bug#30625270: ADD SECONDARY_ENGINE_COST_THRESHOLD NOT MET IN TRACE --echo # RESPONSE WHEN OFFLOAD FAILS --echo # CREATE TABLE t(x INT) SECONDARY_ENGINE = MOCK; INSERT INTO t VALUES (1), (2), (3); ALTER TABLE t SECONDARY_LOAD; ANALYZE TABLE t; SET optimizer_trace = 'enabled=on'; SELECT /*+ SET_VAR(secondary_engine_cost_threshold=100000) */ * FROM t ORDER BY x; SET optimizer_trace = 'enabled=off'; SELECT JSON_PRETTY(JSON_REMOVE(TRACE->'$**.secondary_engine_not_used', '$[0].cost')) AS trace FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; DROP TABLE t; --disable_query_log UNINSTALL PLUGIN mock; --enable_query_log