diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-12-25 18:03:03 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-12-25 18:03:03 -0800 |
| commit | c583aaf56ba14484745e7a38bcc07b8652e516d4 (patch) | |
| tree | da539bd2a985667eb537604034f0bf6a1466a21d /mysql-test/r/join_cache.result | |
| parent | 2b1f0b875775b65496e959db7f54f6eb4220400e (diff) | |
| download | mariadb-git-c583aaf56ba14484745e7a38bcc07b8652e516d4.tar.gz | |
Changed a test case from join_cache.test to make it platform independent.
Diffstat (limited to 'mysql-test/r/join_cache.result')
| -rw-r--r-- | mysql-test/r/join_cache.result | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/mysql-test/r/join_cache.result b/mysql-test/r/join_cache.result index 2fc8cc83821..362158cfdbe 100644 --- a/mysql-test/r/join_cache.result +++ b/mysql-test/r/join_cache.result @@ -4400,17 +4400,12 @@ INSERT INTO t2 VALUES (1, 12, 102), (8, 81, 801), (7, 70, 700), (12, 120, 1200), (8, 82, 802), (1, 13, 103), (1, 14, 104), (3, 31, 301), (1, 15, 105), (8, 83, 803), (7, 71, 701); -INSERT INTO t2 VALUES -(108, 80, 800), (101, 10, 100), (101, 11, 101), (103, 30, 300), -(101, 12, 102), (108, 81, 801), (107, 70, 700), (1012, 120, 1200), -(108, 82, 802), (101, 13, 103), (101, 14, 104), (103, 31, 301), -(101, 15, 105), (108, 83, 803), (107, 71, 701); SET SESSION join_cache_level = 4; SET SESSION join_buffer_size = 192; EXPLAIN SELECT t1.a, t2.c FROM t1,t2 WHERE t1.a=t2.a AND t2.b=99; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 ALL idx NULL NULL NULL 30 Using where +1 SIMPLE t2 ALL idx NULL NULL NULL 15 Using where 1 SIMPLE t1 hash_ALL NULL #hash#$hj 5 test.t2.a 36 Using where; Using join buffer (flat, BNLH join) SELECT t1.a, t2.c FROM t1,t2 WHERE t1.a=t2.a AND t2.b=99; a c |