"Too many SQL variables" while using In

[jonasfranz]

If you try to run a query with more than 999 SQL variables inside an In statement on a sqlite database it will return a too many SQL variables error. This is caused by limitations of sqlite documented here: https://www.sqlite.org/limits.html

The expected behaviour should be to split the query into sub-queries or something equivalent if the limit is exceeded.

Blocks go-gitea/gitea#4018

[lunny]

I think xorm could do nothing for that. Maybe gitea should use another way to do that.