[Asterisk-bugs] [Asterisk 0010175]: 10075 fix in 1.4.7.1 breaks MS SQL 2000

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=10175 
====================================================================== 
Reported By:                stuarth
Assigned To:                russell
====================================================================== 
Project:                    Asterisk
Issue ID:                   10175
Category:                   Resources/res_config_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.4.6 
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        No 
Request Review:              
====================================================================== 
Date Submitted:             07-10-2007 17:00 CDT
Last Modified:              07-10-2007 19:46 CDT
====================================================================== 
Summary:                    10075 fix in 1.4.7.1 breaks MS SQL 2000
Description: 
MSSQL 2000 needs ESCAPE next to LIKE.

This fails:
SELECT * FROM foo WHERE bar LIKE 'weasels' ORDER BY baz ESCAPE '\'

This works:
SELECT * FROM foo WHERE bar LIKE 'weasels' ESCAPE '\' ORDER BY baz

(It also appears that the ESCAPE only applies to the immediately preceding
'LIKE' clause).
====================================================================== 

---------------------------------------------------------------------- 
 stuarth - 07-10-07 19:46  
---------------------------------------------------------------------- 
>So, I guess you're saying the original patch was broken, too.

Yes, sorry I should have checked that. Same for 1.4.7.
s/newparm/newparam/ and apply it to the instance lower down too, and it
fixes MSSQL 2000. Sorry, I am no DBA, and don't know how well positioning
directly after the LIKE clause works on other software.

http://spacehopper.org/10175.diff.txt if you can use it (I didn't attach
it directly as I don't want to sign the disclaimer at the moment), if not
it'll only take a moment to redo :) 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
07-10-07 19:46  stuarth        Note Added: 0067092                          
======================================================================