diff options
| author | Paweł Chmielowski <pchmielowski@process-one.net> | 2020-03-18 14:36:17 +0100 |
|---|---|---|
| committer | Paweł Chmielowski <pchmielowski@process-one.net> | 2020-03-18 14:36:17 +0100 |
| commit | 92a09fdb713cb33f0409378161ed41dc85a11eb5 (patch) | |
| tree | da108bdf600b7ab15525e590668abef1ae9ded39 | |
| parent | Add escape '\' to like expression in pgsql to fix problem cockroachdb (diff) | |
Also add "escape '\'" to prepared statements in pgsqllike_escape
| -rw-r--r-- | src/ejabberd_sql.erl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/ejabberd_sql.erl b/src/ejabberd_sql.erl index 87679f60b..ddcca0459 100644 --- a/src/ejabberd_sql.erl +++ b/src/ejabberd_sql.erl @@ -779,7 +779,7 @@ pgsql_prepare(SQLQuery, State) -> fun(arg, {Acc, I}) -> {[<<$$, (integer_to_binary(I))/binary>> | Acc], I + 1}; (escape, {Acc, I}) -> - {[<<"">> | Acc], I}; + {[<<"ESCAPE E'\\\\'">> | Acc], I}; (List, {Acc, I}) when is_list(List) -> {[<<$$, (integer_to_binary(I))/binary>> | Acc], I + 1} end, {[], 1}, (SQLQuery#sql_query.args)(Escape)), |