From 127bfdf0d90f4c50b1e47674cf3f7c1d2f395882 Mon Sep 17 00:00:00 2001 From: Kentoku SHIBA Date: Sun, 13 Sep 2020 00:55:10 +0900 Subject: MDEV-19177 Geometry support by the partition feature --- mysql-test/suite/innodb_gis/r/geometry.result | 2 +- mysql-test/suite/innodb_gis/t/geometry.test | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/mysql-test/suite/innodb_gis/r/geometry.result b/mysql-test/suite/innodb_gis/r/geometry.result index 70e0f04cdf1..c36f14233cb 100644 --- a/mysql-test/suite/innodb_gis/r/geometry.result +++ b/mysql-test/suite/innodb_gis/r/geometry.result @@ -1091,7 +1091,7 @@ PARTITION pNorth VALUES IN (10,20,30) , PARTITION pEast VALUES IN (40,50,60) , PARTITION pWest VALUES IN (70,80,100) ); -ERROR 42000: The storage engine for the table doesn't support GEOMETRY +ERROR HY000: A BLOB field is not allowed in partition function #check start transaction commit & Rollback START TRANSACTION; DELETE FROM tab3; diff --git a/mysql-test/suite/innodb_gis/t/geometry.test b/mysql-test/suite/innodb_gis/t/geometry.test index 3efc664fbd2..44cba3f4d3c 100644 --- a/mysql-test/suite/innodb_gis/t/geometry.test +++ b/mysql-test/suite/innodb_gis/t/geometry.test @@ -646,7 +646,7 @@ CREATE TABLE child (id GEOMETRY, parent_id GEOMETRY, ) ENGINE=INNODB; --echo #check partition table support ---error 1178 +--error 1502 CREATE TABLE emp2( id GEOMETRY NOT NULL, store_name VARCHAR(30), -- cgit v1.2.1