← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

  • Committer: devananda
  • Date: 2009-06-30 14:27:54 UTC
  • mfrom: (1030.2.4 trunk)
  • mto: (1093.1.7 captain)
  • mto: This revision was merged to the branch mainline in revision 1095.
  • Revision ID: devananda.vdv@gmail.com-20090630142754-vm9w374yxkf1pikc
merge from lp

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/information_schema.test
394
394
--echo #
395
395
 
396
396
SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID();
 
397
 
 
398
#
 
399
# test that SHOW PROCESSLIST works correctly
 
400
#
 
401
--replace_column 1 # 2 # 3 # 6 # 7 #
 
402
show processlist;
 
403
 
 
404
#
 
405
# do a query on the PROCESSLIST table in I_S to ensure it works correctly
 
406
#
 
407
SELECT info, command, db
 
408
FROM information_schema.processlist
 
409
WHERE id = CONNECTION_ID();
 
410
 
 
411
#
 
412
# do a query on the CHARACTER_SET table in I_S 
 
413
#
 
414
SELECT *
 
415
FROM information_schema.character_sets;
 
416
 
 
417
#
 
418
# perform a query on the COLLATIONS table
 
419
#
 
420
SELECT *
 
421
FROM information_schema.collations;
 
422
 
 
423
#
 
424
# perform a query on COLLATION_CHARACTER_SET_APPLICABILITY
 
425
#
 
426
SELECT * 
 
427
FROM information_schema.collation_character_set_applicability;
 
428
 
 
429
#
 
430
# perform a query on KEY_COLUMN_USAGE
 
431
#
 
432
SELECT *
 
433
FROM information_schema.key_column_usage;
 
434
 
 
435
#
 
436
# perform a query on REFERENTIAL_CONSTRAINTS
 
437
#
 
438
SELECT * 
 
439
FROM information_schema.referential_constraints;
 
440
 
 
441
#
 
442
# query TABLE_CONSTRAINTS table
 
443
#
 
444
SELECT *
 
445
FROM information_schema.table_constraints;
 
446
 
 
447
# 
 
448
# do a query on the PLUGINS table in I_S to ensure it works correctly
 
449
# how do we test for this if the contents of this table can change
 
450
# depend on what plugins are configured for use?
 
451
#
 
452
#SELECT *
 
453
#FROM plugins;