silkroad-laravel whereNotIn use to filter deleted chars will cause SQL binding params ERR if the list was big.

whereNotIn use to filter deleted chars will cause SQL binding params ERR if the list was big.

Open quocnguyen opened this issue 3 years ago • 0 comments

Describe the bug whereNotIn use to filter deleted charactors will cause SQL binding params ERR if the list was big.

To Reproduce Steps to reproduce the behavior: Server has more than 2100 deleted charactors.

Additional context Should use Join instead of whereNotIn as we do not know how big the list can go on.

Jan 02 '22 14:01 quocnguyen