Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a)) ENGINE = InnoDB;
3 SET NAMES utf8;
4 DELETE FROM t1 LIMIT 1;
5 SET NAMES latin1;
6 DROP TABLE t1;
7 CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci,
8 FULLTEXT(a)) ENGINE=<default_engine>;
9 DROP TABLE t1;
10 CREATE TABLE t1 (a SERIAL, t TEXT, FULLTEXT f1(t), FULLTEXT f2(t)) ENGINE=InnoDB;
11 Warnings:
12 Note 1831 Duplicate index `f2`. This is deprecated and will be disallowed in a future release
13 INSERT INTO t1 (a,t) VALUES (1,'1'),(2,'1');
14 ALTER TABLE t1 ADD COLUMN g TEXT GENERATED ALWAYS AS (t) VIRTUAL;
15 DELETE FROM t1 WHERE a = 1;
16 ALTER TABLE t1 DROP INDEX f1;
17 INSERT INTO t1 (a,t) VALUES (1,'1');
18 DROP TABLE t1;