Mongo NoSQL FIND ignores Query.setMaxResults() / setFirstResult() because skip/limit are applied after iterator() #2814

import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.Id;
import org.bson.types.ObjectId;
import org.eclipse.persistence.nosql.annotations.DataFormatType;
import org.eclipse.persistence.nosql.annotations.Field;
import org.eclipse.persistence.nosql.annotations.NoSql;

@Entity
@NoSql(dataType = "Item", dataFormat = DataFormatType.MAPPED)
public class Item {

    @Id
    @GeneratedValue
    @Field(name = "_id")
    private ObjectId id;

    private String name;

    public Item() {
    }

    public Item(String name) {
        this.name = name;
    }

    public ObjectId getId() {
        return id;
    }

    public String getName() {
        return name;
    }
}

EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("test-mongo-pu");
EntityManager em = entityManagerFactory.createEntityManager();

em.getTransaction().begin();
for (int i = 0; i < 25; i++) {
    em.persist(new Item("item-" + i));
}
em.getTransaction().commit();

List<Item> page = em.createQuery("SELECT i FROM Item i", Item.class)
        .setFirstResult(0)
        .setMaxResults(10)
        .getResultList();

// page.size() is 25 (all documents), not 10
System.out.println(page.size());

em.close();
entityManagerFactory.close();

if (readQuery.getFirstResult() > 0) {
    interaction.setProperty(SKIP, readQuery.getFirstResult());
}
if (readQuery.getMaxRows() > 0) {
    interaction.setProperty(LIMIT, readQuery.getMaxRows());
}

FindIterable<Document> iterable = collection.find(object);
if (sort != null) {
    iterable.sort(sort);
}
MongoCursor<Document> cursor = iterable.iterator(); // find already sent with limit=0
try {
    if (mongoSpec.getSkip() > 0) {
        iterable.skip(mongoSpec.getSkip());          // too late
    }
    if (mongoSpec.getLimit() != 0) {
        iterable.limit(mongoSpec.getLimit());        // too late
    }
    if (mongoSpec.getBatchSize() != 0) {
        iterable.batchSize(mongoSpec.getBatchSize());
    }

FindIterable<Document> iterable = collection.find(object);
if (sort != null) {
    iterable.sort(sort);
}
if (mongoSpec.getSkip() > 0) {
    iterable.skip(mongoSpec.getSkip());
}
if (mongoSpec.getLimit() != 0) {
    iterable.limit(mongoSpec.getLimit());
}
if (mongoSpec.getBatchSize() != 0) {
    iterable.batchSize(mongoSpec.getBatchSize());
}
try (MongoCursor<Document> cursor = iterable.iterator()) {
    // materialize results
}