diff options
Diffstat (limited to 'mysql-test/r/fulltext3.result')
-rw-r--r-- | mysql-test/r/fulltext3.result | 29 |
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; |