Project

General

Profile

Actions
Copy link

Bug #8201

closed

Searching field groups is case sensitive

Added by krileon over 3 years ago. Updated about 3 years ago.

Status:
Rejected
Priority:
Low
Assignee:
krileon
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.

Actions
Copy link
 #1

Updated by krileon over 3 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.

Actions
Copy link
 #2

Updated by krileon about 3 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
Copy link

Also available in: Atom PDF