Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-627

LP:837496 - Empty resultset when joining OQGRAPH tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.2.14, 5.3.12, 5.5.36
    • Fix Version/s: 5.5
    • Component/s: None
    • Labels:

      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

            Activity

              People

              Assignee:
              andymc73 Andrew McDonnell
              Reporter:
              stephanevaroqui Stephane VAROQUI (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration