[asterisk-bugs] [JIRA] (ASTERISK-15858) [patch] Fix query with double backslash in string literals and stop log warnings

[Friendly Automation (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-15858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=235329#comment-235329 ] 

Friendly Automation commented on ASTERISK-15858:
------------------------------------------------

Change 4980 merged by zuul:
realtime: Fix LIKE escaping in SQL backends

[https://gerrit.asterisk.org/4980|https://gerrit.asterisk.org/4980]

> [patch] Fix query with double backslash in string literals and stop log warnings
> --------------------------------------------------------------------------------
>
>                 Key: ASTERISK-15858
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-15858
>             Project: Asterisk
>          Issue Type: Bug
>          Components: Resources/res_config_pgsql
>            Reporter: Humberto Figuera
>            Severity: Trivial
>         Attachments: res_config_pgsql.c.patch
>
>
> The function realtime_multi_pgsql use "LIKE '\\_%'" when look for a pattern on realtime dialplan, that is a no standard use for "\\" in literal strings.
> This causes the postgresql logfile to be filled with a lot of warnings.
> The correct is use "LIKE E'\\_%'".
> This patch too set a more consistent level of verbosity for a log entry.
> ****** ADDITIONAL INFORMATION ******
> Asterisk 1.6.2.6
> PostgreSQL 8.3.9



--
This message was sent by Atlassian JIRA
(v6.2#6252)