← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/randgen_queries.test

  • Committer: Stewart Smith
  • Date: 2011-02-07 08:29:23 UTC
  • mto: (2154.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 2155.
  • Revision ID: stewart@flamingspork.com-20110207082923-li4wy2hne4mnnych
be sure to start a transaction with a startTransaction call on the first statement when autocommit is OFF. The only statements that DO NOT do this are a) DDL and b) SELECT without a table (e.g. SELECT DATABASE() and SHOW STATUS.

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