summaryrefslogtreecommitdiff
path: root/mysql-test/r/fulltext3.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/fulltext3.result')
-rw-r--r--mysql-test/r/fulltext3.result29
1 files changed, 0 insertions, 29 deletions
diff --git a/mysql-test/r/fulltext3.result b/mysql-test/r/fulltext3.result
deleted file mode 100644
index c0b871cd5a7..00000000000
--- a/mysql-test/r/fulltext3.result
+++ /dev/null
@@ -1,29 +0,0 @@
-DROP TABLE IF EXISTS t1;
-CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a));
-SET NAMES utf8;
-INSERT INTO t1 VALUES(0xF043616161),(0xBEF361616197C22061616161);
-SELECT HEX(a) FROM t1 WHERE MATCH(a) AGAINST(0x97C22061616161 IN BOOLEAN MODE);
-HEX(a)
-BEF361616197C22061616161
-DELETE FROM t1 LIMIT 1;
-CHECK TABLE t1;
-Table Op Msg_type Msg_text
-test.t1 check status OK
-SET NAMES latin1;
-DROP TABLE t1;
-CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci,
-FULLTEXT(a));
-INSERT INTO t1 VALUES(0xA3C2);
-DROP TABLE t1;
-create table t1 (
-id varchar(255),
-business_name text null collate utf8mb4_unicode_ci,
-street_address text,
-fulltext index ft (business_name),
-fulltext index ft2 (street_address)
-);
-select * from t1 where match (business_name, street_address) against ('some business name and address here');
-ERROR HY000: Can't find FULLTEXT index matching the column list
-select * from t1 where match (business_name, street_address) against ('some business name and address here' in boolean mode);
-id business_name street_address
-drop table t1;