LIKE Operator Doesn't Always Work

[ossie-git]

In the sample company.csv in the repository, you have a header that looks like this:

id,name,sector,public,value,description

and lines such as this:

ca2666dc-2f87-462e-ab3c-5c05aecf5b0a,"Baker, Jensen and Bradshaw",repurpose holistic markets,No,559086806.22,"Baker, Jensen and Bradshaw provides the following services:
- User-centric methodical archive
- Enterprise-wide bifurcated alliance
- Right-sized zero-defect success
- Mandatory user-facing flexibility"

However, trying a LIKE on the description column fails for some reason. For example:

:Q SELECT * FROM company WHERE description LIKE '%Baker%';

fails. I think it is because it has newlines

[shshemi]

Hi,
Thanks for bringing up the bug. I've confirmed that the issue is indeed present. It seems like the LIKE/ILIKE operators aren't working correctly with multiline strings in Polars. I've also checked the Python version and found the same problem. I've filed an issue for them here. We'll just have to wait for them to fix it.