diff options
| author | unknown <igor@rurik.mysql.com> | 2006-06-09 12:27:28 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-06-09 12:27:28 -0700 |
| commit | 2fedfd942ea78823c878af64cd2aa536b5e6895f (patch) | |
| tree | a70158e62fab674e0c9b6174716d5b136c8be18d /mysql-test/r/select.result | |
| parent | 1ac44af4c85d576e1b4462d2fd3c15dab8cc313b (diff) | |
| download | mariadb-git-2fedfd942ea78823c878af64cd2aa536b5e6895f.tar.gz | |
Post-merge fixes
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 8b187efff6f..d47d49b5298 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -144,9 +144,9 @@ explain select fld3 from t2 use index (fld1,fld3) where fld3 = 'honeysuckle'; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref fld3 fld3 30 const 1 Using where; Using index explain select fld3 from t2 ignore index (fld3,not_used); -ERROR HY000: Key 'not_used' doesn't exist in table 't2' +ERROR 42000: Key 'not_used' doesn't exist in table 't2' explain select fld3 from t2 use index (not_used); -ERROR HY000: Key 'not_used' doesn't exist in table 't2' +ERROR 42000: Key 'not_used' doesn't exist in table 't2' select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3; fld3 honeysuckle @@ -2722,9 +2722,9 @@ EXPLAIN SELECT * FROM t1 IGNORE INDEX (idx); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 EXPLAIN SELECT * FROM t1 IGNORE INDEX (a); -ERROR HY000: Key 'a' doesn't exist in table 't1' +ERROR 42000: Key 'a' doesn't exist in table 't1' EXPLAIN SELECT * FROM t1 FORCE INDEX (a); -ERROR HY000: Key 'a' doesn't exist in table 't1' +ERROR 42000: Key 'a' doesn't exist in table 't1' DROP TABLE t1; CREATE TABLE t1 ( city char(30) ); INSERT INTO t1 VALUES ('London'); |