search

nalgeon / sqlean

The ultimate set of SQLite extensions
MIT License
3.76k stars 120 forks source link

Regexp lookbehind assertions fail with seemingly incorrect error #104

Closed hacatu closed 9 months ago

hacatu commented 11 months ago

Any call to regexp_substr with a lookbehind assertion, even a simple SELECT regexp_substr('abc5xyz', '(?<=\D*)\d') fails with Runtime error: out of memory (7). I assume this is simply because lookbehind isn't supported or I used the wrong syntax, but the error is not clear

nalgeon commented 9 months ago

Thanks for reporting! Only fixed-length lookbehinds are supported. Error messaging fixed in 0.21.10.