← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/fulltext3.result

  • 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/r/fulltext3.result
 
1
DROP TABLE IF EXISTS t1;
 
2
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a));
 
3
SET NAMES utf8;
 
4
INSERT INTO t1 VALUES(0xF043616161),(0xBEF361616197C22061616161);
 
5
SELECT HEX(a) FROM t1 WHERE MATCH(a) AGAINST(0x97C22061616161 IN BOOLEAN MODE);
 
6
HEX(a)
 
7
BEF361616197C22061616161
 
8
DELETE FROM t1 LIMIT 1;
 
9
CHECK TABLE t1;
 
10
Table   Op      Msg_type        Msg_text
 
11
test.t1 check   status  OK
 
12
SET NAMES latin1;
 
13
DROP TABLE t1;
 
14
CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci,
 
15
FULLTEXT(a));
 
16
INSERT INTO t1 VALUES(0xA3C2);
 
17
DROP TABLE t1;