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

Wrong result (missing rows) on query from a view with WHERE .. ANY, condition_pushdown_for_derived=on

    XMLWordPrintable

Details

    • 10.2.4-3

    Description

      CREATE TABLE t1 (i INT);
      CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1;
      INSERT INTO t1 VALUES (1),(2);
      SELECT * FROM v1 WHERE i <= ANY ( SELECT 3 );
      

      Actual result, 10.2 82b974a1b6

      MariaDB [test]> SELECT * FROM v1 WHERE i <= ANY ( SELECT 3 );
      Empty set (0.00 sec)
      

      Expected result

      MariaDB [test]> SELECT * FROM v1 WHERE i <= ANY ( SELECT 3 );
      +------+
      | i    |
      +------+
      |    1 |
      |    2 |
      +------+
      2 rows in set (0.00 sec)
      

      Attachments

        Activity

          People

            igor Igor Babaev
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.