diff options
| author | Jan Lindström <jan.lindstrom@mariadb.com> | 2017-10-12 17:21:04 +0300 |
|---|---|---|
| committer | Jan Lindström <jan.lindstrom@mariadb.com> | 2017-10-25 06:47:08 +0300 |
| commit | a6a4c25bf7d943ff5a429fbf32fe04fdaca25b16 (patch) | |
| tree | bf00fd160d19ce22c92656e9b1a4846f4cce57d2 /mysql-test/suite/innodb_gis/t/point_basic.test | |
| parent | 42e3e574260dc6ccfe161f8c0d8e8af41e599353 (diff) | |
| download | mariadb-git-a6a4c25bf7d943ff5a429fbf32fe04fdaca25b16.tar.gz | |
MariaDB adjustments to innodb_gis tests.
Some test are still disabled as they provide different results,
fail on different error or crash.
Fixes also MDEV-14060 InnoDB: Foreign key constraint to
geometry type does not work where test intentionally tried
incorrect cases.
Diffstat (limited to 'mysql-test/suite/innodb_gis/t/point_basic.test')
| -rw-r--r-- | mysql-test/suite/innodb_gis/t/point_basic.test | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/mysql-test/suite/innodb_gis/t/point_basic.test b/mysql-test/suite/innodb_gis/t/point_basic.test index c6a2a673c19..1c0d229802b 100644 --- a/mysql-test/suite/innodb_gis/t/point_basic.test +++ b/mysql-test/suite/innodb_gis/t/point_basic.test @@ -772,16 +772,25 @@ ALTER TABLE child ADD SPATIAL INDEX idx2(p ASC); SHOW CREATE TABLE parent; SHOW CREATE TABLE child; ---error ER_CANNOT_ADD_FOREIGN +--replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ +--error ER_CANT_CREATE_TABLE ALTER TABLE child ADD FOREIGN KEY(p) REFERENCES parent(p); +--replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ +show warnings; ALTER TABLE parent DROP INDEX idx1; ---error ER_CANNOT_ADD_FOREIGN +--replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ +--error ER_CANNOT_ADD_FOREIGN,ER_CANT_CREATE_TABLE ALTER TABLE child ADD FOREIGN KEY(p) REFERENCES parent(p); +--replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ +show warnings; ALTER TABLE child DROP INDEX idx2; ---error ER_CANNOT_ADD_FOREIGN +--replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ +--error ER_CANNOT_ADD_FOREIGN,ER_CANT_CREATE_TABLE ALTER TABLE child ADD FOREIGN KEY(p) REFERENCES parent(p); +--replace_regex /#sql-[0-9a-f_]*`/#sql-temporary`/ +show warnings; DROP TABLE child, parent; |