HUGE warning log during indexing due to unsupported "LIMIT -1" in mysql query

When I'm running the occ fulltextsearch:index on the console, my log files fill up to Gig Bytes within seconds!!! The reason being that the query uses LIMIT -1 which is not supported by MySQL:

Exception while generateDocument: An exception occurred while executing 'SELECT uid, displayname FROM oc_users u LEFT JOIN oc_preferences p ON (userid = uid) AND (appid = 'settings') AND (configkey = 'email') WHERE (uid COLLATE utf8mb4_general_ci LIKE ?) OR (displayname COLLATE utf8mb4_general_ci LIKE ?) OR (configvalue COLLATE utf8mb4_general_ci LIKE ?) ORDER BY uid_lower ASC LIMIT -1 OFFSET 0' with params ["%%", "%%", "%%"]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1 OFFSET 0' at ...

Start by reproducing occ fulltextsearch:index with MySQL and inspect the query that generates LIMIT -1 OFFSET 0. The fix is done when indexing no longer emits the unsupported MySQL query or fills the logs with repeated warnings.