diff options
| author | ramil/ram@myoffice.izhnet.ru <> | 2006-10-23 10:32:39 +0500 |
|---|---|---|
| committer | ramil/ram@myoffice.izhnet.ru <> | 2006-10-23 10:32:39 +0500 |
| commit | 800d80542f9b0f778f4ccfcbd7def2ee5eb979cc (patch) | |
| tree | ada943515dde566ac1e6dd09b5972639f87a622e /mysql-test/t/range.test | |
| parent | 0fdfb362636c5efc52ee3ca104bf15a443a3af9e (diff) | |
| parent | f6ea36c3a5e38654b7e7c69ff6ff04cdfe298397 (diff) | |
| download | mariadb-git-800d80542f9b0f778f4ccfcbd7def2ee5eb979cc.tar.gz | |
Merge mysql.com:/usr/home/ram/work/bug20732/my50-bug20732
into mysql.com:/usr/home/ram/work/bug20732/my51-bug20732
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index 1a80234e485..400e28c3e28 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -515,7 +515,17 @@ OR ((pk4 =1) AND (((pk1 IN ( 7, 2, 1 ))) OR (pk1 =522)) AND ((pk2 IN ( 0, 2635)) ) AND (pk3 >=1000000); drop table t1, t2; -# End of 4.1 tests +# +# Bug #20732: Partial index and long sjis search with '>' fails sometimes +# + +create table t1(a char(2), key(a(1))); +insert into t1 values ('x'), ('xx'); +explain select a from t1 where a > 'x'; +select a from t1 where a > 'x'; +drop table t1; + +--echo End of 4.1 tests # # Test for optimization request #10561: to use keys for |