← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Add in new show work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
6
6
select schema_name from data_dictionary.schemas;
7
7
schema_name
8
8
information_schema
9
 
 
10
 
 
 
9
mysql
 
10
test
11
11
show databases like 't%';
12
12
Database (t%)
13
13
test
621
621
SELECT * 
622
622
FROM information_schema.old_referential_constraints;
623
623
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG       UNIQUE_CONSTRAINT_SCHEMA        UNIQUE_CONSTRAINT_NAME  MATCH_OPTION    UPDATE_RULE     DELETE_RULE     TABLE_NAME      REFERENCED_TABLE_NAME
624
 
SELECT schema_name
625
 
FROM data_dictionary.schemas
626
 
ORDER BY schema_name;
627
 
schema_name
628
 
 
629
 
 
630
 
information_schema
 
624
SELECT count(schema_name) FROM data_dictionary.schemas ORDER BY schema_name;
 
625
count(schema_name)
 
626
#
631
627
SHOW STATUS;
632
628
Variable_name   Value
633
629
#       #
862
858
information_schema      OLD_TABLES
863
859
information_schema      OLD_TABLE_CONSTRAINTS
864
860
information_schema      OPEN_SESSION_STATUS
 
861
SELECT count(*) FROM data_dictionary.plugins;
 
862
count(*)
 
863
#