The docblock for QueryInterface::execute() states it returns an int or array; the integer is for count queries. Except, at least on MySQL, it actually returns a string.
This isn't super important in many cases, since PHP is not out of the box type strict, and because we support PHP 7, can't (yet) enforce return or parameter types. This could be fixed on a broader scale in Drupal 10, which will require PHP 8.
This does rear its head in cases when the result is used in type-aware contexts, e.g. on json:api collection counts. If you parse the response in a type-aware language (e.g., TypeScript) this gets stickier.
Run a count query and get a string result instead of an integer.
Maybe just wait until we can type all the things in Drupal 10? Or adjust the various implementations to cast the response into an integer if it is_numeric()?
Closed: duplicate
11.0 🔥
database system
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
This was fixed in #3320240: Entity count query returns a string instead of int →
See https://git.drupalcode.org/project/drupal/-/commit/c1891492e4d31cad222ba...
https://git.drupalcode.org/project/drupal/-/blob/11.x/core/lib/Drupal/Co...
I checked all child classes of QueryInterface and they either cast result to an int, or use php's count() function which returns an int.