diff options
author | Varun Gupta <varunraiko1803@gmail.com> | 2018-05-31 15:51:59 +0530 |
---|---|---|
committer | Varun Gupta <varun.gupta@mariadb.com> | 2018-12-09 09:22:00 +0530 |
commit | 93c360e3a53dbfe843bc4b769e73cbe9248cd5b3 (patch) | |
tree | a619c5ced37b0156487a9107d304fbfd7590001a /mysql-test/main/update.result | |
parent | a25ce5ab4b38f0557abba8c5eb71b0839dc1ec4b (diff) | |
download | mariadb-git-93c360e3a53dbfe843bc4b769e73cbe9248cd5b3.tar.gz |
MDEV-15253: Default optimizer setting changes for MariaDB 10.4
use_stat_tables= PREFERABLY
optimizer_use_condition_selectivity= 4
Diffstat (limited to 'mysql-test/main/update.result')
-rw-r--r-- | mysql-test/main/update.result | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/main/update.result b/mysql-test/main/update.result index ccf2f4451ea..ab6596e8bf1 100644 --- a/mysql-test/main/update.result +++ b/mysql-test/main/update.result @@ -234,7 +234,9 @@ insert into t2 values ( 1, 'abcd1e'); insert into t2 values ( 2, 'abcd2e'); analyze table t1,t2; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK +test.t2 analyze status Engine-independent statistics collected test.t2 analyze status OK update t1, t2 set t1.a = t2.a where t2.b = t1.b; show warnings; @@ -326,7 +328,7 @@ delete from t1 order by a limit 1; show status like 'handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 0 +Handler_read_key 4 Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 |