← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/r/rowid_order_innodb.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-12-09 06:02:39 UTC
  • mto: This revision was merged to the branch mainline in revision 5.
  • Revision ID: james.westby@ubuntu.com-20101209060239-t0ujftvcvd558yno
Tags: upstream-2010.12.05
Import upstream version 2010.12.05

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/tests/r/rowid_order_innodb.result
15
15
(10, 1, 1);
16
16
explain select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
17
17
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
18
 
1       SIMPLE  t1      index_merge     key1,key2       key1,key2       5,5     NULL    4       Using sort_union(key1,key2); Using where
 
18
1       SIMPLE  t1      index_merge     key1,key2       key1,key2       5,5     NULL    5       Using sort_union(key1,key2); Using where
19
19
select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
20
20
pk1     key1    key2
21
21
-100    1       1