diff options
| author | ingo@mysql.com <> | 2005-02-11 11:59:35 +0100 |
|---|---|---|
| committer | ingo@mysql.com <> | 2005-02-11 11:59:35 +0100 |
| commit | 601a4fdfa2d5a8616ba4eb4d9bebdbb336fa92f3 (patch) | |
| tree | d73fcf1368fb2dea3f7313a842fda03a076166ab /mysql-test/r/select.result | |
| parent | 6611d3d2f8ea02886c4b507b7d15f5c3773431cc (diff) | |
| parent | 987731d8b7dd395bec2b3d0589a40efef10176e7 (diff) | |
| download | mariadb-git-601a4fdfa2d5a8616ba4eb4d9bebdbb336fa92f3.tar.gz | |
Merge
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index b72754d3374..06b72b993ff 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2388,3 +2388,16 @@ WART 0100 1 WART 0200 1 WART 0300 3 DROP TABLE t1; +CREATE TABLE t1 ( a BLOB, INDEX (a(20)) ); +CREATE TABLE t2 ( a BLOB, INDEX (a(20)) ); +INSERT INTO t1 VALUES ('one'),('two'),('three'),('four'),('five'); +INSERT INTO t2 VALUES ('one'),('two'),('three'),('four'),('five'); +EXPLAIN SELECT * FROM t1 LEFT JOIN t2 USE INDEX (a) ON t1.a=t2.a; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 5 +1 SIMPLE t2 ref a a 23 test.t1.a 2 +EXPLAIN SELECT * FROM t1 LEFT JOIN t2 FORCE INDEX (a) ON t1.a=t2.a; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 5 +1 SIMPLE t2 ref a a 23 test.t1.a 2 +DROP TABLE t1, t2; |