Debian Codegraph @

mysql-test/suite/innodb_fts/r/misc_debug.result

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