vcol.vcol_keys_innodb 'xtradb' w4 [ fail ] timeout after 9000 seconds
|
Test ended at 2016-04-26 20:49:41
|
|
Test case timeout after 9000 seconds
|
|
== /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/4/log/vcol_keys_innodb.log ==
|
# Rejected FK options.
|
create table t1 (a int, b int as (a+1) persistent,
|
foreign key (b) references t2(a) on update set null);
|
ERROR HY000: Cannot define foreign key with ON UPDATE SET NULL clause on a computed column
|
create table t1 (a int, b int as (a+1) persistent,
|
foreign key (b) references t2(a) on update cascade);
|
ERROR HY000: Cannot define foreign key with ON UPDATE CASCADE clause on a computed column
|
create table t1 (a int, b int as (a+1) persistent,
|
foreign key (b) references t2(a) on delete set null);
|
ERROR HY000: Cannot define foreign key with ON DELETE SET NULL clause on a computed column
|
create table t1 (a int, b int as (a+1) persistent);
|
alter table t1 add foreign key (b) references t2(a) on update set null;
|
ERROR HY000: Cannot define foreign key with ON UPDATE SET NULL clause on a computed column
|
alter table t1 add foreign key (b) references t2(a) on update cascade;
|
ERROR HY000: Cannot define foreign key with ON UPDATE CASCADE clause on a computed column
|
alter table t1 add foreign key (b) references t2(a) on delete set null;
|
ERROR HY000: Cannot define foreign key with ON DELETE SET NULL clause on a computed column
|
drop table t1;
|
create table t1 (a int, b int as (a+1),
|
foreign key (b) references t2(a));
|