Bug 6239 - Wildcard queries with underscores don't work with SQLite
: Wildcard queries with underscores don't work with SQLite
Status: NEW
: Replica Location
: development
: PC Linux
: P3 normal
: ---
Assigned To:
  Show dependency treegraph
Reported: 2008-07-17 09:19 by
Modified: 2008-07-17 09:19 (History)



You need to log in before you can comment on or make changes to this bug.

Description From 2008-07-17 09:19:02
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).