1--source include/have_innodb.inc 2--source include/have_geometry.inc 3 4--echo # 5--echo # Start of 10.1 tests 6--echo # 7 8--echo # 9--echo # MDEV-8948 ALTER ... INPLACE does work for BINARY, BLOB 10--echo # 11 12# 13# Blob variants to GEOMETRY 14# 15CREATE TABLE t1 (a TINYBLOB); 16--error ER_ALTER_OPERATION_NOT_SUPPORTED 17ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 18DROP TABLE t1; 19 20CREATE TABLE t1 (a MEDIUMBLOB); 21--error ER_ALTER_OPERATION_NOT_SUPPORTED 22ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 23DROP TABLE t1; 24 25CREATE TABLE t1 (a BLOB); 26--error ER_ALTER_OPERATION_NOT_SUPPORTED 27ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 28DROP TABLE t1; 29 30CREATE TABLE t1 (a LONGBLOB); 31--error ER_ALTER_OPERATION_NOT_SUPPORTED 32ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 33DROP TABLE t1; 34 35# 36# GEOMETRY to BLOB variants 37# 38 39CREATE TABLE t1 (a GEOMETRY); 40--error ER_ALTER_OPERATION_NOT_SUPPORTED 41ALTER TABLE t1 MODIFY a TINYBLOB, ALGORITHM=INPLACE; 42DROP TABLE t1; 43 44CREATE TABLE t1 (a GEOMETRY); 45--error ER_ALTER_OPERATION_NOT_SUPPORTED 46ALTER TABLE t1 MODIFY a MEDIUMBLOB, ALGORITHM=INPLACE; 47DROP TABLE t1; 48 49CREATE TABLE t1 (a GEOMETRY); 50--error ER_ALTER_OPERATION_NOT_SUPPORTED 51ALTER TABLE t1 MODIFY a BLOB, ALGORITHM=INPLACE; 52DROP TABLE t1; 53 54CREATE TABLE t1 (a GEOMETRY); 55--error ER_ALTER_OPERATION_NOT_SUPPORTED 56ALTER TABLE t1 MODIFY a LONGBLOB, ALGORITHM=INPLACE; 57DROP TABLE t1; 58 59# 60# Different GEOMETRY types 61# 62 63# Can't do INPLACE from a supertype to a subtype 64CREATE TABLE t1 (a GEOMETRY); 65--error ER_ALTER_OPERATION_NOT_SUPPORTED 66ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 67DROP TABLE t1; 68 69# Ok to do INPLACE from a subtype to a supertype 70CREATE TABLE t1 (a POLYGON); 71ALTER TABLE t1 MODIFY a GEOMETRY, ALGORITHM=INPLACE; 72DROP TABLE t1; 73 74# Ok to do INPLACE for two equal geometry subtypes 75CREATE TABLE t1 (a POLYGON); 76ALTER TABLE t1 MODIFY a POLYGON, ALGORITHM=INPLACE; 77DROP TABLE t1; 78 79 80--echo # 81--echo # End of 10.1 tests 82--echo # 83