diff options
| author | unknown <evgen@moonbone.local> | 2006-06-17 02:52:14 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-06-17 02:52:14 +0400 |
| commit | 60d55cc5500ad12738ae85e5d302327cda8d89ec (patch) | |
| tree | a6d811d1c7ce1b7a9168dd7f3c0a630a16832e33 /mysql-test/r/select.result | |
| parent | 707de39a53c3a9d40cabc968475e83f45a754e2e (diff) | |
| download | mariadb-git-60d55cc5500ad12738ae85e5d302327cda8d89ec.tar.gz | |
select.result:
After merge fix
mysql-test/r/select.result:
After merge fix
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index dceb0efe199..b385c576f2e 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2720,6 +2720,16 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t3 index PRIMARY,a,b PRIMARY 8 NULL 2 Using index 1 SIMPLE t2 ALL PRIMARY NULL NULL NULL 2 Range checked for each record (index map: 0x1) DROP TABLE t1,t2,t3; +CREATE TABLE t1 (a int, INDEX idx(a)); +INSERT INTO t1 VALUES (2), (3), (1); +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' +EXPLAIN SELECT * FROM t1 FORCE INDEX (a); +ERROR HY000: Key 'a' doesn't exist in table 't1' +DROP TABLE t1; CREATE TABLE t1 ( K2C4 varchar(4) character set latin1 collate latin1_bin NOT NULL default '', K4N4 varchar(4) character set latin1 collate latin1_bin NOT NULL default '0000', |