summaryrefslogtreecommitdiff
path: root/mysql-test/main/opt_trace_default.test
blob: 221b68a626c47d6d6ec0d04c4bcfa033f0ddb9e3 (plain)
1
2
3
4
5
6
7
8
9
10
11

if (`SELECT 'COMPILE-TIME'<>GLOBAL_VALUE_ORIGIN from INFORMATION_SCHEMA.SYSTEM_VARIABLES where variable_name='optimizer_trace'`) {
--Skip Needs optimizer_trace default to be the compile-time default
}

--echo # Verify that compile-time default for optimizer trace is OFF (enabled=off).
select
  global_value_origin,
  default_value
from
  INFORMATION_SCHEMA.SYSTEM_VARIABLES where variable_name='optimizer_trace';