Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
-
None
Description
It fails like this
[psergey@pylon-fedora15 mysql-test]$ diff -urp r/join_outer_innodb.re{sult,ject}
|
--- r/join_outer_innodb.result 2012-06-28 18:31:05.561398000 +0400
|
+++ r/join_outer_innodb.reject 2013-07-03 06:48:45.835839473 +0400
|
@@ -14,7 +14,7 @@ EXPLAIN
|
SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id
|
WHERE t1.name LIKE 'A%' OR FALSE;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t2 index NULL fkey 5 NULL 5 Using index
|
+1 SIMPLE t2 index NULL fkey 5 NULL 6 Using index
|
1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t2.fkey 1 Using where
|
DROP TABLE t1,t2;
|
Attachments
Issue Links
- is part of
-
MDEV-3932 5.6 merge
- Closed
- relates to
-
MDEV-26516 WSREP: Record locking is disabled in this thread, but the table being modified is not `mysql/wsrep_streaming_log`: `mysql/innodb_table_stats`
- Stalled
-
MDEV-10003 main.range_innodb retuns a wrong number of rows in EXPLAIN
- Closed