https://bugzilla.wikimedia.org/show_bug.cgi?id=71207
Bug ID: 71207
Summary: MS SQL Driver doesn't handle escaping for LIKE
patterns correctly
Product: MediaWiki
Version: 1.25-git
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Web browser: ---
Mobile Platform: ---
MS SQL requires specifying the escape character in the query using the ESCAPE
directive. The way it is currently handled leads to incorrect escaping, for
example, simpleSearch doesn't work since the backend query contains something
like:
"...page_title LIKE '%foo\_bar'%..." which works for most DB's, but MS SQL
requires:
"...page_title LIKE '%foo\_bar'% ESCAPE '\'..."
This is breaking various functions around the code base that expect LIKE
queries to work correctly.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
