search

bricolages / bricolage

AWS-oriented Data Warehouse Framework
114 stars 20 forks source link

[fix] Unload fails when a query has backslash #112

Closed shimpeko closed 4 years ago

shimpeko commented 5 years ago

Unload fails with syntax error when a query has backslash in it.

Example query with backslash

select
    replace(column, '\\','\\\\')
from
    table
;

Generated unload query

unload ('select replace(column, \'\\\',\'\\\\\') from table;')

Error message

ERROR:  syntax error at or near "\"
LINE 1: unload ('select replace(column, \'\\\',\'\\\\\') from table...

replace(column, \'\\\',\'\\\\\') should be replace(column,\'\\\\\',\'\\\\\\\\\').