diff options
Diffstat (limited to 'mysql-test/suite/innodb_gis/t/alter_spatial_index.test')
-rw-r--r-- | mysql-test/suite/innodb_gis/t/alter_spatial_index.test | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/suite/innodb_gis/t/alter_spatial_index.test b/mysql-test/suite/innodb_gis/t/alter_spatial_index.test index 653e250017a..b7eac432fcc 100644 --- a/mysql-test/suite/innodb_gis/t/alter_spatial_index.test +++ b/mysql-test/suite/innodb_gis/t/alter_spatial_index.test @@ -476,6 +476,7 @@ ALTER TABLE tab ADD INDEX idx6(c4(10)) USING BTREE; ALTER TABLE tab MODIFY COLUMN c2 GEOMETRY NOT NULL; +--error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD ALTER TABLE tab MODIFY COLUMN c3 POLYGON NOT NULL; ALTER TABLE tab add COLUMN c7 POINT NOT NULL; @@ -491,9 +492,8 @@ FROM tab LIMIT 1; SELECT HEX(c8) FROM tab; ROLLBACK; -# not instant, not supported ---error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON ALTER TABLE tab add COLUMN c9 POINT NOT NULL AFTER c5, ALGORITHM = INPLACE, LOCK=NONE; +ALTER TABLE tab DROP COLUMN c9, ALGORITHM=INSTANT; SHOW CREATE TABLE tab; @@ -553,8 +553,6 @@ SET @g2 = ST_GeomFromText('LINESTRING(1 1,2 2,3 3)'); --enable_info ALTER TABLE tab MODIFY COLUMN c2 POINT NOT NULL; -ALTER TABLE tab MODIFY COLUMN c3 LINESTRING NOT NULL; - ALTER TABLE tab MODIFY COLUMN c4 POLYGON NOT NULL; --disable_info |