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

LP:1010116 - Incorrect query results in subqueries

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5.25, 5.3.7
    • Fix Version/s: 5.5.27, 5.3.9
    • Component/s: None
    • Labels:

      Description

      https://bugs.launchpad.net/maria/+bug/1010116

      Test case 1 (with default optimizer_switch):

      SELECT
      `Derived1`.`id`,
      `Derived2`.`Val1`
      FROM (select 30631 as `id`) AS `Derived1` LEFT OUTER JOIN (SELECT
      2 as `id`,
      1 AS `Val1`
      FROM (select 30631 as `id`) AS `Derived3`) AS `Derived2` ON `Derived1`.`id` = `Derived2`.`id`;

      Expected result:

      id	Val1
      30631	NULL

      Actual result:

      id	Val1
      30631	1

      Reproducible on maria/5.3 revno 3562, maria/5.5 revno 3508
      Not reproducible on mysql/5.1 revno 3770, mysql/5.5 revno 3900, mysql/5.6 revno 3917, maria/5.2 revno 3168

      Test case 2

      create table t1 ( id int );
      insert into t1 values (30631);
      create table t2 ( id int );
      insert into t2 values (30631);
      create algorithm=MERGE view v2 as select 2 as id, 1 as val1 from t2;
      select t1.*, v2.* from t1 left join v2 on t1.id = v2.id;

      Expected result:

      id	id	val1
      30631	NULL	NULL

      Actual result:

      id	id	val1
      30631	2	1

      Reproducible on maria/5.2, maria/5.3, maria/5.5, mysql/5.1, mysql/5.5, mysql/5.6

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: