diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-03-11 14:29:59 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-03-11 14:29:59 +0200 |
| commit | ba1b5eb4b5149293df466f8713c02f2614dd22f4 (patch) | |
| tree | 1833fea621f6e100c4be1abf244ade1bf17c8f5a /mysql-test/r/explain.result | |
| parent | 16d7c26b7139fd6ae0ef05b0b2cbf3286de06582 (diff) | |
| parent | d3d6f4fdad8176abe0d8981d79a925731df9a5d0 (diff) | |
| download | mariadb-git-ba1b5eb4b5149293df466f8713c02f2614dd22f4.tar.gz | |
merged bug 43354 to 5.1-bugteam
Diffstat (limited to 'mysql-test/r/explain.result')
| -rw-r--r-- | mysql-test/r/explain.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index 3de741b5efb..a81ff554ca2 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -155,6 +155,10 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select 1 AS `1` from (select count(distinct `test`.`t1`.`a`) AS `COUNT(DISTINCT t1.a)` from `test`.`t1` join `test`.`t2` group by `test`.`t1`.`a`) `s1` DROP TABLE t1,t2; +CREATE TABLE t1 (a INT PRIMARY KEY); +EXPLAIN EXTENDED SELECT COUNT(a) FROM t1 USE KEY(a); +ERROR 42000: Key 'a' doesn't exist in table 't1' +DROP TABLE t1; # # Bug#37870: Usage of uninitialized value caused failed assertion. # @@ -182,3 +186,4 @@ dt 2001-01-01 01:01:01 2001-01-01 01:01:01 drop tables t1, t2; +End of 5.1 tests. |