mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
ca88eac835
ha_innobase::check_if_supported_inplace_alter(): Require ALGORITHM=COPY when creating a FULLTEXT INDEX on a versioned table. row_merge_buf_add(), row_merge_read_clustered_index(): Remove the parameter or local variable history_fts that had been added in the attempt to fix MDEV-25004. Reviewed by: Thirunarayanan Balathandayuthapani Tested by: Matthias Leich
57 lines
3.2 KiB
Text
57 lines
3.2 KiB
Text
--- innodb-fts-ddl.result
|
|
+++ innodb-fts-ddl.reject
|
|
@@ -11,8 +11,10 @@
|
|
('MySQL vs. YourSQL','In the following database comparison ...'),
|
|
('MySQL Security','When configured properly, MySQL ...');
|
|
ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY;
|
|
-ERROR 0A000: ALGORITHM=NOCOPY is not supported for this operation. Try ALGORITHM=INPLACE
|
|
-ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=INPLACE;
|
|
+ERROR 0A000: ALGORITHM=NOCOPY is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY
|
|
+ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body);
|
|
+affected rows: 6
|
|
+info: Records: 6 Duplicates: 0 Warnings: 0
|
|
SELECT * FROM fts_test WHERE MATCH (title, body)
|
|
AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
|
|
id title body
|
|
@@ -26,7 +28,9 @@
|
|
('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
|
|
('MySQL vs. YourSQL','In the following database comparison ...'),
|
|
('MySQL Security','When configured properly, MySQL ...');
|
|
-ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY;
|
|
+ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body);
|
|
+affected rows: 12
|
|
+info: Records: 12 Duplicates: 0 Warnings: 0
|
|
SELECT * FROM fts_test WHERE MATCH (title, body)
|
|
AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
|
|
id title body
|
|
@@ -76,8 +80,10 @@
|
|
('MySQL vs. YourSQL','In the following database comparison ...'),
|
|
('MySQL Security','When configured properly, MySQL ...');
|
|
CREATE FULLTEXT INDEX idx on fts_test (title, body) LOCK=NONE;
|
|
-ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED
|
|
-ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body), ALGORITHM=NOCOPY;
|
|
+ERROR 0A000: LOCK=NONE is not supported. Reason: Not implemented for system-versioned operations. Try LOCK=SHARED
|
|
+ALTER TABLE fts_test ADD FULLTEXT `idx` (title, body);
|
|
+affected rows: 6
|
|
+info: Records: 6 Duplicates: 0 Warnings: 0
|
|
ALTER TABLE fts_test ROW_FORMAT=REDUNDANT, LOCK=NONE;
|
|
ERROR 0A000: LOCK=NONE is not supported. Reason: Fulltext index creation requires a lock. Try LOCK=SHARED
|
|
ALTER TABLE fts_test ROW_FORMAT=REDUNDANT;
|
|
@@ -162,7 +168,7 @@
|
|
(20, 'MySQL Security','When configured properly, MySQL ...');
|
|
ALTER TABLE articles ADD FULLTEXT INDEX idx (title),
|
|
ADD FULLTEXT INDEX idx3 (title), ALGORITHM=INPLACE;
|
|
-ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try ALGORITHM=COPY
|
|
+ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY
|
|
ALTER TABLE articles ADD FULLTEXT INDEX idx (title),
|
|
ADD FULLTEXT INDEX idx3 (title);
|
|
affected rows: 6
|
|
@@ -274,7 +280,7 @@
|
|
call mtr.add_suppression("InnoDB: Failed to create");
|
|
CREATE TABLE t1(a TEXT, FTS_DOC_ID BIGINT UNSIGNED NOT NULL UNIQUE) ENGINE=InnoDB;
|
|
ALTER TABLE t1 ADD FULLTEXT(a), ALGORITHM=INPLACE;
|
|
-ERROR HY000: Got error 11 "Resource temporarily unavailable" from storage engine InnoDB
|
|
+ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Not implemented for system-versioned operations. Try ALGORITHM=COPY
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (a VARCHAR(3)) ENGINE=InnoDB;
|
|
ALTER TABLE t1 ADD FULLTEXT KEY(a), ADD COLUMN b VARCHAR(3), ADD FULLTEXT KEY(b);
|