malformed SQL for specific filter char

(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)
e126b5ce-b8d0-4ecc-b174-f08bdee4bd1e.png
c900b1f7-40e4-4cc5-9a80-4f4c098fe2f7.png
0 0 57
0 REPLIES 0
Top Labels in this Space
Top Solution Authors