case_insensitive search does not search for upper case keywords

[yajra]

Discussed in #2899

^{Originally posted by uchajk November 12, 2022}
Case insensitive will search the keyword in lower case format. SQL: LOWER(column) LIKE LOWER(keyword)
'case_insensitive' => true,

I've got an issue with this part of the documentation. Particular column in my table is in upper case and so when searching in lower case:
$keyword = 'abc'
$column = LOWER('ABC')
this works just fine

When searching upper case though:
$keyword = 'ABC'
$column = LOWER('ABC')
does not match the column. LOWER(keyword) is not applied.