https://bugzilla.wikimedia.org/show_bug.cgi?id=20275
Summary: LIKE is completely broken for SQLite
Product: MediaWiki
Version: 1.16-svn
Platform: All
OS/Version: All
Status: NEW
Severity: critical
Priority: Normal
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Blocks: 20257
An easy test showing just top of the iceberg:
* Create a page with a space in title in a namespace that supports subpages
(e.g. User).
* Create a subpage for it.
* Click on former page's move tab. You'll see "This page has no subpages" at
the bottom of the dialog instead of subpage(s).
This is because SQLite requires an implicit ESCAPE, for example, if you would
like to find all values that end with "100_%", you'll have to write something
like:
SELECT * FROM table WHERE field LIKE "%100\_\%" ESCAPE '\'
Therefore, every query that uses LIKE must be appended with ESCAPE for
databases that require it.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- 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
