The error is not being cleared properly when a collection returns an empty list

[utopyin]

• I've validated the bug against the latest version of DB packages

Describe the bug
The error states of a query collection (collection.utils.errorCount, collection.utils.isError) are not being cleared when a collection returns an empty list.

To Reproduce

1. Have a query collection throw an error
2. Call collection.utils.clearError() to clear the error and trigger queryFn again
   -> when queryFn returns an empty list, the error states are not updated at all
   -> when queryFn returns a list with at least one item, then the collection error states are cleared properly

Expected behavior
When the queryFn returns an empty list, it should clear the error and show the data being empty.

• OS: macOS
• Browser: Helium (chromium)
• Version: 0.7.9.1 (Official Build, Chromium 143.0.7499.169) (arm64)

Minimal repro
https://github.com/utopyin/db-error-not-clearing-when-empty

[utopyin]

I believe the error states are updated (actually).
But because collection.utils.errorCount is not a reactive value, when data returned by useLiveQuery hasn't change after the queryFn has returned, React won't trigger any re-render.

So the issue does not come from DB.

But I'm still wondering: how should we subscribe to updates to the collection's error states? In my case, data does not change but I still want to re-render my component after I called collection.utils.clearError() and the error has been cleared.

Edit: I think the issue could be closed. I’m keeping it open for now, as the question of how to reliably subscribe to the collection’s error states is still unresolved.

[utopyin]

closing in favor of #672