← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Brian Aker
  • Date: 2009-02-17 00:40:38 UTC
  • mfrom: (873.2.30 devel)
  • Revision ID: brian@tangent.org-20090217004038-ivu0noxx1958wwls
Merge from Monty.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
263
263
STATISTICS      TABLE_SCHEMA
264
264
TABLES  TABLE_SCHEMA
265
265
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
266
INNODB_CMP      page_size
266
267
INNODB_CMP_RESET        page_size
267
 
INNODB_TRX      trx_id
 
268
INNODB_CMPMEM   page_size
268
269
INNODB_CMPMEM_RESET     page_size
269
270
INNODB_LOCK_WAITS       requesting_trx_id
270
 
INNODB_CMPMEM   page_size
271
 
INNODB_CMP      page_size
272
271
INNODB_LOCKS    lock_id
 
272
INNODB_TRX      trx_id
273
273
SELECT t.table_name, c1.column_name
274
274
FROM information_schema.tables t
275
275
INNER JOIN
302
302
STATISTICS      TABLE_SCHEMA
303
303
TABLES  TABLE_SCHEMA
304
304
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
305
INNODB_CMP      page_size
305
306
INNODB_CMP_RESET        page_size
306
 
INNODB_TRX      trx_id
 
307
INNODB_CMPMEM   page_size
307
308
INNODB_CMPMEM_RESET     page_size
308
309
INNODB_LOCK_WAITS       requesting_trx_id
309
 
INNODB_CMPMEM   page_size
310
 
INNODB_CMP      page_size
311
310
INNODB_LOCKS    lock_id
 
311
INNODB_TRX      trx_id
312
312
SELECT MAX(table_name) FROM information_schema.tables;
313
313
MAX(table_name)
314
314
TABLE_CONSTRAINTS