diff options
| author | unknown <serg@sergbook.mysql.com> | 2002-08-05 00:14:21 +0200 |
|---|---|---|
| committer | unknown <serg@sergbook.mysql.com> | 2002-08-05 00:14:21 +0200 |
| commit | 80e088b427bea538eca3684771ee78ce05f3a523 (patch) | |
| tree | 350f7b14fa9950fc38956a356e2f68b9690434e0 /mysql-test/r/ctype_latin1_de.result | |
| parent | b6fcfd5c994c124aece081833e4bb4b662959e2d (diff) | |
| download | mariadb-git-80e088b427bea538eca3684771ee78ce05f3a523.tar.gz | |
make SEARCH_PREFIX to work with complex (use_coll) charsets, namely latin1_de
Diffstat (limited to 'mysql-test/r/ctype_latin1_de.result')
| -rw-r--r-- | mysql-test/r/ctype_latin1_de.result | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/r/ctype_latin1_de.result b/mysql-test/r/ctype_latin1_de.result index 58ed0dfdbf3..e5ae6f249ee 100644 --- a/mysql-test/r/ctype_latin1_de.result +++ b/mysql-test/r/ctype_latin1_de.result @@ -192,7 +192,7 @@ strcmp('ßa','ss') strcmp('ssa','ß') strcmp('sssb','sßa') strcmp('ß','s') select strcmp('u','öa'),strcmp('u','ö'); strcmp('u','öa') strcmp('u','ö') 1 1 -create table t1 (a varchar(10), key(a)); +create table t1 (a varchar(10), key(a), fulltext (a)); insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test"); select * from t1 where a like "abc%"; a @@ -204,4 +204,7 @@ test select * from t1 where a like "te_t"; a test +select * from t1 where match a against ("te*" in boolean mode)+0; +a +test drop table t1; |