- The automatic optimistic update relies on ID matching. It only works for queries that select the ID field(s).
- Non-entity-fetching queries like
count,aggregate, andgroupByare not affected. - Infinite queries are not affected.
- It doesn't respect filter conditions or access policies that potentially affect the queries under update. For example, for query
client.post.useFindMany({ where: { published: true }}), when a non-publishedPostis created, it'll still be inserted into the query result.