diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-05-11 15:08:08 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-05-11 18:35:03 +0300 |
commit | 671a37f60e6663a175368b134574c0274964589b (patch) | |
tree | b7c275e63ddc93ab784af59cc77d3b2325b1a104 /mysql-test/suite/innodb/r/stored_fk.result | |
parent | 3d10966b7d5ed408f9c085f5ba9ed9b12a7317aa (diff) | |
download | mariadb-git-671a37f60e6663a175368b134574c0274964589b.tar.gz |
Adjust the test case for MariaDB
Note: it does not appear to cover the bug fix! The test
will pass even if the Oracle Bug #26731689 fix is reverted.
Diffstat (limited to 'mysql-test/suite/innodb/r/stored_fk.result')
-rw-r--r-- | mysql-test/suite/innodb/r/stored_fk.result | 46 |
1 files changed, 27 insertions, 19 deletions
diff --git a/mysql-test/suite/innodb/r/stored_fk.result b/mysql-test/suite/innodb/r/stored_fk.result index 6fb1684497f..35524d5a88f 100644 --- a/mysql-test/suite/innodb/r/stored_fk.result +++ b/mysql-test/suite/innodb/r/stored_fk.result @@ -1,41 +1,50 @@ # Create statement with FK on base column of stored column create table t1(f1 int, f2 int as(f1) stored, foreign key(f1) references t2(f1) on delete cascade)engine=innodb; -ERROR HY000: Cannot add foreign key constraint +ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed") # adding new stored column during alter table copy operation. -create table t1(f1 int primary key); +create table t1(f1 int primary key) engine=innodb; create table t2(f1 int not null, f2 int as (f1) virtual, foreign key(f1) references t1(f1) on update cascade)engine=innodb; alter table t2 add column f3 int as (f1) stored, add column f4 int as (f1) virtual; -ERROR HY000: Error on rename of 'OLD_FILE_NAME' to 'NEW_FILE_NAME' (errno: 150 - Foreign key constraint is incorrectly formed) -drop table t2, t1; +show create table t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `f1` int(11) NOT NULL, + `f2` int(11) GENERATED ALWAYS AS (`f1`) VIRTUAL, + `f3` int(11) GENERATED ALWAYS AS (`f1`) STORED, + `f4` int(11) GENERATED ALWAYS AS (`f1`) VIRTUAL, + KEY `f1` (`f1`), + CONSTRAINT `t2_ibfk_1` FOREIGN KEY (`f1`) REFERENCES `t1` (`f1`) ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=latin1 +drop table t2; # adding foreign key constraint for base columns during alter copy. -create table t1(f1 int primary key); -create table t2(f1 int not null, f2 int as (f1) stored); +create table t2(f1 int not null, f2 int as (f1) stored) engine=innodb; alter table t2 add foreign key(f1) references t1(f1) on update cascade, algorithm=copy; -ERROR HY000: Cannot add foreign key constraint -drop table t2, t1; +show create table t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `f1` int(11) NOT NULL, + `f2` int(11) GENERATED ALWAYS AS (`f1`) STORED, + KEY `f1` (`f1`), + CONSTRAINT `t2_ibfk_1` FOREIGN KEY (`f1`) REFERENCES `t1` (`f1`) ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=latin1 +drop table t2; # adding foreign key constraint for base columns during online alter. -create table t1(f1 int primary key); -create table t2(f1 int not null, f2 int as (f1) stored); +create table t2(f1 int not null, f2 int as (f1) stored) engine=innodb; set foreign_key_checks = 0; alter table t2 add foreign key(f1) references t1(f1) on update cascade, algorithm=inplace; -ERROR HY000: Cannot add foreign key on the base column of stored column. -drop table t2, t1; +ERROR 0A000: Cannot add foreign key on the base column of stored column +drop table t2; # adding stored column via online alter. -create table t1(f1 int primary key); create table t2(f1 int not null, foreign key(f1) references t1(f1) on update cascade)engine=innodb; alter table t2 add column f2 int as (f1) stored, algorithm=inplace; -ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. +ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY drop table t2, t1; -set foreign_key_checks = 1; # # BUG#26731689 FK ON TABLE WITH GENERATED COLS: ASSERTION POS < N_DEF # -SET @foreign_key_checks_saved = @@foreign_key_checks; -SET foreign_key_checks=0; -DROP TABLE IF EXISTS s,t; CREATE TABLE s (a INT, b INT GENERATED ALWAYS AS (0) STORED, c INT, d INT GENERATED ALWAYS AS (0) VIRTUAL, e INT) ENGINE=innodb; CREATE TABLE t (a INT) ENGINE=innodb; @@ -63,4 +72,3 @@ ERROR HY000: Failed to add the foreign key constaint. Missing index for constrai ALTER TABLE t ADD PRIMARY KEY(a); ALTER TABLE s ADD CONSTRAINT c FOREIGN KEY (a) REFERENCES t(a) ON UPDATE SET null; DROP TABLE s,t; -SET @@foreign_key_checks = @foreign_key_checks_saved; |