← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/pbxt/group_by.result

  • Committer: Andrew Hutchings
  • Date: 2010-09-23 17:56:06 UTC
  • mfrom: (1788 staging)
  • mto: (1792.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1793.
  • Revision ID: andrew@linuxjedi.co.uk-20100923175606-ns7qazss98flzmz4
Merge trunk into branch

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/pbxt/group_by.result
552
552
delete from t2  where a = 2 and b = 'val-2' order by a,b,c,d limit 30;
553
553
explain select c from t2 where a = 2 and b = 'val-2' group by c;
554
554
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
555
 
1       SIMPLE  t2      ref     PRIMARY,a       PRIMARY 534     const,const     1       Using where; Using temporary; Using filesort
 
555
1       SIMPLE  t2      #       PRIMARY,a       PRIMARY #       const,const     #       #
556
556
select c from t2 where a = 2 and b = 'val-2' group by c;
557
557
c
558
558
val-74
1150
1150
INSERT INTO t1 SELECT a + 128,b FROM t1 limit 16;
1151
1151
ANALYZE TABLE t1;
1152
1152
Table   Op      Msg_type        Msg_text
1153
 
test.t1 analyze note    The storage engine for the table doesn't support analyze
 
1153
test.t1 analyze status  OK
1154
1154
EXPLAIN SELECT a FROM t1 WHERE a < 2;
1155
1155
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1156
1156
1       SIMPLE  t1      ALL     PRIMARY,i2      NULL    NULL    NULL    144     Using where