~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/utility_dictionary/tests/t/random_number.test

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:
 
1
--replace_column 1 #
 
2
SELECT value from data_dictionary.random_number LIMIT 10;
 
3
CREATE TABLE t1 SELECT value from data_dictionary.random_number LIMIT 20;
 
4
SELECT count(*) from t1;
 
5
INSERT INTO t1 SELECT value from data_dictionary.random_number LIMIT 10;
 
6
SELECT count(*) from t1;
 
7
 
 
8
# These two test that we won't just have runaway queries
 
9
--replace_column 1 #
 
10
SELECT value from data_dictionary.random_number GROUP BY value LIMIT 10;
 
11
--replace_column 1 #
 
12
select count(value) from data_dictionary.random_number;
 
13
 
 
14
DROP TABLE t1;