← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/randgen_queries.result

  • 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/r/randgen_queries.result
80
80
DATA_DICTIONARY COLUMNS misc    TABLE_SCHEMA    indexed
81
81
DATA_DICTIONARY COLUMNS misc    TABLE_NAME      indexed
82
82
DATA_DICTIONARY COLUMNS misc    COLUMN_NAME     indexed
 
83
COMMIT;
83
84
CREATE SCHEMA randgen_query_test;
84
85
USE randgen_query_test;
85
86
CREATE TABLE t1 (a INT);
125
126
test    t1      misc    col_text_not_null_key   indexed
126
127
test    t1      misc    pk      primary
127
128
test    t1      misc    col_bigint_key  indexed
 
129
COMMIT;
128
130
DROP SCHEMA randgen_query_test;
129
131
USE test;
130
132
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,