Search strings matching _ and % in LIKE conditions

Description

A customer found that we didn't escape _. It is causing issues with their property matching.

When using "~":

  • % should be a wildcard,

  • _ should not be a wildcard.

When using ==:

  • Neither % or _ should be wildcard, both should be escaped in our LIKE condition.

Environment

None

Observations

None
Resolved

Assignee

Unassigned

Reporter

Adrien Ragot (Play SQL / Requirement Yogi)

Labels

None

Participants

None

Components

Fix versions

Priority

Matter of days