[MDEV-30073] Wrong result on 2nd execution of PS for query with NOT EXISTS - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.5
Component/s: Prepared Statements, Stored routines
Labels:
- wrong_result

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

MDEV-6704 Wrong result (extra rows) on 2nd execution of PS with exists_to_in, MERGE view

Stalled

MDEV-22534 Trivial correlation detection/removal for IN subqueries

In Review

MDEV-23828 Wrong result upon 2nd execution of PS/SP with EXISTS subquery converted to semijoin

Stalled

MDEV-30396 Wrong result with EXISTS subquery over view on 2nd execution of PS

Open

MDEV-31175 Server crash on 2n execution of select with view and aggregate function

Open

MDEV-31269 Various SIGSEGV crashes, UBSAN issues and memory corruption on 2nd PS execution caused by exists-to-in

Stalled

MDEV-33081 Crash on second execution of PS for query over many views

Stalled

is blocked by

MDEV-31277 Wrong result on 2-nd execution of PS to select from view using derived

Closed

MDEV-32466 Potential memory leak on execuing of create view statement

Closed

MDEV-32569 Failure when executing PS for query using IN subquery

Closed

MDEV-32754 Failure at second executon of PS for query using stored function

Closed

relates to

MDEV-31277 Wrong result on 2-nd execution of PS to select from view using derived

Closed

(2 blocks, 4 is blocked by, 1 relates to)

Activity

People

Assignee:: Igor Babaev

Reporter:: Dmitry Shulga

Votes:: 2 Vote for this issue

Watchers:: 17 Start watching this issue

Dates

Created:: 2022-11-22 16:35

Updated:: 2025-02-24 12:04

Git Integration

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