← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/utility_dictionary/tests/r/counter.result

  • Committer: Brian Aker
  • Date: 2010-09-10 16:41:50 UTC
  • mto: (1759.2.1 build)
  • mto: This revision was merged to the branch mainline in revision 1762.
  • Revision ID: brian@tangent.org-20100910164150-grktr2kjfgvk4iw2
This add a couple of utility table functions to be used with testing.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/utility_dictionary/tests/r/counter.result
 
1
SELECT value from data_dictionary.counter LIMIT 10;
 
2
value
 
3
1
 
4
2
 
5
3
 
6
4
 
7
5
 
8
6
 
9
7
 
10
8
 
11
9
 
12
10
 
13
CREATE TABLE t1 SELECT value from data_dictionary.counter LIMIT 20;
 
14
SELECT count(*) from t1;
 
15
count(*)
 
16
20
 
17
INSERT INTO t1 SELECT value from data_dictionary.counter LIMIT 10;
 
18
SELECT count(*) from t1;
 
19
count(*)
 
20
30
 
21
SELECT value from data_dictionary.counter GROUP BY value LIMIT 10;
 
22
value
 
23
41
 
24
select count(value) from data_dictionary.counter;
 
25
count(value)
 
26
1
 
27
DROP TABLE t1;