Debian Codegraph @

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

raw
1 #
2 # Test for bug by [email protected]
3 #
4 --source include/have_innodb.inc
5 --source include/maybe_versioning.inc
6
7 --disable_warnings
8 drop table if exists test;
9 --enable_warnings
10
11 let $default_engine = `select @@SESSION.default_storage_engine`;
12 # --replace_result $default_engine <default_engine>
13 CREATE TABLE test (
14 gnr INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
15 url VARCHAR(80) DEFAULT '' NOT NULL,
16 shortdesc VARCHAR(200) DEFAULT '' NOT NULL,
17 longdesc text DEFAULT '' NOT NULL,
18 description VARCHAR(80) DEFAULT '' NOT NULL,
19 name VARCHAR(80) DEFAULT '' NOT NULL,
20 FULLTEXT(url,description,shortdesc,longdesc),
21 PRIMARY KEY(gnr)
22 ) ENGINE = InnoDB;
23
24 insert into test (url,shortdesc,longdesc,description,name) VALUES
25 ("http:/test.at", "kurz", "lang","desc", "name");
26 insert into test (url,shortdesc,longdesc,description,name) VALUES
27 ("http:/test.at", "kurz", "","desc", "name");
28 update test set url='test', description='ddd', name='nam' where gnr=2;
29 update test set url='test', shortdesc='ggg', longdesc='mmm',
30 description='ddd', name='nam' where gnr=2;
31
32 check table test;
33 drop table test;
34
35 # End of 4.1 tests