diff options
| author | Monty <monty@mariadb.org> | 2023-01-26 11:38:31 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2023-02-10 12:59:36 +0200 |
| commit | 01c82173dd8b6ea627dec949dbc57dfcc94a656d (patch) | |
| tree | e46baaa2137bfaf0f2972880c07eed45af08dd06 /mysql-test/main/update_use_source.result | |
| parent | 87507bbb4f2f8e3cc0ccd3a2b8e45cf218963d7d (diff) | |
| download | mariadb-git-01c82173dd8b6ea627dec949dbc57dfcc94a656d.tar.gz | |
Removed /2 of InnoDB ref_per_key[] estimates
The original code was there to favor index search over table scan.
This is not needed anymore as the cost calculations for table scans
and index lookups are now more exact.
Diffstat (limited to 'mysql-test/main/update_use_source.result')
| -rw-r--r-- | mysql-test/main/update_use_source.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/update_use_source.result b/mysql-test/main/update_use_source.result index 2774e7ee92d..91b2f7c8890 100644 --- a/mysql-test/main/update_use_source.result +++ b/mysql-test/main/update_use_source.result @@ -317,7 +317,7 @@ rollback; explain update t1 set c1=0 where exists (select 'X' from t1 a where a.c2 = t1.c2) and c2 > 3; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 range t1_c2 t1_c2 5 NULL 2 Using where -2 DEPENDENT SUBQUERY a ref t1_c2 t1_c2 5 test.t1.c2 4 Using index +2 DEPENDENT SUBQUERY a ref t1_c2 t1_c2 5 test.t1.c2 8 Using index start transaction; update t1 set c1=c1+10 where exists (select 'X' from t1 a where a.c2 = t1.c2) and c2 >= 3; affected rows: 4 |