In 10.5.8, do this:
The last statement returns "SQL Error (1406): Data too long for column 'TABLE_SCHEMA' at row 1".
It did work fine in 10.4.8.
On 10.4.17, the same sequence returns either the same error or "ERROR 1242 (21000): Subquery returns more than 1 row" (which is wrong, the subquery on its own returns exactly one row). Which of these error messages i get seems to depend on the user.
I got the error message about "more than 1 row" on 10.5.8 when trying
Other similar queries also fail:
It seems like this occurs with any non-empty table from information_schema, both Memory and Aria. I never saw that from any other database.