← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb_mysql.result

  • Committer: Patrick Crews
  • Date: 2010-08-09 16:31:29 UTC
  • mto: (1711.1.21 build)
  • mto: This revision was merged to the branch mainline in revision 1714.
  • Revision ID: gleebix@gmail.com-20100809163129-jh0jlwejpuefjrok
Updated test results with changes due to optimizer bug fix.  EXPLAIN output now includes 'Using where' for several queries that didn't previously have this output

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb_mysql.result
315
315
WHERE t1.name LIKE 'A%';
316
316
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
317
317
1       SIMPLE  t1      index   PRIMARY,name    PRIMARY 4       NULL    3       Using where
318
 
1       SIMPLE  t2      ref     fkey    fkey    5       test.t1.id      1       Using index
 
318
1       SIMPLE  t2      ref     fkey    fkey    5       test.t1.id      1       Using where; Using index
319
319
EXPLAIN
320
320
SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id
321
321
WHERE t1.name LIKE 'A%' OR FALSE;