#81802SQL Exception when searching in recycler using PostgreSQL
Description
Searching for any string in the recycler causes an SQL Exception, e.g. searching for 98770 leads to
Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing
'SELECT COUNT(*) FROM "tx_extension_table" WHERE ("pid" = ?) AND (("uid" = ?) OR ("pid" = ?) OR ("uid" LIKE ?)) AND ("deleted" <> ?)'
with params [18, "98770", "98770", "'%98770%'", 0]:
SQLSTATE[42883]: Undefined function: 7
FEHLER: Operator existiert nicht: integer ~~ unknown LINE 1: ...= $1) AND (("uid" = $2) OR ("pid" = $3) OR ("uid" LIKE $4)) ... ^
HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
Doctrine\DBAL\Exception\DriverException thrown in file vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php in line 91. Requested URL: http://example.org/typo3/index.php?ajaxID=%2Fajax%2Frecycler&ajaxToken=XXX&action=getDeletedRecords&depth=999&startUid=18&table=tx_extension_table&filterTxt=98770&start=0&limit=50
I guess this happens because column uid is of type int and a LIKE search is performed on the column.