Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug57904.result

raw
1 CREATE TABLE product (category INT NOT NULL, id INT NOT NULL,
2 price DECIMAL, PRIMARY KEY(category, id)) ENGINE=INNODB;
3 CREATE TABLE customer (id INT NOT NULL, PRIMARY KEY (id)) ENGINE=INNODB;
4 CREATE TABLE product_order (no INT NOT NULL AUTO_INCREMENT,
5 product_category INT NOT NULL,
6 product_id INT NOT NULL,
7 customer_id INT NOT NULL,
8 PRIMARY KEY(no),
9 INDEX (product_category, product_id),
10 FOREIGN KEY (product_category, product_id)
11 REFERENCES product(category, id) ON UPDATE CASCADE ON DELETE RESTRICT,
12 INDEX (customer_id),
13 FOREIGN KEY (customer_id)
14 REFERENCES customer(id)
15 ) ENGINE=INNODB;
16 SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
17 WHERE table_name = 'product_order';
18 CONSTRAINT_CATALOG def
19 CONSTRAINT_SCHEMA test
20 CONSTRAINT_NAME product_order_ibfk_1
21 UNIQUE_CONSTRAINT_CATALOG def
22 UNIQUE_CONSTRAINT_SCHEMA test
23 UNIQUE_CONSTRAINT_NAME PRIMARY
24 MATCH_OPTION NONE
25 UPDATE_RULE CASCADE
26 DELETE_RULE RESTRICT
27 TABLE_NAME product_order
28 REFERENCED_TABLE_NAME product
29 CONSTRAINT_CATALOG def
30 CONSTRAINT_SCHEMA test
31 CONSTRAINT_NAME product_order_ibfk_2
32 UNIQUE_CONSTRAINT_CATALOG def
33 UNIQUE_CONSTRAINT_SCHEMA test
34 UNIQUE_CONSTRAINT_NAME PRIMARY
35 MATCH_OPTION NONE
36 UPDATE_RULE RESTRICT
37 DELETE_RULE RESTRICT
38 TABLE_NAME product_order
39 REFERENCED_TABLE_NAME customer
40 DROP TABLE product_order;
41 DROP TABLE product;
42 DROP TABLE customer;