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

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

Details

    • Q2/2025 Development

    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

          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-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-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

          Task - A task that needs to be done. MDEV-35673 Item_subselect::used_tables_cache issues with outer references and optimization.

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          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-31277 Wrong result on 2-nd execution of PS to select from view using derived

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

          Activity

            People

              Johnston Rex Johnston
              shulga Dmitry Shulga
              Votes:
              2 Vote for this issue
              Watchers:
              17 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.