addBatch doesn't cleanup subquery parameters

    private static final String INSERT_COSMETICS = """

            INSERT IGNORE INTO cosmetic(name, category)

            VALUES(?, (SELECT id FROM cosmetic_category WHERE name = ?))

            """;

    public boolean insertCosmetics() throws SQLException {

        try (Connection connection = dataSource.getConnection();

             PreparedStatement statement = connection.prepareStatement(INSERT_COSMETICS)) {

            for (CosmeticCategory category : CosmeticCategory.CATEGORIES) {

                for (Cosmetic<?> cosmetic : cosmetics.getRegistrar().getCosmetics(category)) {

                    statement.setString(1, cosmetic.getName());

                    statement.setString(2, category.getName());

                    statement.addBatch();

                }

            }

            statement.executeBatch();

            return true;

        } catch (SQLException e) {

            throw e;

        }

    }