diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2021-01-18 12:29:12 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2021-01-18 12:29:12 +0530 |
| commit | e7f289c514290d4995b0f3c2fc764e0eb11675ca (patch) | |
| tree | 447ff490652ff3c4c016ed19b9fb38f3aa15ced9 /mysql-test/main/opt_trace.test | |
| parent | edb5ae009c13e6bbb68696f0aeb2ce1b69c2b493 (diff) | |
| download | mariadb-git-10.4-opt_trace.tar.gz | |
MDEV-23646: Optimizer trace: optimize_cond() should show ON expression processing10.4-opt_trace
Print in the optimizer trace equality and constant propagation of the ON expression
Diffstat (limited to 'mysql-test/main/opt_trace.test')
| -rw-r--r-- | mysql-test/main/opt_trace.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test index 99ddbae8079..9f83a596e38 100644 --- a/mysql-test/main/opt_trace.test +++ b/mysql-test/main/opt_trace.test @@ -642,6 +642,12 @@ where t1.a = t2.a; SELECT JSON_DETAILED(JSON_EXTRACT(trace, '$**.where_clause_after_substitution')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; SELECT JSON_DETAILED(JSON_EXTRACT(trace, '$**.having_clause_after_substitution')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; SELECT JSON_DETAILED(JSON_EXTRACT(trace, '$**.on_clause_after_substitution')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; + +--echo # +--echo # MDEV-23646: Optimizer trace: optimize_cond() should show ON expression processing +--echo # + +SELECT JSON_DETAILED(JSON_EXTRACT(trace, '$**.condition_processing')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; DROP TABLE t1,t2,t3; set optimizer_trace='enabled=off'; |