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

LP:837496 - Empty resultset when joining OQGRAPH tables

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.2.14, 5.3.12, 5.5.36
    • 5.5(EOL)
    • 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

        1. LPexportBug837496.xml
          6 kB
          Rasmus Johansson
        2. LPexportBug837496_leaf-explain.txt
          5 kB
          Rasmus Johansson

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.