nalgeon / sqlean

The ultimate set of SQLite extensions
MIT License
3.67k stars 117 forks source link

`regexp_replace` strips all substrings identical to the one matched by an expression with `$`, even if they aren't at EOL #23

Closed Hurricos closed 2 years ago

Hurricos commented 2 years ago
SELECT regexp_replace('2020-04-17 08:15:00-04', '-[0-9][0-9]$', '');

yields:

2020-17 08:15:00

.... whereas

SELECT regexp_replace('2020-05-17 08:15:00-04', '-[0-9][0-9]$', '');

yields

2020-05-17 08:15:00
nalgeon commented 2 years ago

Fixed in 0.8.4