~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

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