TYPO3 Core

Can reproduce on v11.5.28, v12.4.2, and main.

Steps to reproduce:

1. Insert a large amount of rows (one that exceeds the prepared statement placeholder limit) into a table that has a select TCA field,
with that field set to an ID that does not exist on the foreign_table. Provided is an example SQL script that inserts 65535 records
into the pages table (adjust the 65535 value according to your database engine):

DROP PROCEDURE IF EXISTS insertdata;
DELIMITER //
CREATE PROCEDURE insertdata()
BEGIN
    DECLARE i INT DEFAULT 0;
    WHILE i <= 65535 DO
        INSERT INTO pages (l10n_parent) VALUES (i + 10000);
        SET i = i + 1;
    END WHILE;
END;
//

CALL insertdata();

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/79440

Applied in changeset 91fa2902509a2293136c032c22d4c531ae29c98e.