https://bugzilla.wikimedia.org/show_bug.cgi?id=20275
--- Comment #13 from Max Semenik <maxsem.w...@gmail.com> 2009-08-28 19:31:33
UTC ---
(In reply to comment #12)
> (In reply to comment #9)
> > (In reply to comment #8)
> > > \\\\ appears to be a mysqlism, in SQLite it looks two times more sane:D
> >
> > Then SQLite needs to do more overriding of escapeLike(). We should check
> > how
> > other databases behave -- if MySQL is the odd one out, the base method
> > should
> > be changed.
>
> Nope, PosgtreSQl also needs four. I was unable to find any mention for SQLite,
> so minus point for poor documentation seems to go to SQLite (two points if the
> behaviour is actually different).
>
Results of
die(wfGetDb(DB_MASTER)->addQuotes(wfGetDb(DB_MASTER)->escapeLike('foo_bar'))):
* SQLite: 'foo\_bar'
* MySQL: 'foo\\_bar'
Both seem to work as inteneded (and produce the same results when run from
within MW). After further experiments in PhpMyAdmin I discovered that
SELECT * FROM page WHERE page_title LIKE 'M_in\\_P%'
works indistinguishable from
SELECT * FROM page WHERE page_title LIKE 'M_in\_P%'
Quirks mode against double-escaping?
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
