~drizzle-trunk/drizzle/development

CREATE TABLE product (category INT NOT NULL, id INT NOT NULL,

price DECIMAL,

PRIMARY KEY(category, id)) ENGINE=INNODB;

CREATE TABLE customer (id INT NOT NULL,

PRIMARY KEY (id)) ENGINE=INNODB;

CREATE TABLE product_order (no INT NOT NULL AUTO_INCREMENT,

product_category INT NOT NULL,

product_id INT NOT NULL,

customer_id INT NOT NULL,

PRIMARY KEY(no),

INDEX (product_category, product_id),

FOREIGN KEY (product_category, product_id)

REFERENCES product(category, id)

ON UPDATE CASCADE ON DELETE RESTRICT,

INDEX (customer_id),

FOREIGN KEY (customer_id)

REFERENCES customer(id)) ENGINE=INNODB;

show create table product_order;

Table	Create Table

product_order	CREATE TABLE `product_order` (

  `no` INT NOT NULL AUTO_INCREMENT,

  `product_category` INT NOT NULL,

  `product_id` INT NOT NULL,

  `customer_id` INT NOT NULL,

  PRIMARY KEY (`no`) USING BTREE,

  KEY `product_category` (`product_category`,`product_id`) USING BTREE,

  KEY `customer_id` (`customer_id`) USING BTREE,

  CONSTRAINT `product_order_ibfk_1` FOREIGN KEY (`product_category`, `product_id`) REFERENCES `product` (`category`, `id`) ON UPDATE CASCADE ON DELETE RESTRICT,

  CONSTRAINT `product_order_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)

) ENGINE=InnoDB COLLATE = utf8_general_ci

drop table product_order, customer, product;

drop table if exists t_34455;

create table t_34455 (

a int not null,

foreign key (a) references t3 (a) match full match partial);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'match partial)' at line 3

create table t_34455 (

a int not null,

foreign key (a) references t3 (a) on delete set default match full);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'match full)' at line 3

create table t_34455 (

a int not null,

foreign key (a) references t3 (a) on update set default match full);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'match full)' at line 3

create table t_34455 (

a int not null,

foreign key (a) references t3 (a)

on delete set default on delete set default);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'delete set default)' at line 4

create table t_34455 (

a int not null,

foreign key (a) references t3 (a)

on update set default on update set default);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'update set default)' at line 4

create table t_34455 (a int not null);

alter table t_34455

add foreign key (a) references t3 (a) match full match partial);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'match partial)' at line 1

alter table t_34455

add foreign key (a) references t3 (a) on delete set default match full);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'match full)' at line 1

alter table t_34455

add foreign key (a) references t3 (a) on update set default match full);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'match full)' at line 1

alter table t_34455

add foreign key (a) references t3 (a)

on delete set default on delete set default);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'delete set default)' at line 2

alter table t_34455

add foreign key (a) references t3 (a)

on update set default on update set default);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'update set default)' at line 2

drop table t_34455;