~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/data_dictionary_like_info.result

  • Committer: Brian Aker
  • Date: 2010-03-17 19:18:40 UTC
  • mto: This revision was merged to the branch mainline in revision 1354.
  • Revision ID: brian@gaz-20100317191840-9ro7fajqp6lhaqjo
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
247
247
table_name      column_name
248
248
SELECT MAX(table_name) FROM data_dictionary.tables;
249
249
MAX(table_name)
250
 
TABLE_DEFINITION_CACHE
 
250
VIEW_TABLE_USAGE
251
251
SELECT table_name from data_dictionary.tables
252
252
WHERE table_name=(SELECT MAX(table_name)
253
253
FROM data_dictionary.tables);
254
254
table_name
255
 
TABLE_DEFINITION_CACHE
 
255
VIEW_TABLE_USAGE
256
256
create table t1 (f1 int);
257
257
create table t2 (f1 int, f2 int);
258
258
select table_name from data_dictionary.tables