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

Wrong result on 2nd execution of PS for query with NOT EXISTS

    XMLWordPrintable

Details

    • Q1/2026 Server Maintenance

    Description

      To reproduce the bug report, unpack the .7z archive file attached to the linked bug report, start MariaDB server and run the following statements to prepare environment:

      $ mysql -e 'CREATE DATABASE local_portal' -u root
      		 
       
      		 
      $ mysql -u root local_portal < /path/to/dir/where/archive/was/extracted/tableSchemaAndData-mariaDbTest
      		 
      $ mysql -u root local_portal < /path/to/dir/where/archive/was/extracted/item_creation_retailer_group_retailers_mariadbtest.sql
      		 
      $ mysql -u root local_portal < /path/to/dir/where/archive/was/extracted/qry_exporterImages-mariaDb_storedProcIssue.sql
      		 
      $ mysql -u root local_portal < /path/to/dir/where/archive/was/extracted/vu_productimages_retailergroup-mariaDb-storedProcIssue.sql
      		 
       
      		 
      $ mysql -u root local_portal
      		 
      MariaDB [local_portal]> CALL qry_exporterImages_mariaDbTest(3569,4,628);
      		 
      MariaDB [local_portal]> CALL qry_exporterImages_mariaDbTest(3569,4,628);

      Result sets returned on the first and the second invocation of the stored routine qry_exporterImages_mariaDbTest are different (at least, number of rows returned by two invocations are different)

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6704 Wrong result (extra rows) on 2nd execution of PS with exists_to_in, MERGE view

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14557 Assertion `m_sp == __null' failed in Item_func_sp::init_result_field upon 2nd execution of SP

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19178 Server crash in create_view_field or Assertion `m_sp == __null' failed in Item_func_sp::fix_fields after invalidating view by dropping function

          • Major - Major loss of function.
          • Confirmed

          Task - A task that needs to be done. MDEV-22534 Trivial correlation detection/removal for IN subqueries

          • Major - Major loss of function.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23828 Wrong result upon 2nd execution of PS/SP with EXISTS subquery converted to semijoin

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26944 Server crash on selecting some data from information_schema

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30396 Wrong result with EXISTS subquery over view on 2nd execution of PS

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31175 Server crash on 2n execution of select with view and aggregate function

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31178 Server crash on second execution of prepare statement with in_predicate_conversion_threshold=1 (or =2)

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32038 "Invalid use of group function" on 2nd execution of PS for SELECT from view created with aggregate functions

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33081 Crash on second execution of PS for query over many views

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34184 SIGSEGV in st_select_lex::update_used_tables | JOIN::optimize_inner

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35673 Correlated subquery problems causing wrong results and server crash

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31277 Wrong result on 2-nd execution of PS to select from view using derived

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32466 Potential memory leak on execuing of create view statement

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32569 Failure when executing PS for query using IN subquery

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32754 Failure at second executon of PS for query using stored function

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36607 find_order_in_list mismatch when order item needs fixing()

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31269 Various SIGSEGV crashes, UBSAN issues and memory corruption on 2nd PS execution caused by exists-to-in

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23828 Wrong result upon 2nd execution of PS/SP with EXISTS subquery converted to semijoin

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30396 Wrong result with EXISTS subquery over view on 2nd execution of PS

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31277 Wrong result on 2-nd execution of PS to select from view using derived

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36877 SIGABRT due to dereferencing a null Item pointer occurs in Item::val_native()

          • Major - Major loss of function.
          • Closed

          Activity

            People

              psergei Sergei Petrunia
              shulga Dmitry Shulga
              Votes:
              2 Vote for this issue
              Watchers:
              18 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.