Bug #8201
closed
Searching field groups is case sensitive
Added by krileon over 3 years ago.
Updated about 3 years ago.
Start date:
09 October 2020
Description
This is due to the JSON functions being case sensitive for their searching behavior. Probably need to cast to LOWER both sides of the query to remove the case sensitivity.
- Priority changed from Normal to Low
This shouldn't be the case since we're not using JSON functions to search the JSON string. We're using JSON_EXTRACT to extract a value then normal operators are being applied. Needs further testing for confirmation.
- Status changed from Assigned to Rejected
- Target version deleted (
2.0.0)
- % Done changed from 0 to 100
Issue in CB itself. During query construction the JSON_EXTRACT needs to be cast to lowercase in addition to the value being compared against otherwise it will be a strict string to string comparison resulting in case sensitivity. See #8437
Also available in: Atom
PDF
Updated by