← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema_inno.result

  • Committer: Brian Aker
  • Date: 2010-02-14 02:02:48 UTC
  • mfrom: (1273.13.64 fix_is)
  • Revision ID: brian@gaz-20100214020248-bhovaejhz9fmer3q
Merge in data_dictionary.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema_inno.result
5
5
FOREIGN KEY (t1_id) REFERENCES t1(id)  ON UPDATE CASCADE) ENGINE=INNODB;
6
6
CREATE TABLE t3 (id INT PRIMARY KEY, t2_id INT, INDEX par_ind (t2_id),
7
7
FOREIGN KEY (id, t2_id) REFERENCES t2(t1_id, id)  ON DELETE CASCADE) ENGINE=INNODB;
8
 
select * from information_schema.TABLE_CONSTRAINTS where
 
8
select * from information_schema.OLD_TABLE_CONSTRAINTS where
9
9
TABLE_SCHEMA= "test";
10
10
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
11
11
NULL    test    PRIMARY test    t1      PRIMARY KEY
14
14
NULL    test    t2_ibfk_2       test    t2      FOREIGN KEY
15
15
NULL    test    PRIMARY test    t3      PRIMARY KEY
16
16
NULL    test    t3_ibfk_1       test    t3      FOREIGN KEY
17
 
select * from information_schema.KEY_COLUMN_USAGE where
 
17
select * from information_schema.OLD_KEY_COLUMN_USAGE where
18
18
TABLE_SCHEMA= "test";
19
19
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        POSITION_IN_UNIQUE_CONSTRAINT   REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME   REFERENCED_COLUMN_NAME
20
20
NULL    test    PRIMARY NULL    test    t1      id      1       NULL    NULL    NULL    NULL
46
46
select a.CONSTRAINT_SCHEMA, b.TABLE_NAME, CONSTRAINT_TYPE,
47
47
b.CONSTRAINT_NAME, UNIQUE_CONSTRAINT_SCHEMA, UNIQUE_CONSTRAINT_NAME,
48
48
MATCH_OPTION, UPDATE_RULE, DELETE_RULE, b.REFERENCED_TABLE_NAME
49
 
from information_schema.TABLE_CONSTRAINTS a,
50
 
information_schema.REFERENTIAL_CONSTRAINTS b
 
49
from information_schema.OLD_TABLE_CONSTRAINTS a,
 
50
information_schema.OLD_REFERENTIAL_CONSTRAINTS b
51
51
where a.CONSTRAINT_SCHEMA = 'test' and a.CONSTRAINT_SCHEMA = b.CONSTRAINT_SCHEMA and
52
52
a.CONSTRAINT_NAME = b.CONSTRAINT_NAME;
53
53
CONSTRAINT_SCHEMA       TABLE_NAME      CONSTRAINT_TYPE CONSTRAINT_NAME UNIQUE_CONSTRAINT_SCHEMA        UNIQUE_CONSTRAINT_NAME  MATCH_OPTION    UPDATE_RULE     DELETE_RULE     REFERENCED_TABLE_NAME
71
71
) engine=innodb;
72
72
use test;
73
73
select referenced_table_schema, referenced_table_name 
74
 
from information_schema.key_column_usage
 
74
from information_schema.OLD_key_column_usage
75
75
where constraint_schema = 'db-1';
76
76
referenced_table_schema referenced_table_name
77
77
NULL    NULL
83
83
set foreign_key_checks = 0;
84
84
drop table t1;
85
85
select UNIQUE_CONSTRAINT_NAME
86
 
from information_schema.referential_constraints
 
86
from information_schema.OLD_referential_constraints
87
87
where constraint_schema = schema();
88
88
UNIQUE_CONSTRAINT_NAME
89
89
NULL