← 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-08 02:42:24 UTC
  • mfrom: (1054.1.6 merge)
  • Revision ID: brian@gaz-20090608024224-zlff1bpq62r8m5gy
Removal of LOCK TABLES.

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);