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

Mon Apr 18 12:14:09 CDT 2011

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 12:14 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0133885) korihor (reporter) - 2011-04-18 12:14
 https://issues.asterisk.org/view.php?id=17077#c133885 
---------------------------------------------------------------------- 
Who uses a version older than 8.2? ;) 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-04-18 12:14 korihor        Note Added: 0133885                          
======================================================================