mysql-test/suite/innodb/r/innodb-online-alter-gis.result
raw| 1 | create table t1(a int not null primary key, b geometry not null) engine=innodb; |
| 2 | ALTER ONLINE TABLE t1 ADD SPATIAL INDEX new(b), ALGORITHM=INSTANT; |
| 3 | ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Do not support online operation on table with GIS index. Try ALGORITHM=NOCOPY |
| 4 | show warnings; |
| 5 | Level Code Message |
| 6 | Error 1846 ALGORITHM=INSTANT is not supported. Reason: Do not support online operation on table with GIS index. Try ALGORITHM=NOCOPY |
| 7 | show errors; |
| 8 | Level Code Message |
| 9 | Error 1846 ALGORITHM=INSTANT is not supported. Reason: Do not support online operation on table with GIS index. Try ALGORITHM=NOCOPY |
| 10 | ALTER ONLINE TABLE t1 ADD SPATIAL INDEX new(b), LOCK=SHARED, ALGORITHM=NOCOPY; |
| 11 | show warnings; |
| 12 | Level Code Message |
| 13 | show errors; |
| 14 | Level Code Message |
| 15 | drop table t1; |
| 16 | create table t1(a int not null, b geometry not null, d int,spatial key c(b), key d(d)) engine=innodb; |
| 17 | show create table t1; |
| 18 | Table Create Table |
| 19 | t1 CREATE TABLE `t1` ( |
| 20 | `a` int(11) NOT NULL, |
| 21 | `b` geometry NOT NULL, |
| 22 | `d` int(11) DEFAULT NULL, |
| 23 | SPATIAL KEY `c` (`b`), |
| 24 | KEY `d` (`d`) |
| 25 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
| 26 | ALTER ONLINE TABLE t1 ADD PRIMARY KEY(a),DROP INDEX d, ALGORITHM=INPLACE; |
| 27 | ERROR 0A000: LOCK=NONE is not supported. Reason: Do not support online operation on table with GIS index. Try LOCK=SHARED |
| 28 | show warnings; |
| 29 | Level Code Message |
| 30 | Error 1846 LOCK=NONE is not supported. Reason: Do not support online operation on table with GIS index. Try LOCK=SHARED |
| 31 | show errors; |
| 32 | Level Code Message |
| 33 | Error 1846 LOCK=NONE is not supported. Reason: Do not support online operation on table with GIS index. Try LOCK=SHARED |
| 34 | ALTER ONLINE TABLE t1 ADD PRIMARY KEY(a),DROP INDEX d, LOCK=SHARED; |
| 35 | show warnings; |
| 36 | Level Code Message |
| 37 | show errors; |
| 38 | Level Code Message |
| 39 | drop table t1; |
| 40 | # |
| 41 | # MDEV-14038 ALTER TABLE does not exit on error with InnoDB + bad default function |
| 42 | # |
| 43 | CREATE TABLE t1 (a INT) ENGINE=InnoDB; |
| 44 | ALTER TABLE t1 ADD COLUMN b LINESTRING DEFAULT POINT(1,1); |
| 45 | ERROR 22007: Incorrect LINESTRING value: 'POINT(1 1)' for column ``.``.`b` at row 0 |
| 46 | DESCRIBE t1; |
| 47 | Field Type Null Key Default Extra |
| 48 | a int(11) YES NULL |
| 49 | DROP TABLE t1; |
| 50 | # |
| 51 | # Bug #19077964 ASSERT PAGE_SIZE.EQUALS_TO SPACE_PAGE_SIZE |
| 52 | # BTR_COPY_BLOB_PREFIX |
| 53 | # |
| 54 | CREATE TABLE t1(f1 INT PRIMARY KEY, f3 LINESTRING NOT NULL, |
| 55 | SPATIAL KEY(f3))ENGINE=InnoDB ROW_FORMAT=COMPRESSED |
| 56 | KEY_BLOCK_SIZE=1; |
| 57 | SHOW CREATE TABLE t1; |
| 58 | Table Create Table |
| 59 | t1 CREATE TABLE `t1` ( |
| 60 | `f1` int(11) NOT NULL, |
| 61 | `f3` linestring NOT NULL, |
| 62 | PRIMARY KEY (`f1`), |
| 63 | SPATIAL KEY `f3` (`f3`) |
| 64 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 |
| 65 | INSERT INTO t1 VALUES (1, ST_linefromtext(concat('linestring', '( 0 0, 1 1, 2 2, 3 3, 4 4, 5 5, 6 6, 7 7, 8 8, 9 9, 10 10, 11 11, 12 12, 13 13, 14 14, 15 15, 16 16, 17 17, 18 18, 19 19, 20 20, 21 21, 22 22, 23 23, 24 24, 25 25, 26 26, 27 27, 28 28, 29 29, 30 30, 31 31, 32 32, 33 33, 34 34, 35 35, 36 36, 37 37, 38 38, 39 39, 40 40, 41 41, 42 42, 43 43, 44 44, 45 45, 46 46, 47 47, 48 48, 49 49, 50 50, 51 51, 52 52, 53 53, 54 54, 55 55, 56 56, 57 57, 58 58, 59 59, 60 60, 61 61, 62 62, 63 63, 64 64, 65 65, 66 66, 67 67, 68 68, 69 69, 70 70, 71 71, 72 72, 73 73, 74 74, 75 75, 76 76, 77 77, 78 78, 79 79, 9999 9999)')));; |
| 66 | ALTER TABLE t1 ROW_FORMAT = DYNAMIC, KEY_BLOCK_SIZE=0, ALGORITHM=INPLACE; |
| 67 | DROP TABLE t1; |