Debian Codegraph @

mysql-test/suite/innodb_fts/t/basic.test

raw
1 # This is the basic function tests for innodb FTS
2
3 -- source include/have_innodb.inc
4 --let $modify_create_table= 1
5 -- source include/maybe_versioning.inc
6
7 let $basic_stage= create_table;
8 --source basic.inc
9
10 let $basic_stage= insert_1;
11 --source basic.inc
12
13 -- disable_result_log
14 ANALYZE TABLE articles;
15 -- enable_result_log
16
17 let $basic_stage= select_1;
18 --source basic.inc
19
20 let $basic_stage= insert_2;
21 --source basic.inc
22
23 let $basic_stage= select_2;
24 --source basic.inc
25
26 let $basic_stage= insert_3;
27 --source basic.inc
28
29 let $basic_stage= select_3;
30 --source basic.inc
31
32 drop table articles;
33
34 --echo #
35 --echo # Bug #22679185 INVALID INNODB FTS DOC ID DURING INSERT
36 --echo #
37
38 create table t1 (f1 int not null primary key, f2 varchar(100),
39 FTS_DOC_ID bigint(20) unsigned not null,
40 unique key `FTS_DOC_ID_INDEX` (`FTS_DOC_ID`),
41 fulltext key (f2))engine=innodb;
42
43 insert into t1 values(1, "This is the first record", 20000);
44 insert into t1 values(2, "This is the second record", 40000);
45 select FTS_DOC_ID from t1;
46 drop table t1;
47
48
49 create table t1 (f1 int not null primary key, f2 varchar(100),
50 FTS_DOC_ID bigint(20) unsigned not null auto_increment,
51 unique key `FTS_DOC_ID_INDEX` (`FTS_DOC_ID`),
52 fulltext key (f2))engine=innodb;
53
54 set auto_increment_increment = 65535;
55 insert into t1(f1, f2) values(1, "This is the first record");
56 insert into t1(f1, f2) values(2, "This is the second record");
57 insert into t1(f1, f2) values(3, "This is the third record");
58 select FTS_DOC_ID from t1;
59 drop table t1;
60
61 CREATE TABLE t1 (FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
62 title VARCHAR(200), FULLTEXT(title)) ENGINE=InnoDB;
63 INSERT INTO t1 VALUES (NULL, NULL), (20030101000000, 20030102000000);
64 DROP TABLE t1;