Subquery gives wrong results in ON DUPLICATE KEY UPDATE ... part of INSERT

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