← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/randgen_queries.result

  • Committer: Brian Aker
  • Date: 2010-03-27 04:12:14 UTC
  • mfrom: (1395.1.18 build)
  • Revision ID: brian@gaz-20100327041214-2pm5eay51312xjvq
Merge (fixes known issues in ALTER TABLE not resetting correctly DFE).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/randgen_queries.result
63
63
WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
64
64
ELSE 'indexed' END 
65
65
 
66
 
data_dictionary CHARACTER_SETS  function        CHARACTER_SET_NAME      indexed
67
 
data_dictionary CHARACTER_SETS  function        DEFAULT_COLLATE_NAME    indexed
68
 
data_dictionary CHARACTER_SETS  function        DESCRIPTION     indexed
69
 
data_dictionary CHARACTER_SETS  function        MAXLEN  indexed
70
 
data_dictionary COLLATIONS      function        CHARACTER_SET_NAME      indexed
71
 
data_dictionary COLLATIONS      function        COLLATION_NAME  indexed
72
 
data_dictionary COLLATIONS      function        DESCRIPTION     indexed
73
 
data_dictionary COLLATIONS      function        ID      indexed
74
 
data_dictionary COLLATIONS      function        IS_DEFAULT      indexed
75
 
data_dictionary COLLATIONS      function        IS_COMPILED     indexed
76
 
data_dictionary COLLATIONS      function        SORTLEN indexed
77
 
data_dictionary COLUMNS function        TABLE_SCHEMA    indexed
78
 
data_dictionary COLUMNS function        TABLE_NAME      indexed
79
 
data_dictionary COLUMNS function        COLUMN_NAME     indexed
80
 
data_dictionary COLUMNS function        COLUMN_TYPE     indexed
81
 
data_dictionary COLUMNS function        ORDINAL_POSITION        indexed
82
 
data_dictionary COLUMNS function        COLUMN_DEFAULT  indexed
83
 
data_dictionary COLUMNS function        COLUMN_DEFAULT_IS_NULL  indexed
84
 
data_dictionary COLUMNS function        COLUMN_DEFAULT_UPDATE   indexed
85
 
data_dictionary COLUMNS function        IS_NULLABLE     indexed
 
66
DATA_DICTIONARY CHARACTER_SETS  function        CHARACTER_SET_NAME      indexed
 
67
DATA_DICTIONARY CHARACTER_SETS  function        DEFAULT_COLLATE_NAME    indexed
 
68
DATA_DICTIONARY CHARACTER_SETS  function        DESCRIPTION     indexed
 
69
DATA_DICTIONARY CHARACTER_SETS  function        MAXLEN  indexed
 
70
DATA_DICTIONARY COLLATIONS      function        CHARACTER_SET_NAME      indexed
 
71
DATA_DICTIONARY COLLATIONS      function        COLLATION_NAME  indexed
 
72
DATA_DICTIONARY COLLATIONS      function        DESCRIPTION     indexed
 
73
DATA_DICTIONARY COLLATIONS      function        ID      indexed
 
74
DATA_DICTIONARY COLLATIONS      function        IS_DEFAULT      indexed
 
75
DATA_DICTIONARY COLLATIONS      function        IS_COMPILED     indexed
 
76
DATA_DICTIONARY COLLATIONS      function        SORTLEN indexed
 
77
DATA_DICTIONARY COLUMNS function        TABLE_SCHEMA    indexed
 
78
DATA_DICTIONARY COLUMNS function        TABLE_NAME      indexed
 
79
DATA_DICTIONARY COLUMNS function        COLUMN_NAME     indexed
 
80
DATA_DICTIONARY COLUMNS function        COLUMN_TYPE     indexed
 
81
DATA_DICTIONARY COLUMNS function        ORDINAL_POSITION        indexed
 
82
DATA_DICTIONARY COLUMNS function        COLUMN_DEFAULT  indexed
 
83
DATA_DICTIONARY COLUMNS function        COLUMN_DEFAULT_IS_NULL  indexed
 
84
DATA_DICTIONARY COLUMNS function        COLUMN_DEFAULT_UPDATE   indexed
 
85
DATA_DICTIONARY COLUMNS function        IS_NULLABLE     indexed
86
86
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,
87
87
(SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
88
88
COUNT(*) AS count FROM t1;