REPORT request with <oc:filter-files> cannot be limited after deleting and recreating user

[individual-it]

Steps to reproduce

1. create user
2. login
3. mark files as fav.
4. request limited REPORT curl -u user1:user1 -X REPORT http://localhost/owncloud-core/remote.php/dav/files/user1/ -d '<?xml version="1.0" encoding="utf-8" ?><oc:filter-files xmlns:a="DAV:" xmlns:oc="http://owncloud.org/ns" ><a:prop><oc:favorite/></a:prop><oc:filter-rules><oc:favorite>1</oc:favorite></oc:filter-rules><oc:search><oc:limit>2</oc:limit></oc:search></oc:filter-files>' | xmllint --format -
   All works well
5. delete user
6. create same user
7. request limited REPORT curl -u user1:user1 -X REPORT http://localhost/owncloud-core/remote.php/dav/files/user1/ -d '<?xml version="1.0" encoding="utf-8" ?><oc:filter-files xmlns:a="DAV:" xmlns:oc="http://owncloud.org/ns" ><a:prop><oc:favorite/></a:prop><oc:filter-rules><oc:favorite>1</oc:favorite></oc:filter-rules><oc:search><oc:limit>2</oc:limit></oc:search></oc:filter-files>' | xmllint --format -
   empty result

Expected behaviour

limited search reported

Actual behaviour

empty report

Server configuration

Operating system:
Ubuntu 18.04
Web server:
Apache2
Database:
MySQL
PHP version:
7.1
ownCloud version: (see ownCloud admin page)
11.0
Updated from an older ownCloud or fresh install:
fresh
Where did you install ownCloud from:
git

[individual-it]

reason seems to be that tables oc_vcategory_to_object and oc_vcategory are not cleaned on user deletion

[ownclouders]

GitMate.io thinks possibly related issues are #1841 (Files deleted after recreating user), #33835 (REPORT request with oc:filter-files cannot be limited in subfolder), #27274 (delete), #28084 (Feature Request: Warning before deleting user), and #10453 (Can't delete user.).