[Asterisk-bugs] [Asterisk 0010175]: 10075 fix in 1.4.7.1 breaks MS SQL 2000
noreply at bugs.digium.com
noreply at bugs.digium.com
Tue Jul 10 18:06:31 CDT 2007
A NOTE has been added to this issue.
======================================================================
http://bugs.digium.com/view.php?id=10175
======================================================================
Reported By: stuarth
Assigned To:
======================================================================
Project: Asterisk
Issue ID: 10175
Category: Resources/res_config_odbc
Reproducibility: always
Severity: major
Priority: normal
Status: new
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 18:06 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).
======================================================================
----------------------------------------------------------------------
russell - 07-10-07 18:06
----------------------------------------------------------------------
1.4.7.1 shouldn't have made this any different versus 1.4.7. All I did was
make the ESCAPE only get added if LIKE was being used. So, I guess you're
saying the original patch was broken, too. I'll have to look at this in
more detail tomorrow.
Issue History
Date Modified Username Field Change
======================================================================
07-10-07 18:06 russell Note Added: 0067088
======================================================================
More information about the Asterisk-bugs
mailing list