← 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: 2010-07-09 18:58:57 UTC
  • mfrom: (1644.2.2 drizzle)
  • Revision ID: brian@gaz-20100709185857-t6f1e3py5vxka9o9
Merge in Patrick

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/randgen_queries.test
45
45
key (`col_enum_key` )) ENGINE=innodb;
46
46
set AUTOCOMMIT=OFF;
47
47
 
48
 
#
49
 
select SQL_BIG_RESULT
50
 
       table_schema, 
 
48
# bookkeeping query in Executor/Drizzle.pm in randgen
 
49
select SQL_BIG_RESULT table_schema, 
51
50
       table_name, 
52
51
       CASE WHEN table_type = 'STANDARD' THEN 'table' 
53
52
            WHEN table_type = 'FUNCTION' then 'function' 
58
57
       ELSE 'indexed' END 
59
58
       FROM data_dictionary.tables INNER JOIN
60
59
            data_dictionary.columns USING(table_schema, table_name) ORDER BY table_schema, table_name limit 20;
61
 
 
62
 
 
63
 
--sorted_result
 
60
# end bookkeeping test
 
61
 
 
62
# bookkeeping query in Executor/Drizzle.pm in randgen - variant 1
 
63
# test of non-DATA_DICTIONARY / INFORMATION_SCHEMA tables
 
64
CREATE SCHEMA randgen_query_test;
 
65
USE randgen_query_test;
 
66
CREATE TABLE t1 (a INT);
 
67
CREATE TABLE t2 LIKE t1;
 
68
CREATE TABLE t3 LIKE t1;
 
69
CREATE TABLE t4 (b CHAR(500));
 
70
CREATE TABLE t5 LIKE t4;
 
71
 
 
72
select SQL_BIG_RESULT table_schema,
 
73
       table_name,
 
74
       CASE WHEN table_type = 'STANDARD' THEN 'table'
 
75
            WHEN table_type = 'FUNCTION' then 'function'
 
76
       ELSE 'misc' END,
 
77
       column_name,
 
78
       CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary'
 
79
             WHEN IS_INDEXED = 'TRUE' THEN 'indexed'
 
80
       ELSE 'indexed' END
 
81
       FROM data_dictionary.tables INNER JOIN
 
82
            data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')
 
83
       ORDER BY table_schema, table_name limit 20;
 
84
 
 
85
DROP SCHEMA randgen_query_test;
 
86
USE test;
 
87
# end bookkeeping test
 
88
 
 
89
 
64
90
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,
65
91
                        (SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
66
92
                        COUNT(*) AS count FROM t1;