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/r/range.result | |
| 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/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index cfdee6e630e..04923c9e24c 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -665,6 +665,16 @@ OR ((pk4 =1) AND (((pk1 IN ( 7, 2, 1 ))) OR (pk1 =522)) AND ((pk2 IN ( 0, 2635)) pk1 pk2 pk3 pk4 filler 2621 2635 1000015 0 filler drop table t1, t2; +create table t1(a char(2), key(a(1))); +insert into t1 values ('x'), ('xx'); +explain select a from t1 where a > 'x'; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range a a 2 NULL 2 Using where +select a from t1 where a > 'x'; +a +xx +drop table t1; +End of 4.1 tests CREATE TABLE t1 ( id int(11) NOT NULL auto_increment, status varchar(20), |