diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2010-10-14 01:48:03 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2010-10-14 01:48:03 +0400 |
| commit | 508e75c259a88638999822cccdc66c271769a167 (patch) | |
| tree | ecbbd32491a220d9c370df77141c914ff07edb7c /mysql-test/r/select_pkeycache.result | |
| parent | 49ae85afd564e34ea3fb8df308cbafe347d76303 (diff) | |
| download | mariadb-git-508e75c259a88638999822cccdc66c271769a167.tar.gz | |
Merge MariaDB 5.2 -> MariaDB 5.3
- post-merge fixes
Diffstat (limited to 'mysql-test/r/select_pkeycache.result')
| -rw-r--r-- | mysql-test/r/select_pkeycache.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/select_pkeycache.result b/mysql-test/r/select_pkeycache.result index 252006cfcf3..7722fbe5dcc 100644 --- a/mysql-test/r/select_pkeycache.result +++ b/mysql-test/r/select_pkeycache.result @@ -4396,7 +4396,7 @@ INSERT INTO t1 VALUES EXPLAIN SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 -1 SIMPLE t2 ALL a NULL NULL NULL 2 Using where +1 SIMPLE t2 ALL a NULL NULL NULL 2 Range checked for each record (index map: 0x1) SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2; 1 1 @@ -4406,7 +4406,7 @@ SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2; EXPLAIN SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2 FORCE INDEX(a); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 -1 SIMPLE t2 ALL a NULL NULL NULL 2 Using where +1 SIMPLE t2 ALL a NULL NULL NULL 2 Range checked for each record (index map: 0x1) SELECT 1 FROM t1 NATURAL LEFT JOIN t1 AS t2 FORCE INDEX(a); 1 1 |