diff options
| author | bar@mysql.com <> | 2005-06-06 21:22:23 +0500 |
|---|---|---|
| committer | bar@mysql.com <> | 2005-06-06 21:22:23 +0500 |
| commit | abb2d7aa347c0d12ad40fc04315167d3274baae0 (patch) | |
| tree | 09f463d7610585f6452120c8fe3fa5ffa9e799c0 | |
| parent | 5ec15497760ca41368e2b9bcd020b4f4b3de91a1 (diff) | |
| download | mariadb-git-abb2d7aa347c0d12ad40fc04315167d3274baae0.tar.gz | |
ctype_cp1250_ch.result, ctype_cp1250_ch.test:
Adding test.
ctype-win1250ch.c:
Bug #9759 Empty result with 'LIKE' and cp1250_czech_cs
Wrong min_sort_char fix.
| -rw-r--r-- | mysql-test/r/ctype_cp1250_ch.result | 12 | ||||
| -rw-r--r-- | mysql-test/t/ctype_cp1250_ch.test | 12 | ||||
| -rw-r--r-- | strings/ctype-win1250ch.c | 2 |
3 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/r/ctype_cp1250_ch.result b/mysql-test/r/ctype_cp1250_ch.result index 62936b84caf..7b2ca7d7e0e 100644 --- a/mysql-test/r/ctype_cp1250_ch.result +++ b/mysql-test/r/ctype_cp1250_ch.result @@ -7,3 +7,15 @@ SELECT a, length(a), a='', a=' ', a=' ' FROM t1; a length(a) a='' a=' ' a=' ' 0 1 1 1 DROP TABLE t1; +CREATE TABLE t1 ( +popisek varchar(30) collate cp1250_general_ci NOT NULL default '', +PRIMARY KEY (`popisek`) +); +INSERT INTO t1 VALUES ('2005-01-1'); +SELECT * FROM t1 WHERE popisek = '2005-01-1'; +popisek +2005-01-1 +SELECT * FROM t1 WHERE popisek LIKE '2005-01-1'; +popisek +2005-01-1 +drop table t1; diff --git a/mysql-test/t/ctype_cp1250_ch.test b/mysql-test/t/ctype_cp1250_ch.test index 06aea7b9979..814da628fb7 100644 --- a/mysql-test/t/ctype_cp1250_ch.test +++ b/mysql-test/t/ctype_cp1250_ch.test @@ -10,3 +10,15 @@ CREATE TABLE t1 (a char(16)) character set cp1250 collate cp1250_czech_cs; INSERT INTO t1 VALUES (''); SELECT a, length(a), a='', a=' ', a=' ' FROM t1; DROP TABLE t1; + +# +# Bug#9759 Empty result with 'LIKE' and cp1250_czech_cs +# +CREATE TABLE t1 ( + popisek varchar(30) collate cp1250_general_ci NOT NULL default '', + PRIMARY KEY (`popisek`) +); +INSERT INTO t1 VALUES ('2005-01-1'); +SELECT * FROM t1 WHERE popisek = '2005-01-1'; +SELECT * FROM t1 WHERE popisek LIKE '2005-01-1'; +drop table t1; diff --git a/strings/ctype-win1250ch.c b/strings/ctype-win1250ch.c index d843971b93f..2a899dfd147 100644 --- a/strings/ctype-win1250ch.c +++ b/strings/ctype-win1250ch.c @@ -550,7 +550,7 @@ static uchar NEAR like_range_prefix_max_win1250ch[] = { 240, 242, 242, 245, 245, 245, 245, 247, 248, 251, 251, 251, 251, 253, 254, 255, }; -#define min_sort_char '\x00' +#define min_sort_char '\x20' #define max_sort_char '\xff' /* |