Bugzilla – Bug 6239
Wildcard queries with underscores don't work with SQLite
Last modified: 2008-07-17 09:19:02
You need to
before you can comment on or make changes to this bug.
When using SQLite database as the backend for RLS, wildcard queries with
underscores in don't seem to work (for example, searching for "test_*" won't
find the lfn "test_file"). It works fine when using MySQL as the backend.
I think this might be because Globus is escaping '_' characters as '\_',
because they are interpreted as wildcards in SQL otherwise. This works on MySQL
which recognises the backslash as an escape character, but SQLite as far as I
can see doesn't have an escape character at all unless one is specified in an
ESCAPE clause of the query.
(Just to avoid confusion: I know RLS supports both UNIX style (* and ?) and SQL
style (% and _) for the wildcards. I'm only talking about using the UNIX style,
in which case any '_' characters should be interpreted as literals).