between rule - false positives in comments
Hi. Check for 'Don't use between' rule returns false positives when 'between' keyword is used in comments.
Comments can appear in functions and views definition queries:
"...You have 1 query/queries that use BETWEEN clause: - create view test as (select /* just testing between */ 1)) "
Replacing "...WHERE query ~ ' between' with "...WHERE query ~ 'between(((?!.+?*/)|(?=.+?/*))(?<!--[^\n]*?))' in between.sql should help.
Regexp explanation and simple test in attached file, although more tests may be needed.
Thanks for nice tool. regex_test.sql