← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Merge catalog with current trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
187
187
AND t.table_name NOT LIKE 'falcon%'
188
188
  ORDER BY t.table_name, c1.column_name;
189
189
table_name      column_name
 
190
CATALOGS        CATALOG_CREATION_TIME
190
191
CHARACTER_SETS  DEFAULT_COLLATE_NAME
191
192
COLLATIONS      COLLATION_NAME
192
193
COLUMNS TABLE_SCHEMA
251
252
AND t.table_name NOT LIKE 'falcon%'
252
253
  ORDER BY t.table_name, c1.column_name;
253
254
table_name      column_name
 
255
CATALOGS        CATALOG_CREATION_TIME
254
256
CHARACTER_SETS  DEFAULT_COLLATE_NAME
255
257
COLLATIONS      COLLATION_NAME
256
258
COLUMNS TABLE_SCHEMA
311
313
create table t2 (f1 int, f2 int);
312
314
drop table t1,t2;
313
315
select 1 as f1 from data_dictionary.tables  where "CHARACTER_SETS"=
314
 
(select cast(table_name as char)  from data_dictionary.tables
315
 
order by table_name limit 1) limit 1;
 
316
(select cast(table_name as char)  from data_dictionary.tables WHERE TABLE_SCHEMA=schema()
 
317
AND TABLE_NAME = "CHARACTER_SETS"
 
318
 order by table_name limit 1) AND TABLE_SCHEMA=schema() limit 1;
316
319
f1
317
 
1
318
320
select t.table_name, group_concat(t.table_schema, '.', t.table_name),
319
321
count(*) as num1
320
322
from data_dictionary.tables t