Steps to reproduce:

1. Use MySQL 8 as a database (tests were run on 8.0.27).
2. Install Ibexa Experience v4.2.0.
3. Follow the steps to upgrade to v4.2.3 -> https://doc.ibexa.co/en/4.3/update_and_migration/from_4.2/update_from_4.2/#update-from-v42x-to-v42latest.

Result:
Running:

mysql -u <username> -p <password> <database_name> < vendor/ibexa/installer/upgrade/db/mysql/ibexa-4.2.2-to-4.2.3.sql

results in an SQL error:

Error Code: 1093. You can't specify target table 'ipsp1' for update in FROM clause

Expected result:
Queries should be run without any problems.