← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/randgen_queries.test

  • Committer: Brian Aker
  • Date: 2011-02-22 06:12:02 UTC
  • mfrom: (2190.1.6 drizzle-build)
  • Revision ID: brian@tangent.org-20110222061202-k03czxykqy4x9hjs
List update, header fixes, multiple symbols, and David deletes some code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/randgen_queries.test
61
61
 
62
62
# bookkeeping query in Executor/Drizzle.pm in randgen - variant 1
63
63
# test of non-DATA_DICTIONARY / INFORMATION_SCHEMA tables
 
64
COMMIT;
64
65
CREATE SCHEMA randgen_query_test;
65
66
USE randgen_query_test;
66
67
CREATE TABLE t1 (a INT);
82
83
            data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')
83
84
       ORDER BY table_schema, table_name limit 20;
84
85
 
 
86
COMMIT;
85
87
DROP SCHEMA randgen_query_test;
86
88
USE test;
87
89
# end bookkeeping test
96
98
--replace_column 1 ####.##.####
97
99
--sorted_result
98
100
select COUNT(*) from data_dictionary.tables;
99
 
 
 
101
COMMIT;
100
102
DROP TABLE t1;