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

LP:784281 - Wrong result from view containing outer reference in simijoin subquery

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      A wrong result is returned by the query below for the test case of bug #33389 from mysql-test/t/view.test.

      To reproduce the problem first execute the following statements:

      create table t1 (a int, key(a));
      create table t2 (c int);

      create view v1 as select a b from t1;
      create view v2 as select 1 a from t2, v1 where c in
      (select 1 from t1 where b = a);

      insert into t1 values (1), (1);
      insert into t2 values (1), (1);

      Then run the query
      select * from v2.

      You'll get:

      MariaDB [test]> select * from v2;
      Empty set (0.00 sec)

      The expected result is:
      MariaDB [test]> select * from v2;
      ---

      a

      ---

      1
      1
      1
      1

      ---
      4 rows in set (0.00 sec)

      Attachments

        Activity

          People

            igor Igor Babaev
            igor Igor Babaev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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