← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

  • Committer: Olaf van der Spek
  • Date: 2011-03-28 14:32:36 UTC
  • mto: (2257.1.1 build) (2276.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 2258.
  • Revision ID: olafvdspek@gmail.com-20110328143236-4ge1d793iqaktfq0
Common fwd

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/information_schema.test
264
264
#
265
265
--sorted_result
266
266
select 1 as f1 from data_dictionary.tables  where "CHARACTER_SETS"=
267
 
(select cast(table_name as char)  from data_dictionary.tables
268
 
 order by table_name limit 1) limit 1;
 
267
(select cast(table_name as char)  from data_dictionary.tables WHERE TABLE_SCHEMA=schema()
 
268
 AND TABLE_NAME = "CHARACTER_SETS"
 
269
 order by table_name limit 1) AND TABLE_SCHEMA=schema() limit 1;
269
270
 
270
271
select t.table_name, group_concat(t.table_schema, '.', t.table_name),
271
272
       count(*) as num1