Formatting of regexps with $ characters changes code

dataform-co / dataform

Dataform is a framework for managing SQL based data operations in BigQuery

https://cloud.google.com/dataform/docs

Apache License 2.0

856 stars 166 forks source link

Closed lewish closed 4 years ago

lewish commented 4 years ago

For example, formatting the following file:

select when regexp_contains(value, r'ABCDEF$') then 'ABCDEF'

Results in:

select
  when regexp_contains(value, r'ABCDEF) then 'ABCDEF') then 3512592308a6428d

The issue appears to be the $ in the regexp, as it works if you remove this.

BenBirt commented 4 years ago