← 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 08:40:41 UTC
  • mfrom: (1643.3.13 rollup)
  • Revision ID: brian@gaz-20100709084041-tkghyfbzwvfqypi8
Merge IS

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/randgen_queries.test
46
46
set AUTOCOMMIT=OFF;
47
47
 
48
48
#
49
 
select table_schema, 
 
49
select SQL_BIG_RESULT
 
50
       table_schema, 
50
51
       table_name, 
51
52
       CASE WHEN table_type = 'STANDARD' THEN 'table' 
52
53
            WHEN table_type = 'FUNCTION' then 'function' 
56
57
             WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
57
58
       ELSE 'indexed' END 
58
59
       FROM data_dictionary.tables INNER JOIN
59
 
            data_dictionary.columns USING(table_schema, table_name) limit 20;
60
 
 
61
 
 
 
60
            data_dictionary.columns USING(table_schema, table_name) ORDER BY table_schema, table_name limit 20;
 
61
 
 
62
 
 
63
--sorted_result
62
64
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,
63
65
                        (SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
64
66
                        COUNT(*) AS count FROM t1;
65
67
 
 
68
--sorted_result
66
69
select collation_name,character_set_name FROM data_dictionary.collations;
67
70
--replace_column 1 ####.##.####
 
71
--sorted_result
68
72
select COUNT(*) from data_dictionary.tables;
69
73
 
70
74
DROP TABLE t1;