← 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-04-09 15:03:26 UTC
  • mfrom: (971.1.44 mordred)
  • Revision ID: brian@gaz-20090409150326-cu50yn12esijpy1c
Merge Monty

Show diffs side-by-side

added added

removed removed

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