Actions
Bug #8201
closedSearching field groups is case sensitive
Start date:
09 October 2020
Due date:
% Done:
100%
Estimated time:
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.
Updated by krileon over 4 years ago
- 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.
Updated by krileon about 4 years ago
- 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
Actions