malformed SQL for specific filter char

Looker Q&A Looker
,
1

(i use snowflake)
seq

  • user sets filter as “contains” and puts ‘test$%^23’ (without quotes) then sql contains a string
    … LIKE ‘%test$%^23%' ESCAPE '’
    (which is fine and expected)

  • but when filter is set to “is equal to” and the same string then sql contains
    … = ‘test$%23’
    (which is wrong as ^ sign is lost)