Debian Codegraph @

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

raw
1 CREATE TABLE opening_lines (
2 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 opening_line TEXT(500),
4 author VARCHAR(200),
5 title VARCHAR(200)
6 ) ENGINE=InnoDB;
7 CREATE FULLTEXT INDEX idx ON opening_lines(opening_line);
8 CREATE FULLTEXT INDEX ft_idx1 ON opening_lines(title);
9 INSERT INTO opening_lines(opening_line,author,title) VALUES
10 ('Call me Ishmael.','Herman Melville','Moby Dick'),
11 ('A screaming comes across the sky.','Thomas Pynchon','Gravity\'s Rainbow'),
12 ('I am an invisible man.','Ralph Ellison','Invisible Man'),
13 ('Where now? Who now? When now?','Samuel Beckett','The Unnamable'),
14 ('It was love at first sight.','Joseph Heller','Catch-22'),
15 ('All this happened, more or less.','Kurt Vonnegut','Slaughterhouse-Five'),
16 ('Mrs. Dalloway said she would buy the flowers herself.','Virginia Woolf','Mrs. Dalloway'),
17 ('It was a pleasure to burn.','Ray Bradbury','Fahrenheit 451');
18 SET GLOBAL innodb_ft_aux_table='test/opening_lines';
19 SELECT * FROM information_schema.innodb_ft_config;
20 KEY VALUE
21 optimize_checkpoint_limit 180
22 synced_doc_id 0
23 stopword_table_name
24 use_stopword 1
25 SELECT * FROM opening_lines WHERE MATCH(opening_line) AGAINST('Ishmael');
26 id opening_line author title
27 1 Call me Ishmael. Herman Melville Moby Dick
28 SELECT * FROM opening_lines WHERE MATCH(opening_line) AGAINST('invisible');
29 id opening_line author title
30 3 I am an invisible man. Ralph Ellison Invisible Man
31 SELECT * FROM opening_lines;
32 id opening_line author title
33 1 Call me Ishmael. Herman Melville Moby Dick
34 2 A screaming comes across the sky. Thomas Pynchon Gravity's Rainbow
35 3 I am an invisible man. Ralph Ellison Invisible Man
36 4 Where now? Who now? When now? Samuel Beckett The Unnamable
37 5 It was love at first sight. Joseph Heller Catch-22
38 6 All this happened, more or less. Kurt Vonnegut Slaughterhouse-Five
39 7 Mrs. Dalloway said she would buy the flowers herself. Virginia Woolf Mrs. Dalloway
40 8 It was a pleasure to burn. Ray Bradbury Fahrenheit 451
41 SET GLOBAL innodb_optimize_fulltext_only=ON;
42 SET DEBUG_SYNC='fts_crash_before_commit_sync SIGNAL hung WAIT_FOR ever';
43 OPTIMIZE TABLE opening_lines;
44 connect con1,localhost,root,,;
45 SET DEBUG_SYNC='now WAIT_FOR hung';
46 # restart
47 SELECT * FROM opening_lines WHERE MATCH(opening_line) AGAINST('Ishmael');
48 id opening_line author title
49 1 Call me Ishmael. Herman Melville Moby Dick
50 SELECT * FROM opening_lines WHERE MATCH(opening_line) AGAINST('invisible');
51 id opening_line author title
52 3 I am an invisible man. Ralph Ellison Invisible Man
53 SELECT * FROM opening_lines;
54 id opening_line author title
55 1 Call me Ishmael. Herman Melville Moby Dick
56 2 A screaming comes across the sky. Thomas Pynchon Gravity's Rainbow
57 3 I am an invisible man. Ralph Ellison Invisible Man
58 4 Where now? Who now? When now? Samuel Beckett The Unnamable
59 5 It was love at first sight. Joseph Heller Catch-22
60 6 All this happened, more or less. Kurt Vonnegut Slaughterhouse-Five
61 7 Mrs. Dalloway said she would buy the flowers herself. Virginia Woolf Mrs. Dalloway
62 8 It was a pleasure to burn. Ray Bradbury Fahrenheit 451
63 DROP TABLE opening_lines;