← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: lbieber
  • Date: 2010-09-13 23:03:27 UTC
  • mfrom: (1761.1.1 build)
  • Revision ID: lbieber@orisndriz08-20100913230327-63e4fk97eacjrtbg
Merge Brian - Adds random_number, random_string, and a counter table to DD

Show diffs side-by-side

added added

removed removed

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