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 DROP INDEX title ON articles;
8 INSERT INTO articles (title,body) VALUES
9 ('MySQL Tutorial','DBMS stands for DataBase ...') ,
10 ('How To Use MySQL Well','After you went through a ...'),
11 ('Optimizing MySQL','In this tutorial we will show ...'),
12 ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
13 ('MySQL vs. YourSQL','In the following database comparison ...'),
14 ('MySQL Security','When configured properly, MySQL ...');
15 BEGIN;
16 INSERT INTO articles (title,body) VALUES
17 ('MySQL Tutorial','DBMS stands for DataBase ...');
18 # Kill and restart
19 INSERT INTO articles VALUES
20 (8, 'MySQL Tutorial','DBMS stands for DataBase ...');
21 CREATE FULLTEXT INDEX idx ON articles (title,body);
22 SELECT * FROM articles
23 WHERE MATCH (title,body)
24 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
25 id title body
26 1 MySQL Tutorial DBMS stands for DataBase ...
27 5 MySQL vs. YourSQL In the following database comparison ...
28 8 MySQL Tutorial DBMS stands for DataBase ...
29 INSERT INTO articles (title,body) VALUES
30 ('MySQL Tutorial','DBMS stands for DataBase ...') ,
31 ('How To Use MySQL Well','After you went through a ...'),
32 ('Optimizing MySQL','In this tutorial we will show ...'),
33 ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
34 ('MySQL vs. YourSQL','In the following database comparison ...'),
35 ('MySQL Security','When configured properly, MySQL ...');
36 BEGIN;
37 INSERT INTO articles (title,body) VALUES
38 ('MySQL Tutorial','DBMS stands for DataBase ...');
39 # Kill and restart
40 INSERT INTO articles VALUES
41 (16, 'MySQL Tutorial','DBMS stands for DataBase ...');
42 SELECT * FROM articles
43 WHERE MATCH (title,body)
44 AGAINST ('Database' IN NATURAL LANGUAGE MODE);
45 id title body
46 1 MySQL Tutorial DBMS stands for DataBase ...
47 5 MySQL vs. YourSQL In the following database comparison ...
48 8 MySQL Tutorial DBMS stands for DataBase ...
49 9 MySQL Tutorial DBMS stands for DataBase ...
50 13 MySQL vs. YourSQL In the following database comparison ...
51 16 MySQL Tutorial DBMS stands for DataBase ...
52 DROP TABLE articles;
53 CREATE TABLE articles (
54 id int PRIMARY KEY,
55 FTS_DOC_ID BIGINT UNSIGNED NOT NULL,
56 title VARCHAR(200),
57 body TEXT
58 ) ENGINE=InnoDB;
59 CREATE FULLTEXT INDEX idx1 on articles (title, body);
60 INSERT INTO articles VALUES
61 (1, 10, 'MySQL Tutorial','DBMS stands for DataBase ...') ,
62 (2, 1, 'How To Use MySQL Well','After you went through a ...'),
63 (3, 2, 'Optimizing MySQL','In this tutorial we will show ...'),
64 (4, 11, '1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
65 (5, 6, 'MySQL vs. YourSQL','In the following database comparison ...'),
66 (7, 4, 'MySQL Security','When configured properly, MySQL ...');
67 BEGIN;
68 INSERT INTO articles VALUES
69 (100, 200, 'MySQL Tutorial','DBMS stands for DataBase ...');
70 # Kill and restart
71 INSERT INTO articles VALUES (8, 12, 'MySQL Tutorial','DBMS stands for DataBase ...');
72 SELECT * FROM articles WHERE MATCH (title, body)
73 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
74 id FTS_DOC_ID title body
75 3 2 Optimizing MySQL In this tutorial we will show ...
76 1 10 MySQL Tutorial DBMS stands for DataBase ...
77 8 12 MySQL Tutorial DBMS stands for DataBase ...
78 DROP TABLE articles;
79 CREATE TABLE articles (
80 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
81 title VARCHAR(200),
82 body TEXT,
83 FULLTEXT (title,body)
84 ) ENGINE=InnoDB;
85 SET SESSION debug="+d,ib_dict_create_index_tree_fail";
86 CREATE FULLTEXT INDEX idx ON articles(body);
87 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
88 SET SESSION debug="-d,ib_dict_create_index_tree_fail";
89 ALTER TABLE articles STATS_PERSISTENT=DEFAULT;
90 DROP TABLE articles;