[asterisk-bugs] [Asterisk 0017077]: [patch] Fix query with double backslash in string literals and stop log warnings

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17077 
====================================================================== 
Reported By:                korihor
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17077
Category:                   Resources/res_config_pgsql
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.6.2.6 
JIRA:                       SWP-1132 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-03-22 21:49 CDT
Last Modified:              2011-04-18 11:20 CDT
====================================================================== 
Summary:                    [patch] Fix query with double backslash in string
literals and stop log warnings
Description: 
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.
====================================================================== 

---------------------------------------------------------------------- 
 (0133875) rgagnon (reporter) - 2011-04-18 11:20
 https://issues.asterisk.org/view.php?id=17077#c133875 
---------------------------------------------------------------------- 
The compiler will change "\\_%" into "\_%" which PGSQL will see as:

a literal underscore with the % matching character following it.  This is
the intent of the calling routine to find something that starts with the
underscore character in that field. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-04-18 11:20 rgagnon        Note Added: 0133875                          
======================================================================