[sqlite] maybe bug in regexp and replace with newlines?

[michael]

I tried
sqlite3 -header flexsql.db "select distinct text from v_term_item where
name='text' and lower(text) REGEXP('.*some_text.*');"
which doesn't works

sqlite3 -header flexsql.db "select distinct text from v_term_item where
name='text' and lower(text) like '%some_text%';"
works

so I tried a work-around.

sqlite3 -header flexsql.db "select distinct replace(lower(text),0x0A,'')
from v_term_item where lower(text) REGEXP('.*some_text.*') limit 1;"

also no luck

with
sqlite3 -header flexsql.db "select distinct hex(replace(text,0x0A,''))
from v_term_item where lower(text) like '%some_text%' limit 1;"
I saw the new lines (0A) still exist

I used:
sqlite 3.8.10.2 compiled on gentoo linux