| 1 |
CREATE TABLE articles ( |
| 2 |
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, |
| 3 |
title VARCHAR(200), |
| 4 |
body TEXT, |
| 5 |
FULLTEXT (title,body) |
| 6 |
) ENGINE=InnoDB; |
| 7 |
SET @saved_debug_dbug = @@SESSION.debug_dbug; |
| 8 |
SET SESSION debug_dbug="+d,ib_dict_create_index_tree_fail"; |
| 9 |
CREATE FULLTEXT INDEX idx ON articles(body); |
| 10 |
ERROR HY000: Out of memory. |
| 11 |
SET SESSION debug_dbug=@saved_debug_dbug; |
| 12 |
ALTER TABLE articles STATS_PERSISTENT=DEFAULT; |
| 13 |
DROP TABLE articles; |
| 14 |
CREATE TABLE t (a INT, b TEXT) engine=innodb; |
| 15 |
SET debug_dbug='+d,alter_table_rollback_new_index'; |
| 16 |
ALTER TABLE t ADD FULLTEXT INDEX (b(64)); |
| 17 |
ERROR HY000: Unknown error |
| 18 |
SET SESSION debug_dbug=@saved_debug_dbug; |
| 19 |
DROP TABLE t; |
| 20 |
CREATE TABLE t1 (pk INT, a VARCHAR(8), PRIMARY KEY(pk), |
| 21 |
FULLTEXT KEY(a)) ENGINE=InnoDB; |
| 22 |
CREATE TABLE t2 (b INT, FOREIGN KEY(b) REFERENCES t1(pk)) ENGINE=InnoDB; |
| 23 |
DROP TABLE/*foo*/ t1; |
| 24 |
ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails |
| 25 |
SET DEBUG_DBUG="+d,fts_instrument_sync"; |
| 26 |
INSERT INTO t1 VALUES(1, "mariadb"); |
| 27 |
ALTER TABLE t1 FORCE; |
| 28 |
DROP TABLE t2, t1; |
| 29 |
SET SESSION debug_dbug=@saved_debug_dbug; |
| 30 |
# |
| 31 |
# MDEV-25200 Index count mismatch due to aborted FULLTEXT INDEX |
| 32 |
# |
| 33 |
CREATE TABLE t1(a INT, b TEXT, c TEXT, FULLTEXT INDEX(b)) ENGINE=InnoDB; |
| 34 |
INSERT INTO t1 VALUES(1, "test", "test_1"); |
| 35 |
connect con1,localhost,root,,test; |
| 36 |
SET DEBUG_DBUG="+d,innodb_OOM_inplace_alter"; |
| 37 |
SET DEBUG_SYNC='innodb_commit_inplace_alter_table_enter SIGNAL s2 WAIT_FOR g2'; |
| 38 |
ALTER TABLE t1 ADD FULLTEXT(c); |
| 39 |
connection default; |
| 40 |
SET DEBUG_SYNC='now WAIT_FOR s2'; |
| 41 |
START TRANSACTION; |
| 42 |
SELECT * FROM t1; |
| 43 |
a b c |
| 44 |
1 test test_1 |
| 45 |
SET DEBUG_SYNC='now SIGNAL g2'; |
| 46 |
connection con1; |
| 47 |
ERROR HY000: Out of memory. |
| 48 |
disconnect con1; |
| 49 |
connection default; |
| 50 |
SET DEBUG_SYNC=RESET; |
| 51 |
ALTER TABLE t1 ADD bl INT AS (LENGTH(b)) VIRTUAL; |
| 52 |
CHECK TABLE t1; |
| 53 |
Table Op Msg_type Msg_text |
| 54 |
test.t1 check status OK |
| 55 |
DROP TABLE t1; |
| 56 |
# |
| 57 |
# MDEV-25663 Double free of transaction during TRUNCATE |
| 58 |
# |
| 59 |
call mtr.add_suppression("InnoDB: \\(Too many concurrent transactions\\)"); |
| 60 |
call mtr.add_suppression("InnoDB: Cannot save table statistics for table `test`\\.`t1`: Too many concurrent transactions"); |
| 61 |
SET @saved_debug_dbug= @@debug_dbug; |
| 62 |
CREATE TABLE t1 (b CHAR(12), FULLTEXT KEY(b)) engine=InnoDB; |
| 63 |
SET debug_dbug='+d,ib_create_table_fail_too_many_trx'; |
| 64 |
TRUNCATE t1; |
| 65 |
SET debug_dbug=@saved_debug_dbug; |
| 66 |
DROP TABLE t1; |
| 67 |
# End of 10.3 tests |
| 68 |
CREATE TABLE t1(f1 INT NOT NULL, f2 CHAR(100))ENGINE=InnoDB; |
| 69 |
SET DEBUG_DBUG="+d,stats_lock_fail"; |
| 70 |
ALTER TABLE t1 ADD FULLTEXT(f2); |
| 71 |
ERROR HY000: Lock wait timeout exceeded; try restarting transaction |
| 72 |
SET debug_dbug=@saved_debug_dbug; |
| 73 |
ALTER TABLE t1 DISCARD TABLESPACE; |
| 74 |
ALTER TABLE t1 ADD FULLTEXT(f2); |
| 75 |
ERROR HY000: Tablespace has been discarded for table `t1` |
| 76 |
DROP TABLE t1; |