[MDEV-28608] Subquery gives wrong results in ON DUPLICATE KEY UPDATE ... part of INSERT - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.5, 10.6, 10.11, 11.4
Component/s: Data Manipulation - Insert, Data Manipulation - Subquery, Data Manipulation - Update
Labels:
- upstream
- wrong_result

Description

In case of multi-row update like this

INSERT ... SELECT ... ON DUPLICATE KEY UPDATE b=(select ... )

all rows get last subquery result

This bug has been reported upstream, see https://bugs.mysql.com/107325

Tested mariadb versions (with issue):

10.7.3-MariaDB-1:10.7.3+maria~focal (demo: https://onecompiler.com/mariadb/3y4dh8xj2)
10.3.28-MariaDB-1:10.3.28+maria~focal

Tested mysql versions (with issue):

8.0.27 (demo: https://onecompiler.com/mysql/3y4dh73zw)
5.7.22 (demo: https://www.db-fiddle.com/f/bwXWot2AGMRypKqaguLj77/0)
5.6.40
5.5.62

Attachments

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Janez Resnik

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2022-05-18 12:48

Updated:: 2024-11-22 17:09

Git Integration

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