"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "mysql-test/suite/gcol/r/innodb_virtual_fk.result" between
mariadb-10.2.21.tar.gz and mariadb-10.2.22.tar.gz

About: MariaDB is a relational database management system (a drop-in replacement for MySQL). Stable (GA) release (10.2).

innodb_virtual_fk.result  (mariadb-10.2.21):innodb_virtual_fk.result  (mariadb-10.2.22)
skipping to change at line 705 skipping to change at line 705
c1 TIMESTAMP, c1 TIMESTAMP,
c2 YEAR, c2 YEAR,
c3 TIME, c3 TIME,
c4 CHAR(10), c4 CHAR(10),
v1 TIMESTAMP AS (c1) VIRTUAL, v1 TIMESTAMP AS (c1) VIRTUAL,
v2 YEAR AS (c2) VIRTUAL, v2 YEAR AS (c2) VIRTUAL,
v3 TIME AS (c3) VIRTUAL, v3 TIME AS (c3) VIRTUAL,
v4 CHAR(10) AS (c4) VIRTUAL v4 CHAR(10) AS (c4) VIRTUAL
) ENGINE=InnoDB; ) ENGINE=InnoDB;
ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col); ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col);
ERROR HY000: Can't create table `test`.`#sql-temporary` (errno: 150 "Foreign key constraint is incorrectly formed") ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed")
SET foreign_key_checks=0; SET foreign_key_checks=0;
ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col); ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col);
ERROR HY000: Failed to add the foreign key constaint. Missing index for constrai nt 'fk' in the foreign table 't1' ERROR HY000: Failed to add the foreign key constaint. Missing index for constrai nt 'fk' in the foreign table 't1'
ALTER TABLE t1 ADD INDEX(v4); ALTER TABLE t1 ADD INDEX(v4);
ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col); ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col);
SET foreign_key_checks=1; SET foreign_key_checks=1;
SHOW CREATE TABLE t1; SHOW CREATE TABLE t1;
Table Create Table Table Create Table
t1 CREATE TABLE `t1` ( t1 CREATE TABLE `t1` (
`c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestam p(), `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestam p(),
skipping to change at line 728 skipping to change at line 728
`c4` char(10) DEFAULT NULL, `c4` char(10) DEFAULT NULL,
`v1` timestamp GENERATED ALWAYS AS (`c1`) VIRTUAL, `v1` timestamp GENERATED ALWAYS AS (`c1`) VIRTUAL,
`v2` year(4) GENERATED ALWAYS AS (`c2`) VIRTUAL, `v2` year(4) GENERATED ALWAYS AS (`c2`) VIRTUAL,
`v3` time GENERATED ALWAYS AS (`c3`) VIRTUAL, `v3` time GENERATED ALWAYS AS (`c3`) VIRTUAL,
`v4` char(10) GENERATED ALWAYS AS (`c4`) VIRTUAL, `v4` char(10) GENERATED ALWAYS AS (`c4`) VIRTUAL,
KEY `v4` (`v4`), KEY `v4` (`v4`),
CONSTRAINT `fk` FOREIGN KEY (`v4`) REFERENCES `nosuch` (`col`) CONSTRAINT `fk` FOREIGN KEY (`v4`) REFERENCES `nosuch` (`col`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
ALTER TABLE t1 DROP FOREIGN KEY fk; ALTER TABLE t1 DROP FOREIGN KEY fk;
ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col); ALTER TABLE t1 ADD CONSTRAINT fk FOREIGN KEY (v4) REFERENCES nosuch(col);
ERROR HY000: Can't create table `test`.`#sql-temporary` (errno: 150 "Foreign key constraint is incorrectly formed") ERROR HY000: Can't create table `test`.`t1` (errno: 150 "Foreign key constraint is incorrectly formed")
SHOW CREATE TABLE t1; SHOW CREATE TABLE t1;
Table Create Table Table Create Table
t1 CREATE TABLE `t1` ( t1 CREATE TABLE `t1` (
`c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestam p(), `c1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestam p(),
`c2` year(4) DEFAULT NULL, `c2` year(4) DEFAULT NULL,
`c3` time DEFAULT NULL, `c3` time DEFAULT NULL,
`c4` char(10) DEFAULT NULL, `c4` char(10) DEFAULT NULL,
`v1` timestamp GENERATED ALWAYS AS (`c1`) VIRTUAL, `v1` timestamp GENERATED ALWAYS AS (`c1`) VIRTUAL,
`v2` year(4) GENERATED ALWAYS AS (`c2`) VIRTUAL, `v2` year(4) GENERATED ALWAYS AS (`c2`) VIRTUAL,
`v3` time GENERATED ALWAYS AS (`c3`) VIRTUAL, `v3` time GENERATED ALWAYS AS (`c3`) VIRTUAL,
 End of changes. 2 change blocks. 
2 lines changed or deleted 2 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)