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_CATALOG def
20 CONSTRAINT_NAME product_order_ibfk_1
21 CONSTRAINT_NAME product_order_ibfk_2
22 CONSTRAINT_SCHEMA test
23 CONSTRAINT_SCHEMA test
24 DELETE_RULE NO ACTION
25 DELETE_RULE RESTRICT
26 MATCH_OPTION NONE
27 MATCH_OPTION NONE
28 REFERENCED_TABLE_NAME customer
29 REFERENCED_TABLE_NAME product
30 TABLE_NAME product_order
31 TABLE_NAME product_order
32 UNIQUE_CONSTRAINT_CATALOG def
33 UNIQUE_CONSTRAINT_CATALOG def
34 UNIQUE_CONSTRAINT_NAME PRIMARY
35 UNIQUE_CONSTRAINT_NAME PRIMARY
36 UNIQUE_CONSTRAINT_SCHEMA test
37 UNIQUE_CONSTRAINT_SCHEMA test
38 UPDATE_RULE CASCADE
39 UPDATE_RULE NO ACTION
40 DROP TABLE product_order;
41 DROP TABLE product;
42 DROP TABLE customer;