~vjsamuel/drizzle/fix-bug-585982

« back to all changes in this revision

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

  • 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:
 
1
--replace_column 1 #
 
2
SELECT value from data_dictionary.counter LIMIT 10;
 
3
CREATE TABLE t1 SELECT value from data_dictionary.counter LIMIT 20;
 
4
SELECT count(*) from t1;
 
5
INSERT INTO t1 SELECT value from data_dictionary.counter 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.counter GROUP BY value LIMIT 10;
 
11
--replace_column 1 #
 
12
select count(value) from data_dictionary.counter;
 
13
 
 
14
DROP TABLE t1;