Issue with null check in query

[jdshah98]

While executing query with r2dbcEntityTemplate and with binding null query takes a lot of time and it fails

Anyone can help in this scenario?

SELECT A.NAME, A.BRANCH, A.CITY, A.MECHANISM, B.DESCRIPTION FROM MainBank A LEFT JOIN Payscale B ON A.PAYMECH = B.REDDIVCODE LEFT JOIN CUSTOMER C ON A.ID = C.ID WHERE (:mobile IS NULL OR C.MOBILE = :mobile) AND (:city IS NULL OR A.CITY = :city)