diff options
| author | ramil/ram@mysql.com/myoffice.izhnet.ru <> | 2006-10-19 16:15:30 +0500 |
|---|---|---|
| committer | ramil/ram@mysql.com/myoffice.izhnet.ru <> | 2006-10-19 16:15:30 +0500 |
| commit | f6ea36c3a5e38654b7e7c69ff6ff04cdfe298397 (patch) | |
| tree | 86c6c0aa08ccf4c172196dfc0d398e73fd46bd93 /mysql-test/t/range.test | |
| parent | 3a709f50b27acf9bce0fd6e5ddcd45ae2f277bee (diff) | |
| parent | 0027b6e4b772a6b90ed67048451f3455aacfbf5d (diff) | |
| download | mariadb-git-f6ea36c3a5e38654b7e7c69ff6ff04cdfe298397.tar.gz | |
Merge mysql.com:/usr/home/ram/work/bug20732/my41-bug20732
into mysql.com:/usr/home/ram/work/bug20732/my50-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 240851e6ac4..5a146bbcf86 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 |