~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
74
74
select TABLE_ROWS from information_schema.tables where 
75
75
table_schema="information_schema" and table_name="COLUMNS";
76
76
TABLE_ROWS
77
 
NULL
 
77
0
78
78
select table_type from information_schema.tables
79
79
where table_schema="mysql" and table_name="user";
80
80
table_type
169
169
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '' at line 1
170
170
drop database information_schema;
171
171
ERROR 42000: Access denied for user ''@'' to database 'information_schema'
172
 
drop table information_schema.tables;
 
172
use information_schema;
 
173
drop table tables;
173
174
ERROR 42000: Access denied for user ''@'' to database 'information_schema'
174
 
alter table information_schema.tables;
 
175
alter table tables;
175
176
ERROR 42000: Access denied for user ''@'' to database 'information_schema'
176
177
use information_schema;
177
178
create temporary table schemata(f1 char(10));
211
212
table_schema='information_schema' and
212
213
(column_type = 'varchar(7)' or column_type = 'varchar(20)'
213
214
 or column_type = 'varchar(27)')
214
 
group by column_type order by num;
 
215
group by column_type order by column_type, num;
215
216
column_type     group_concat(table_schema, '.', table_name)     num
216
217
varchar(20)     information_schema.MODULES      1
217
218
varchar(27)     information_schema.COLUMNS      1