diff options
Diffstat (limited to 'mysql-test/r/single_delete_update.result')
| -rw-r--r-- | mysql-test/r/single_delete_update.result | 54 |
1 files changed, 27 insertions, 27 deletions
diff --git a/mysql-test/r/single_delete_update.result b/mysql-test/r/single_delete_update.result index 00231d8377a..72419c6ec9d 100644 --- a/mysql-test/r/single_delete_update.result +++ b/mysql-test/r/single_delete_update.result @@ -306,21 +306,21 @@ NULL 13 13 SHOW SESSION STATUS LIKE 'Sort%'; Variable_name Value Sort_merge_passes 0 -Sort_range 0 +Sort_range 1 Sort_rows 4 -Sort_scan 1 +Sort_scan 0 SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 -Handler_read_key 0 +Handler_read_key 2 Handler_read_last 0 -Handler_read_next 0 +Handler_read_next 7 Handler_read_prev 0 -Handler_read_rnd 0 -Handler_read_rnd_next 17 +Handler_read_rnd 4 +Handler_read_rnd_next 0 EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; id select_type table type possible_keys key key_len ref rows filtered Extra -x x x x x x x x x x Using where; Using filesort +x x x x x x x x x x Using sort_union(key1,key2); Using where; Using filesort Warnings: x x x FLUSH STATUS; @@ -328,18 +328,18 @@ DELETE FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; SHOW SESSION STATUS LIKE 'Sort%'; Variable_name Value Sort_merge_passes 0 -Sort_range 0 +Sort_range 1 Sort_rows 4 -Sort_scan 1 +Sort_scan 0 SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 -Handler_read_key 0 +Handler_read_key 2 Handler_read_last 0 -Handler_read_next 0 +Handler_read_next 7 Handler_read_prev 0 -Handler_read_rnd 4 -Handler_read_rnd_next 17 +Handler_read_rnd 8 +Handler_read_rnd_next 0 SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; i key1 key2 EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; @@ -850,21 +850,21 @@ NULL 13 13 SHOW SESSION STATUS LIKE 'Sort%'; Variable_name Value Sort_merge_passes 0 -Sort_range 0 +Sort_range 1 Sort_rows 4 -Sort_scan 1 +Sort_scan 0 SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 -Handler_read_key 0 +Handler_read_key 2 Handler_read_last 0 -Handler_read_next 0 +Handler_read_next 7 Handler_read_prev 0 -Handler_read_rnd 0 -Handler_read_rnd_next 17 +Handler_read_rnd 4 +Handler_read_rnd_next 0 EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; id select_type table type possible_keys key key_len ref rows filtered Extra -x x x x x x x x x x Using where; Using filesort +x x x x x x x x x x Using sort_union(key1,key2); Using where; Using filesort Warnings: x x x FLUSH STATUS; @@ -872,18 +872,18 @@ UPDATE t2 SET i = 123 WHERE key1 < 13 or key2 < 14 ORDER BY key1; SHOW SESSION STATUS LIKE 'Sort%'; Variable_name Value Sort_merge_passes 0 -Sort_range 0 +Sort_range 1 Sort_rows 4 -Sort_scan 1 +Sort_scan 0 SHOW STATUS LIKE 'Handler_read_%'; Variable_name Value Handler_read_first 0 -Handler_read_key 0 +Handler_read_key 2 Handler_read_last 0 -Handler_read_next 0 +Handler_read_next 7 Handler_read_prev 0 -Handler_read_rnd 4 -Handler_read_rnd_next 17 +Handler_read_rnd 8 +Handler_read_rnd_next 0 SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; i key1 key2 123 10 10 @@ -892,7 +892,7 @@ i key1 key2 123 13 13 EXPLAIN EXTENDED SELECT * FROM t2 WHERE key1 < 13 or key2 < 14 ORDER BY key1; id select_type table type possible_keys key key_len ref rows filtered Extra -x x x x x x x x x x Using where; Using filesort +x x x x x x x x x x Using sort_union(key1,key2); Using where; Using filesort Warnings: x x x DROP TABLE t2; |