| 1 |
|
| 2 |
# |
| 3 |
# test of new fulltext search features |
| 4 |
# |
| 5 |
|
| 6 |
--disable_warnings |
| 7 |
DROP TABLE IF EXISTS t1; |
| 8 |
--enable_warnings |
| 9 |
|
| 10 |
let $default_engine = `select @@SESSION.default_storage_engine`; |
| 11 |
# |
| 12 |
# BUG#29299 - repeatable myisam fulltext index corruption |
| 13 |
# |
| 14 |
# INNODB_FTS: Not yet support gbk charset |
| 15 |
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a)) ENGINE = InnoDB; |
| 16 |
SET NAMES utf8mb4; |
| 17 |
# INSERT INTO t1 VALUES(0xF043616161),(0xBEF361616197C22061616161); |
| 18 |
# SELECT HEX(a) FROM t1 WHERE MATCH(a) AGAINST(0x97C22061616161 IN BOOLEAN MODE); |
| 19 |
DELETE FROM t1 LIMIT 1; |
| 20 |
#CHECK TABLE t1; |
| 21 |
SET NAMES latin1; |
| 22 |
DROP TABLE t1; |
| 23 |
|
| 24 |
# End of 5.0 tests |
| 25 |
|
| 26 |
# |
| 27 |
# BUG#29464 - load data infile into table with big5 chinese fulltext index |
| 28 |
# hangs 100% cpu |
| 29 |
# |
| 30 |
--replace_result $default_engine <default_engine> |
| 31 |
EVAL CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci, |
| 32 |
FULLTEXT(a)) ENGINE=$default_engine; |
| 33 |
# INSERT INTO t1 VALUES(0xA3C2); |
| 34 |
DROP TABLE t1; |
| 35 |
|
| 36 |
# End of 5.1 tests |
| 37 |
|
| 38 |
# End of 5.6 tests |
| 39 |
SET NAMES utf8mb4; |
| 40 |
|
| 41 |
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gb18030, FULLTEXT(a)) ENGINE = InnoDB; |
| 42 |
|
| 43 |
INSERT INTO t1 VALUES(0xF043616161),(0xBEF361616197C22061616161); |
| 44 |
SELECT CONVERT(a USING utf8) FROM t1; |
| 45 |
SELECT CONVERT(_gb18030 0x97C22061616161 USING utf8); |
| 46 |
SELECT HEX(a), CONVERT(a USING utf8) FROM t1 WHERE MATCH(a) AGAINST(0x97C220616161 IN BOOLEAN MODE); |
| 47 |
SELECT HEX(a), CONVERT(a USING utf8) FROM t1 WHERE MATCH(a) AGAINST(0x97C22061616161 IN BOOLEAN MODE); |
| 48 |
SELECT HEX(a), CONVERT(a USING utf8) FROM t1 WHERE MATCH(a) AGAINST(0x97C2206161616161 IN BOOLEAN MODE); |
| 49 |
|
| 50 |
SET NAMES latin1; |
| 51 |
DROP TABLE t1; |
| 52 |
|
| 53 |
# |
| 54 |
# BUG 18700668 - GB18030 + FTS: ASSERTION FAILED: ((UCHAR) (*SRC) <= 0X7F) |
| 55 |
# |
| 56 |
CREATE TABLE t1 (a TEXT, FULLTEXT(a)) ENGINE=InnoDB DEFAULT CHARSET=gb18030 COLLATE=gb18030_bin; |
| 57 |
CREATE TABLE t2 (a TEXT, FULLTEXT(a)) ENGINE=InnoDB DEFAULT CHARSET=gb18030 COLLATE=gb18030_chinese_ci; |
| 58 |
CREATE TABLE t3 (a TEXT, FULLTEXT(a)) ENGINE=InnoDB DEFAULT CHARSET=gb18030 COLLATE=gb18030_unicode_520_ci; |
| 59 |
|
| 60 |
SELECT * FROM t1 WHERE MATCH(a) AGAINST(0xff00ff); |
| 61 |
SELECT * FROM t1 WHERE MATCH(a) AGAINST(0xfe00feff8320218400010203); |
| 62 |
SELECT * FROM t2 WHERE MATCH(a) AGAINST(0xff00ff); |
| 63 |
SELECT * FROM t2 WHERE MATCH(a) AGAINST(0xfe00feff8320218400010203); |
| 64 |
SELECT * FROM t3 WHERE MATCH(a) AGAINST(0xff00ff); |
| 65 |
SELECT * FROM t3 WHERE MATCH(a) AGAINST(0xfe00feff8320218400010203); |
| 66 |
|
| 67 |
DROP TABLE t1, t2, t3; |
| 68 |
|
| 69 |
SET NAMES utf8mb4 COLLATE utf8mb4_0900_ai_ci; |
| 70 |
|
| 71 |
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET utf8mb4, FULLTEXT(a)) ENGINE = InnoDB; |
| 72 |
|
| 73 |
INSERT INTO t1 VALUES(0xC4B4616161),(0xE1B48C616161E292A92061616161); |
| 74 |
SELECT HEX(a), a FROM t1; |
| 75 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST(0xE292A920616161 IN BOOLEAN MODE); |
| 76 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST(0xE292A92061616161 IN BOOLEAN MODE); |
| 77 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST(0xE292A9206161616161 IN BOOLEAN MODE); |
| 78 |
TRUNCATE TABLE t1; |
| 79 |
INSERT INTO t1 VALUES("abcd"); |
| 80 |
INSERT INTO t1 VALUES("áƀcd"); |
| 81 |
INSERT INTO t1 VALUES("áƀde"); |
| 82 |
INSERT INTO t1 VALUES("áƀテストde"); |
| 83 |
SELECT HEX(a), a FROM t1; |
| 84 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST("ab" IN BOOLEAN MODE); |
| 85 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST("abcd" IN BOOLEAN MODE); |
| 86 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST("áƀ*" IN BOOLEAN MODE); |
| 87 |
|
| 88 |
SET NAMES latin1; |
| 89 |
DROP TABLE t1; |