~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Brian Aker
  • Date: 2010-12-15 21:28:47 UTC
  • mto: This revision was merged to the branch mainline in revision 1998.
  • Revision ID: brian@tangent.org-20101215212847-c52kuprsbrcm8sfk
Update name usage for user defined objects.

Show diffs side-by-side

added added

removed removed

Lines of Context:
230
230
TABLE_CACHE     TABLE_SCHEMA
231
231
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
232
232
TABLE_DEFINITION_CACHE  TABLE_SCHEMA
233
 
USER_BARRIERS   SESSION_ID
 
233
USER_DEFINED_BARRIERS   SESSION_ID
 
234
USER_DEFINED_LOCKS      SESSION_ID
234
235
USER_DEFINED_VARIABLES  VARIABLE_VALUE
235
 
USER_LOCKS      SESSION_ID
236
236
SELECT t.table_name, c1.column_name
237
237
FROM data_dictionary.tables t
238
238
INNER JOIN
293
293
TABLE_CACHE     TABLE_SCHEMA
294
294
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
295
295
TABLE_DEFINITION_CACHE  TABLE_SCHEMA
296
 
USER_BARRIERS   SESSION_ID
 
296
USER_DEFINED_BARRIERS   SESSION_ID
 
297
USER_DEFINED_LOCKS      SESSION_ID
297
298
USER_DEFINED_VARIABLES  VARIABLE_VALUE
298
 
USER_LOCKS      SESSION_ID
299
299
SELECT MAX(table_name) FROM data_dictionary.tables;
300
300
MAX(table_name)
301
301
VIEW_TABLE_USAGE