← Back to branch summary

~ubuntu-branches/ubuntu/vivid/mariadb-5.5/vivid-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/innodb/r/foreign-keys.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2014-11-14 21:04:24 UTC
  • mfrom: (1.1.6)
  • Revision ID: package-import@ubuntu.com-20141114210424-xlyna0ozl11647o5
Tags: 5.5.40-0ubuntu0.14.10.1
https://launchpad.net/bugs/1391676
* SECURITY UPDATE: Update to 5.5.40 to fix security issues (LP: #1391676)
  - CVE-2014-6507
  - CVE-2014-6491
  - CVE-2014-6500
  - CVE-2014-6469
  - CVE-2014-6555
  - CVE-2014-6559
  - CVE-2014-6494
  - CVE-2014-6496
  - CVE-2014-6464
* Add bsdutils as mariadb-server dependency like upstream does in 5.5.40.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/innodb/r/foreign-keys.result
 
1
#
 
2
# Bug #19471516 SERVER CRASHES WHEN EXECUTING ALTER TABLE
 
3
# ADD FOREIGN KEY
 
4
#
 
5
CREATE TABLE `department` (`department_id` INT, `department_people_fk` INT,
 
6
PRIMARY KEY (`department_id`)) engine=innodb;
 
7
CREATE TABLE `title` (`title_id` INT, `title_manager_fk` INT,
 
8
`title_reporter_fk` INT, PRIMARY KEY (`title_id`)) engine=innodb;
 
9
CREATE TABLE `people` (`people_id` INT, PRIMARY KEY (`people_id`)) engine=innodb;
 
10
ALTER TABLE `department` ADD FOREIGN KEY (`department_people_fk`) REFERENCES
 
11
`people` (`people_id`);
 
12
ALTER TABLE `title` ADD FOREIGN KEY (`title_manager_fk`) REFERENCES `people`
 
13
(`people_id`);
 
14
ALTER TABLE `title` ADD FOREIGN KEY (`title_reporter_fk`) REFERENCES `people`
 
15
(`people_id`);
 
16
drop table title, department, people;