Skip to content

Issue with null check in query #869

@jdshah98

Description

@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)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions