LIKE filtering on the message field is not working

[jorgeaponte]

I have a query similar to the following but I have not been able to filter using LIKE on the message field (it works fine on the title field).

SELECT title, author_name, datetime, message FROM commits WHERE datetime > '2024-09-11 01:01:01' AND message LIKE '%alternative%' 

[AmrDeveloper]

Hello @jorgeaponte,

Thank you for reporting, the problem was that regex was not supporting multi lines strings like message because that it works fine with title, i updated it to support multi lines and unicode, your query will work fine now, also you can write query like this

select count() from commits where message like "%😎%"

Solved here: 8a4bebb

I will release it in 0.29.0

Thank you, have a nice day
Amr Hesham

[jorgeaponte]

Thanks a lot