We have the same warning as with the Drupal9 version (see ticket https://www.drupal.org/project/drupal/issues/3352318 🐛 PHP 8.1: Deprecation warnings when executing a query within a where condition in Drupal database object Closed: works as designed )
Executing a query within a where condition in the Drupal database connection class with PHP 8.1 minimum generates deprecation warnings:
Deprecated function: stripos(): Passing null to parameter #1 ($haystack) of type string is deprecated en Drupal\Core\Database\Query\Condition->compile()
Deprecated function: strpbrk(): Passing null to parameter #1 ($string) of type string is deprecated en Drupal\Core\Database\Query\Condition->compile()
Deprecated function: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated en Drupal\Core\Database\Query\Condition->mapConditionOperator()
We have adapted the patch made in the previous ticket so that it is compatible with version 10.2 : Force data types passed to functions to be strings.
Active
10.2 ✨
Since there's been no follow up going to close out. If still an issue in D11 please re-open.