← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/randgen_queries.test

  • Committer: Joe Daly
  • Date: 2010-03-08 04:23:54 UTC
  • mto: This revision was merged to the branch mainline in revision 1380.
  • Revision ID: skinny.moey@gmail.com-20100308042354-7k0jibdqaxkhac7o
scoreboard implementation for statistics

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
# Obviously, FUNCTION does not always means VIEW.
48
49
#
49
50
select table_schema, 
50
51
       table_name, 
51
 
       CASE WHEN table_type = 'STANDARD' THEN 'table' 
52
 
            WHEN table_type = 'FUNCTION' then 'function' 
53
 
       ELSE 'misc' END, 
 
52
       'STANDARD',
 
53
#       CASE WHEN table_type = 'STANDARD' THEN 'table' 
 
54
#            WHEN table_type = 'VIEW' THEN 'view' 
 
55
#            WHEN table_type = 'FUNCTION' then 'view' 
 
56
#       ELSE 'misc' END, 
54
57
       column_name,
55
58
       CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary' 
56
 
             WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
 
59
      #      WHEN column_key = 'MUL' THEN 'indexed' 
 
60
      #      WHEN column_key = 'UNI' THEN 'indexed' 
57
61
       ELSE 'indexed' END 
58
 
       FROM data_dictionary.tables INNER JOIN
59
 
            data_dictionary.columns USING(table_schema, table_name) limit 20;
60
 
 
 
62
FROM data_dictionary.index_parts;
61
63
 
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
 
66
68
select collation_name,character_set_name FROM data_dictionary.collations;
67
 
--replace_column 1 ####.##.####
68
69
select COUNT(*) from data_dictionary.tables;
69
 
 
70
 
DROP TABLE t1;