← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/distinct.result

  • Committer: Monty Taylor
  • Date: 2010-12-03 19:56:07 UTC
  • mto: (1975.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1976.
  • Revision ID: mordred@inaugust.com-20101203195607-yw50aynlw04dt5k6
All protocol stuff except for the buffer_length. WTF?

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/distinct.result
523
523
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
524
524
1       SIMPLE  t1      ALL     NULL    NULL    NULL    NULL    3       
525
525
EXPLAIN SELECT DISTINCT t1_1.a, t1_1.b FROM t1 t1_1, t1 t1_2;
526
 
ERROR HY000: Implicit cartesian join attempted.
 
526
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
 
527
1       SIMPLE  t1_1    ALL     NULL    NULL    NULL    NULL    3       Using temporary
 
528
1       SIMPLE  t1_2    index   NULL    PRIMARY 4       NULL    3       Using index; Distinct; Using join buffer
527
529
EXPLAIN SELECT DISTINCT t1_1.a, t1_1.b FROM t1 t1_1, t1 t1_2
528
530
WHERE t1_1.a = t1_2.a;
529
531
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra