diff options
| author | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-15 18:30:13 +0700 |
|---|---|---|
| committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-23 19:47:30 +0700 |
| commit | 184e65954b88266bd426de1c82973bf54a88afb1 (patch) | |
| tree | 482b5be7d68aad5c18a47e439c1f5d0929bd34a8 /mysql-test/main/opt_trace_index_merge.test | |
| parent | 78dcf71e88c86772f89f4ae788079c3619a4d38c (diff) | |
| download | mariadb-git-184e65954b88266bd426de1c82973bf54a88afb1.tar.gz | |
MDEV-27691: make working view-protocol
Update tests for version 10.4
Diffstat (limited to 'mysql-test/main/opt_trace_index_merge.test')
| -rw-r--r-- | mysql-test/main/opt_trace_index_merge.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/opt_trace_index_merge.test b/mysql-test/main/opt_trace_index_merge.test index 73240b6a9e2..85918211184 100644 --- a/mysql-test/main/opt_trace_index_merge.test +++ b/mysql-test/main/opt_trace_index_merge.test @@ -119,6 +119,8 @@ insert into t1 (key1, key2, key3, key4, filler1) values (100, 100, -1, -1, 'key1 insert into t1 (key1, key2, key3, key4, filler1) values (-1, -1, 100, 100, 'key4-key3'); set optimizer_trace='enabled=on'; +#check after fix MDEV-27871 +--disable_view_protocol --echo # 3-way ROR-intersection explain select key1,key2,key3 from t1 where key1=100 and key2=100 and key3=100; select JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; @@ -128,6 +130,7 @@ select JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) fro explain select key1,key2,key3,key4 from t1 where key1=100 and key2=100 or key3=100 and key4=100; select JSON_DETAILED(JSON_EXTRACT(trace, '$**.analyzing_range_alternatives')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; select JSON_DETAILED(JSON_EXTRACT(trace, '$**.chosen_range_access_summary')) from INFORMATION_SCHEMA.OPTIMIZER_TRACE; +--enable_view_protocol drop table t0,t1; set optimizer_trace="enabled=off"; |