diff options
| author | unknown <ramil/ram@myoffice.izhnet.ru> | 2006-10-23 10:32:39 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@myoffice.izhnet.ru> | 2006-10-23 10:32:39 +0500 |
| commit | e1a142961e0ae2adcea2cfb4d399b93581a8a6eb (patch) | |
| tree | ada943515dde566ac1e6dd09b5972639f87a622e /mysql-test/t/range.test | |
| parent | c055efba90fc5a9e0bf15d559f0fd7679dd9be36 (diff) | |
| parent | 68c2a008a1e5fc305a735cf90bd994230729a68d (diff) | |
| download | mariadb-git-e1a142961e0ae2adcea2cfb4d399b93581a8a6eb.tar.gz | |
Merge mysql.com:/usr/home/ram/work/bug20732/my50-bug20732
into mysql.com:/usr/home/ram/work/bug20732/my51-bug20732
mysql-test/r/range.result:
Auto merged
mysql-test/t/range.test:
Auto merged
sql/opt_range.cc:
Auto merged
sql/opt_range.h:
Auto merged
sql/sql_select.cc:
Auto merged
sql/table.cc:
manual merging.
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 |