Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
This is a part of MDEV-23766.
One can run the entire main testuite with optimizer trace enabled like so:
./mysql-test-run --suite=main --mysqld=--optimizer_trace=enabled=on
|
On a 10.5-based tree, it fails just one test for me:
CURRENT_TEST: main.opt_trace
|
--- /optane/dev-git2/10.5-opt-trace-fix/mysql-test/main/opt_trace.result 2021-10-22 17:44:19.947288399 +0300
|
+++ /optane/dev-git2/10.5-opt-trace-fix/mysql-test/main/opt_trace.reject 2021-10-22 18:05:12.727056238 +0300
|
@@ -6,7 +6,7 @@
|
OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES
|
show variables like 'optimizer_trace';
|
Variable_name Value
|
-optimizer_trace enabled=off
|
+optimizer_trace enabled=on
|
set optimizer_trace="enabled=on";
|
show variables like 'optimizer_trace';
|
Variable_name Value
|
|
|
mysqltest: Result length mismatch
|
|
If we can get that test to pass, we can get the buildbot to run this.
We can run non-main testsuites as well, but this is considered to have less benefit.
Attachments
Issue Links
- blocks
-
MDEV-23766 Optimizer tracing code is prone to producing invalid JSON
-
- Closed
-
Activity
Keeping this open until it is merged into all versions. Then, we can ask Elena to enable the optimizer-trace-enabled run in the buildbot.
Pushed this into 10.4:
commit d352bc5b6772f735a7e4bc540f578e0efc280e71 (HEAD -> 10.4, origin/bb-10.4-mdev26929-part2, origin/10.4, bb-10.4-mdev26929-part2)
|
Author: Sergei Petrunia <psergey@askmonty.org>
|
Date: Fri Oct 29 11:44:09 2021 +0300
|
|
|
MDEV-26929: Make the main testsuite runnable with optimizer trace enabled
|
|
Part#2: check that compile-time default @@optimizer_trace is correct.
|
I see that now the commit d352bc5b6772f735a7e4bc540f578e0efc280e71 has been merged to all versions.