← 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-05-13 01:31:43 UTC
  • mto: This revision was merged to the branch mainline in revision 1013.
  • Revision ID: brian@gaz-20090513013143-l0a5oh6aly1e15td
Removed TL_READ_HIGH_PRIORITY

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/group_by.result
105
105
cid     CONCAT(firstname, ' ', surname) COUNT(call_id)
106
106
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 NULL;
107
107
cid     CONCAT(firstname, ' ', surname) COUNT(call_id)
108
 
SELECT HIGH_PRIORITY 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;
 
108
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
109
cid     CONCAT(firstname, ' ', surname) COUNT(call_id)
110
110
drop table t2;
111
111
unlock tables;