Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
innodb_gis.point_basic 'innodb' [ fail ]
|
Test ended at 2017-10-12 17:18:34
|
|
CURRENT_TEST: innodb_gis.point_basic
|
mysqltest: At line 781: query 'ALTER TABLE child ADD FOREIGN KEY(p) REFERENCES parent(p)' failed with wrong errno 1005: 'Can't create table `test`.`#sql-76c2_9` (errno: 150 "Foreign key constraint is incorrectly formed")', instead of 1215...
|
|
The result from queries just before the failure was:
|
< snip >
|
parent CREATE TABLE `parent` (
|
`p` point NOT NULL,
|
PRIMARY KEY (`p`(25)),
|
SPATIAL KEY `idx1` (`p`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
SHOW CREATE TABLE child;
|
Table Create Table
|
child CREATE TABLE `child` (
|
`p` point NOT NULL,
|
SPATIAL KEY `idx2` (`p`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
ALTER TABLE child ADD FOREIGN KEY(p) REFERENCES parent(p);
|
ERROR HY000: Can't create table `test`.`#sql-76c2_9` (errno: 150 "Foreign key constraint is incorrectly formed")
|
show warnings;
|
Level Code Message
|
Warning 150 Alter table '`test`.`child`' with foreign key constraint failed. There is no index in the referenced table where the referenced columns appear as the first columns near 'FOREIGN KEY(p) REFERENCES parent(p)'.
|
Error 1005 Can't create table `test`.`#sql-76c2_9` (errno: 150 "Foreign key constraint is incorrectly formed")
|
Warning 1215 Cannot add foreign key constraint
|
ALTER TABLE parent DROP INDEX idx1;
|
ALTER TABLE child ADD FOREIGN KEY(p) REFERENCES parent(p);
|
|
More results from queries before failure can be found in /dev/shm/log/point_basic.log
|
|
- saving '/dev/shm/log/innodb_gis.point_basic-innodb/' to '/dev/shm/log/innodb_gis.point_basic-innodb/'
|