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

    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

          Activity

            People

              igor Igor Babaev
              shulga Dmitry Shulga
              Votes:
              2 Vote for this issue
              Watchers:
              14 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.