diff options
| author | unknown <ramil/ram@mysql.com/myoffice.izhnet.ru> | 2006-10-19 16:15:30 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/myoffice.izhnet.ru> | 2006-10-19 16:15:30 +0500 |
| commit | 68c2a008a1e5fc305a735cf90bd994230729a68d (patch) | |
| tree | 86c6c0aa08ccf4c172196dfc0d398e73fd46bd93 /mysql-test/r | |
| parent | 48dfeb4de0e3444fe5ddf9aba1040707d11cfa85 (diff) | |
| parent | da7af481cda9d0fb836f010d421ce00830b69f56 (diff) | |
| download | mariadb-git-68c2a008a1e5fc305a735cf90bd994230729a68d.tar.gz | |
Merge mysql.com:/usr/home/ram/work/bug20732/my41-bug20732
into mysql.com:/usr/home/ram/work/bug20732/my50-bug20732
sql/opt_range.cc:
Auto merged
sql/opt_range.h:
Auto merged
sql/sql_select.cc:
Auto merged
sql/table.cc:
Auto merged
mysql-test/r/range.result:
SCCS merged
mysql-test/t/range.test:
SCCS merged
Diffstat (limited to 'mysql-test/r')
| -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 add95613d62..c96173e74cc 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), |