← 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: Olaf van der Spek
  • Date: 2011-08-04 08:13:04 UTC
  • mfrom: (2384 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2385.
  • Revision ID: olafvdspek@gmail.com-20110804081304-rlejjpvoos17bjdf
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema_inno.result
7
7
FOREIGN KEY (id, t2_id) REFERENCES t2(t1_id, id)  ON DELETE CASCADE) ENGINE=INNODB;
8
8
select * from data_dictionary.indexes where TABLE_SCHEMA= "test";
9
9
TABLE_SCHEMA    TABLE_NAME      INDEX_NAME      IS_USED_IN_PRIMARY      IS_UNIQUE       IS_NULLABLE     KEY_LENGTH      INDEX_TYPE      INDEX_COMMENT
10
 
test    t1      PRIMARY YES     YES     NO      4       UNKNOWN NULL
11
 
test    t2      PRIMARY YES     YES     NO      4       UNKNOWN NULL
12
 
test    t2      par_ind NO      NO      YES     8       UNKNOWN NULL
13
 
test    t3      PRIMARY YES     YES     NO      4       UNKNOWN NULL
14
 
test    t3      id      NO      NO      YES     8       UNKNOWN NULL
15
 
test    t3      par_ind NO      NO      YES     4       UNKNOWN NULL
 
10
test    t1      PRIMARY YES     YES     NO      4       BTREE   NULL
 
11
test    t2      PRIMARY YES     YES     NO      4       BTREE   NULL
 
12
test    t2      par_ind NO      NO      YES     8       BTREE   NULL
 
13
test    t3      PRIMARY YES     YES     NO      4       BTREE   NULL
 
14
test    t3      id      NO      NO      YES     8       BTREE   NULL
 
15
test    t3      par_ind NO      NO      YES     4       BTREE   NULL
16
16
drop table t3, t2, t1;
17
17
CREATE TABLE t1(a1 INT NOT NULL, a2 INT NOT NULL,
18
18
PRIMARY KEY(a1, a2)) ENGINE=INNODB;