Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.2.14, 5.3.12, 5.5.36
-
None
Description
tested on mariadb 5.2.8
Issue SELECT with JOIN OR SUBQUERIES
SELECT * FROM t_oqg WHERE t_oqg.origid IN (1,2,3) AND latch =1; |
works fine
SELECT * FROM t_oqg INNER JON t1 ON t1.id = t_oqg.origid WHERE t1.id IN (1,2,3) AND t_oqg.latch =1; |
empty result
SELECT * FROM t_oqg WHERE t_oqg.origid IN (SELECT t1.id FROM t1 WHERE t1.id IN (1,2,3)) AND t_oqg.latch =1; |
empty result
Attachments
Issue Links
- relates to
-
MDEV-12517 oqgraph returns empty resultset if used within a subquery
- Confirmed