Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.8, 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
GNU/Linux Centos 7.5
Description
I have detected an issue when execute a select count
of another query that internaly uses myisam with mroonga with an index.
I have attached a file that demostrates the problem.
The result of the sql script is:
SELECT COUNT(*) FROM tbl_aaa;
|
|
|
COUNT(*)
|
10
|
|
|
SELECT COUNT(*) FROM tbl_bbb;
|
|
|
COUNT(*)
|
20
|
|
|
SELECT COUNT(*)
|
FROM (
|
SELECT a.id |
FROM tbl_aaa a
|
LEFT JOIN tbl_bbb b ON b.id_aplicacion=21 AND b.id_registro=a.id |
) c;
|
|
|
COUNT(*)
|
10
|
|
|
CREATE INDEX ccc ON tbl_bbb (id_registro);
|
|
|
SELECT COUNT(*)
|
FROM (
|
SELECT a.id |
FROM tbl_aaa a
|
LEFT JOIN tbl_bbb b ON b.id_aplicacion=21 AND b.id_registro=a.id |
) c;
|
|
|
COUNT(*)
|
15
|