← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

Merging in Padraig's final I_S plugin work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/information_schema.test
412
412
# do a query on the CHARACTER_SET table in I_S 
413
413
#
414
414
SELECT *
415
 
FROM information_schema.character_sets;
 
415
FROM information_schema.character_sets
 
416
ORDER BY character_set_name;
416
417
 
417
418
#
418
419
# perform a query on the COLLATIONS table
419
420
#
420
421
SELECT *
421
 
FROM information_schema.collations;
 
422
FROM information_schema.collations
 
423
ORDER BY collation_name;
422
424
 
423
425
#
424
426
# perform a query on COLLATION_CHARACTER_SET_APPLICABILITY
425
427
#
426
428
SELECT * 
427
 
FROM information_schema.collation_character_set_applicability;
 
429
FROM information_schema.collation_character_set_applicability
 
430
ORDER BY collation_name;
428
431
 
429
432
#
430
433
# perform a query on COLUMNS
431
434
#
432
435
SELECT table_name, column_name
433
 
FROM information_schema.columns;
 
436
FROM information_schema.columns
 
437
ORDER BY table_name;
434
438
 
435
439
#
436
440
# perform a query on KEY_COLUMN_USAGE
448
452
# query the SCHEMATA table
449
453
#
450
454
SELECT catalog_name, schema_name
451
 
FROM information_schema.schemata;
 
455
FROM information_schema.schemata
 
456
ORDER BY schema_name;
 
457
 
 
458
#
 
459
# Query the STATUS and VARIABLES related
 
460
# I_S related tables. 
 
461
#
 
462
--replace_column 1 # 2 #
 
463
SELECT *
 
464
FROM information_schema.session_status
 
465
ORDER BY variable_name;
 
466
 
 
467
--replace_column 1 # 2 #
 
468
SHOW STATUS;
 
469
 
 
470
#--replace_column 1 # 2 #
 
471
#SELECT *
 
472
#FROM information_schema.session_variables
 
473
#ORDER BY variable_name;
 
474
 
 
475
#--replace_column 1 # 2 #
 
476
#SHOW VARIABLES;
 
477
 
 
478
--replace_column 1 # 2 #
 
479
SELECT *
 
480
FROM information_schema.global_status
 
481
ORDER BY variable_name;
 
482
 
 
483
#--replace_column 1 # 2 #
 
484
#SELECT *
 
485
#FROM information_schema.global_variables
 
486
#ORDER BY variable_name;
452
487
 
453
488
#
454
489
# query TABLE_CONSTRAINTS table
460
495
# query TABLES
461
496
#
462
497
SELECT table_schema, table_name
463
 
FROM information_schema.tables;
 
498
FROM information_schema.tables
 
499
ORDER BY table_name;
464
500
 
465
501
# 
466
502
# do a query on the PLUGINS table in I_S to ensure it works correctly