summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSergei Krivonos <sergei.krivonos@mariadb.com>2021-10-28 18:35:33 +0300
committerSergei Krivonos <sergei.krivonos@mariadb.com>2021-10-28 18:35:33 +0300
commit9d8e9acfefd0b63ed97feb3a77b96c36b1057260 (patch)
treebdb821c459a388589e823828deaf43154cca6ab3
parenta8ded395578ccab9c256b9beee7e62d4ada08522 (diff)
downloadmariadb-git-bb-10.5-MDEV-26929.tar.gz
MDEV-26929: fixed opt_trace test for --mysqld=--optimizer_trace=enabled=onbb-10.5-MDEV-26929
-rw-r--r--mysql-test/main/opt_trace.result6
-rw-r--r--mysql-test/main/opt_trace.test2
2 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result
index 0815ff06557..a20d3c419d3 100644
--- a/mysql-test/main/opt_trace.result
+++ b/mysql-test/main/opt_trace.result
@@ -4,14 +4,14 @@ OPTIMIZER_TRACE QUERY
OPTIMIZER_TRACE TRACE
OPTIMIZER_TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE
OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES
-show variables like 'optimizer_trace';
-Variable_name Value
-optimizer_trace enabled=off
set optimizer_trace="enabled=on";
show variables like 'optimizer_trace';
Variable_name Value
optimizer_trace enabled=on
set optimizer_trace="enabled=off";
+show variables like 'optimizer_trace';
+Variable_name Value
+optimizer_trace enabled=off
create table t1 (a int, b int);
insert into t1 values (1,2),(2,3);
create table t2 (b int);
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test
index a191761d17d..c5eb6a74fa9 100644
--- a/mysql-test/main/opt_trace.test
+++ b/mysql-test/main/opt_trace.test
@@ -1,10 +1,10 @@
--source include/not_embedded.inc
--source include/have_sequence.inc
SELECT table_name, column_name FROM information_schema.columns where table_name="OPTIMIZER_TRACE";
-show variables like 'optimizer_trace';
set optimizer_trace="enabled=on";
show variables like 'optimizer_trace';
set optimizer_trace="enabled=off";
+show variables like 'optimizer_trace';
create table t1 (a int, b int);
insert into t1 values (1,2),(2,3);