← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/t/fulltext3.test

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/fulltext3.test
 
1
--source include/have_gbk.inc
 
2
#
 
3
# test of new fulltext search features
 
4
#
 
5
 
 
6
--disable_warnings
 
7
DROP TABLE IF EXISTS t1;
 
8
--enable_warnings
 
9
 
 
10
 
 
11
#
 
12
# BUG#29299 - repeatable myisam fulltext index corruption
 
13
#
 
14
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a));
 
15
SET NAMES utf8;
 
16
INSERT INTO t1 VALUES(0xF043616161),(0xBEF361616197C22061616161);
 
17
SELECT HEX(a) FROM t1 WHERE MATCH(a) AGAINST(0x97C22061616161 IN BOOLEAN MODE);
 
18
DELETE FROM t1 LIMIT 1;
 
19
CHECK TABLE t1;
 
20
SET NAMES latin1;
 
21
DROP TABLE t1;
 
22
 
 
23
# End of 5.0 tests
 
24
 
 
25
#
 
26
# BUG#29464 - load data infile into table with big5 chinese fulltext index
 
27
#             hangs 100% cpu
 
28
#
 
29
CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci,
 
30
FULLTEXT(a));
 
31
INSERT INTO t1 VALUES(0xA3C2);
 
32
DROP TABLE t1;
 
33
 
 
34
# End of 5.1 tests