/richest does not work with SQLite

[Nerahikada]

In the SQLite database, the metrics displayed in the rankings are not updated after the first account update.
(If recompute-frequency is set to 0, the metrics will be updated.)

[SOF3]

Is this issue specific to SQLite? Can you provide full steps to reproduce the issue?

[Nerahikada]

This issue could not be reproduced in MySQL.

To reproduce this issue:

1. Put the plugins into the clean server.
2. Configure the command

  top-player-commands:
    richest:
      command:
        description: Displays the richest player
        requires-op: false
      selector: []
      ordering: desc
      metric: balance-sum
      refresh:
        batch-size: 200
        batch-frequency: 1
        recompute-frequency: 1
      pagination:
        per-page: 5
        limit: 5
      messages:
        header: Showing page {page} of {totalPages}
        entry: '#{rank} {name}: ${value}'
        footer: ""

3. Join a player to the server.
4. Execute the following commands (and get outputs)

addmoney Nerahikada 1
[00:43:14.733] [Server thread/INFO]: Nerahikada has received $1. They now have $101 left.

richest
[00:43:36.612] [Server thread/INFO]: Showing page 1 of 1
[00:43:36.613] [Server thread/INFO]: #1 nerahikada: $101
[00:43:36.613] [Server thread/INFO]:

addmoney Nerahikada 1
[00:43:52.532] [Server thread/INFO]: Nerahikada has received $1. They now have $102 left.

richest
[00:44:45.678] [Server thread/INFO]: Showing page 1 of 1
[00:44:45.679] [Server thread/INFO]: #1 nerahikada: $101
[00:44:45.679] [Server thread/INFO]: