fulltext_update.test

来自「这是linux下运行的mysql软件包,可用于linux 下安装 php + m」· TEST 代码 · 共 30 行

#
# Test for bug by [e-mail]
#

--disable_warnings
drop table if exists test;
--enable_warnings
CREATE TABLE test (
  gnr INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  url VARCHAR(80) DEFAULT '' NOT NULL,
  shortdesc VARCHAR(200) DEFAULT '' NOT NULL,
  longdesc text DEFAULT '' NOT NULL,
  description VARCHAR(80) DEFAULT '' NOT NULL,
  name VARCHAR(80) DEFAULT '' NOT NULL,
  FULLTEXT(url,description,shortdesc,longdesc),
  PRIMARY KEY(gnr)
);

insert into test (url,shortdesc,longdesc,description,name) VALUES 
("http:/test.at", "kurz", "lang","desc", "name");
insert into test (url,shortdesc,longdesc,description,name) VALUES 
("http:/test.at", "kurz", "","desc", "name");
update test set url='test', description='ddd', name='nam' where gnr=2;
update test set url='test', shortdesc='ggg', longdesc='mmm', 
description='ddd', name='nam' where gnr=2;
check table test;
drop table test;

# End of 4.1 tests