diff options
| author | unknown <serg@serg.mysql.com> | 2002-11-09 19:57:13 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-11-09 19:57:13 +0100 |
| commit | bb2ceda1b2b8bba35bcabcc63dba3d95c67fa85a (patch) | |
| tree | 3dd322e6544b1be34652a39b4f63dbb0ea5d1872 /mysql-test/r/select.result | |
| parent | 773fd5f2a1b1373ecd3efdba9521149ca43a365f (diff) | |
| download | mariadb-git-bb2ceda1b2b8bba35bcabcc63dba3d95c67fa85a.tar.gz | |
results fixed
mysql-test/r/isam.result:
fixed result for new errmsg
mysql-test/r/select.result:
fixed result for IGNORE/USE INDEX
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 1a40c5b11c3..fdcc7f9cdea 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -1331,10 +1331,10 @@ table type possible_keys key key_len ref rows Extra t2 ref fld3 fld3 30 const 1 Using where; Using index explain select fld3 from t2 ignore index (fld3) where fld3 = 'honeysuckle'; table type possible_keys key key_len ref rows Extra -t2 index NULL fld3 30 NULL 1199 Using where; Using index +t2 ALL NULL NULL NULL NULL 1199 Using where explain select fld3 from t2 use index (fld1) where fld3 = 'honeysuckle'; table type possible_keys key key_len ref rows Extra -t2 index NULL fld3 30 NULL 1199 Using where; Using index +t2 ALL NULL NULL NULL NULL 1199 Using where explain select fld3 from t2 use index (fld3) where fld3 = 'honeysuckle'; table type possible_keys key key_len ref rows Extra t2 ref fld3 fld3 30 const 1 Using where; Using index |