diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2022-12-16 13:33:05 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-03 14:33:18 +0300 |
| commit | e4fbec1463bdf71482a2c9cd2b69b1a10b3c52ec (patch) | |
| tree | d10fc69080cbe166082229fbda0bc72cc14e9f4e /mysql-test/main/opt_trace.result | |
| parent | 15298815954c88a22e5b6b3967f79cd89d23cb21 (diff) | |
| download | mariadb-git-e4fbec1463bdf71482a2c9cd2b69b1a10b3c52ec.tar.gz | |
Make tests work with --view-protocol
Diffstat (limited to 'mysql-test/main/opt_trace.result')
| -rw-r--r-- | mysql-test/main/opt_trace.result | 22 |
1 files changed, 14 insertions, 8 deletions
diff --git a/mysql-test/main/opt_trace.result b/mysql-test/main/opt_trace.result index abeee77c185..207fa0f38a1 100644 --- a/mysql-test/main/opt_trace.result +++ b/mysql-test/main/opt_trace.result @@ -12960,7 +12960,8 @@ select * from t10 where a<3 and b!=5 and c<10; a b c 1 1 1 2 2 2 -select json_detailed(json_extract(trace, '$**.attaching_conditions_to_tables')) as out1 from information_schema.optimizer_trace; +select json_detailed(json_extract(trace, '$**.attaching_conditions_to_tables')) as out1 +from information_schema.optimizer_trace; out1 [ { @@ -12979,7 +12980,6 @@ drop table t10; # # MDEV-21092: EXISTS to IN is not reflected in the optimizer trace # -set @@optimizer_switch = 'exists_to_in=on,in_to_exists=on,semijoin=on,materialization=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on'; set optimizer_trace='enabled=on'; create table t1 (cn_c int, cn_n char(10), cn_a int ); create table t2 (ci_p int, ci_c int ); @@ -12988,8 +12988,12 @@ SELECT cn_n FROM t1 WHERE (EXISTS (select 1 from t2 where ci_p > 100000 and cn_c OR (cn_n LIKE 'L%') ) AND cn_a > 1000000; cn_n -select json_detailed(json_extract(trace, '$.steps[*].join_optimization[0].steps[0].transformation')) from information_schema.optimizer_trace; -json_detailed(json_extract(trace, '$.steps[*].join_optimization[0].steps[0].transformation')) +select +json_detailed( +json_extract(trace, '$.steps[*].join_optimization[0].steps[0].transformation') +) as out1 +from information_schema.optimizer_trace; +out1 [ { "select_id": 2, @@ -13011,8 +13015,9 @@ explain partitions select * from t2,t3 where t2.a in (2,3,4) and t3.a in (4,5); id select_type table partitions type possible_keys key key_len ref rows Extra 1 SIMPLE t3 p4,p5 ALL NULL NULL NULL NULL 2 Using where 1 SIMPLE t2 p2,p3,p4 ALL NULL NULL NULL NULL 3 Using where; Using join buffer (flat, BNL join) -select json_detailed(json_extract(trace, '$**.prune_partitions')) from information_schema.optimizer_trace; -json_detailed(json_extract(trace, '$**.prune_partitions')) +select json_detailed(json_extract(trace, '$**.prune_partitions')) as out1 +from information_schema.optimizer_trace; +out1 [ { "table": "t2", @@ -13035,8 +13040,9 @@ insert into t1 values (5),(15),(22); explain select * from t1 where a = 28; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables -select json_detailed(json_extract(trace, '$**.prune_partitions')) from information_schema.optimizer_trace; -json_detailed(json_extract(trace, '$**.prune_partitions')) +select json_detailed(json_extract(trace, '$**.prune_partitions')) as out1 +from information_schema.optimizer_trace; +out1 [ { "table": "t1", |