← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/group_by.result

  • Committer: Brian Aker
  • Date: 2009-06-05 23:10:06 UTC
  • mto: This revision was merged to the branch mainline in revision 1055.
  • Revision ID: brian@gaz-20090605231006-01nyw7pfpj2z2v8p
Remove guts in parser for LOCK TABLE.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/group_by.result
95
95
PRIMARY KEY (call_id),
96
96
KEY contact_id (contact_id)
97
97
);
98
 
lock tables t1 read,t2 write;
99
98
INSERT INTO t2 VALUES (10,2);
100
99
INSERT INTO t2 VALUES (18,2);
101
100
INSERT INTO t2 VALUES (62,2);
108
107
SELECT cid, CONCAT(firstname, ' ', surname), COUNT(call_id) FROM t1 LEFT JOIN t2 ON cid=contact_id WHERE firstname like '%foo%' GROUP BY cid ORDER BY surname, firstname;
109
108
cid     CONCAT(firstname, ' ', surname) COUNT(call_id)
110
109
drop table t2;
111
 
unlock tables;
112
110
drop table t1;
113
111
create table t1 (foo int);
114
112
insert into t1 values (1);