| 1 |
--- innodb-fts-ddl.result 2023-11-23 13:40:18.932463721 +0100 |
| 2 |
+++ innodb-fts-ddl,vers.result 2024-04-09 11:34:42.968505497 +0200 |
| 3 |
@@ -11,8 +11,10 @@ |
| 4 |
('MySQL vs. YourSQL','In the following database comparison ...'), |
| 5 |
('MySQL Security','When configured properly, MySQL ...'); |
| 6 |
ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY; |
| 7 |
-ERROR 0A000: ALGORITHM=NOCOPY is not supported for this operation. Try ALGORITHM=INPLACE |
| 8 |
-ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=INPLACE; |
| 9 |
+ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY |
| 10 |
+ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body); |
| 11 |
+affected rows: 6 |
| 12 |
+info: Records: 6 Duplicates: 0 Warnings: 0 |
| 13 |
SELECT * FROM fts_test WHERE MATCH (title, body) |
| 14 |
AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); |
| 15 |
id title body |
| 16 |
@@ -26,7 +28,9 @@ |
| 17 |
('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'), |
| 18 |
('MySQL vs. YourSQL','In the following database comparison ...'), |
| 19 |
('MySQL Security','When configured properly, MySQL ...'); |
| 20 |
-ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY; |
| 21 |
+ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body); |
| 22 |
+affected rows: 12 |
| 23 |
+info: Records: 12 Duplicates: 0 Warnings: 0 |
| 24 |
SELECT * FROM fts_test WHERE MATCH (title, body) |
| 25 |
AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE); |
| 26 |
id title body |
| 27 |
@@ -76,8 +80,10 @@ |
| 28 |
('MySQL vs. YourSQL','In the following database comparison ...'), |
| 29 |
('MySQL Security','When configured properly, MySQL ...'); |
| 30 |
ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY, LOCK=NONE; |
| 31 |
-ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED |
| 32 |
-ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY; |
| 33 |
+ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY |
| 34 |
+ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body); |
| 35 |
+affected rows: 6 |
| 36 |
+info: Records: 6 Duplicates: 0 Warnings: 0 |
| 37 |
ALTER TABLE fts_test ROW_FORMAT=REDUNDANT, ALGORITHM=INPLACE, LOCK=NONE; |
| 38 |
ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED |
| 39 |
ALTER TABLE fts_test ROW_FORMAT=REDUNDANT; |
| 40 |
@@ -162,7 +168,7 @@ |
| 41 |
(20, 'MySQL Security','When configured properly, MySQL ...'); |
| 42 |
ALTER TABLE articles ADD FULLTEXT INDEX idx (title), |
| 43 |
ADD FULLTEXT INDEX idx3 (title), ALGORITHM=INPLACE; |
| 44 |
-ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try ALGORITHM=COPY |
| 45 |
+ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY |
| 46 |
ALTER TABLE articles ADD FULLTEXT INDEX idx (title), |
| 47 |
ADD FULLTEXT INDEX idx3 (title); |
| 48 |
affected rows: 6 |
| 49 |
@@ -274,7 +280,7 @@ |
| 50 |
call mtr.add_suppression("InnoDB: Failed to create"); |
| 51 |
CREATE TABLE t1(a TEXT, FTS_DOC_ID BIGINT UNSIGNED NOT NULL UNIQUE) ENGINE=InnoDB; |
| 52 |
ALTER TABLE t1 ADD FULLTEXT(a), ALGORITHM=INPLACE; |
| 53 |
-ERROR HY000: Got error 11 "Resource temporarily unavailable" from storage engine InnoDB |
| 54 |
+ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY |
| 55 |
DROP TABLE t1; |
| 56 |
CREATE TABLE t1 (a VARCHAR(3)) ENGINE=InnoDB; |
| 57 |
ALTER TABLE t1 ADD FULLTEXT KEY(a), ADD COLUMN b VARCHAR(3), ADD FULLTEXT KEY(b); |