Fields with value starting with a single quote cannot be searched
Create a product with Name: 'Test
this is, starting with a single quote
Try to search that product by name
it doesn't find the record.
The same issues is affecting when importing a CSV in Update mode, if the key starts or ends with a quote the record to update is not found.
Attaching a patch that solves partially the issue - with the patch you can search records starting XOR ending with a single quote.
But I think we still have problems with records starting and ending with a single quote on an import CSV key.