diff options
Diffstat (limited to 'mysql-test/r/select_pkeycache.result')
| -rw-r--r-- | mysql-test/r/select_pkeycache.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/select_pkeycache.result b/mysql-test/r/select_pkeycache.result index 56d383a57b7..f9d6c80018b 100644 --- a/mysql-test/r/select_pkeycache.result +++ b/mysql-test/r/select_pkeycache.result @@ -5018,3 +5018,16 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; |