diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-01-13 02:59:11 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-01-13 02:59:11 +0200 |
| commit | bda130e6b3ddc45218e4ed1b81cb03a213e5e00c (patch) | |
| tree | ba5162d1169933a90ff41e9410b3e2a0e5713913 /mysql-test/r/table_elim.result | |
| parent | 162dd48fc4d4fce7a0832bc764402f3677abfc10 (diff) | |
| download | mariadb-git-bda130e6b3ddc45218e4ed1b81cb03a213e5e00c.tar.gz | |
Updated test results for 5.3
Changed handler.inc to make test row order independent
mysql-test/r/table_elim.result:
Updated test results for 5.3
mysql-test/suite/handler/aria.result:
Updated result
mysql-test/suite/handler/handler.inc:
Changed handler.inc to make test row order independent
mysql-test/suite/handler/heap.result:
Updated result
mysql-test/suite/handler/innodb.result:
Updated result
mysql-test/suite/handler/myisam.result:
Updated result
Diffstat (limited to 'mysql-test/r/table_elim.result')
| -rw-r--r-- | mysql-test/r/table_elim.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/table_elim.result b/mysql-test/r/table_elim.result index 19567770042..06135e28efb 100644 --- a/mysql-test/r/table_elim.result +++ b/mysql-test/r/table_elim.result @@ -560,9 +560,9 @@ JOIN t5 ON t4.f3 ON t3.f1 = t5.f5 ON t2.f4 = t3.f4 WHERE t3.f2 ; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t3 ALL NULL NULL NULL NULL 2 Using where -1 SIMPLE t5 ref f5 f5 5 test.t3.f1 2 Using index -1 SIMPLE t4 ALL NULL NULL NULL NULL 3 -1 SIMPLE t2 ALL f4 NULL NULL NULL 11 Using where; Using join buffer +1 SIMPLE t5 ref f5 f5 5 test.t3.f1 2 Using where; Using index +1 SIMPLE t4 ALL NULL NULL NULL NULL 3 Using where +1 SIMPLE t2 ALL f4 NULL NULL NULL 11 Using where; Using join buffer (flat, BNL join) # ^^ The above must not produce a QEP of t3,t5,t2,t4 # as that violates the "no interleaving of outer join nests" rule. DROP TABLE t1,t2,t3,t4,t5; |