← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/randgen_queries.result

  • Committer: Olaf van der Spek
  • Date: 2011-02-12 18:24:24 UTC
  • mto: (2167.1.2 build) (2172.1.4 build)
  • mto: This revision was merged to the branch mainline in revision 2168.
  • Revision ID: olafvdspek@gmail.com-20110212182424-kgnm9osi7qo97at2
casts

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/randgen_queries.result
42
42
key (`col_char_not_null_key` ),
43
43
key (`col_text_key`  (255)),
44
44
key (`col_enum_key` )) ENGINE=innodb;
45
 
Warnings:
46
 
Warning 1071    Specified key was too long; max key length is 767 bytes
47
 
Warning 1071    Specified key was too long; max key length is 767 bytes
48
45
set AUTOCOMMIT=OFF;
49
 
select table_schema, 
 
46
select SQL_BIG_RESULT table_schema, 
50
47
table_name, 
51
48
CASE WHEN table_type = 'STANDARD' THEN 'table' 
52
49
WHEN table_type = 'FUNCTION' then 'function' 
53
50
ELSE 'misc' END, 
54
51
column_name,
55
 
CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary' 
56
 
WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
 
52
CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary' 
 
53
WHEN IS_INDEXED = 'YES' THEN 'indexed' 
57
54
ELSE 'indexed' END 
58
55
FROM data_dictionary.tables INNER JOIN
59
 
data_dictionary.columns USING(table_schema, table_name) limit 20;
 
56
data_dictionary.columns USING(table_schema, table_name) ORDER BY table_schema, table_name limit 20;
60
57
table_schema    table_name      CASE WHEN table_type = 'STANDARD' THEN 'table' 
61
58
WHEN table_type = 'FUNCTION' then 'function' 
62
 
ELSE 'misc' END column_name     CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary' 
63
 
WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
 
59
ELSE 'misc' END column_name     CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary' 
 
60
WHEN IS_INDEXED = 'YES' THEN 'indexed' 
64
61
ELSE 'indexed' END 
65
62
 
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
 
63
DATA_DICTIONARY CATALOGS        misc    CATALOG_NAME    indexed
 
64
DATA_DICTIONARY CATALOGS        misc    CATALOG_CREATION_TIME   indexed
 
65
DATA_DICTIONARY CATALOGS        misc    CATALOG_UPDATE_TIME     indexed
 
66
DATA_DICTIONARY CATALOGS        misc    CATALOG_UUID    indexed
 
67
DATA_DICTIONARY CATALOGS        misc    CATALOG_VERSION indexed
 
68
DATA_DICTIONARY CATALOG_CACHE   misc    CATALOG_NAME    indexed
 
69
DATA_DICTIONARY CHARACTER_SETS  misc    CHARACTER_SET_NAME      indexed
 
70
DATA_DICTIONARY CHARACTER_SETS  misc    DEFAULT_COLLATE_NAME    indexed
 
71
DATA_DICTIONARY CHARACTER_SETS  misc    DESCRIPTION     indexed
 
72
DATA_DICTIONARY CHARACTER_SETS  misc    MAXLEN  indexed
 
73
DATA_DICTIONARY COLLATIONS      misc    CHARACTER_SET_NAME      indexed
 
74
DATA_DICTIONARY COLLATIONS      misc    COLLATION_NAME  indexed
 
75
DATA_DICTIONARY COLLATIONS      misc    DESCRIPTION     indexed
 
76
DATA_DICTIONARY COLLATIONS      misc    ID      indexed
 
77
DATA_DICTIONARY COLLATIONS      misc    IS_DEFAULT      indexed
 
78
DATA_DICTIONARY COLLATIONS      misc    IS_COMPILED     indexed
 
79
DATA_DICTIONARY COLLATIONS      misc    SORTLEN indexed
 
80
DATA_DICTIONARY COLUMNS misc    TABLE_SCHEMA    indexed
 
81
DATA_DICTIONARY COLUMNS misc    TABLE_NAME      indexed
 
82
DATA_DICTIONARY COLUMNS misc    COLUMN_NAME     indexed
 
83
COMMIT;
 
84
CREATE SCHEMA randgen_query_test;
 
85
USE randgen_query_test;
 
86
CREATE TABLE t1 (a INT);
 
87
CREATE TABLE t2 LIKE t1;
 
88
CREATE TABLE t3 LIKE t1;
 
89
CREATE TABLE t4 (b CHAR(500));
 
90
CREATE TABLE t5 LIKE t4;
 
91
select SQL_BIG_RESULT table_schema,
 
92
table_name,
 
93
CASE WHEN table_type = 'STANDARD' THEN 'table'
 
94
            WHEN table_type = 'FUNCTION' then 'function'
 
95
       ELSE 'misc' END,
 
96
column_name,
 
97
CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary'
 
98
             WHEN IS_INDEXED = 'YES' THEN 'indexed'
 
99
       ELSE 'indexed' END
 
100
FROM data_dictionary.tables INNER JOIN
 
101
data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')
 
102
ORDER BY table_schema, table_name limit 20;
 
103
table_schema    table_name      CASE WHEN table_type = 'STANDARD' THEN 'table'
 
104
            WHEN table_type = 'FUNCTION' then 'function'
 
105
       ELSE 'misc' END  column_name     CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary'
 
106
             WHEN IS_INDEXED = 'YES' THEN 'indexed'
 
107
       ELSE 'indexed' END
 
108
 
 
109
randgen_query_test      t1      misc    a       indexed
 
110
randgen_query_test      t2      misc    a       indexed
 
111
randgen_query_test      t3      misc    a       indexed
 
112
randgen_query_test      t4      misc    b       indexed
 
113
randgen_query_test      t5      misc    b       indexed
 
114
test    t1      misc    col_bigint      indexed
 
115
test    t1      misc    col_text        indexed
 
116
test    t1      misc    col_char        indexed
 
117
test    t1      misc    col_enum        indexed
 
118
test    t1      misc    col_int indexed
 
119
test    t1      misc    col_char_not_null       indexed
 
120
test    t1      misc    col_int_not_null_key    indexed
 
121
test    t1      misc    col_text_not_null       indexed
 
122
test    t1      misc    col_enum_not_null_key   indexed
 
123
test    t1      misc    col_int_key     indexed
 
124
test    t1      misc    col_char_key    indexed
 
125
test    t1      misc    col_enum_not_null       indexed
 
126
test    t1      misc    col_text_not_null_key   indexed
 
127
test    t1      misc    pk      primary
 
128
test    t1      misc    col_bigint_key  indexed
 
129
COMMIT;
 
130
DROP SCHEMA randgen_query_test;
 
131
USE test;
86
132
select AVG(`col_int_key`) + AVG(`col_int`) AS average1,
87
133
(SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
88
134
COUNT(*) AS count FROM t1;
90
136
NULL    NULL    0
91
137
select collation_name,character_set_name FROM data_dictionary.collations;
92
138
collation_name  character_set_name
 
139
binary  binary
 
140
utf8_bin        utf8_general_ci
 
141
utf8_czech_ci   utf8_general_ci
 
142
utf8_danish_ci  utf8_general_ci
 
143
utf8_esperanto_ci       utf8_general_ci
 
144
utf8_estonian_ci        utf8_general_ci
93
145
utf8_general_ci utf8_general_ci
94
 
utf8_bin        utf8_general_ci
95
 
utf8_unicode_ci utf8_general_ci
 
146
utf8_hungarian_ci       utf8_general_ci
96
147
utf8_icelandic_ci       utf8_general_ci
97
148
utf8_latvian_ci utf8_general_ci
 
149
utf8_lithuanian_ci      utf8_general_ci
 
150
utf8_persian_ci utf8_general_ci
 
151
utf8_polish_ci  utf8_general_ci
 
152
utf8_roman_ci   utf8_general_ci
98
153
utf8_romanian_ci        utf8_general_ci
 
154
utf8_sinhala_ci utf8_general_ci
 
155
utf8_slovak_ci  utf8_general_ci
99
156
utf8_slovenian_ci       utf8_general_ci
100
 
utf8_polish_ci  utf8_general_ci
101
 
utf8_estonian_ci        utf8_general_ci
 
157
utf8_spanish2_ci        utf8_general_ci
102
158
utf8_spanish_ci utf8_general_ci
103
159
utf8_swedish_ci utf8_general_ci
104
160
utf8_turkish_ci utf8_general_ci
105
 
utf8_czech_ci   utf8_general_ci
106
 
utf8_danish_ci  utf8_general_ci
107
 
utf8_lithuanian_ci      utf8_general_ci
108
 
utf8_slovak_ci  utf8_general_ci
109
 
utf8_spanish2_ci        utf8_general_ci
110
 
utf8_roman_ci   utf8_general_ci
111
 
utf8_persian_ci utf8_general_ci
112
 
utf8_esperanto_ci       utf8_general_ci
113
 
utf8_hungarian_ci       utf8_general_ci
114
 
utf8_sinhala_ci utf8_general_ci
115
 
binary  binary
 
161
utf8_unicode_ci utf8_general_ci
116
162
select COUNT(*) from data_dictionary.tables;
117
163
COUNT(*)
118
164
####.##.####
 
165
COMMIT;
119
166
DROP TABLE t1;