Debian Codegraph @

mysql-test/suite/innodb_fts/r/innodb-fts-ddl,vers.rdiff

raw
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);